Search results

I have a field defined as currency. How do I write the following query in VBA so it will be accepted and form a new row? strSQL = "Insert INTO test (money) Values ($0.00);" DoCmd.RunSQL strSQL field: money field size: long integer format: currency decimal places: auto I know it's a stupid...

Hello, Without getting into great detail, I have a query that worked when I constructed it in MS Access Queries (static data)but now that I am trying to get it to work in VBA (dynamic data) it claims that I have a Datatype Mis-Match (Error 13). I have ensured all my fields are of the same...

After a lot of searching, printing and highlighting I want to double check that I have the right idea. I have a simple inventory control database. From reading the forum, it seems the best approach is to drop the detail lines table of the purchase order (incoming) and the detail lines table of...

I am just wondering how good of an example Northwind is? I have been playing with the database and noticed that the number of units in stock doesn't decrease after I have created an order. I am trying to build an inventory database and would like this feature. Am I wasting my time with...

I have a form where I display the client's information and a series of checkboxes showing which services have been registered to them (ex. telephone, internet, cell phone (all info is held in separate tables with client id as the foreign key...). For instance: I have a working query that...