Search results

Hi just a quick one im sure for you experts. Im having trouble with a datasheet its ran from a macro button using BrowseTo command. Im having trouble with the where condition; i would like to show records where the [FittingDate] is blank... i have tried isnull() and [FittingDate]=""

I used some vba on the after update box as follows [Forms]![frmCustomerNew].requery Not sure if this works or not, it seems to do something as when i close the form in front to go back to the customer form its now on the first record as apposed to the customer record i was looking at...

Ok i Have a Customer form showing customer details, with a sub form datasheet showing Customer Jobs. From the customer form you click a button to take you to a Jobs Form showing the job details for each job for that customer. When i create a new job for that customer and close the Jobs form...

Hi This relates to 2 tables a customer and a jobs table both linked by [CustomerID]. I have a button opening the jobs form from the customer form showing jobs for that customer. When i go to add a record the [JobID] field on the jobs form shows (New) but the [CustomerID] is not passed over...

Thanks alot number 2 worked, which was the one thing i thought to try but i must of not linked the field up right.

Ok i have a customer form with a button that opens a job form the customer and job tables are linked with a customerid field. When the job form opens the records are filtered to show the ones matching the customerid displayed on the customer form. Problem is when i then go to add a new record...

Thanks for the links but they dont really answer my question they just explain the structure which i feel i know enough about...

I was using it but went back to paper while i try and make improvements, thanks for the link i will take a look...

Please see attached image of tables and relationships

Sorry if this is in the wrong section... Basically working on a Customer Order Database for my carpet shop. I have a Customer, Job and Order table. The order table contains the line items for each job and each customer can have many jobs. I have a field in the Order table showing the item...

Thanks thats done it! :)

I have a calculated field in a report footer which is as follows; CCur(Sum([Line Total])) Where the answer should be £147.72 Im getting 147.722 Any ideas?

Ahh i think ive solved it, i was using page footer instead of report footer!!

I have a Report (Invoice), which is based on a query. The query has two calculated fields in it [Quantity] - which multiplys the lengh and width fields and [Line Total] - which multiplys [Quantity] with [Unit Price]. I would like a total of the [Line Total] on the Invioce. What i have done is...

Is there a way of adding a footer in datasheet view? as thats how the data is displayed. I dont want to display on the main form, i want to calculate and display on the subform, but because its a datasheet there isnt any space to put fields like in a form and i cant get the totals line at the...

If i look at the table in design view the data type is set to Number. I set this up using the look up wizard and it automatically set the data type for me??

Ok guys maybe im getting confused here, when you say allow new data to add to list doesnt that mean it will add the entered item to the sub menu list? I do not want that to happen, i need it to bypass the list altogether. Look at the combo box in my situation as a list of commonly purchased...

Private Sub Item_Description_NotInList(NewData As String, Response As Integer) Dim db As DAO.Database Dim rs As DAO.Recordset Set db = CurrentDb Set rs = db.OpenRecordset("OrderDetailsTbl", dbOpenDynaset) On Error Resume Next rs.AddNew rs!AEName = NewData rs.Update...

Thanks for this i'll give it a try if i can get it working the next step would be taking out the message boxes as i dont need the verification as i am using this database myself.

I found this... msdn.microsoft.com/en-us/library/bb214329(v=office.12).aspx But i honistly dont know where to go from here i dont understand it. Im assuming NewData is what has been entered and i need to tell it when the not in list error is triggered to pass on the newdata to the record. I...