Recent content by jammy1812

So I've done a bit more tinkering. I've discovered that the issue is only present on the following 2 sections: TblOrderDetails and FmOrderDetails TblCircuit and FmCircuit These are the only 2 tables/forms with foreign keys and joins in them...could this be the issue? If so, any help on how...

I've uploaded my Database for your records. As you can see I've added data into the table, but its not appearing on the linked form. Edit: Hi JHB, Yeah I've tried refreshing/opening closing but nothing updates.

Hi guys, Have an issue with my Database. I have: TblOrderDetails FmOrderDetails (There are several other forms and tables, but I'm focusing on this one at the moment.) Whenever I add data into the Form, it will update the table as expected. However when I add data into the Table the Form...

I know how to build a query in query designer, but I'm not sure what to put in as my criteria for selecting/displaying results. So where in query designer would I write the code (if my above code is correct) to ensure that any entries with "CompletionDate" selected, would not show up in the query?

Hey, thanks for the reply but I don't really follow you. I've got the grid open, but not sure what to type and where? I've clicked the three instances, but how do I get them to show what I want based on the data in the fields?

Hi guys, I'm building a query, but can't quite get the coding to work. I have 3 items I've selected for this query: ContractDeliveryDate AmmendedContractDeliveryDate CompletionDate I'm trying to make a query that display any orders that are within 7 WORKING days of today's date, but with...

Hello, managed to solve this issue of the joins, etc. But have another question. Say I have Order Type with 2 options: "Provide" and "Cease" on a combo box. If the value is "Provide" I'd like an option to add circuit to come up on the form, which in turn would lead to another form. However, if...

Sorry about that, didn't realise. Makes perfect sense though. I'll get the cross-post closed.

Hello, I'm making a database where I want to fetch a record from a table "Customer Details", from a drop down box in an order form, additionally, if the customer does not exist, I'd like it to add the customer name to "Customer Details" if a user types a name in. I've managed to do this with...

Hey, I used the create form wizard, is there another way I should do it?

Hi guys, Need a bit of help with a user form I'm trying to make for a database. I've attached the database file with my attempt at the file too. Not sure why, but it doesn't seem to allow me to update any data. I've attached a few screens of what my eventual form will look like (spread over two...