Search results for query: *

Hello, I am using Access Database 2002-2003 and this is a question regarding an Add Record form with subform and several linked combo boxes. I am creating an order entry system. Half-way through the testing phase one of the users (the department head) decides that it would be a good idea to...

The back-end or the front-end?

I have this occasionally recurring problem that I would like to have fixed. I have searched the Knowledge base, Googled and searched Tek-Tips and cannot seem to find anyone else with this error. We are running Access2003 SP2. I have about eight users the database is a split database with the...

1. I have Break on UnHandled Errors It Highlights While obIE.Busy = True after both the obIE.navigate vURL and the obie.visible 2. I changed all of the obie.busy to the obIE.Object.Document.ReadyState <> "complete". and will see if it works today. 3. We paste on average about 600 notes each...

I created a form that loops through records pasting the information onto the vendor’s website and then moves onto the next record. The problem is that sometimes due to a slow connection either on our side or the vendors, the code debugs due to the page not pulling up in time. I wrote an on...

Ummm... Found the answer. I hope no one started to look into this. Just in case someone wants to know the code is as follows: <SCRIPT language=vbscript event=ondblclick for=CSGACCTNUMBER> <!-- Dim vURL Dim strCSGACCTNUMBER strCSGACCTNUMBER =...

I have a data access page that pulls data from an access database. The records are in a Tabular format on the html page. The page lists 20 records at a time. I have an on dblclick event that when you double click on the account number is supposed to open a http site that lists the account...

I am sorry, She has her printer defaulted to a HP Printer and is able to print other applications.

Hello, I have 4 users on a DB. It is ACCESS 2003. It is a Split-Database, with the front-end sitting on the C drive and the back-end on the server. All but 1 user can open the reports. This user can do everything else. When she tries to open a report using the switchboard she gets ERROR...

This was exactly what I needed. Thank you very much

Hello, I have built a Access Database to keep track of Defective Returns to the Manufacture. To Return Equipment we must apply online for a Return Authorization Number. All data needed is in the Access Database. The Return Department is currently copying and Pasting the Data onto the Web...

I have a form that uses a dlookup function. However, I also have the following: A Table with Part Information, for example: tblPart tblPart has the following field: PartNo, PartDescription, PartCost, PartInvPrice On my form, I have a combo box that refers to the part field in tblePart...

Please give the Error, it helps

Got it. Thank you very much

Hello, I am using a form to send out report (queries) to multiple accounts limiting the report to records with their account #. The report is in excel format and comes from a query. Everything works find, except my Yes/No fields show up as True/False. My Boss wants Yes/No. The Table format...

That just never occurred to me I was so sure it had to be something complicated. Thank you so much

Hi, I have a problem; I have a form that explains how to import SerialNumber Scan sheets, which are scanned in under a PO Number into access. On this form, I have an On Click event that says: Private Sub Label13_Click() DoCmd.OpenQuery "QueryListPurchaseOrdersStore10", acViewNormal, acReadOnly...

This works great, I never thought to specify each character in the expression. Thank you so much. :-D

Hello, I have a table of Scanned Serial Numbers. Our Serial Numbers are 12 characters and are alphanumeric. Sometimes the scanner will create a bad scan, it misses or adds characters, or adds a $ sign or some other symbol. I need to filter out the bad scans, and update them as such. I cannot...

Yes, sorry about that. An ex: is below. I want the query to pull only the current fiscal year. However, whenever I try to put Year (Now ()) in the FY Criteria it would not work, so I tried 2004 instead and still got the Data type error. A date such as #10/01/04# does not work either. Query...