Search results

Hiya I have created a query (Weekend) from 2 other querys (BCV & Daily Sales). The BCV & Daily Sales queries work fine but when they are added together I am unable to add new records. I only have 1 line of data that can not be updated. I thought it was a relationship problem and have been and...

Mark Thanks for all your help, its much appreciated!

Slight Glitch When I try to add a new record I get Run Time Error: 94 Invalid use of Null The debug highlights the first line of code Me.Create_U607ST50.Visible = DatePart("w", Tape_Date) = 6

Thanks for that, just another point Is it possible to have more than one label/child assigned to one parent

I will need to add other dates to a different field, why what do you suggest?

Ken, I owe you a pint, thanks very much

Sorry tried that but it does not work. Tape_date is the name of the date field on this form and I'm trying to make a combo box called 'Tape' visible on that specific date?

OK I have done a select case as follows Private Sub Form_Current() Select Case DatePart("w", Tape_Date) Case 1, 3, 5 Clearly this runs/works on a Sunday, Tuesday and Thursday. I have tried to adjust this to work on a specific date but I'm struggling. Would I use 'datePart' or just...

OK Thanks Any chance you can just explain the benefits of having it that way rather than the way I was doing, as it still seems a rather long winded way of doing it?

Hiya is there an easier way of grouping together 'Select Case' statements rather than this way I have done them. They work but I still have more to add and feel this way is a little long winded! Private Sub Form_Current() Select Case DatePart("w", Tape_Date) Case 1, 3, 5...

Hooray I've done it It was simple in the end, Tape_Date not Tape.Date Thanks for all your help

Well the record displayed is the 12th January which is a Thursday. I am correct in thinking that Sunday = 1, Monday = 2 and so on

It returns a number 4

OK so the code I now have is as below (date now works, welcome to the world of strange) Not sure why but the below code shows the checkbox on the first record, then it goes when you go to the next record never to return on any records after that. I'll owe you pint after this

OK so the code I now have is as below (date now works, welcome to the world of strange) Not sure why but the below code shows the checkbox on the first record, then it goes when you go to the next record never to return on any records after that.

Sorry if I'm being thick but I thought it was a case of the below I now get 'Variable not defined' and it highlights the 'Tape' bit.

I'm working on it, bare with me!

Hope this helps, be nice to be sorted out!

Thanks Selena Just a thought, does it matter how my date is formatted on the form. Has it got to be so it shows the days of the week?