Search results for query: *

Hi, I did the conditional formatting with the box enabled by the criteria. I did also have to add a second stmt that disabled based on the not equal to criteria to disable the box as opposed to disabling on Form open. This way allows the duplicate command to work with no issues at all. THe...

Hi Aceman, I did try that in different ways but not with the coding disabled. I was trying to black it out and even blend it into the background as much as possible so it didn't look like it existed so even if they did try to enter they would not see it and eventually quit trying. I'll try it...

Hi, the code worked fine except it was for a continous subform so when enabled or visible it would revert all the records on the subform to the same status so here is what my friend suggested and assisted me with. I don't have the exact code at home but we ended up using a Select Case stmt that...

I like those kind of answers. I have some that will still try to enter info even if it was disabled which might generate some unnecessary calls to me telling me its broke. I think hiding it may be the better route as I think outloud here. Simple is best. Thanks for your help.

Thank you to both of you. The field is not really named "COUNT" but just a quick way to type up my dilemma. Thanks for the info though. I will give this a shot in the morning. Could I also add some code so that it is not visible until those Enabling tasks are chosen?

Hi, I want to disable entry into a form field based on the entry of a prior field. For example, if the person enters "A","B" or "C" into field [TASK], then the [COUNT] field is disabled or will not accept data. (This also could just default to "0") If the selection in [TASK] is "D" or "E" I...

Hi, I closed my Access 2003 database at work and came home and was going to begin working on it again and now I am getting an Unrecognized File Format error.Is there a fix for this? I've tried converting, compact and repair and creating a new database then importing but I still get the error...

Hi, I have an Access 2003 database on our server and it has been working fine until two days ago. Certain queries are running into various Undefined "function" errors. The functions so far have included the date() and Mid function. What is now causing this and can it be corrected?

Thanks. I didn't even think of that. Issue resolved!

Thank you!

A database I have is linked to an Excel file that contains data pulled and saved from another source each day. This data is uploaded and appended to an Access table. For some reason, each time they overwrite the excel file it takes out the Share Workbook link which inturn causes the database to...

Hi, I am applying a docmd.applyfilter command onclick to a form cmdbutton. I have used the code many times before but cannot figure out why it will not filter. This form does contain many one-to-one subforms the others have not. The code is docmd.applyfilter , "[DueDate]= 'date()'" to...