Search results

I'm really sorry i completely missed your post. Thank you for the suggestion

Good suggestions thanks a lot guys. I'll work something out.....it's not a major issue anyway. Thanks again for all the help i appreciate it very much bob.......your Access abilities are surpassed only by your modesty 😉

They both actually work well. Last thing (i know women are never happy)......if the booking is cancelled can i prevent the record from being saved in tbl_Orders. I could probably work around it but is there a line of code which would achieve the same result ?

Ok i took the code off of the parent form and just used the subform code. It's working better now but when i try to select more than one item from the subform menu, the 'Booking Confirmed' message keeps popping up after every choice i make. Sorry if i've done something silly ! bob......of...

Sorry guys i've been under the weather a little for the last couple of days so haven';t checked the thread. Thanks arnelgp. I had a look at your example but it still gives me the 'Booking confirmed' message before i even make a selection on the subform ? bob...i know Save buttons are not...

Ok was just thinking out loud. I always found that if i didn't include a save button, people would always ask for one. I know they're unnecessary. If i switched the code to the BeforeUpdate event of the subform maybe ?

Could i put the code into the OnClick event of a Save button on the main form or something ?

Thanks bob it seems to have solved the problem. I'm attaching my database (it looks like nothing at the moment). I have a form and a subform for adding the order items. It's not the same as yours so i'm getting the 'Order Confirmed' message before i even select the items i need ?. I haven't...

I've just had a look at your database bob and J***s you don't mess about even when you're 'at a loose end'. I could spend a month trying to get something to look and work like that and still not achieve it !. I'm going to have a close look at your table structure and see if i can improve mine...

bob...sorry i got busy in work after my initial post so no i haven't tried it yet. I will create a form first thing in the morning and add your code and get back to you. Ok my normalization is probably not quite there yet....would it make a big difference if i just left things the way they are...

Thanks bob.....i'm just starting and the tables are below tbl_Orders OrderID (PK Autonumber) TodaysDate (Date/Time) TimeNow (Date/Time) OrderedBy (Short Text) PreferredTime (Short Text) Note: Time for job (half hour windows) eg: 11.00 - 11.30am tbl_OrderDetails OrderDetailsID...

Hi All, I'm working on a maintenance ordering system and one of the conditions is that nobody can place an order for that particular day after 10am that morning. If it's after 10am they can place an order for the following day no problem. Is there a way i can prevent a record being added to...

Thanks arnelgp and MickJav for taking the time to help. It's working fine now. Thank you also to everyone who helped along the way....i'd never get any of these projects finished without you guys. Emma xx

Hi guys....here's the file. It looks terrible but pay no attention to that. If it turns out i've been doing something silly i apologise in advance :rolleyes:

MickJav...i thought your suggestion had worked but then i tried to add a new record and the date in the Last Calibrated txt box wasn't correct. I think the best thing to do at this point is for me to strip the database and add leave the relevant forms for you guys to have a look at. I'll be...

It's just called txtEquipID. One odd thing i've noticed is that the brackets you have at the end of the code are never there when i open up the code window ? The very last one is there but the two before it (after the word Date) are always missing

bob....i probably should have said earlier but my field name is EquipID. The Fk was just when i laid out the table structure i was saying this was the foreign key. I've just been altering the code to delete it. I tried the square brackets anyway and am still getting that weird date

bob....still the same error Gasman...thanks i did that arnelgp......i put your code into the Form Current event and the text box now displays the date 30/12/1899 ?

Thanks bob......i gave it a try and a getting the #name? error in the txtbox

Hi All, I've got a form and subform as below. The main form contains details of a piece of machinery, and the subform has details of each occasion it was serviced. When i'm entering a new record on the subform, is it possible to make the date that particular machine was last serviced appear...