Search results

Thanks for the reply. However, the link between the products table and the 'order form' is simply a relationship link between the two tables, so I'm not sure if what you're suggesting would work? I also don't know how to add the boolean field. Sorry, I have very little Access experience.

I have a simple ordering database set up with product codes and their descriptions, etc. in one table (and the 'product code' field as the primary key) and then a separate table for the orders raised. When a product becomes obsolete, I would like to be able to prevent anyone from raising a new...

Hi, I have a data entry form that, when completed, I need to send as a report via automatic email. I have created a report that pulls the relevant information and I know I can use 'Send Object' in the 'Before Update' event to send it. However, I need to change the 'To' email address based on...

That's exactly what it was - I had re-added the product code field after adding an input mask and forgot to change the tab order. Now I just need to get my outstanding orders query working correctly (instead of duplicating an 'ordered' line when it sees a 'receipt') and I'm all set. Thank...

It is in the Before Update event of the form. There is no code in the textbox events.

Actually, what it seems to be doing is giving me the warning message as soon as I tab to the next field after I enter the product code. If I say no and then fill in the rest of the fields and click the 'submit' command button it gives me the warning message again. However, if when I first...

Thank you! That works and gives me 'this part has already been ordered. Proceed?' question fine now. However, if I select 'yes' to proceed, it clears the product code value I have just entered. In theory, they should never need to proceed, but there may be an instance where, due to someone...

Yeah, I realised that as soon as I posted, typically. I've now changed it and as soon as I type in the product code I am getting: Run-time error '2471' The expression you entered as a query parameter produced this error: 'BLFT12345' (where BLFT12345 is the product code I have entered in...

Thanks. I'm now getting 'runtime error 438. Object doesn't support this property or method' and it's highlighting the whole 'DLookup' line. I changed it to txtProductCode for the 'Name' of the textbox label in the 'other' tab on the property sheet. Is that correct? I obviously need to keep...

My query is a calculation and I have the criteria set that it only includes any values where the resulting calculation is >0 (to give me outstanding orders). The query is grouped so that it only returns one line per product code. Does this mean I need DLookup instead? I'm getting an error...

Thanks for this. I'm just trying to understand what specific details I need to replace though. I'm guessing that [Field] would be the field from my form that I want to check against (in this case 'Product Code') and the "TableorQuery" would be the name of the Query I use to detect outstanding...

I already have it returning the product code, which is how I then group it. I assume you mean return it in a different way, but I'm not sure what you mean exactly. I know how to add criteria to return the sum of a particular product code, i.e. by typing the specific product code in the...

Correct Not sure what you mean by 'count'. I have the query set up so that it performs a calculation like 'sum of plates ordered' - 'sum of plates received' and grouped by product code. What I guess I need a way of doing is that when they click 'submit' on the new order data entry form...

To hopefully clarify, the 'part number' in this case is actually the 'product code' referred to in my query. We don't generate an order number when we create an order, as we have a general standing order with the supplier. We will receipt in the quantity of plates received for the product...

Thanks for the reply. I'm very new to Access, but the code I have for the 'outstanding orders' query is below. Probably more complicated than I need it be, but hopefully it makes sense. SELECT [Product Codes and Descriptions].[Product Code], [Product Codes and Descriptions].Description...

Hi, I'm currently creating a database for product orders (for us to use to place an order to buy something from a supplier). As part of this, there is a data entry form for the shift supervisor to complete to create an order. However, we have a situation where one shift leader may not...

Hi, I have created a data entry form and one of the things I would like to do is to have an Excel file open automatically if the value in one of the data entry form fields is above a certain criteria (this will then trigger the data entry person that they need to complete another file, which...

Thanks for the reply. Unfortunately, I don't know any VBA (haven't done any since programming PLCs in uni, far too long ago). Is there a way of doing it without using VBA, just with general Access commands? If not, I'll investigate VBA but would prefer this as a last resort.

Hi, I am very new to Access and am struggling as to whether the following is possible: We have a situation where we need to enter a range of pallet numbers into a form, but then have the table behind the form store the numbers in the range individually. For example, the data entry may be...