Recent content by pkraja

To answer your question - "Is there away to set up the form so that when it opens it brings up fro example a blank record - the user enters the student number and then it autofills the student data (as it does now) but it would then automatically bring up the relevant sub form.". What I do is to...

It turns out that I needed to used the syntax Forms![Form_Name]![Field_Name] = "XXX" as opposed to [Form_Name]![Field_Name] = "XXX" . Gotta love the Microsoft error messages.

I just installed Access 2016 32 bit and ran into this issue of not being to send data to a new record in form. Error '424' Object Required. Does anyone have a suggestion as to how I get around this. I cannot add Microsoft DAO 3.6 Object Library as the name conflicts with an existing library -...

I am using Access as front end to a mySQL hosted by a third party company. My internal users can view, edit, add and delete records. My external users use a web interface to view, edit, delete, and add records. To say that Access cannot connect to mySQL hosted on the web is simply not true.

I just installed Access 2016 32 bit and ran into this issue of not being to send data to a new record in form. Error '424' Object Required. Does anyone have a suggestion as to how I get around this. I cannot add Microsoft DAO 3.6 Object Library as the name conflicts with an existing library -...

I used the information from this site to solve several problems I had in developing Access applications. I have used Access since it was first released in the 90's when I worked for a Microsoft Solution Provider.