dieselrocks
Last Activity: Apr 19 '10, 08:46 PM
Joined: Mar 17 '09
Location:
-
Incorporate/Utilize Built In Search Function
I have a form that among other things list the first and last names of customers. I need to add a command button that will allow the user to search on last name. Is there a way to program the command button to utilize Access' built in search feature (i.e. CTRL F) to do this?? If so, how could I just limit the search to 1 field (Last name)? -
Thanks Linq, your advice was right on! -
One more time....It's a zip file containing a DBF...Leave a comment:
-
Here it is. I exported it to a dbf. Some of the values are formated mm/dd/yyyy some are mmddyyyy.Leave a comment:
-
I'm working in a querty window...Gettin g some strange results...Here is my formula: AcDate: CDate([action date]).
Most of the result fields contain this: #ERROR.
A field with this value 02/04/2009 Returns 10/29/7490 ??????Leave a comment:
-
Convert String To Date
To the Experts: I have a string field I need to convert to date format. I have the following formats:
mm/dd/yyyy
mm/d/yyyy
m/dd/yyyy
m/d/yyyy
What to do?? can I use Cdate?? if so, how to get around the different formats?
Thanks!! -
AJ,
The trim function worked....Thank s!!Leave a comment:
-
I get James.......Jon es......
instead of
JamesJones
the dots represent spaces in the first exampleLeave a comment:
-
Join 2 Fields...Results Not What I Expect
When I join 2 fields together, I'd expect to get just the values without spaces. However, when I join the first and last name fields I get:
James Jones
instead of
JamesJones
Any idea???? -
Linq,
ALL PCs are using Access 2003. I will look into the information you sent me. Thanks!Leave a comment:
-
Disappearing Drop Down List
Need help on this one. I have a DB that multiple users have access to from various servers. (The various users map a network drive to gain access to it). On one of the forms in the DB there is a drop down list populated by a query. The strange thing is some users can see the contents of the drop down list; other can not. It's like it's invisable as opposed to blank, because if you scroll down the list and click on the "invisable" list,... -
Password Prompt if linking one database to another
Hello,
I have an Access DB that I want to link to another Access DB. If one of them has a password, will one be prompted to enter the password once the first DB tries to link to the 2nd DB? -
As usual, you're right on, Stewart. Thanks!Leave a comment:
-
Deleted Records Still Show
Hopefully someone can shed some light on this. I have a table in a DB that is linked to another DB I deleted several records in the linked table. They no longer show up in any of the tables, but when I view the form that is linked to the table, the deleted records still show.....what is going on??? -
Stewart,
Thanks for your wisdom...it WORKS!!!! Glad I found this web site....I'm sure I'll be back!!
p.s. thanks to you too Dan2KxLeave a comment:
-
Thanks, but, no cigar....
I made the changes but once I click OK, access converts the code to this:
=DLookUp("order received","qryo rder received","[order ID] = " & Forms!mainform! order id)Leave a comment:
-
I think I have the code figured, but I only get #error for results. Here is my code:
=DLookUp("[order received]","qryorder received","[order id] = " & Forms!mainform! order id)
Order ID is text. Does it matter that on the form, orderID has an input mask? I believe the value is stored without it.Leave a comment:
-
Thanks for the insight and sorry about the posting error. I read the inital post and thought it might be an easy follow up question.
Back to my issue. I understand your directions. I created a seperate query named qryOrder Received to obtain the information needed. I plan to then use the Dlookup to obtain the corresponding value. However, I'm still struggling with the code. First, the record source for the order form is not...Leave a comment:
-
DLookup
Stewart/NeoPa,
I'm having a little trouble getting the syntax correct on a Dlookup. I have a form with an ID field on it. I want to match that ID to another field in a table. Once it finds a match, I want to retrieve the value of a different field in the same table. Here is the code:
To clarify,...Code:=DLookUp("[Order Received]",("Orders"),"forms![mainform]![orderID]="[EbayOrder], [orderID]"
No activity results to display
Leave a comment: