Search results

I have download the code 39 font and which location should I stored and unzipped it so that Access 2003 could easily access those font files?? Thanks!!

Sorry that my Access is a Chinese version and I could only manage to explain what's my problem and the error message complained by Access!! Firstly, I create a form and sub-form relationship of which the sub-form linked with a combobox on main form. When user wondering in the combobox, the...

which barcode font is suitable for my case ?? Thanks!!

I have created a new ID in the Accessforums.net, for the above post. WHen I tried to download one of the Zip file in the above post, the system rejected me and explained that I am not have the right to download and access that post!! Is there anyone kind enough to download that Zip file for me...

I have created a new ID in the Accessforums.net, for the above post. WHen I tried to download one of the Zip file in the above post, the system rejected me and explained that I am not have the right to download and access that post!! Is there anyone kind enough to download that Zip file for me...

YEs! FIle = table!!

I stored invoice number in an invoice file which store unique data such as invoice date and invoice total etc, and in a transaction file with all relevant transaction data record! What I want is to create a bar code for my staff to just scan and can get all invoice data for a particular invoice...

May be I put it on the top of an afterupdate Sub, let me try to put it in another place. Is that Open recordset only worked within a Sub but not for all Sub Environment??

I have the following VBA to open a MSQUARE file.... Set TRANS3 = db.OpenRecordset("select * " & " from MSQUARE", dbOpenDynaset) Then, I would like to close it but I tried the following coding and not working as a result!! Any idea?? Thanks!! CLOSE DoCMD.CLOSE TRANS3.CLOSE

Barcode font seems is font for watching and printing barcode. However, I still don't get any idea of how to create a barcode when a new invoice with invoice such as W1234334 created!!?? Any further ideas? Thanks a lot!!

Thanks Uncle Gizmo. However, Uncle Gizmo only gave an idea of how to store it. In fact, I don't know what's barcode font either!! After some wondering in this site, I still don 't have any idea of how to create a barcode based on my invoice number. I got some hints is to involve a ActiveX. But...

I am newbie to barcode but I need to generate barcode for my invoice with the invoice something likes W12675679. Just want to know how to generate barcodes based on that type of invoice number, and how to store barcodes in ACCESS 2003! Thanks a lot for any ideas!!

I have an input box and wanted user just to input 7 digital data. However, I am afraid user may enter string data. Is there any way to check and ensure user can only input 7 digital data to that input box? Thanks a lot!!

How to set up when an user open his/her computer, an ACCESS program will then be run automatically and exit without being noticed!!?? Thanks a lot!!

IT seems ISNULL(NAME) and ISNULL(AMT) worked well!!

In my table, I got text fields and numeric fields, however, sometimes, user put an empty field in some records which I disliked. I try to put some checking such as following syntax to check those empty field but nothing happened. Am I missing something?? Any idea?? Thanks! 1) If len(NAME) = 0...

Thanks all! I used another way to work it out!!

1) when using "between", the query return all results from thousand to unity. 2) when I put "!" instead of ".", the query simply reacted the same as before, ie. show nothing!!

I have put the following criteria in a query form, but not working! >[forms].[custloss].[dayloss1] And <[forms].[custloss].[dayloss2] I have tested it with input parameters said 7 and 15 in the query form according to query asking for entering the data for dayloss1 and dayloss2. The result...

I got some transactions with sub-total as a row for each invoice, and Grand total as the last row. In Excel VBA, how to make those sub-total and Grand Total row with bold format cause one of customer made this request. Thanks a lot!!