Search results

Thanks so much that works perfectly.

Yeah but the problem I get is that it does not show the detai;s of both queries which differ. and I can't seem to get it to check both the number and the date as I don't want the records that don't have an AA_No in both queries. does that make sense? I need to check that the dates for the...

Hi, Please can someone help me create a query that looks up two queries and comes back with the lines that don't match. Basically I have two queries (qry1 & qry2) with both have a number field - AA_NO and a date field - AA_DATE. I want to find the records in the queries that don't have the...

Thanks so much, it all works now. *hugs*

Thank you but it still throws an error back - sorry here is my code now: Dim ValDate As Date Dim SQL As String ValDate = Now SQL = "INSERT INTO tbl_Logon_History ( Date_Time, Staff_Member) SELECT ( #" & ValDate & "# , " & lstName.Value & ");" DoCmd.RunSQL SQL error message - "Syntax error...

Hi, thanks for that, but it still s gives me errors so I took out some variables etc and did this: Dim ValDate As Date Dim SQL As String ValDate = Now SQL = "INSERT INTO 'tbl_Logon_History' ( 'Date_Time','Staff_Member') SELECT ( #" & ValDate & "# , " & lstName.Value & ");" DoCmd.RunSQL SQL...

Please help I've written the code below so that when a name is selected in a list (lstName) the code adds a line to a table (tbl_logon_history) to show when someone logged on. However I keep getting an error: "Syntax error in INSERT INTO statement" Please can someone tell me what I'm doing...

Cool Thanks that makes total sense now you say it! I can't check at the minute as my pc needs a rebuild to make access work again. but Thanks a lot I'll try it when I can. Angel

I've already indicated the highlighted line from the error in the code (see the bold bit) The error is as follows: Run-time error '2471': The expression you entered as a query parameter produced this error: 'Angela' (NB Angela is the user login name I picked from the drop down list) Ta

I have a login script but I cannot see why there is an error, here is the code: Private Sub cmdLogin_Click() 'Check to see if data is entered into the UserName combo box - works fine If IsNull(Me.cmboLogon) Or Me.cmboLogon = "" Then MsgBox "You must enter a User Name.", vbOKOnly...

I'm trying to change the source of a subreport. but the code I'm using doesn't work. Can anybody help me? code I'm using is: DoCmd.SetValue Reports![Main_Report]![SubReport1].SourceObject.stSRreport I've also tried DoCmd.SetValue Reports![Main_Report]![SubReport1].SourceObject =...

Excel 2003 with SP2

When I export my database report to excel I lose any characters in cells which are over 255 characters. Please can anyone show me how to get around this? Thanks

:)Thank You:) :)Thank You:) :)Thank You:) :D Angel

ok I've cut down the database to the two tables and the two querys. Query 1 - is the one that worked and Query 2 is when I added more fields . I want only the details expanded on the records in Q1 - how do I do this? Thanks :)

I still can't get this to work - I can get the last record if all other fields of that Item ID are the same but as soon there are any differences then all the records that are different come up not just the last one. sorry to be a pain Angel

How do I do this with two fields - they have an ID but two different types of item can have the same id but are different types e.g. bull 1 = monitor & base unit bull 2 = base unit only bull 3 = base unit, monitor and tape drive ???

I have a database with a few thousand items on it. Each of these items has a history associated to it using a different table. How do I get a query to produce the last record in the history for each item, without getting all the places that item has been in the past as well as the current...