Search results

Cause that would be too easy. ;)

So I need to make the field a double, right? I'll play around with that and see what I get. Thanks for the tip.

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

Seems to be that I am slow. The Mismatch data type is for the itPricePerUnit field. It is defined as Currency and can't seem to accpet 0 as a value (where is does if you create a query in Access). I'll post my solution when I've got one.

I am pretty sure they are, I thought I made sure by transferring the data into known variables before inserting them into the table. I'll continue hacking away at it and see what I come up with. Thansk again.

Changed long to variant, didn't work. I am still playing with the code, something might pan out. txtNewCount and cboInventoryList are from the Form I am pulling the data from. When I pull up the locals window in VB they are getting their data into the right variables. I'll keep at it.

I have tried the query developed in Access with all hardcoded data that worked perfectly, in VBA, it still gives me the Run-Time Error '13' Type Mismatch. How can it work one place and not another???

Details it is then... Private Sub btnSaveRecount_Click() On Error GoTo Err_btnSaveRecount_Click Dim currentCount As Long Dim newCount As Long Dim diffCount As Long Dim strSQL As String Dim inventoryID As Long 'Encountered a problem when QuantityOnHand is Null...

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

Links They have a things about links in signatures lines. Thought you might like to know.

Funny enough, I had saved it a couple of weeks ago, but now that I look at it again, it makes a lot more sense. Thanks for putting up your sample.

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

Thanks, I found this solution from the search function. It always amazes me how simple the answers always are.

Thanks for your help, I have this sorted out finally. Each of the checkboxes is it's own tiny subform that is related to it's own query. Definitely not something I would have initially thought of. It works, so I'm not complaining. Now on to the most time consuming task, making it look good...

Thanks, a more elegant solution. How do I get it to translate to the checkbox? Is it simply a matter of changing the Control Source in the checkbox properties? I tried that, it is doesn't seem to work.... The master form is bound to the Client Table. The checkboxes are currently not bound to...

SELECT Nz([ctID],0) Or Not (Nz([ctID],1)) AS Expr1 FROM ClientRecords LEFT JOIN CellRecords ON ClientRecords.ctID = CellRecords.clID WHERE (((ClientRecords.ctID)=[Forms]![frmMasterForm]! [txtID]) AND ((CellRecords.clCellExpiryDate)>Date())); Makes sense to me. I am joining two tables (Client...

I have the query that RuralGuy suggested in place, I have the appropriate field as the control source for the check box. But I get nothing, the check box is still grayed out, somthing is not working. Is there something fundamental I am missing about using a query to populate a checkbox? Is...

Thanks, but that's not quite it... This checkbox isn't based on a field in the client table, it's based on whether or not the query returns a result or not on a different table (ex. Cell Phone Table). I have been asked to provide a form that shows you the client info, followed by a series of...

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