Search results

I was wondering if someone could help me please? I have a few tables, one of which stores a record of changes made to user accounts, and some of those changes are linked to a "multichange" table for when I have made the same change to multiple accounts. What I am trying to do is select the...

Thank you, that's brilliant! :) I used the second example and it works perfectly. Really appreciate it. :D

I'm struggling with a bit of code and can't seem to get the syntax right. I have an On Click procedure for one of my buttons but I don't want to allow it to run unless another form is currently open. My other form is frm_go_live and it contains some variables relating to a project launch. I...

Paul's snippet seems to work for IsNull and ZLS, so thank you... and thank you MSAccessRookie too for the alternative suggestion. :)

Well I'm a complete n00b soooo... :rolleyes: I'm used to SQL functions and PHP, so working with Access and VB at work is melting my brain a bit, but it's good to learn. :)

pr2-eugin, you are my hero today! ;) That worked perfectly, thanks. Brian, the (...) was just to save me pasting a ridiculous amount of confusing code. :rolleyes:

I need a bit of help with syntax as this one keeps throwing me off. I think it is likely to be a simple fix but I just can't figure it out. I have a field on frm_main2 called txt_leavers_list_multichange_id and within my VB code I want to make sure this field is populated before the script is...

Ahhhhhhhhhhhhhhhh it must just be a case of missing single quotes around " & leavers_list_multichange_id & " !!! Just changed it to '" & leavers_list_multichange_id & "' and it works. :eek::eek::eek: Sometimes it's so easy to miss these things! Thank you for pointing me in the right...

INSERT INTO dbo_ipms_user_change (ipms_user_id, username, change_type, action_date, actioned_by, user_change_source, user_change_summary, user_change_description, ipms_change_id) VALUES (25484, 'JENNIFERLA', 'no change', #12/12/2012#, 'BonnieG', 'leavers list', 'Left on 09-Dec-2012.', '', )

I've uploaded a screencap of the table structure as it didn't seem to want to let me copy and paste. I think it's okay? What should Debug.Print do? I've added it into the code and I'm just getting the run-time error still.

Hmmm thanks guys. I have changed my code to this: SQL = "INSERT INTO dbo_ipms_user_change (ipms_user_id, username, change_type, action_date, actioned_by, user_change_source, user_change_summary, user_change_description, ipms_change_id) VALUES (" & ipms_user_id & ", '" & username & "', 'no...

I am getting an intermittent error with my database running on SQL server with on-click actions written in VB. The error is... When I go to Debug it highlights the following area of code as a problem: actioned_by = Environ("username") SQL = "INSERT INTO dbo_ipms_user_change (ipms_user_id...

Thanks for the suggestion, but unfortunately that makes no difference. :( I am now wondering if I need to save the other form before attempting to requery it? I have two forms open - frm_new_user and frm_get_uids. I'm getting the error on the Save command on frm_get_uids (which contains...

Great, thank you. :) I've replaced all occurences of that line with what you suggested, however I'm still getting "Property Not Found" on one form when I try to save, when the data has changed... Private Sub cmd_save_Click() 'On Error GoTo Err_cmd_save_Click DoCmd.RunCommand...

Hmm interesting. Is the syntax the same? I've changed the code as follows: DoCmd.RunCommand acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70 However I now get the Compile Error "Wrong number of arguments or invalid property assignment".

The other form's debug info is highlighting this line of code as the problem area: DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70 Again, this isn't new code and it worked in Access 2003. :confused:

Thanks so much. I really appreciate it, as it's driving me a little crazy now! :(

Ahhh thank you - that has told me the problem is with this bit: Forms!frm_new_user.Requery This code hasn't changed since the old version. Can Requery no longer be used? frm_new_user is open in the background, behind the existing form, so it's definitely there and available to be requeried...

Our department users an MS Access database file created in an old version of access. The purpose is to maintain records of what access our IT users have to our systems. Since upgrading to Access 2010 I have been getting a "Property not found" error upon using the existing Save button on...