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

No problem I have a fifth field which does not show This is my field 'Format([tbotime],"hh:nn:ss")' My Criteria is '#07:00:00#' The working SQL is as follows, I think. Clearly there is a 'WHERE' in that but I deleted the 'WHERE' from the design view. Looking back it was like your first...

WoooHoo!!! It works. I deleted the old query and started with a new one, I've lost the 'WHERE' bit and kept in the ':ss' (seconds)and its works a treat. Thank you very much for your help! Thats another couple of pints I owe the forummers!

This may sound silly but what sort of query should I have Union Pass-Through Data Definition I create my query in design view and then change the code by going in Query > SQL specific I'm on access 97 if that matters

OK my query now looks like this SELECT Monitoring.tbotime, Monitoring.[EDM Total Backups], Monitoring.[EDM Queued Backups], [EDM Total Backups]+[EDM Queued Backups] AS [Total Activity] FROM Monitoring WHERE (((Format([tbotime],"hh:nn"))=#12/30/1899 7:0#)); If I try to run it I get a box appear...

Ok I've substituted " for # and lost the brackets, tabbed to the next field and Access has made the criteria into "WHERE TimeValue#07:00#". When I run it I get a data type mismatch error. The query has 4 fields tbotime-date/time EDM Total Backups-number EDM Queued backups-number Total...

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

Superb, it works a treat. Thanks for all your help, thats a pint I owe you!

Right then, I've renamed my field 'tbotime' and I've put DMax as the third argument. Unfortunately whenever I take the quotes off as soon as I move to the next line, Access has added the quotes back in, if I lose the quotes and use some sort of bracker set up I get various errors. Thanks for you...

Thanks for that OK I've made the default value DateAdd("h",+1,"Time") with 'Time' being the name of the field and the field having a format of dd/mm/yyyy hh:nn When I add a new record I get #Error where I am going wrong

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

OK I think I've foung the problem table and I've checked for 'aggregate functions' but cannot see any. Is there any way I can search for them?

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

DOH! What a numpty Thank you very much!

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'm trying get this working as well but still get all records displayed I've done the code as follows Private Sub cmdPrint_Click() If Me.Dirty Then RunCommand acCmdSaveRecord End If DoCmd.OpenReport "Tapehardcopy", acViewPreview, , "[01/01/2006] = " & Me.[01/01/2006] End Sub Private...

Well basically my brief is to create an on-line version of our work schedules. We currently have 10 paper based schedules and I am currently turning these into tables/forms, etc. I have made it so the date is the primary key on each table as each job is ran just once a day but not everyday. We...

Sorry what does that mean?

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