No announcements
Found 320701 threads
-
1 Votescheckbox dlookup
I have a checkbox in a continuous form. if the ordernr is in the query "last ordernr final" then the checkbox is yes else the checkbox is no. in the control i ...Answered | 1 Replies | 653 Views | Created by tekoko10 - Sunday, April 13, 2014 2:14 PM | Last reply by Luna Zhang - MSFT - Monday, April 14, 2014 8:25 AM
-
0 Votes
Attempting to build a query for auto-generated text
domain). Use the DLookup function in a Visual Basic for Applications (VBA) module, a macro, a query expression, or a calculated control on a form or ...Answered | 3 Replies | 282 Views | Created by ZeroWard - Sunday, April 10, 2016 5:20 PM | Last reply by David_JunFeng - Wednesday, April 13, 2016 5:26 AM -
0 Votes
Get Value
You can either use the DLookup() function or use a query joining the two tables together. Hope that helps...Answered | 3 Replies | 244 Views | Created by Redpen Business - Monday, March 28, 2016 2:23 AM | Last reply by .theDBguy - Monday, March 28, 2016 12:20 PM -
3 Votes
DLookup Not Working??
Very sorry for my slow reply. I've still been fighting this. I do have a solution however.... I copied the SQL of the query and the name to Notepad, ...Answered | 5 Replies | 328 Views | Created by mbrad - Tuesday, August 15, 2017 3:38 AM | Last reply by mbrad - Wednesday, August 23, 2017 12:34 PM -
7 Votes
Sort a form based on a dlookup?
Access doesn't allow the results of a dlookup, run in the form itself, to be sorted/filtered/etc. By using the query you suggested...Answered | 21 Replies | 1250 Views | Created by NonprofitBecca - Friday, June 17, 2016 3:38 PM | Last reply by .theDBguy - Thursday, June 23, 2016 7:51 PM -
0 Votes
DLookUp - getting the right criterion
Rather than calling the DLookup function, a more efficient solution would to include the tblSuppliers and tblCurrencies tables in the frmSproducts form's RecordSource query. ...Answered | 2 Replies | 355 Views | Created by NK-Bristol - Saturday, May 19, 2018 9:28 PM | Last reply by NK-Bristol - Sunday, May 20, 2018 3:42 PM -
0 Votes
Equivalent of this statement in Access (DLOOKUP?)
DLOOKUP (or Allen Brown's ELOOKUP) is the answer, but so far I have been unable to get the same results. Here's my statement right now in an Access ...Answered | 3 Replies | 767 Views | Created by greenthnkr - Monday, September 28, 2015 7:32 PM | Last reply by RunningManHD - Monday, September 28, 2015 11:26 PM -
0 Votes
Dlookup multiple criteria - syntax error
hi, apologies for the late reply - i was being a bit dense, in the end i just created a query with the values and then used the dlookup to reference the query and then limit ...Answered | 3 Replies | 9556 Views | Created by RhysDavies - Thursday, April 29, 2010 1:11 PM | Last reply by RhysDavies - Friday, May 14, 2010 1:34 PM -
5 Votes
SQL to string.
For DFirst/DLast you shoud use sorted query. For your case i think better is DLookup (http://msdn.microsoft.comAnswered | 6 Replies | 1121 Views | Created by UpTide - Wednesday, July 3, 2013 7:59 PM | Last reply by UpTide - Friday, July 5, 2013 12:37 PM -
2 Votes
DLookup equivalent?
A DLookup in Access is functionally equivalent to using a separate, filtered dataset in Reporting Services. The quick answer to your question is No - you must have a separate dataset to ...Answered | 1 Replies | 6002 Views | Created by voyager_87 - Monday, July 6, 2009 6:16 PM | Last reply by Paul Turley - Wednesday, July 8, 2009 6:26 AM -
0 Votes
dlookup in unbound text box report
of these 5 queries. This new query will be the recordsource for you report. Don't use DLookUp, DCount and other Domain functions too much. If you want to add 1 ...Answered | 5 Replies | 3771 Views | Created by KIWI DAVE - Tuesday, May 17, 2011 6:38 AM | Last reply by KIWI DAVE - Wednesday, May 18, 2011 6:23 AM -
0 Votes
Retieve Data from a table
You can use the DLookup() function (look in Help) or you can open a recordset and read the data manually from the table or via a query (you need some VBA coding expertise to do ...Answered | 2 Replies | 641 Views | Created by DonnaLPorter - Monday, June 10, 2013 6:23 PM | Last reply by QA Guy CommElec - Monday, June 10, 2013 7:27 PM -
0 Votes
Access DLookup conversion to SQL Stored Procedure
Hi I am not very competent in Access so forgive me please. I have inherited an Access Database that uses DLookup but, I need to take this control out ...Answered | 1 Replies | 1193 Views | Created by Darrylw99 - Thursday, August 20, 2015 8:30 AM | Last reply by Alphonse G - Thursday, August 20, 2015 12:53 PM -
0 Votes
AutoComplete
Hi, you can use DLookUp http://msdn.microsoft.com/en-us/library/aa172176(office.11).aspx or SubFormAnswered | 3 Replies | 4771 Views | Created by Seductiv - Sunday, August 29, 2010 4:48 PM | Last reply by Bessie Zhao - Monday, September 6, 2010 9:39 AM -
0 Votes
Using DLookup to Populate a Field
;=[Forms]![MyFormName]![FieldA] Then refer to that query in the VBA DLookupAnswered | 8 Replies | 400 Views | Created by Christopher_Beard - Thursday, December 27, 2018 3:14 PM | Last reply by DriveEV - Thursday, December 27, 2018 6:35 PM -
0 Votes
DLookup with 3-field criteria
"The expression you entered as a query parameter produced this error: 'WarF'". The code is: DLookup("[Adjustment]", ...Answered | 4 Replies | 611 Views | Created by Barry J M - Friday, January 30, 2015 4:07 AM | Last reply by Barry J M - Friday, January 30, 2015 11:26 AM -
0 Votes
dlookup values from two different linked tables?
relationship to a table called MMAssetType that contains a foreign key from both tbl_Asset and tbl_TypesList. I was wondering if Dlookup would be appropriate for ...Answered | 3 Replies | 7351 Views | Created by Christnia Glabas - Monday, September 20, 2010 7:57 PM | Last reply by Christnia Glabas - Monday, September 20, 2010 10:00 PM -
0 Votes
Runtime error 2471 - DLookup
CusType = DLookup("[ID]", "Customer List"Answered | 4 Replies | 1314 Views | Created by Abzal Ali - Saturday, July 26, 2014 6:43 AM | Last reply by Abzal Ali - Saturday, July 26, 2014 12:46 PM -
0 Votes
DLookup issue
operator) in query expression 'ITEM = 1000 And VENDOR = 24268' AND R_STATUS = "0".<<Answered | 2 Replies | 307 Views | Created by HendersonMikeWNC - Friday, May 13, 2016 5:50 PM | Last reply by David_JunFeng - Monday, May 16, 2016 2:47 AM -
1 Votes
Mulltiple fields in Dlookup command
The help file says the third argument of DLookup is a string. So you have to concatenate a string, that is essentially a SQL Where-clause without the word ...Answered | 2 Replies | 377 Views | Created by ballj_351 - Monday, September 3, 2018 10:34 PM | Last reply by ballj_351 - Tuesday, September 4, 2018 2:31 AM
No announcements
