Search results

I have a query which has a field with a where statement and criteria: ([forms]![form1]![List2]), however i now have 'form1' as a subform on 'form2', what do i write in now? The explanations on the net haven't really helped. Thanks guys. , Leon

I just tried the alias thing again and this time it all worked, no #name?. Not sure why it worked, restarting access didn't do anything last time. Maybe because its access 97 -.-. Thanks for all you help though guys. Kind Regards, Leon PS: attached is an example of what i was trying to do.

Thanks guys, i see what you mean, but this is exactly the problem I'm having, i had aliases at the start but that's what brought up the #Name? issue. I just tried something which strangely worked. I made an alias for a field (Alias: REPAIR_DATE), but left the text box control source as...

Attached is a screen of what it all looks like when it works. For the combobox, could i use Private Sub Form_Open(Cancel As Integer) Dim powerboard as string powerboard = "sumoffault_powerboard" End Sub for each field, and then Private Sub Combo8_AfterUpdate() Me.Text10.ControlSource =...

Hi guys, Thanks for your replies. The controlsources were selected from the dropdown. I removed the changed field names in the query and then the form works fine. But this is annoying as the combobox shows fields that are hard to understand, unless they're renamed. What does this mean and what...

Hi, I have looked up the #Name? problem on other sites, but it has not helped. Attached is a screen of a form with its control source (Query). The controls on the form are linked simply to fields on in the query, with no spelling mistakes, and no extra calculations. As you can see the query...

This helps, thanks Bob

Ok, but my antivirus software (Avira Pro) has that site listed as a reported attack page ("Part of this site was listed for suspicious activity 2 time(s) over the past 90 days."), not sure if should visit it, but I'm guessing since you work at a large bank you would have far better antivirus...

Could you provide a solution as to how to do this better than please? There is a parts table and a product table There are around 500 different parts, and around 50 different products. I need to know how much of each part is used in each product. Whats the best way to do this?

Thanks for your reply Bob. I think I've figured it out now :) As to you second post, the list in the parts table you saw are the products, the parts are the records and the amount that the part is used is listed under each product.

Hi i have a query which has the above (thread name) problem coming up when i try to run the query. The query should display all the products ("product id as on product") where the "product id" = "LS1212" and the "c customer specific" does not = 0. Attached is an image of the query design and a...

Well, if this works, it will be a subform for another form. However i need to make a calculation on that main form that uses the the product amounts (from the form we are discussing) multiplied by that products 'multiplier' (on the main form). Product X amount (subform) multiplied by Product X...

OK, but how do i have 1 text box (with data source: Quantity) to show the quantity of product X and another text box to show the quantity of product Y. I tried having {SELECT... FROM... WHERE product="X"} in the default value property, but it doesn't work, only works on combo boxes or list...

Hi, I have a query that has 2 fields, product and quantity I want a form that has a text box for each product, with the quantity in the box and the product as the label. Is this possible? Thanks, Leon

What exactly do you need to know? The tables have too many fields to screenshot, and there are a number of queries.

Hi, Sorry i wasn't sure where to put this thread... I have a table that has rows/records of parts. It contains fields for description, part no., quantity etc. However it also has fields headings of product names that the parts are used in, in these fields there is a number, these numbers show...

Thanks everyone for your time and help. I haven't used access in a long while, so it took me a while to get my head around this code. I had realised in the end i didn't need to have a month total :o I just needed to code it differently... I know alot more about date literals and interpretations...

Hi pbaldy, That does work, however my datediff line looks like this: W_C2 = DateDiff("m", (DateAdd("yyyy", W_C, Me.[WARRANTY RETURNED])), [Date recieved]) (and yes i know the received is spelt wrong) I can't add # in there; At the moment the datediff looks at the date in AUS date format, but...

Oh, sorry i should have explained better, those dates were just examples. Date1 and Date2 are full dates, but are over a year apart. Its just the the "m" variable only looks at the month difference within a 1 year not all the years, so for example: Datediff ("m", 1/01/2006, 1/05/2011) gives the...

Hi, The code below wont seem to do anything, doesn't fill in anything :mad: Private Sub cboTypeOfService_AfterUpdate() If Me.cboTypeOfService = "Warranty Exchange" Or Me.cboTypeOfService = "Dealer Exchange" Then Me![FAULT_WARRANTY_EX] = "1" Me.Refresh Me.txtCustomerComments =...