Search results

Hello, I’m trying to get a macro to run on access. I tried to do the command quit to close Access after the macro runs, but it doesn’t work it gives me the error: The Command or action ‘Quit’ isn’t available now. * You may be in a read-only database or an unconverted database from an earlier...

Alright hopefully this will be my last problem. I have the search going, and if a user enters a item number it will bring them all up with a list of serial numbers they can choose. When they choose a serial number it should bring up all the info for that serial number. One of the items that...

Hello, I am having a problem with my SQL update statement, maybe someone can tell me what i have wrong. Here it is: strSQL = "UPDATE [Printtable] SET [ReprintNum] = '" & rp & "' WHERE [SerialNum] = '" & SNsearch & "'" CurrentDb.Execute (strSQL) All on one line I keep getting the error...

Hello, I'm trying to use a subform to display a query. The user can enter any two search criterial and I want the subform to bring up all the records that match it. However the problem is when i do the requery for the subform it brings up every record and they have to scroll though each of...

Alright, maybe someone can give me a hand here. I'm made a search query, where the user can enter either one or two items on a form. If they do, it comes ups with the field that they searched for. This works great, except it also brings up one empty field with no data what-so-ever. The form you...

Hello, I have a form set up to do an undo macro if the person leaves it. This is becuase if they change some info in the database which they can do on this form it's a perm change. The undo is to make it so if someone leaves it's not perm. That works fine, problem is: If they requery it or do...