Search results

Ahh its ok I fixed it, I removed the ' symbols from the record number and it worked. Duh!!

I'm getting a "criteria mismatch" error when trying to execute some code, im sure it has something to do with the formatting of the field but cant see where. I have a table called T_locks which I want to record the record number, username and date and time opened for files in a multiuser...

I have a form with a lot of fields on it. I am toying with the idea of making the field change colour (say turn the background yellow) when the field has focus, and then go back to white when it loses focus. Is there a quick way to do this to all the fields rather than adding a few lines of...

Ahhh sorry Mike I didnt see this reply. Yes I did cut and paste my code but i also compiled it before running it so surely it would have come up with an error saying the variable was not defined or something? Fixed now anyway, but thanks for pointing that out, yes I did cut and paste it.

Thanks However I have fixed it now by going back to basics. Just changed it to say If (countdays = 1 or countdays = 2 etc up to 5) then and now it works. Weird why the original IF statement wouldnt work correctly though! Thanks Gary

Yes i'm doing that. I am opening and closing then re-opening the form as the code is within in OnLoad event of the form. It works when I change the date to a date that has past, but not one within 5 days.

Ok i'm banging my head against a wall with this one. I have a field on my form (Date to complete IA). What I want is if the date to complete IA is within 5 days of todays date, I want the field to turn orange. If the date has past, then I want it to turn red, provided that the IA Status meets...

Its ok I have remembered how to do it now!!

Have you spelt forms correctly on your query as it is spelt incorrectly above. Should work, check the syntax in the query critera : =[Forms]![Form1]![Text0] Form1 being the name of the form where you specify the start/end dates Text0 being perhaps the start date, or the end date

Ok I did this years ago and cant remember now how to do it. Right, I have a form, in the form header I have placed the good old ActiveX Calendar control. In the detail, which is continous, I have my data fields, such as Date, Time, Event. What I want is: 1) when the user clicks on a...

You want to filter data based on two dates correct? A start and end date? If so, I would create a form, with two text boxes, one called StartDate and one called EndDate. Create a query which extracts the fields you want, and for the date fields, in the criteria, point the query to this...

Yes that worked, but prior to the rowsource line. Ken, once again, you are a star, thanks :)

Problem is, could your security be bypassed by a user holding down the shift key when loading the database?

I would have thought the lines in a sub are executed in order, but I have a sub which updates the data in a list as such: sub anexample() me.statusbox = "Please wait..." me.listbox1.rowsource = "Select blah blah blah" me. statusbox = "" End sub Theroetically, I would have thought...

Too many fields for one table though.

I have 6 tables, with a field relating to a change number, then fields starting Jan06 through to Jan 2015, the tables record resource useage for every month through this time period for a change. As you can see this is a lot of numeric fields. The problem I have is that I now want to be able...

Thanks all for your replies

Did the compact and repair thingie, no difference. Infact, I read somewhere that may have been the cause of the problem as compacting and reparing the database may reset the autonumber?? though ive not heard of this before....

Never seen this happen before in all my 10 years of using Access. I have a table with a primary key field (record number) which is a autonumber field. Been using it fine for months, now all of a sudden, after record number 1105 it reverts back to 430, which of course already exists. I have...

Hi Yes the dcounts all refer to the same table just with different criteria. Not sure how I can do what you say though... can you give me an example please?