Search results for query: *

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 have 2 tables: PurchaseOrderTbl & LineItemTbl PurchaseOrderTbl contains information on each PO like vendor, total amount, etc. etc. LineItemTbl contains information on each line item of the purchase order - I need this separated because different line items can be charged to different work...

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?

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 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?

I have multiple records for a set number of people, 4 records each,I need to extract only the top 3 records for each person...can someone tell me how to do this?

I have a report based on a query, the numeric field is formatted as currency with 2 decimal places. When I use this table or query in a report it rounds the numbers in this field. We have changed it to double, single, and long integer but it keeps rounding. How can we get the report to...