Search results

hi gemma. i have these spefications in my table. each OrderItemsID has a start time and duration. so start time + duration = finish time. the other issue you raised i think is solved. i have a diary view that you dbl click to make a new appointment. each time 9:00, 9;15 etc is a text box and...

sorry ive just tried it again and it works now. i must not of tried DoCmd.SetProperty "DateOfTreatment", acPropertyEnabled, "0" before thanks for your help

i have used this for the time box i have DoCmd.SetProperty "comboOrderTime", acPropertyEnabled, "0" this works but it doesnt work for the date box

yes. the actual vba was [DateOfTreatment].Enabled = False i even copied and pasted the name just to make sure there was no spelling error

where do i start!!! in my form i want to check if the appointment does not overlap another appointment. the appointment is made up of items that all have an individual time allocated. i thought of doing something like this but i am useless with syntax etc. if DSum("[TreatmentTime]"...

ive tried it both ways. i tried the actual name and the control source. the control source name is OrderDate the date box is DateOfTreatment. any suggestions?

i want to use vba to lock or diable a date box on my form. i have used[button].Enabled = Falsethis works ok for buttons but doesnt seem to work for my date fieldMe.OrderDate.Enabled = Falsei get an errormethod or data member not found. it highlights the .Enabled partany advise?

thank you. can i ask what i was missing from the form. was it some fields in the form query. thank you for your help

worked a treat. im sorry about the incomplete upload. ive only noticed when i tried the new code. ive uploaded a new version with your code in it. the next problem is when i select the item(meeting/Lunch). any help on this please. i did actually think that this was a no hoper. i came to this...

i am trying to have a continuous form where i have a combo filter to filter the records. i would like to be able to add records on this form but i keep getting an error Field cannot be updated runtime error 3348 cannot add record(s); join key of table 'tblOrdersItems' not in record set...

sorry this is entirely my fault. cant remember what i did wrong but i did. its sorted now thanks

what is you end goal. do you want to pull up a record and see what parts have been cut out of the slab? if so. can this not be done on one table?

ye thanks. the problem i have is when i change the dates or the combo box. how do i requery the results without requerying the whole form. i have a continous form that already has a combo box to filter the results but i did that through the wizzard but this form wont let me do that.

i have been given a sample of a one to many table system. ive uploaded it for you

are you wanting to have a field in your child table to be the unique id of one of your records in the parent table. preferably the last?

you could try Me.InputText.DefaultValue = DLookUp()

i want to filter my form with a combo box and a couple of date boxes. with the combo box i cant use the wizard as it is not just from one table. ive tried to put Me.Requery on the change event for my combo with the criteria in the record source to be the combo box but this doesnt work and im a...

im wondering if there is a way to run code daily. i have in mind to run a delete query every day. the query would be to delete any record where the date is <DateAdd('yyyy',-1,date()) i have other update queries and things that i would like to be automated every day and would like to not have...

can i ask why this is better than copy/paste from query design view to vba behind the form. thats how i am doing it at the moment. also i could just have the query as a query rather than code. but the only reason i want it in code is that i want it there. if something happens when i click or...

thanks for all of your suggestions and opinions. we have a system at the moment that we paid for. their is an audit part to it. but it only records when records are changed or made etc. there have only been a couple of occasions when i wish i knew if x button was clicked but it was still needed...