I am seeking to create a multi criteria DLookup for my DB and have not had much luck. I have a db, has 1 form with 3 sub forms sort of like a cascading combo. Lets say I put "Test" in first ...

The premise of my database is an automated process for the Championship tables for a motorsport club I am in. There is a Driver table of race number/name and a results table for entering a finishing ...

I'm using a Excel 2016 with Database Access 2016 too. At home the code run perfectly, but in my office the same file getting a error in this line: varX = DLookup("[Código]", "Campanha&...

Please bear with me. I am still new to Access VBA. TBL_Orders is an external source = SharePoint list linked where entries are now 5,000+ and will keep having more entries. Ordered_By is a field of ...

I need to create a unique ID based on 4 fields in a table - all are strings, despite 2 that look like numbers. Two of those fields are determined by user input on a form. A 3rd is based on the 2 ...

I am fairly new with Access so please forgive my newness. The database I am working on is to calculate pay based on piecework from subcontractors. I have been using DLookup to pull the quantity of ...

I'm trying to work and understand how to deal with dates in ms access vba and tables. I have this variable: Dim locking as Date locking = Now then I proceed and update some table from vba with the ...

I'm new to access and im creating a search on Microsoft access. It takes the name field has an input to check, then provide a link to a PDF. I've got it working, but I'm trying to add a criteria that ...

I am working with Access version MS 365 Apps for enterprise (desktop version). When I try to get a specific field value out of my table, I instead get the equivalent to an empty or null result. I'm in ...

I have a table [RPG] that sometimes contains empty cells after an update. To fill those cells I need to reference another table [SITELIST] and specific fields on that table. It sounds very similar ...

I feel like I have done adequate research and come up empty handed so I now pass it off to you. Pretty simple, really: I am getting a type mismatch error in the immediate window with the following ...

Trying to pull the value in the Query to populate Form Field, not working with what I've tried. Table 1: Quote Data Fields: Quote #, Part #, CNC Hours Table 2: Rate Chart Fields: Rate Type, Cost ($) ...

I have two forms: transfert Form with its subform and intransfert Form. I am using DoCmd.OpenForm "intransfert", , , , acFormAdd, acDialog, Me!Text83 (where text83 is =[transfertasubform].[...

I have about 10 forms in my access and in all of them I need to put some basic information like, date and user, to do that I use the same code on all forms, I'm searching a form to set this ...

I have made this work before, but I can not find it and do not remember how. SELECT tblMyData.ID, tblMyData.LineNum, tblBudgetRange.[Budget Name] FROM tblMyData INNER JOIN tblBudgetRange ON ...