Search results

Hi, it's a list box

Yep, each line is for a separate control

Hi, Nothing that was checked was flagged as missing so I guess the references are ok. When I click on the .Requery this is the code I see: Private Sub Button_Update_Click() ' Update list of incomplete security requests OpenCall_OnHold.Requery OpenCall_Unix.Requery...

Hi, Thanks for the reply. When I drill down into the code and right click on the .requery I am taken into the VB Object Browser. It lists from left to right the forms, then Classes (of which ListBox is selected) and then Members of ListBox (of which Requery is selected). Requery seems to be a...

Yep, all up to date thanks :)

Hi guys, The operating system is Windows 2000 and it's Access 2003. All patched up too. Dave, The database has been split so that the forms are indeed in the front end. Maybe I'm not referencing someting correctly though? Perhaps I've left a function to execute with a default connection...

Hi guys, me again... Help! It seems that I've managed to break another Access command in splitting my database. Essentially I have a form with several subforms and a button that fires off a command from VBA along the lines of OpenCall_OnHold.Requery etc for each of the subforms. The idea is...

Fixed! I am officially much happier now :) This is the snippet of code which allowed me to avoid using the .Index line and now all is well: Validate_User_Exist =isnull(dlookup("User_ID","tbl_User","User_ID=" & Form_User_Create.Textbox_UserID)) Many thanks for the advice, I wouldn't have...

No dice I'm afraid, the code still errors on the "rstUser.Index" line. Thanks anyway, Andy

Hi guys and gals, Got a weird problem so really hoping someone has seen this before and can lend a hand :) I have recently split a database into a front end and a back end for multi-user reasons. In the front end the database contains all the code of the back end but none of the data...

Close but no banana, that's a formatting change. I still get the same error message :)

Hi guys, Can anyone help with how I should be constructing this query please? I have this so far: SELECT Format(A.Date_Logged,"yyyy" & " mm " & "dd") AS DateRange, A.Action as Action, Count(*) AS Total FROM tbl_security_request as A left join tbl_security_request_track_amend as B on...