Recent content by angellrp

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 :)