I will be out of the office starting 12/31/2002 and will not return until 01/02/2003. I am currently out of the office - returning Thursday, Jan. 2nd...
Sarah, I would put all the fields you need in a query and generate the labels from the query using the label wizard. You can select the type of Avery label ...
ADO is in fact the direction of the future, in that MS are phasing out DAO. So yes you can use it. For local stuff (dynamically re writing pass through queries...
Hi Everybody, We at Yamaha are upgrading from Access 97 to Access 2002. Our operating system is Windows 2000. After using the automated conversion feature in...
Happy New Year To Everybody. I have a access file1 protect with database password. then, I have another access file2 try to connect to file1, could somebody...
Lum Pooi Yeng
py-lum@...
Jan 2, 2003 6:17 pm
8474
If you tell us whats wrong! ie, whats the error message :) Cheers, Andrew ... From: Lum Pooi Yeng [mailto:py-lum@...] Sent: Thursday, 2...
Yes, we have experienced this once in a while also and not only with conversions but with just modifying a db. 1. Create a new database and import all objects...
Thanks. I've tried that. Sometimes it solves the problem, sometimes not. ... From: John Ruff [mailto:papparuff@...] Sent: Thursday, January 02, 2003...
Thanks Allan, Since I'm using a cboBox to locate the FirstName and the LastName and I'm plucking the LastName out and filling the Invoice database with the...
Yes, once you have made the stated corrections, you code (the code you included below) should produce the desired results. ' David McNamara <mcnamaras@...>...
I've read that it is necessary to put indexes on fields that most frequently put on the WHERE clause like IDs. But for booleans like blnPosted or dates is it...
Hi Andrew, Error message is "Password Invalid (Error 3031)" But i confirm it so many times already, i still facing same error message. If i direct open the...
Lum Pooi Yeng
py-lum@...
Jan 3, 2003 2:24 am
8482
I use this kind of connection string when I have my database passworded. CONNSTR = "Provider=Microsoft.Jet.OLEDB.4.0;" & _ "Data Source=c:\MyDBase.mdb;" & _ ...
From the Microsoft website: ' ' The connect argument is expressed in two parts: the database type, followed by a semicolon (;) and the optional arguments. You...
Dear all, I am just learning about the MS-Access. And now I am trying to create a product database for my company. Everything works okay until my boss ask me...
Hello Friends, We are having following MS Access Table.we need to generate report as shown in REPORT structure. TABLE1: srno name item MthYear (Date/Time...
shivu kumar
haishivakumar@...
Jan 3, 2003 9:20 am
8486
Which Version of Access are you using? With Access2K or AccessXP, this should be relatively easy using a ListBox. I'm going to assume/hope its one of the...
I cannot figure out the problem with one of my tables. If I try to copy a record, it takes over an hour to copy one line item, at the bottom it reads "Copy in...
I don't know if I'm calling it the correct words but what I'm seeking to do is if a user enters text in a text box say the name micheal, and he enters it as...
Have you ever worked with an input mask? It will correct the case to whatever you want as the user is entering the data. To do this for the example 'MICHAEL',...
You will need to put some code in the AfterUpdate event of the text box you want to modify. 'Convert to ProperCase after data entry has been performed Private...
So this answer I gave you yesterday on another board wasn't good enough? Or do you just post all over the place and not even check back? Date: Thu Jan 2,...
Is your database on a stand-alone computer, network or internet server? How many records in the table in question? When you created the new database, did you...
John, At your company, does this error occur more in the production environment than in development or vice versa? Thanks, Larry ... From: John Ruff...
It is on a network computer. The table contains about 300 records. I did not import the data, I created all records myself. I reboot my copmuter daily and I am...
100% of the time in a development environment. I've never seen it in a work environment. I normally see a file corruption problem in a work evnironment and...