Recent content by Jackvmae

My insert query is shown below. It is triggered by a command button on an unbound form. The purpose of the query is to insert a new record into a table. strSQL = "INSERT INTO tblJournal (NameID, CompanyID, dateDoBy) VALUES ('" & Me.NameID & "', '" & Me.CompanyID & "','" & Me.dateDoBy & "');"...

Using Access 2000, I have a standard mdb. The back end (tables only) are shared from one central computer. All the other computers on the network have the front end components only (forms, queries, etc). My question is this: Let's say you have 10,000 records in the customers table. On the front...

I have an insert query that adds a new row directly to a table. The query is triggered by code behind an "add new record" form. One of the fields in the new record that the query is adding to the table is a date field. The insert query works perfectly so long as the new record that is inserted...

In a regular Access 2000 MDB networked file/server database you can use DAO to add, delete and edit records. You can also use SQL to do the exact same things. In what circumstances would you say it's best to use DAO and when is it best to use SQL? Right now I feel my code is sort of sloppy...

Lee, I've been following this thread. I too would like to see how you do it. Thanks, Jack

Great answers and I might be able to find my way around with them, but let me explain a bit more... The NewItem text box is on an unbound form. The contents of the NewItem box will update to any of several different tables, depending upon choices the user made elsewhere in the form. Sometimes...

I have a text box on my form called NewItem. I have two questions: 1) How can I use VBA to change this text box to a number box, currency box or back to a text box? 2) How can I use VBA to test of the contents of the NewItem box is text or number or currency? Thanks, Jack

The following items have been recommended to developers. The claim is that these products develop runtime versions of Access apps much better than the program that comes with Access developer. I wonder if any of you use these products and have an opinion on them: Wise: http://www.wise.com/...

Leeroi - If some of your stations only have SR1 for Access 2000 then I am really surprised you have not had more corruption problems. Updating to the current (SR3) is absolutely necessary. I am still learning, so others may have more experience than me with regards to unbound forms. However I...

Regarding the Autonumber field... (For Michael, Daniel and Jeremy) I never thought of the autonumber field as a source of problems because it's never caused any at our office (that I know of). Also, in my app almost all new records are first filled in by the user on an unbound form, thus...

I recently read that it is faster to add a record to a table using SQL instead of DAO. So I would like to change my DAO code to SQL, but all the SQL syntax I've tried results in errors. Can someone provide me with SQL syntax to accomplish the same as this DAO procedure: Dim db As...

On a demo application I saw a really neat trick. I'd like to incorporate it into my application, but I can't find out how it's done. I can't find the code anywhere. Can anyone explain this "puzzle?" On a form is an ordinary text box. No drop down arrow like your typical combo box...

Michael, Can you explain what the problem is with Autonumber fields and how to avoid them. I use autonumber fields in almost all my tables. Jack

Let me explain a bit further... What I wish to do is have my code use DAO to delete the record from the table (this part is working fine) and then have the code go on to requery my list box so that the deleted record is no longer in the list box. The problem is that the list box get requeried...

I'd like to ask this question of all the experienced Access developers... I have started making an Access 2000 application. I plan to sell it to very small offices in a small niche market. Usually these offices don't have more than 5 computers on a network. Now I am having second thoughts...