Search results for query: *

It is working now Remou, thank you. Sometimes you just need to sleep on something and get the help of someone who knows something to fix the problem. I did as you suggested above but still got the same error message. I double checked the ApprovalType field name and realized I had renamed it...

Thanks but I am getting the same error I have been getting most of the day "Object doesn't support this property of method" Any Ideas? Code: Private Sub Command161_Click() On Error GoTo Err_Command161_Click If ApprovalType = "eo" Then DoCmd.OpenForm "CheckListEO" Else If Customer =...

Hi all, I am sure this is simple but it has wasted most of my day. I have one button on my main form that depending on the results in two seperate fields on my main form will open one of three optional forms when clicked. My three forms I want to optionally call and the criteria are...

I don't know much but this is what I did. It gives the user a chance to either discard changes or save changes to a record. If they choose to save changes it dumps the current date into the "last edit date" field. Private Sub Form_BeforeUpdate(Cancel As Integer) If MsgBox("Would You Like To...

I think what you are asking is how to hide the database window. In which case, go to: Tools Startup Uncheck the "Display Database Window" checkbox

Thx PHV it worked perfectly, Thanks all.

Thanks all for posting, I have not been back to my desk since I asked the question so have not had time to try the suggestions. I will on Monday though. @ TheAceMan1/ Currently yes Issue and Version are being used interchangeably, just another thing that will have to get fixed but it requires a...

Hi, I am working on a database which tracks drawing numbers/ letters. I have created a form / query which creates new revisions but would like to automaticaly go to the next number / letter in sequence. sometimes it is a number somtimes a letter. Version A should become Version B, Issue 1...