Help Using APPEND Query

Hi,

I'm looking to create a "LOG" table. This table will contain 4 fields;
1. SessionID - AutoNumber
2. DateTime - Text
3. User - Text
4. AccessLevel - Text

Very simple.

Purpose: I can eventually (6months or more from now) create a report to see 
if more staff/users/admin are accessing the system and what times they are 
accessing the system, am/pm etc.

I have created a public function which determines and returns the username
I have created a public function which determines and returns a string 
identifying their access level. "Student" "Staff" "Admin". - This table will 
be for log purposes only.

I need to have an append query which I can run, which will add the following 
to a new record in the table:

1. SessionID - AutoNumber - Automatically?
2. DateTime - Result from NOW Function
3. User - Result from my function ie "DAN"
4. AccessLevel - Result from my Access Level.

Any help would be most appreciated.

Thank you in advance

DAN
0
Utf
10/31/2007 6:50:01 PM
access.queries 6343 articles. 1 followers. Follow

0 Replies
563 Views

Similar Articles

[PageSpeed] 38

Reply:

Similar Artilces:

Help building a filter on a form
Okay, I downloaded the Issue database template and simplified it greatly. Now, I can't get the "search issues" form to work. I have the following controls on my search form: Application (dropdown list) TextSearch (text field) I'd like to modify the existing code so that when I make an entry and click the "search" button, it will make the form footer visible (where the "browse_all_issues" form is imbedded as a subform). That part works. But, the next lines set the filter and turn it on... Me.FormFooter.Visible = True DoCmd.Mo...

Can you ignore table validation on query append?
Hello, I have a table that has validation: IIf([Document 1] Is Null,[Document 2] Is Not Null And [Document 3] Is Not Null,IIf([Document 1] Is Not Null,[Document 2] Is Null And [Document 3] Is Null)) This is because when my user fills out their form, they must select one choice from List A OR one item from List B and one item from list C. My problem is that I have an append query to add any new hires to the table in an autoexec. The append query is failing because I am not updating any data for the above Documents. Is there anyway for me to get around the table validation on my append? Any ...

Append Query
I have a table "Rates" with the following data: StartDate: 5/15/08 End Date: 6/23/08 Rate: $53 StartDate: 6/24/08 End Date: 7/15/08 Rate: $86 StartDate: 7/16/08 EndDate: 9/19/08 Rate: $99 I have another table "Transactions". I want to create an append query such that if I supply the StartDate and EndDate, the query will populate the "Transactons" table with date and rate data from the "Rates" table for each and every day within the date range. Example: If I supply the StartDate of 6/23/08 and the EndDate of 6/25/08, the query would pop...

Using bitmaps with CPaintDC
Is the code below the right approach to displaying bitmaps to a dialog. And is there any obvious problems with it, such as not being consistently displayed on other monitors. Also I would need to display a number of (small) bitmaps side by side on rows, and will need to add scroll functionability to this dialog. Does anyone know of the best approach to displaying these bitmaps in rows, and then adding a scroll for just a certain area of the dialog where the bitmaps are displayed. The member variables bmp and cdc are declared in the class declaration. void CDCBmpTestDlg::OnPaint() { CPain...

can i use
Hello, I am Pramod from INDIA. I have some code in C# and some code in VC+ +.NET. I want to know that , can I use my C# code in VC++.NET. if yes what's way to use it give me example. Thanks & regards Pramod Sahgal These articles may be intersting to you assuming you are trying to call managed code from unmanaged code. If you are using totally managed code in C++/CLI then it is less of an issue. http://www.codeproject.com/useritems/InterOp.asp http://www.thescripts.com/forum/thread620468.html http://www.andymcm.com/csharpfaq.htm http://msdn2.microsoft.com/en-us/library/sd10k43k(...

100% CPU used by SQL and HQClient
We are seeing both HQ Client and SQL tie up resources at the store servers during connection to HQ. This can slow access to the store database by registers for a long period of time. Anyone else seeing similar performance issues on store servers? This is a multi-part message in MIME format. ------=_NextPart_000_059A_01C7B449.07A22E70 Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: quoted-printable Rick, Make sure you're running 1.3 or higher. Consider more RAM and processor = speed. Maybe even dedicate a processor core to it. --=20 Regards, Jeff...

All help is worthy
I have set up a simple database in excel, using barcodes (i found this easier to scan and lookup, than access) plus the people working with this will find it simple to use. I have however reached a giant full stop. The database is pulled from Dave Peterson's update log worksheet, which works very well, the problems is that on a lookup sheet( using Vlookup ) where the user scans the barcode it will pull all info from the "database" sheet in reference to the barcode, ie: barcode number, surname,forename,address, early greenfees purchased,mid purchased,late. Is it possible to manipu...

Excel 2007 and Word 2007 Hangs when using the File -> Open command
I have a couple users that when they have Excel 2007 or Word 2007 open, and click the File -> Open option, and choose a file, it either takes about 3 minutes to open the file or the program will crash. If they were to double click on the documents or spreadsheets, the doc or sheet will open right up. This is happening on the user's Hard drive as well as network drives. Once you get a file opened in Word or Excel, however, the next time you go to File -> Open, it's really fast to open the file. ...

HELP: Need To Print Better Quotes
I am having a terrible time being able to print a good looking quote from MS CRM. it either prints the plain quote (Address, amount..etc) or i can print the product list (With no address, or nothing).. is there anyway to print a normal quote as others do where you can have the company informaiton and also all of the products that they are buying listed there? one would think that is the most basic feature that is not there.. don't you guys think? ANY help you can provide will be appreciated.. Thanks Quoteless In DC :-) Add a customized quote via Reports using Crystal. >-----Origin...

IF Function Help
How do I write a command that says: =if(a1=1&b1=a number, c1/d1,"na") How do I write the "a number" part? Hi Flutie99 Try: =IF(A1=1,IF(ISNUMBER(B1)=TRUE,C1/D1,"na")) -- Sincerely, Michael Colvin "Flutie99" wrote: > How do I write a command that says: > > =if(a1=1&b1=a number, c1/d1,"na") > > How do I write the "a number" part? If I am reading your post correctly you want a cell to equal C1/D1 when A1=1 and B1= some some number and for the cell to = "na" otherwise =if(and(A1=1,B1=xx),C1/D1,&...

Publisher documents do not print. Help!
I just set up a new computer with an HP Deskjet 5440 and Microsoft Publisher 2003. Documents print perfectly from every software package except Publisher. Publisher documents don't print at all, even after I reinstalled the printer drivers. The entire document or just the pictures? If it is just the pictures, click the advanced print settings button in the print dialogue, graphics and fonts tab. Be sure "Do not print any graphics" is checked. Look on the HP site to be certain you have the most current driver. http://h10025.www1.hp.com/ewfrf/wc/softwareList?lc=en&cc=us...

Help in my VB Code .. to Delete
This is a multi-part message in MIME format. ------=_NextPart_000_0089_01C34629.B378D5B0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable hi,=20 I have been trying to solve this problem since morning, and haven't = really come up with a solution. it is frustrating. please help. =20 i have a datagrid and got a delete column =20 <asp:datagrid id=3D"dgdocument" runat=3D"server" = AutoGenerateColumns=3D"False" EnableViewState=3D"True" = OnDeleteCommand=3D"DeleteCommand"> <Columns&...

Running Access Query Returns Incorrect Number of Records
I am running some code which loops through and runs the queries in an Access Database. The count of the records is then stored in a Worksheet. For most of the queries, the figure stored in the Worksheet matches the number of records if you run the query in Access. But for certain queries, the count of the records does not match the number of records when the query is run in Access. If I change the query to a make table query and then base another query on that table, the results are correct. Can anybody suggest running the query from Excel would results in a different number of records bein...

Check query shows voided checks too!
I am running this query but its also showing voided checks! How can I make it now show voided checks? SELECT VCHRNMBR AS PaymentNumber, VENDORID, DOCDATE AS CheckDate, DOCNUMBR AS CheckNumber, DOCAMNT AS CheckAmount FROM PM30200 WHERE (DOCTYPE = 6) AND (DOCAMNT > 25000) Add this to the end of the WHERE clause AND (VOIDED = 0) -- Japheth Nolt MCP Microsoft GP/SBF Specialist Landis Computer http://landiscomputer.com "Michael@nyresume.com" <Michaelnyresumecom@discussions.microsoft.com> wrote in message news:7163A485-9E90-48C7-B931-C989827039D6@micros...

Select Query acting like an Update Query
I am having trouble with my database where my select queries are acting as update queries. If a user happens to accidentally or otherwise adjust the results provided by the query, it is updating the information on the table(s). I need to find out why it is doing this and how to prevent this from occurring and altering the data. Thank you, Terri On Dec 17, 9:34 am, Tboartz <Tboa...@discussions.microsoft.com> wrote: > I am having trouble with my database where my select queries are acting as > update queries. If a user happens to accidentally or otherwise adjust the > res...

How to configure replies when using multiple email addresses?
Good morning, Here is my problem. There are several people in our organization that receive email from two different email domains, for the sake of argument, lets call them user1@abc.com and user1@xyz.com. Email from both email domains are routed through our Exchange server and then the clients receive their email through their Outlook clients, (Exchange 2000 and Outlook 2002). Abc.com is the primary email domain, and we have setup a partnership with another company, hence the arrival of the xyz.com domain. When they reply to an email, regardless if it arrives to their abc.com or xyz....

Help Everything is gone. It's all been deleted.
I went on excel last on Dec 5th and I saved before exiting as usual. When I opened the file today everything was gone. There is nothing there. The file it's saved as is still there but it's a new page. I don't know what to do. I need that information. HELP! Are you sure you opened the same workbook? What do you mean by "page"? Excel has pages only when you print. Do you mean a blank worksheet? Are there any other worksheets available or just the one blank one? Did you create a backup of the workbook when you saved? If you "need" the inf...

Use with Office Communicator saving Conversations (IM)
Our office just upgraded our email, and now we have Office Communicatior available. OC allows the saving of conversations to Outlook. I noticed that when a conversation is closed or saved and returned to after a time delay, there are 2 conversations in the folder. Is there a way to only have 1 conversation in the folder? or to have the seperate conversations be distinct, i.e. convo 1 at 930am and ends at 1015 is one, and another covo starts at 215-225. now i'll have a conversation saved at 1015 that has all im from 930, as well as a convo at 225 that has the 215-225 as we...

Problem using a report from Access2003 to Access2007
I am trying to use a database created with Access 2003 in Access 2007 but have come up with a problem. The database contains a report which produces invoices for sales between two dates. When the report is run the user is asked to input sale date From and To (this is set up in the Invoice Query), Invoice Date and Invoice Start Number - these two are set up as text boxes on the report. Invoice Date conrol source has [Enter Invoice Date] and Invoice Start Number has [Page]+[Invoice Start Number]-1. This works fine in Access 2003 and the invoices come out correctly but in 2007 invoice ...

Does anyone use "location" field in Outlook?
After all these years, I just noticed when I go to make an appointment in Outlook (2003version, with BCM), that there's a second field after "subject" which would seem to be the one everbody mostly uses. The appointment fields are: 1. SUBJECT: (example: "Conference call with Joe and Mary) 2. LOCATION: (does anyone use this?) Is the idea to put something like "Annapolis, MD" meaning maybe a meeting there or something? I know it's a hokey question, but wondered about some examples of how other people are using it. Thanks, G Standard following us...

Can I use Rule to move digitally signed messages to separate folder?
Is there a way to move digitally signed messages to a separate folder using a Rule? Other options for segregating digitally signed messages? Thanks in advance. deko <nospam@hotmail.com> wrote: > Is there a way to move digitally signed messages to a separate folder > using a Rule? Other options for segregating digitally signed > messages? I don't see that as a selection criterion in the Rules wizard. -- Brian Tillman ...

Need help with cursor spacing problem
> This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. --B_3173510125_666133 Content-type: text/plain; charset="ISO-8859-1" Content-transfer-encoding: 8bit Hello: I�m trying to fill in a form that�s MS Word based. I�m using MS Office X on a Mac G4 with system 10.3.4. When I type, the cursor seems to have an extra space between the last letter and the place where I want to put a new one. In other words, I�m unable to align the cursor exactly where I want it to go. It makes typing almost imposs...

Having Tabbed UI using CFormView in an SDI project
Hey Guys I want know whether we cud implement tabbbed UI using CPropertySheet and Cproperty using CFormView or CScrollView in a SDI MFC project. If Yes how? Hope for Quick reply Pankaj It would be kinda hard to put a CView in a PropertySheet. Try these instead: http://www.codeguru.com/cpp/w-d/doc_view/tabs/article.php/c3347/ http://www.codeguru.com/cpp/w-d/doc_view/tabs/article.php/c3315/ http://www.codeguru.com/cpp/w-d/doc_view/tabs/article.php/c6107/ http://www.codeguru.com/cpp/w-d/doc_view/tabs/article.php/c3357/ http://www.codeguru.com/cpp/w-d/doc_view/tabs/article.php/c3247/ AliR. ...

Dlookup in query
Hi guys, I have a query in which i want to use a dlookup which i have embedded in a function. Strange thing is that the first record returns the correct value and after that i get a invalid use of null.. ?? scenario (for testing purposes) table1: MyDate (set to date time) MyAmount (set to currency - standard - two decimals) table2: Dummy (text field) FutureDate (Set to date time) Created a query with the two fields from table2 both fields added to the querygrid. Third field added as follows: Amount: getprice(FutureDate) Module: function GetPrice(FutureDate) as d...

open excel 2007 refresh query from batch file
Hello all, I have a simple script saved as "C:\refresh_excel.vbs" that opens an Excel file, and does a refresh for a query on Sheet 1. I created a scheduled task to run this every day. It worked fine for previous versions of Excel, but since I have upgraded to Excel 2007 it doesn't work. Any help it helping me figure this out would be appreciated. /*contents of refresh_excel.vbs*/ Set objExcel = CreateObject("Excel.Application") objExcel.Visible = True Set objWorkBook = objExcel.Workbooks.Open("C:\reports\UPS.xls") objWorkbook.Sheets("...