Search results

I have a set of nested forms (image below) where I have an input box on the main form that I need to set to null on form open and I need the results to be displayed in the second form. This second form is based on a query and is where we will be editing the data. Using a form that was...

I have a series of update queries that I have to run on my data set. These queries set a series of different values. I have it set up for the queries to run one after another in VBA but I still am being asked if I want to update the data. Here is the command to run the query...

I have a query where I need to exclude all items which has a value of CSS in a text field. I am using <>(InStr(1,[tblStarsMaster]![strSalesOffice],"CSS",1)) as my criteria, but it is not working. What in the world am I missing? Or is there a better solution. Thanks

Ok everyone here is my situation. I have an Access 2003 DB and I need help merging a user login db that I found. The Login DB has the following tables : Tbl-Users tbl-Permissions 1 Form : FrmLogin and that form has a nice set of VBA code sitting in it that handles all of the management of...

I am new here so if this has been asked before please forgive me. Ok this is a real head scratcher for me. I have a linked Excel file that until a couple of weeks ago updated just fine. It is the source data for my data base which I am using for various department reports. Now every time...

Have a data set where I have the following. Each month certain items are moved from a one status to a new status. When that status is set and the date field for that status is changed I need the month for that date to be populated in a third field Example: [Item] [Booked Status] [Date...

New to here, have been given a new project which will require me to do some detailed access design and programming. Have a background in VBA but very limited in Access, for now.