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...

After redoing parts of the code, and using your code instead of mine I got it to work. I'm not sure if it was the new code, or becuase of something I changed in the second try, but it works now. Thanks for your help :)

The message box returns true and false, if it is true and false. The checkbox always is unchecked though, and just in this area. I started taking parts away and I am currently working on that now trying to figure out why it doesn't work here but everywhere else.

That is there incase someone enters a number into the list that does not exsist in the table so there isn't a search error. Rather than brining up the error it just exits the sub.

Ok here it is then: Private Sub snlist_Change() Dim strSQL As String Dim db As DAO.Database Dim rs As DAO.Recordset Set db = CurrentDb ' Search for when an item on the list is changed If switch2.Enabled = True Then If IsNull(SNlist) Then Exit Sub End If SNsearch = SNlist OrderSearch...

Nah that's just the parts I'm having trouble with. The rest of the code works (I did add the recordset too, I have Set rs = db.OpenRecordset(strSQL) )

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...

Thank you, that solved the problem :)

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...

Ok I got it. forms!ptquery!searcha ended up working, for some reason it didn't save when it the first time when I did it (Even though I am pretty sure I hit ctrl-s, I guess I forgot). Thanks your help and quick responce, hopefully I won't have anymore problems.

They are in the form. The query isn't the same name as the form either.

Yeah ptquery is the name of the form not the subform. If I change it, it still brings up every record, not just the ones filtered by the search.

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...

It's not in query mode, it's in the form where this shows up. Though I take it that extra blank record is what is causing the problem though so if there is a way to get rid of that I think it would fix what I am having an issue with.

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...