Search results for query: *

I would like to use a select statement to select a group of records and then display the sum of those records... I am currently using the following code, but only get the value of the first record, not the sum, does anyone know how to get the sum of records in a recordset? (varactual should...

I hope someone can help, The following code is meant to update a new price into the TblLC, When I run the code it produces the following error: "RUN TIME 3622, You must use the dbSeeChanges option with OpenRecordset when accessing a SQL Server table that has an IDENTITY column" Dim...

I have an invoice report with four fields in a horizontal line: Qty - Description-Unit Price - Amount. The description sometimes needs to flow onto two lines, so I have the can grow set to yes on all four boxes. However, when my description grows my quantity, unit price, and amount stay...

When I save my purchase order(based on purchase order table) I would like to add a new record to my shipping table. The following code gives me an "Invalid use of Null" error. My shipping table has four fields - ID, MachineID, Ship Date, Complete. ID is an autonumber ID field, and I...

A simpler way to keep your subform refreshed may be this... Use the timer function in the subform's properties. Under timer interval use a value of about 1000, and the On Timer Event Procedure is a simple, Me.Requery. This will refresh the info in your subform almost as quickly as you enter...

When I save my purchase order(based on purchase order table) I would like to add a new record to my shipping table. The following code gives me an "Invalid use of Null" error. The following is my code...Can anyone help me? Dim db As Database Dim qdf As QueryDef Dim rst...

Never mind - I linked my SQl tables and created a view - Then based the form on this view - Now it works perfectly.

I have a shipping form that pulls information from a shipping table and a machine table - It shows each machine's shipping information. The form is set to continuous and the shipping table is it's data source. However on open I have a dLookup function that fills in the machines ID number and...

Thanks for your reply! Sorry I was not clear enough. The shipping address is held in it's own table as it is specific to each sale, not each customer. So I need to know how to insert the CustomerID into the new Shipping Address record that is created if their is no existing shipping address...

I have a form called Sale. It has a field for called custo mer. It has a button called ShipAddr. I want to be able to open a form called shipto from the ShippAddr button. When Opened I want the ShippAddr form to display the Sales shipto address based on the value in the customer field on the...

Sorry I can't help you, but maybe you can help me. I am trying to figure out how to open Autocad from ACCESS. What are you doing?

If you are using Access 2000 this should work. Place this code in the After Update of your combo box. Replace Fields in CAPITALS with your Values Here goes: Dim strFilter As String '(Evaluate filter before it's passed to DLookup function.) strFilter = "CLIENTTABLENAME =...

Nope...That didn't work, Thanks for trying though.

Hi there! I hope someone can help. I am using Access 2000 I have a main form called "frmPurchaseOrder" the source of this form is "tblMachine" it has a field called "Model" and a subform which has a combobox call "Pricingcategories" The form is opened...

I have a field called "Model" in my parent form.  Based on the "Model" the user chooses I would like to populate the "Options" field in my subform.  When the user chooses an "Option" from the subform, I would like the "Unit...

I have an unbound query box called PONumber that the user updates to find a record.  However I do not want them to be able to edit the record.  When I set the form property to be uneditable it does not allow the user to update the PONumber.  How can I set the...