I have a report that is based on a list box in a form - the user is to pick items from the list box and then a report runs filtered on the list box ...I have tried it 2 ways ...both ways I get an the following error
"EXTRA ) in quiery expression '(Name =)'
HELP!!!
First Way:
Private Sub...
I need a field in a form that can do one of two things .... if the field contains a badge number then add the corresponding employee name from a table or if the field has no badge number then let me add my own employee name
Is this possible?
I'm not the original poster, but I have a db that I need to email reports from and we use Lotus Notes - can you post the code to use Lotus Notes...p. l. e. a. s. e.
thank you!
...$80.00) in the field LineItemAmount in the LineItemTbl
(I need access to calculate the Line Item amount) i.e. LineItemAmount = $20.00 (purchase order total amount from PurchaseOrderTble * percentage from LineItemTbl entered by the user)
I don't mean to ramble - just want to draw a clear...
TO RICK39:
HELP - I tried your idea and it lets me enter a new data, but I don't get the message box and it doesn't keep the entry in the table...here is the code I added to my combo box in my form
Private Sub Craft_NotInList(NewData As String, Response As Integer)
Dim db As Database, rs As...
We are getting this message:
Error No.: -2147467259
[Microsoft][ODBC-Driver Manager] Driver's SQLSetConnectAttr failed
SQLState: IM006
What can I do to fix this?
Well, I am guilty of doing things the hard way, but this time I ended up just writing a Trim statement to get rid of all the dashes and it worked just fine!
Thanks to everyone for the tips.....
Figured out a "beginner" way to do it - I just changed the input mask on the field with no dashes to include dashes and then I ran the query to compare the 2 fields...thanks for all the help, I would like to know exactly how to do it the correct way if someone doesn't mind taking the...
Well, I'm too much of a beginner for this, I put the function in the Access module, and the formual in the query, but when I run it I don't get any results at all - what am I doing wrong?
I have a field that was imported from Excel - I need to compare with another field - the one imported from Excel has dashes and the existing field does not. I know that I can use a trim statement, but I can't get it to work:
here's an example
is: 123-45-6789
needs to be: 123456789
Can...
I tried the suggestion from jebry on Sep 30, 2002
NewTextField: Format([mytable]![mytextfield]," ")
and also the leading zeros one
the leading zeros works fine, but I can't get it to put in the leading spaces...
here's what I used
newreason: Format([table1]![reason],"...
I have a db that all the fields are will be exported in txt format into another system, in one field the users will enter a 5 digit number but when it exports in txt format it needs to export as an 8 digit field
Example:
user enters 12345
exports as 00012345
Any suggestions?
Never mind, I got it:
SELECT Table1.member, Table1.time
FROM Table1
WHERE (((Table1.ID) In
(SELECT TOP 3 tbl.id
FROM table1 AS tbl
WHERE table1.member = tbl.member
ORDER BY tbl.member, tbl.time DESC)))
ORDER BY Table1.member, Table1.time DESC;
I tried it but I'm doing something wrong:
SELECT table1.member, table1.time
FROM Table1
WHERE table1.id IN
(SELECT TOP 3 tblgbt.id
FROM table1 AS tblgbt
WHERE table1.time = tblgbt.time
ORDER BY tblgbt.member, tblgbt.time DESC)
ORDER BY table1.member, table1.time DESC;
my table:
ID...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.