Search results

DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70 if the commands constants are zero based then I assume 8 refers to acDelete

In the code below it seems that the 3 refers to the menuname acRecordsMenu and if the commands constants are zero based then I assume 0 refers to acNew. Does that make sense to you? Docmd.DoMenuItem acFormBar, 3, 0, , acMenuVer70 Take a look at...

I was asked to complete the VBA code in an incomplete Access database. I found the following line of code which means to save the current record: DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70 I am using Access 2010. Would it not be better to write it this way...

CJ_London Answering your statement: I'm now lost was to what you are trying to achieve I haven't coded in Access VBA for over 7 years, so I am trying to familiarise myself with the VBA syntax, while trying to write the program. My client presented me with an incomplete Access database...

I have to say that you and some of the other guys here have given me some very good coding advice over the past two days. Thanks very much for your help. Keep up the good work because people like me really appreciate it.

Thanks pbaldy I am a bit frustrated because when I fix one error, up pops the next one. I am a C# coder and struggling to get used to the VBA syntax. I incorporated your suggestion and it seems to work fine now.

I am getting a datatype mismatch error in criteria expression

It was a typo I made in my If statement, I corrected it and thank you very much I clearly missed it. you have for records 1358 and 1359 which Is it possible to leave out the else statements? I only want to write Add, Edit or View in the Allowed field and exclude the "None". I removed...

Ok I have managed to attach the text files - see attachment

Sorry struggling a bit to find the correct format. I exported the query to Word, Excel but the uploader is complaining about the file extension

Is this what you mean by "list all possible cases" - See attachments

The indexes actually caused more problems. The only reason I added them was to prevent a user from adding the same record twice. Sometimes a user's mind wonders a bit and then he/she cannot remember whether they have already saved the record - See the attachment "ResultNow". The result I...

I removed the index from the three fields and it now saves to the table - See the attachment "ResultNow". Can I leave out the 'else-statements'? Because the result I actually want is in the attachment: "Result I want"?

Please see the table structure and indexes in the attachment. I don't want users to save duplicate records that's why I added the indexes. Should "Ignore Nulls" be Yes or No?

I added the code as you suggested but I am getting an new error: Error 3022 complaining about duplicate records, because I added a unique index on FK_UserID, FK_UserRoleID and FormName. It only saved the two lines in the first else-statement:

I added and update per check box as you said, but I'm getting an error: Error 3314: You must enter a value in the tblUserPermissions.FK_UserID field. What about the two combo boxes at the beginning of the code: I amended my code and now it looks like this

I am writing a program in Access 2010. My check boxes are not saving to the table. I have stepped through the code with no errors and it only saves the last check box to the table. Here is my code: I attached the full code.

Hi Pat I managed to fix my previous code. I am now trying to run a simple select statement and I get this error: No value given for one or more parameters! The long and short is that the user logs in. When the user selects Manage Employees on the Main Menu, the Employees form must open in...

Thanks CJ_London Thanks very much for your time and wisdom, you have been a great help. I deleted the line I added the unique index to the fields you suggested and it seems to be working fine now. I am going to merge the code with the rest of the app and test it to see if everything is...

Hi CJ_London Thanks for your input. The data now saves to the table, but now when I click the save button again it saves the record again. I added a line rstPermissions.RecordCount > 0 to prevent duplicate records from being saved, but it doesn't seem to work. Any ideas? If...