Search results for query: *

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

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/...

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

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

I highlight a record in a listbox, and then I use DAO to delete the record from the table. My code then goes on to requery the list box to make the deleted record disappear from the list box. Only problem is, that record does not disappear. If I place a cmdButton on the form to requery the list...

This problem is one of those little annoyances and has me really confused. Here's the problem... When I turn on my Win XP laptop the desktop area opens up centered and very small on my screen. There is about 3 inches of black space on all four sides of the desktop image. In order to get the...