Search results

Ok what I would like to do is have a switchboard with a number of command buttons on, each button opens to a form with a few fields within them. Is it possible for the initial switchboard labels to be 'red', then as the related form is opened and populated the switchboard label turns 'amber'...

Hiya I'm trying to compact my database and receive an error. I click to compact it and watch in the bottom left hand corner the status of the compact, the status bar seems to complete but then I get a message saying 'Record(s) can't be read: no read permission on <<file path>>. Following the...

Hello I have a query that I'm trying to run. The first field is a date/time field (tbotime) which is updated hourly I want to get the results to show just the data from 07:00 and no other times, although I need it to show for each day. So I'd get the data for 07:00 yesterday, today, tomorrow and...

Hiya I've searched the forum and can't quite find what I need so I'm asking for further guidance form all you Access masters out there! I have a field 'Time' in the format of 'dd/mm/yyyy hh:mm' which has a default value of =DMax("Time ","[Monitoring]")+1. This increments 1 on the 'dd' bit when...

Hiya I have a unbound text box that I would like to format a week, so rather than displaying the current week number of the year =Format(Date(),"ww"), I need it to show me what week it is out of a rolling 4 week period. The form one on which the box will sit is for DLT tapes and we have to...

Hiya I have gone back to my database after a couple months (other work commitments)to find that for some reason I can not see new records that I have added. To be honest I'm not sure if it was OK whan I last used it. I can add a new record in a form but if I come out of the form and go back in...

I would like to create a text box where I can input todays date, then I want to be able to select the tables I want to update with that information. So if I input todays date I can then update my Stock, Sales and Control tables with todays date. Tomorrow I would only like to update the Control...

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...

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...

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...

Hiya I'm trying to get a check box to be visible/enabled on Tuesdays, Thursdays and Sundays. I've been dabbling with the code and 'DatePart' but with little effect. I've been trying other suggestions on other threads but am still struggling I'm afraid. All help much appreciated, and I'm fairly...