Stack Overflow
Stack Overflow

Questions tagged [dlookup]

DLookup is a built-in MS-Access function to get the value of a particular field from the set of records or data from table, query, SQL, or Recordset.

60 questions
0
votes
1 answer

Decoupling Win authentification, ODCB driver authentification and SQL authentification - ODCB auth error and DLookup error

I'm trying to connect a user to my company's postgreSQL Server to access a postgres database via MS Access 2019. Connection should be established via ODCB driver. I manage the following server via Plesk and…
Anna Valla
  • 1
  • 2
0
votes
1 answer

Why is Access Dlookup Formula Giving Compile Error

so here's my problem. The below works: =DLookUp("[CylindersCompleted]","WO_User_Input_Save","WorkOrder=331091") Unfortunately I need 331091 to be Combo4. Once I change the formula to: =DLookUp("[CylindersCompleted]","WO_User_Input_Save","WorkOrder"=…
VBA_Noob
  • 3
  • 1
0
votes
1 answer

Matching values from another table - access

Hoping someone can help me on this. I have two tables where I am trying to grab a field from one table if it contains a value. Table 1 Value Level Officer C-Level Exec C-Level Table 2 Title Level2 …
rockies2
  • 1
  • 2
0
votes
0 answers

Microsoft Access DLookup Syntax Error when using button's 'OnClick' Event

Good Morning, I am trying to use a button's OnClick event on a subform to update a textbox control on the main form each time the button is clicked. I get the following run-time error: Run-time error '3075' Syntax error (missing operator) in query…
Nick Barnes
  • 41
  • 4
0
votes
2 answers

Opposite of the Dlookup function

the Dlookup function retrieves single data from a table. Is there a function that works the opposite of this? Exports data selected from the form to a given table. It cannot be anything from SQL. Opposite to Dlookup??
mokko kolo
  • 1
0
votes
1 answer

Create query that calculates the due dates using Dlookup

I am trying to use a module as of of my fields for a query that looks up the frequencies of a training and how long until it is due for a certain employee. I have a table which holds all the employee info (Workday_Excel_Update) as well as the…
Br0grammer
  • 9
  • 2
0
votes
1 answer

Dlookup Returning the first field from the list regardless of the criteria

I am Working with a form with a combo box (LaborType) and a text box (LaborCost1) I have the following code on the after update event of the combo box and it returns the same value no matter the criteria. [LaborCost1] = DLookup("LaborCost",…
Jesse
  • 1
  • 1
0
votes
1 answer

Access DLookup RunTime 94 error - Invalid use of Null

I want to obtain the lower_limit value searching from the table Threshold where it is stored but I'm always getting: "Error RunTime 94: Invalid use of Null value". I don't want the subroutine to give me back lower_limit, its only useful for the…
Lea
  • 15
  • 5
0
votes
0 answers

I'm using the Dlookup function not working as it should be

'I have a Table name PublicHolidays that contain fields name : 'PHA_ID as key field 'PH_Holiday as a foreign key 'PH_Date as a short date 'On a form a date is requested as M_Date 'The After Update event of M_Date is as follows : Dim…
Mahess
  • 1
  • 1
0
votes
1 answer

Set DefaultValue in Access form to last record of a table

I have an Access form with a text box named Box1. In this text box, I want to have the name of the last product in my table Products as the default value. My table product has the fields: P_ID and P_Name. I have coded in VBA in the…
Acces124
  • 1
  • 3
0
votes
1 answer

When importing an Excel Sheet to Access using VBA how do you overcome slashes in the cell causing runtime 3075

Found a similar post on this question, but it was using an SQL Query and I'm using a DLookup. I'm importing an Excel sheet to Access. I'm getting the run-time 3075 - Syntax error (missing operator)... '[Component]='don't have/want a car'. That…
Slick2000
  • 21
  • 4
0
votes
0 answers

MS Access VBA: Fetch data from a query which corresponds to an ID field from a selected row in a subform table

I'm completely new to VBA and MS Access! I have a Subform within a form which contains data about items which all have an "Equipment ID" field. Using data from a different table, I have a query to count the number of "faults" associated with each…
Char95
  • 1
0
votes
1 answer

vba access Dlookup with dates in dd/mm/yyyy forma

I'm trying to get a value using a DlookUp, the problem is access formats my dd/mm/yyyy into mm/dd/yyyy despite using the Format function. muestraAguasDatos = Nz(DLookup("[name]", "samples", "[location] = '" & location & "' AND ([name] LIKE '*ACRT*'…
adrian
  • 97
  • 2
  • 12
0
votes
1 answer

I want to check duplicate values of two field in single table using Dlookup function

enter image description hereI need to check duplicate values in two fields on a single table. I need to check duplicate entries for particular employers' EMPNo (Employer Number) and EMPDATE(Employer Attendance Date). I used the following code but it…
Franz Asoka
  • 1
  • 2
0
votes
1 answer

How to code DLookup using multiple combo boxes?

I've been wrestling with how to code a DLookup on a form. I have two Combo Boxes (one Employee, one Training Class Name) and need a message box to pop up if an Employee has already taken a class. I am grabbing on record from the Employee table and…
Kimi
  • 1
1 2
3
4