Search results

Hi, I'm setting up a query which will eventually run as a report to show sales within a specific date period and so on. In my table "tblJobs" I have a field named "JobInputDate" - this will act as my date source, everything else included within the query works fine, i.e. costs etc, etc. The...

Hi All, Quick question (not sure it's under the correct section)... We have a split database in our company where the backend sits on the server and the front end is distributed to each employee. If an employee wanted to access the database and input data from another location away from the...

Solved - I wasn't refreshing the form before it was opened. Thanks for you help.

I've created a copy to make a test and when I try to add a product to an order I'm shown this error message... "You cannot add or change a record because a related record is required in the table tblOrders." Where might I start with this?

This is a good point, however I've created a form called frmCustomerOrdersList which includes two Sub forms (see attached). I was hoping as I navigate through the customers it would display all of their orders below in the sub forms, which are frmOrders and frmOrderDetails Sub form. Will this...

I've created a new field in the tblOrdersDetails called 'OrderDetailsID' - will this now allow me to add the same product, in different colours to the same order (see attachment)? Will I need to change anything in tblPackaging or tblColours as you mentioned, or will this 'traditional' way not...

Thanks, I think I understand what your referring to. I did created my relationships before I began work on my forms etc. I've attached screenshots of both my relationships and sub-form properties. The 'Link Child' properties were set automatically, as you mentioned. I've not added any orders...

Hi, I'm creating an Orders Management database and I need help adding data that has been input into a form, then into its respective table. Example: I'm adding a new Order to the database using a form I've created frmAddNewOrder. Within the form which has a form layout on the top half where...

Hi, Hopefully you can help me out again, it' regarding the query I created in my above posts. The query works fine up until I enter new data to the table. Now when I run the report which uses the query to return the data, it doesn't include the new data. What could be the cause? Regards,

So simple, thank you!

Hi, Pardon me for what I'm sure is a very simple answer but I appear to have just completely forgotten how to do this... I want to run a query to show all my outstanding orders between two dates. I've done all this correctly and it works fine. However I only want the query to show me the...

Hi Galaxiom, Thank you for your quick and helpful response. Does this also apply if I'm adding new fields to a table and also If I re-design a report i.e layout etc? Will it affect other users copies too, even if they have their own copy? My questions are specific as these are the immediate...

Hi, I'm working on a database that's been split (front end/back end). The database is being used by numerous people in my workplace and I want to make some changes. My question is, if I make changes to the front end, i.e design changes to the forms, or adding some command button etc. Will it...

Hi MarKK, I've now created the tables and it's all looking a lot better. My next question is.. I want to create a 'New Order' or 'Order Entry' form where when I I'm entering a new order for a customer, after completing all of the customer details, order dates etc, I want the ability to add...

Thank you very much, I understand why 2 tables are needed now. I will try this. Big help, thank you.

Here is a copy, I didn't realise I could add it as an attachment. In what way will I need to link them if I created the tables that you mentioned - minus the sizes? Would this allow me to add numerous products to one order at the same time?

Thanks for your response. At the moment I only have Customers: Customer ID First Name Last Name Address Contact No Email Products Product ID Product Name Price Orders Order ID Customer Name (Lookup field) Product Name (Lookup field) Colour (Lookup field) Order Date Delivery Method (Lookup...

Hi all, Recently my wife has started her own company. She designs and produces glitter products. She has asked me to set up some sort of system that will be able to Track orders - add new orders, see details about the orders and update them when they are shipped and paid for. Get reports -...

If you're not too familiar with code, how else would you describe what I need to do. I'm sorry to act so stupid - I just need to understand it...

Hi, I'm really sorry to be posting a question that I'm sure has been answered time and time again. However, I'm relatively new to access and I've come across and issue with a database I'm working on but didn't build. I have a form that includes and checkbox and to give you a background to what...