f



creating logs by date

I need to create a supervisory log for my clients.  The log table has the
following fields date, checkbox and notes.  now for the tricky part... one
log is weekly and should be generated every monday.  i have a similar log
that will be run on the first of each month.

so i need a record auto generated every Monday of the week and another
generated on the first of every month... these will be in two separate tables.
.. also possible to auto email to the client???

from there i will email that record w/access 2007 to the client so they can
fill out the rest of the information.  then i can append the record back the
DB and create a report.

suggestions please and thanks in advance.

bl

-- 
brandon

Message posted via http://www.accessmonster.com

0
bml337
11/7/2007 5:18:48 PM
comp.databases.ms-access 42670 articles. 0 followers. Post Follow

2 Replies
386 Views

Similar Articles

[PageSpeed] 34

bml337 via AccessMonster.com wrote:
> I need to create a supervisory log for my clients.  The log table has the
> following fields date, checkbox and notes.  now for the tricky part... one
> log is weekly and should be generated every monday.  i have a similar log
> that will be run on the first of each month.
> 
> so i need a record auto generated every Monday of the week and another
> generated on the first of every month... these will be in two separate tables.
> . also possible to auto email to the client???
> 
> from there i will email that record w/access 2007 to the client so they can
> fill out the rest of the information.  then i can append the record back the
> DB and create a report.
> 
> suggestions please and thanks in advance.
> 
> bl
> 
I might have a small table with only 1 record.  Two fields could be 
called Monday and FirstOfMonth.  When the app opens, check those fields. 
   You might want to prefill them with the last Monday and the date of 
the last 1stofmonth.

You'd need some logic applied to it.  For example, a few US holidays are 
on Monday.  So the chances of people being off work that day are high.
So add 7 days to the last Monday.  If today is equal or greater that 
date then you need to create a Monday record.  Now add a month (see 
DateAdd in help) to the 1stofmonth and see if the date is greater/equal 
to that date.  If either case is true, add the respective record.

Simply adding a record does nothing.  Who's in charge of that record? 
You?  Or another worker.  So even if you add a record somebody needs to 
be made aware that a record has been created and notes need to be filled 
in and then someone needs to email the record.

So the above is just a suggestion, logic needs to be defined.

0
oil (4047)
11/7/2007 6:46:13 PM
Im in charge and currently use excel.  I know access has the email feature
and the only thing i need to do is make sure the date is correct and is sent
to each client for them to populate (does not have to be sent on the actual
date).  Just trying to find the right way to do this... i know access can be
a very complex system

thanks

Salad wrote:
>> I need to create a supervisory log for my clients.  The log table has the
>> following fields date, checkbox and notes.  now for the tricky part... one
>[quoted text clipped - 12 lines]
>> 
>> bl
>
>I might have a small table with only 1 record.  Two fields could be 
>called Monday and FirstOfMonth.  When the app opens, check those fields. 
>   You might want to prefill them with the last Monday and the date of 
>the last 1stofmonth.
>
>You'd need some logic applied to it.  For example, a few US holidays are 
>on Monday.  So the chances of people being off work that day are high.
>So add 7 days to the last Monday.  If today is equal or greater that 
>date then you need to create a Monday record.  Now add a month (see 
>DateAdd in help) to the 1stofmonth and see if the date is greater/equal 
>to that date.  If either case is true, add the respective record.
>
>Simply adding a record does nothing.  Who's in charge of that record? 
>You?  Or another worker.  So even if you add a record somebody needs to 
>be made aware that a record has been created and notes need to be filled 
>in and then someone needs to email the record.
>
>So the above is just a suggestion, logic needs to be defined.

-- 
brandon

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/databases-ms-access/200711/1

0
bml337
11/7/2007 8:57:02 PM
Reply:

Similar Artilces:

Create MS/ACCESS database app for non-ms/access users
Is it possible to create an MS/ACCESS database application and package it for users who do not have MS/ACCESS loaded in their PCs? I was told that this is possible, but I don't know what software is needed. Do you know? If so, please answer this post. Thanks. SueB *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! Per Sue Bricker: >Is it possible to create an MS/ACCESS database application and package >it for users who do not have MS/ACCESS loaded in their PCs? > >I was told that this is possible, but...

How to read MS Access Database Table Created Date
Hi, may need some help here. I am using Borland Delphi Dev 2006. I am able to read the list of tables names in MS Access 2003 database using ADOConnection1.GetTableNames, but I am trying to read the list of tables with their created/modified dates, appreciate some help here please. Thanks. Xan. ...

How to read MS Access Database Table Created Date
Hi, may need some help here. I am using Borland Delphi Dev 2006. I am able to read the list of tables names in MS Access 2003 database using ADOConnection1.GetTableNames, but I am trying to read the list of tables with their created/modified dates, appreciate some help here please. Thanks. Xan. ...

How do you create an Access SQL Query to list all Database Objects, or Queries only, with their Size, Date Created and Date Modified
.... or any good Access book which would cover this subject. Thank you for your help. J.P. Most of the information you mention is contained in the hidden system table MSysObjects - with the exception of size, and I don't know any way of getting that information. You can write a query - using the standard query builder, if that's your preference - to retrieve what you want. You'll probably need to do some googling to find what some of the values used in this table represent, but it's readily available (don't have any links to hand on the computer I'm using at the moment). The key thing is to use the Options dialog box (from the Tools - Options menu in A2003 and earlier; or by right-clicking the Navigate bar and choosing Navigation options in A2007 (and later, I assume)) to make both System and Hidden objects visible. Until you do so, you can't browse the system tables (there are several of them) or use them in a query. HTH, Rob <jpr.charron@gmail.com> wrote in message news:5e29660d-e08e-432f-bba4-f8c1f281a39f@googlegroups.com... > ... or any good Access book which would cover this subject. > Thank you for your help. > J.P. On 25/02/2014 00:57:53, wrote: > ... or any good Access book which would cover this subject. > Thank you for your help. > J.P. > This will get you started Function GetDescription(ObjName As String, ObjType As Long) As String ' Get descri...

Creating/Formatting a date in MS Access
HI everyone ... I am interested in creating a date field on an ACCESS form that will be used to update a DB/2 Table (Link Table). I am interested in creating a DB/2 timestamp field in the following format CCYY-MM-DD-HH-MM-SS (i.e. 2004-04-30-15.45.33) and it comes from the system/PC clock. Can anyone suggest an easy way to do this? Is there a format formula to add to the text box? Thanks ... Joel. -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Not sure if this will work, but... Format(Now(), "YYYY-MM-DD-HH-NN-SS") "NN" is the symbol for minutes, to differentiate from...

Creating MS Access databases with VB (.net)
Hello, I am trying to create MS Access databases using VB .net. I can create MS Access 2000 databases OK but also want to create (using VB .net code) 97 format MS Access databases as well. Was using ADOX but the create statement has no parameters for access format and just creates database to whatever format of access you have installed. --- CODE START --- Dim cat As New ADOX.Catalog() Dim sCreateString As String sCreateString = _ "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Test.mdb" cat.Create(sCreateString) --- CODE END --- Cheers Paul M Let me steal from a regul...

Libname method to create MS ACCESS database?
Hi there, OK, I know that I can added tables into an exsiting MS ACCESS database: libname xx access "g:\xxx\xx.mdb"; data xx.junk; set sashelp.class; run; Where xx.mdb already there. What about if there is no database file yet, can I create a database using libname method? I tried the following but failed: libname xx access "g:\xxx\yy.mdb"; data xx.junk; set sashelp.class; run; ERROR: Connect: Could not find file 'g:\xxx\yy.mdb'. ERROR: Error in the LIBNAME statement. Thanks Ya ...

Inserting Date/Time into MS Access Database
I'm trying to insert a timestamp into an MS Access Database using the Labview database connectivity toolset.&nbsp; However, I keep getting an error saying that the parameter is in the incorrect format.&nbsp; I'm using the "DB Tools Format DateTime String.vi", and it doesn't seem to be working. Hello, I don't have the answer to your question, but.... How did you get information to be written into MS Access from labview. Thanks. If you are using this function to create the date but using SQL to put the date into the DB, this is probably the cause of your problem, because the VI adds a header to your string which is removed later by the parser. If you want to use this date in an SQL command, you should build it yourself or remove the header. &nbsp; As for roboticstudent, just look at the examples in the example finder to see how to interact with databases. I tried it both ways.&nbsp; I tried using the format date/time into string where it would return "11/7/05 8:22:34 PM", which I then tried to insert in to the DB, but to no avail.&nbsp; I even tried various formats, changing the order of the numbers, etc., but it doesn't seem to work. It would be easiest if you post your code, or at least an image of it. Also, which error exactly are you getting? Is it possible you're trying to enter a string into a numeric field (for example)? If I define a date\time field in Access and then use Insert Data (with the LV format...

Re: Libname method to create MS ACCESS database?
Ya, I don't know of a direct way to get around the problem. A kind of indirect way is to simply create an empty ms access file (say, called empty.mdb), in access, and then copy it whenever you want to create a new access file. e.g., x "copy g:\xxx\empty.mdb g:\xxx\xx.mdb"; libname xx access "g:\xxx\xx.mdb"; data xx.junk; set sashelp.class; run; HTH, Art -------- On Mon, 1 Feb 2010 19:15:58 -0500, Ya Huang <ya.huang@AMYLIN.COM> wrote: >Hi there, > >OK, I know that I can added tables into an exsiting MS ACCESS database: > >libname xx access "g:\xxx\xx.mdb"; > >data xx.junk; > set sashelp.class; >run; > >Where xx.mdb already there. > >What about if there is no database file yet, can I create a database >using libname method? > >I tried the following but failed: > >libname xx access "g:\xxx\yy.mdb"; > >data xx.junk; > set sashelp.class; >run; > >ERROR: Connect: Could not find file 'g:\xxx\yy.mdb'. >ERROR: Error in the LIBNAME statement. > >Thanks > >Ya ...

How to creat thumbnails of jpg images in MS-Access database
Hi there, This is my first time here,.....I am a Perl developer by trade but currently working on Access database. Anyway,...I use this artical from Microsoft knowldge base number (285820) to creat a database that contains few .jpg images. My question is; how can I create a thumbnail imges for those jpg images and, if how can I get the the original jpg image to be displayed once I click on the thumbnail? Thanks for yoyr help. Tim You can use an image control(s) then use the width and height propertie(s) of your control(s). Make sure that the size mode property of the image contorl (in t...

Inserting Date/Time into MS Access Database #2
Hi All I am using Labview 8.0. I am able to write the Date in MS Access but i am not able to read it through Labview. In my case i have to read the data where Start Date=02/10/2007 and End Date= 23/10/2007. I am using this command - SELECT*From Table_Name Where Date between '02/10/2007' AND '23/10/2007'&nbsp;&nbsp;&nbsp; but i am getting error - Error -2147217887 occurred at Conn Execute.vi-&gt;Untitled 2.vi Possible reason(s):Exception occured in Microsoft OLE DB Provider for ODBC Drivers: ODBC driver does not support the requested properties. in Conn Execute.vi-&gt;Untitled 2.vi Please give suggestion to read the data. regards J ...

Track the User logged in the Shared MS Access Database
Hi, is there a way to know which user last logged in the shared Access database. My requirement is that I must be able to track the users that log in the database and incase its not working because one of the user has done something wrong that I must be able to track him/her. TIA -G. See: HOW TO: Check Who Logged into Database with Jet UserRoster in Access 2000 at: http://support.microsoft.com/?id=198755 You may find it easier to use your initialization code (e.g. AutoExec macro) to actually log the users in and out. Just Execute an Append query statement on a table set up for thi...

how do you update a java.sql.date type in an ms access database
when i update a row in an access database the date field does not update to the correct date it brings up some funny date which i dont know where it comes from. Below is the method i use to update. maybe the date types are not compatable? thanks in advance, public static void bookIN(int custID, int rNumber,java.sql.Date bkInDate ){ try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); String filename = "hotelDB.mdb"; String database = "jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ="; database+= filename.trim() + ";DriverID=22;READONLY=true}"; Connection con = DriverManager.getConnection( database ,"",""); int yes = 1; Statement s = con.createStatement(); s.executeUpdate("update Rooms set CustomerId ="+custID+",BookINDate ="+ bkInDate +",Occupied = "+yes+" where RoomNo = "+rNumber+" "); s.close(); con.close(); } catch (Exception err) { System.out.println("ERROR: " + err); } } "chose" wrote... > when i update a row in an access database the date field > does not update to the correct date it brings up some > funny date which i dont know where it comes from. It comes from db's attempt to parse an invalid date-string... In Access/Jet,...

request for explanation on access an database in ms access
This is the code that I found on the internet for accessing an ms access database: import java.sql.*; class Test { public static void main(String[] args) { try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); // set this to a MS Access DB you have on your machine String filename = "d:/java/mdbTEST.mdb"; String database = "jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ="; database+= filename.trim() + ";DriverID=22;READONLY=true}"; // add on to the end // now we can get the connection from the DriverManager Connection con = DriverManager.getConnection( database ,"",""); } catch (Exception e) { System.out.println("Error: " + e); } } } What I don't understand is the declaration of database. What I did was putting the database in the same dir as the sourcecode and use "jdbc:odbc:CafeJolt.mdb". But this doesn't work. And the above code does, why is that??? Actually it's not Java question. It's ODBC question. You have to have ODBC connection. Depending of Windows it's usually something like this (for my Windows 2000): Start->Sttings->Control Panel->Administartive Tools->Data Sources(ODBC)-> User DSN -> [Add]-> Driver to Microsoft Access(*.mdb) === And here, finally you can choose file name. ...

Access MS-ACCESS database on server from client????
I m currently developing a java based application and want to know how can i make client access database located on the server? "HeMan_Speaks" <Lunar20092010@gmail.com> wrote in message news:d71ce567-0434-48b8-b1d2-bb191706ab45@w8g2000prd.googlegroups.com... >I m currently developing a java based application and want to know how > can i make client access database located on the server? I think you're going to have to expand a little bit more in your question here, as is not 100% quite clear what you're trying to do. You might want to make a little bit of a distinction between MS access, the development system that allows you to write code, build forms, and build reports, and that of the database engine that you choose to use with MS access. When you build an application MS access, you then choose your database engine, that might be oracle, SQL server, or perhaps more often leave the default jet database. So when you say make a client access application, are you talking about a piece of software that you plan to install and each computer? The fact that your introducing the issue of java further complicates your question. Perhaps your question is simply you have some java code running on a server, and with to open a mdb file (an access database file). In this situation you're not really using MS access at all here (you using what is called the jet database engine to read that mdb file). For all the trouble in this type of sce...

MATLAB command to access MS Access database
Hi! Is there a MATLAB command which gives access to a .mdb MS Access database or do I need a special driver? Thanks, Andree Hi Andree Ellert, you can use activeXcontrol to interact with MS-Access database. access = actxserver('Access.Application'); returns the handle for Access. set(access, 'Visible', 1); will show the opened Access window. use get(access) and set(access) commands to find the methods available to call. -Vadivelu M =========== http://www.mathworks.com/access/helpdesk/help/toolbox/database/datatool.shtml "Andree Ellert" <ellert@gmx.net/////\\\\\> wrote in message news:eed9874.-1@webx.raydaftYaTP... > Hi! > > Is there a MATLAB command which gives access to a .mdb MS Access > database or do I need a special driver? > > Thanks, > > Andree Andree Ellert wrote: > > > Hi! > > Is there a MATLAB command which gives access to a .mdb MS Access > database or do I need a special driver? > > Thanks, > > Andree <http://www.mathworks.com/matlabcentral/fileexchange/loadFile.do?objectId=4045&objectType=file> -Hardik ...

Accessing MS ACCESS database using Data Environment
HI, I have developped a program in Visual Basic 6.0 using MS Access database. I have created all my reports through Data Environment where I have entered the location of my database file (for e.g c:\project\app\test.mdb) in the Connection properties. I have installed my application on another PC using Package & Deployment wizard. When viewing the reports on the other PC, I have to enter everytime the new location of the database. How can I solve this problem, please? nadia wrote: > HI, > I have developped a program in Visual Basic 6.0 using MS Access database. >...

Access project database
Why isn't a database created on the MSDE?? Network: Two Win2K Pro machines connected as peers. (No domains.) MS Access is on X, MSDE2000A is on H. MS Access is run under: Windows Administrator. MSDE is set for Windows Authentication only. On using the Microsoft SQL Server Database Wizard to create an Access project, I don't specify a usename or password. After the wizard says it has the info it needs, it closes and a progress bar appears for a only a split second as the wizard tries to create the database. Indications are that the connections to the MSDE was dropped during creatio...

Best way to access a remote MS ACCESS database
What is the best way, via the internet, to access a remote Microsoft Access database? I was thinking of using VPN, but I thought that I would check here to see if there is a better way. Any suggestions? Thanks Do you mean remotely controlling an Access database, or linking tables over the internet? The first is doable, the second is a recipe for disaster. Remote Control: If your remote OS is Windows XP, you can use Remote Desktop (although only 1 person can access the PC at a time; this will change in the upcoming Service Pack for XP, but that may not help you now). Otherwise, GoToMyPC offers similar services, as does Terminal Server (a component of a Windows Server machine), PCAnywhere, et al. Linking to remote tables: You will almost certainly encounter severe problems with corruption, and your performance will almost certainly be so poor as to be unworkable. I attempted this once, with a web server in Canada and my machine in Augusta, GA. Even tiny data requests on a very well optimized data structure took waaaay too long to process ... it's simply not workable, IMO. Other alternatives would be covert the app to a web-based and place your data on a web server. Access/Jet isn't really designed for those workloads, but running a small site with minimal transactions and users can be done. Otherwsie, consider switching to a more robust data platform like MySQL, SQL Server, etc. -- Scott McDaniel CS Computer Software Visual Bas...

Accessing a MS Access database across two servers
Hi The technical support guys at my company have set up my system so that the server containing the MS Access database is on one server, while the pages that should access the database are on another server. When the pages and database are on the same server, I usually just connect through ODBC. The problem is that I don't know how to set up an ODBC connection to link from one server to a database in another. Anyone know what I am getting at and know of a possible solution, or a link to a site which may help. thanks in advance Brendan "Singularity" <Brendan.Collins@Sin...

Accessing 2 tables having same name but different databases ms-access
Hi, I have an application with MS-Access as backend and JSP/ tomcat as frontend/webserver. For getting better response time(as access is very slow compared to other RDBMS's), I have split the main DB into two DB's on different disks on my server for better performance.I have kept the table names same but changed the DB names. How do I access tables from both the DB's? This is what I have done; I made different connection to the respective DB's i.e. con and con2. When I want to access data, I am using 2 result sets for retriving data from the tables, but getting no result. Here is my code: rs2_1=stmt2_1.executeQuery("select * from Requests where Status='Released' AND LoginName='"+login+"' order by Req_No"); rs=stmt.executeQuery("select * from Requests where Status='Released' AND LoginName='"+login+"' AND Req_No> 5500 order by Req_No"); So, rs & stmt are for latest records and rs2_1 & stmt2_1 correspond the records from older DB. I think, I'm forgetting some small thing but cant get it. Please advice. What do you mean "no result"? Does "next()" return false for both rs2_1 an= d rs? If you're really trying to improve response time, you should probably be ru= nning the two queries in separate threads ... but as you acknowledge, Acces= s may not have as high performance as other RDBMSs. You would also see rel= iability adv...

MS Access database with a file extension of .mde
Good day: Can you kindly assist me in opening a MS Access database with a file extension of .mde? I get an error message stating "This database is in an unrecognized format". Any help is greatfull. TIA This usually indicates an attempt to open an Access 2000 database in an earlier version. -- MichKa [MS] NLS Collation/Locale/Keyboard Development Globalization Infrastructure and Font Technologies This posting is provided "AS IS" with no warranties, and confers no rights. "mary" <chloemelmom@yahoo.com> wrote in message news:a0a64947.0311151242.4df0c...

accessing MS Access database fila via ODBC problem
Hi! I'm trying to connect to a MDB file via ODBC like this: char *DSN = "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=c:\\dev-cpp\\test\\1.mdb"; SQLAllocEnv(&env); SQLAllocConnect(env, &hdbc); SQLBrowseConnect(hdbc, (UCHAR*)DSN, strlen(DSN), (UCHAR*)buf, BUF_SIZE, (SQLSMALLINT*)&rcvlen); The function SQLBrowseConnect fails and SQLGetDiagRec returns "IM001 Driver does not support this function" Can anyone help me? Thanks! David On S...

Free JDBC driver to access MS Access database from Linux enviroment.
I'm looking for a free JDBC driver that will allow me to acces a MSAccess database that resides on a Windows server from a JSPapplication that resides on a Redhat Linx server.Any suggestions would be appreciated.Thanks,Tim tim@nocomment.com wrote:> I'm looking for a free JDBC driver that will allow me to acces a MS> Access database that resides on a Windows server from a JSP> application that resides on a Redhat Linux server.> Any suggestions would be appreciated.Sounds like RmiJdbc is a solution.See <http://rmijdbc.objectweb.org>-- Thomas...

Creating Access Database
I have Access 97. I have a spread sheet with 60 columns and 7000 records. I would like to be able to use this spreadsheet data and sort/filter through it in a database. I have written sort of a simple database(names, addresses, etc.) before. I suspect this database is much more complicated. Can this be done in Access? And is there available a sample database that I can change to accomplish what I want? Appreciate any advice you can offer...... TIA DB Newbie previously wrote: > I have Access 97. I have a spread sheet with 60 columns and 7000 > records. I would like to be abl...

Web resources about - creating logs by date - comp.databases.ms-access

Wikipedia:Creating a bot - Wikipedia, the free encyclopedia
It is often far simpler to request a bot job from an existing bot. If you have only periodic requests or are uncomfortable with programming languages, ...

U.K. Woman Faces 20 Months For Creating Fake Facebook Accounts, Sending Herself Abusive Messages
A woman in Cornwall in the U.K. came up with a creative way to use Facebook to accelerate a family spat, and it earned her 20 months in prison. ...

Sandi Krakowski’s Tips for Creating Great Content
Quick tips to help you create great content for your business.

Bug - Creating a Video.Watches Action stopped working - Facebook-Entwickler
Since today executing a POST on a me/video.wacthes endpoints no longer works, it was working around 10 hours ago since then the call always returns ...

Facebook simplifies process for creating repeat events
Facebook introduced a new feature for events this week that allows users to quickly create a similar event as one they previously hosted or attended. ...

The Obama campaign won by creating their own Facebook, with unique features for political campaigns.
... seen as too dangerous to nominate someone who is so thoroughly narcissistic, arrogant and dishonest. The Obama campaign won basically by creating ...

Creating A Great Startup Culture
... with any Bay Area startup these days (ping pong, beer on tap, catered lunches and Macbook Airs) – though these things are, of course, Creating ...

Campus Coaches: Creating a culture of wellness, one school at a time on the App Store
Read reviews, compare customer ratings, see screenshots, and learn more about Campus Coaches: Creating a culture of wellness, one school at a ...

Creating Economic Dynamism: Joseph E. Stiglitz
DAVOS/SWITZERLAND, 25JAN13 - Joseph E. Stiglitz, Professor, Columbia University, USA talks during the session 'Creating Economic Dynamism' at ...

YouTube - Super Human Abilities: Tila Tequila Creating Energy Balls & Electricity Out of Thin Air!
Veröffentlicht am 24.04.2013 Hey Guys! For a long time now I have been able to do some pretty supernatural things that most would consider "SUPER ...

Resources last updated: 3/20/2016 9:42:38 PM