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
1
vote
2 answers

MS Access Subform conditional format based on data on a table

My database has a Form view for the Lab to input the results of their tests to each batch we produce. I have a query as Subform data source and I use a date combo box for the lab guys to see the production for the day. My problem is that when they…
Guilherme Brum
  • 51
  • 6
0
votes
1 answer

Is there a way to use a query/VBA to fill in empty cells within a table?

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 to VLOOKUP in Excel. Is there a way to use…
Joe Beck
  • 3
  • 4
0
votes
0 answers

What is the correct way to create an IIF expression with DLookUp in Access?

My name is Jaime and I'm been building a Access DB from scratch, looking and watching information in the internet, so I'm a totally rooky on this, looking for some help from this great community. I Hope someone can help me. I have a form…
James Leri
  • 1
  • 1
0
votes
0 answers

Type Mismatch Error when using DLookup on a date field

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…
TileHittinMofo
  • 19
  • 1
0
votes
1 answer

DLookUp not working properly in Microsoft Access

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 ($) Query 1: Cost of CNC Fields: Quote #, Part #, CNC…
Rose Lavoie
  • 1
  • 1
0
votes
1 answer

prevent duplicates when passing values between two forms (with Args)

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].[Form]![transfertadetailid] under Private Sub…
fredi
  • 1
0
votes
0 answers

Join query using between

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 tblMyData.LineNum Between ([tblBudgetRange].[fromLine])…
Joel
  • 1
0
votes
0 answers

Circuit tracing in Access

Im trying to build a database of equipment in Access, and I need to trace circuit nodes downstream. The first table shows what is downstream from what. Column C is downstream from Column B, which is downstream from Column A, etc. I need a Column D…
Henry Stahl
  • 1
  • 1
0
votes
1 answer

I run the following Dlookup expr to return prices from another query

Expr1: DLookUp("[price]","[query1]","[converted]<=" & [converted] & " And [item]='" & [item] & "'") when converted is a date mm/dd/yyyy converted with CDbl(because i thought that I was wrong writing Expr with date criteria) But again it return…
fredi
  • 1
0
votes
1 answer

Problems Searching in Access

Wonder if any of y'all can help me. I keep getting errors on this. Here's my table: - tblCutting - PartNumber (Primary Key Text Field) - CuttingStep1 (Number) - CuttingStep2 (Number) - CuttingStep3 (Number) I'm trying to use a…
IndianaRedneck
  • 3
  • 3
0
votes
1 answer

Retrieve field data from other table

I have table#1 which contains customers pending invoices, and table#2 which contains customer master data such as their email addresses. I'm trying to create a button in a form based on table#1 to send the pending invoice number by email. I couldn't…
Faisal
  • 1
  • 1
0
votes
0 answers

DLOOKUP Value In textbox Unable to save into table MS Access

After having a successful Dlookup function,am able to autofill my two textbox, one for the combobox and the other for the text,but now,when I click save only the combobox is able to save,the textbox is not saved in the table.how can i save both by…
Ernest Murimi
  • 1
  • 3
0
votes
1 answer

Using textbox to update another text box in MS Access

I am trying to update a textbox#2 based on the value in Textbox#1. The value in the textbox#1 is taken from from a string using " Mid([ScantheCode],1,10)" from ScantheCode box. I have tried couple of things but I am getting #error or #name. I am…
rohan n
  • 1
0
votes
0 answers

case sensitive compare password when found the id with dlookup

I want a code to lookup for a username and compare the password ( case sensitive ) using the dlookup here is my code and it doenst care for the pass if it is capital letter nor not If (IsNull(DLookup("UserName", "UserID", "UserName='" &…
walid761
  • 35
  • 3
0
votes
1 answer

Combining Dlookup with IIF function to check for a record

I am trying to use DLOOKUP to check another table for the current form record, and if it returns null (ie other table doesn't already have it) then to proceed with Appending the current record. I have two tables, both connected to their respective…
Zrhoden
  • 57
  • 7
1
2
3 4