Search results

Show the code or post the database.

Sure it is a pain and time consuming, but …! When I have had a problem, that I not could solve with Compact & Repair or import into a new database, or try the database on another computer. I’ve created a brand new database, opened all forms and reports one at a time in the old database, marked...

With two different systems, do you mean two different computers?

Have you tried the database on another computer?

You need to surround text string with an apostrophe, numbers doesn't need apostrophe VALUES ('" & _ Me.HotelName & "', '" & _ Me.RFAYear & "', " & _

You are asking for BIG trouble, when you use Lookup fields (Combo box and List view) at table level.

You need to make the combobox unbound, else it would try to replace the value with the value from the combobox and then you'll get 2 values with the same numbers in the table. I've attached the changed database, try it..

Have you tried a Compact and Repair? Else post your database.

That would also be my proposal!

LGDGlen, thanks for the second link, that helped very much. The_Doc_Man, until now I didn't find anything about the interface, so .. shame on them, maybe I find something something later. :-) I know it would be hard, but the first step is to get some data out and I think the link LGDGlen gave...

Thanks for the link, but it is not in VBA. Others who have some suggestions?

How can I read and write data using the USB interface in VBA? I want to make some diagnostic tool for my E-bike. Does anyone have some example code of using the USB interface? Thanks in advance JHB

The control name isn't ALLOCATION but Combo32, so the event isn't triggered.

I think it is normal. We are too busy to get our idea to work, that we can't see the forest for all the trees! :) A break does wonder, is my experience. :)

Post a printscreen of the error and the actually code, or post your database with some sample data + description to reproduce the error.

Did you try to create a new database with a new form and a date picker in it? If that works okay, I would delete the control in the old database with the date picker and create it from new!

What Windows version were you running before and after the computer update? Also what version of MS-Access before and after?

I do not get the error you mention, (but something else according to the Error$)! Did you try the database you posted? Do a "Compact & Repair". And please next time, if you want people to help you: DON'T Lock anything in the database.

Could you post your database with some sample data, zip it!

The line marked with red: Private Sub Form_BeforeUpdate(Cancel As Integer) Dim strMsg As String Dim iResponse As Integer ' Specify the message to display. Beep strMsg = "Wil je deze aanvraag bewaren?" & vbLf & "Klik ''Yes'' om te bewaren of ''No'' om af te sluiten." & vbLf & vbLf...