Search results

is there an alternative to the .seek method that will work for me? Ive tried Mytable.FindFirst Forms![Vehicle Profile]![VIN] instead and I still get the same error

Is there an alternative to the .seek method that will work for me?

Ok, after debug, it highlighted "Mytable.Index = "VIN"" and when I hover over it, it says "Operation is not supported for this type of object"

Ok added Microsoft DAO 3.6 Object Library, tested the database and still had the same error when I clicked the button. "Operation is not supported for this type of object"

The conversion was done through access. The database started in 2003 .mdb format, Through the Access office button I hit convert, and it converted/saved it as a new .accdb file. Both the front end and back end are 2007 .accdb

When I try and add Microsoft DAO 3.6 Object Library, i get "Name conflicts with existing module, project, or object library"

Still the same. The message was "Invalid Operation" when i used DB_OPEN_TABLE. Now I have DB_OPEN_DYNASET and the error instead is "Operation is not supported for this type of object"

Yes the database was created by someone else. My job was to convert it to Access 2007 and then make a backend. In the VBA no errors come when I compile the code. The error just comes when i run the database, does not give me an option to debug then, just "ok".

I've tried changing "DB_OPEN_TABLE" to "DB_OPEN_DYNASET" and instead of invalid operation, I get "Operation is not supported for this type of object". Any ideas??

My database was working fine before an access back-end was created. I was able to click buttons on the form that took me to other forms. Now after the database was split, when I click the buttons, I get an "Invalid Operation". Here is the code behind the button. Does something need to be...

Your right, I see where the mistake is, I set mytable twice. Set MyDB = DBEngine.Workspaces(0).Databases(0) Dim strSQL As String strSQL = "SELECT * FROM [Vehicle Operating Data] WHERE VIN = '" & Me!VIN & "'" Set Mytable = MyDB.OpenRecordset(strSQL, dbOpenDynaset) This now works...

Hopefully I make sense when trying to explain this.. Before I split my database into a front and backend, the code blocks listed below worked fine and the buttons on the forms did what they were suppost to do: Dim MyDB As DAO.Database, Mytable As DAO.Recordset, x As String Set MyDB =...

As of right now I was just testing the visibility functionality and did not add in the user-level access.

No errors, just acts as if the code isnt there.

I have a maintenance button on a form that I want to be visible/invisible based on user-level security access. However for testing purposes in the form_load I set the button to be invisible, but it is still visible. Here is the code: Private Sub Form_Open(Cancel As Integer)...

I know "Me.btnMain.Enabled = False" will work in the form that the button is in. However, what code can I use to enable/disable a button on another form from a module?

Oh jeez, I didn't think about that..:o. I guess it's too early for me to be messing around with databases. Thanks a lot!

All the textbox shows is #Error

I have two forms (form1, form2). Form1 has a combo box named "Owner" which lists locations. I want a textbox in form2 to update with whichever location the user chooses from form1. Im using the DLookup function: =DLookup("[location]", "tblAddress", "[location] =" & Forms![form1]!Owner) Any...