Search results

I'm not sure where you are having an issue but the code would go in the AfterUpdate event of the control where you are entering a date.

I'm going to start by suggesting your use this link to review your code and the use of reserved words: http://www.allenbrowne.com/AppIssueBadWord.html#F

Try *importing* your db into a fresh, new db and see if the issue follows.

I have not done any testing but SubForms are not listed in the Forms collection so you may need to add the .FORM! qualifier. http://theaccessweb.com/forms/frm0031.htm

You're most welcome. Glad we could be of help.

You should be able to reference the %temp% value with this: environ("temp") ...so change this: TestFile = CurrentProject.Path & "\UpdateDbFE.cmd" ...to... TestFile = environ("temp") & "\UpdateDbFE.cmd" ...in the first set of code. It executes as the last part of that same code.

You can trust *anything* that Pat posts. She is an excellent helper.

The interval value has these choices: Settings The interval argument has these settings: Setting Description "yyyy" Year "q" Quarter "m" Month "y" Day of year "d" Day "w" Weekday "ww" Week "h" Hour "n" Minute "s" Second You'll notice that D is not among the choices.

Your 1st argument (D) is not a string value.

I'm a bit confused by your code. I would think that: Public Function CountDays1(startDate As Date, NoOfDays As Integer) As Date would be more like: Public Function CountDays1(StartDate As Date, LastDate As Date) As Long Which would then count the number of "working" days between the two dates.

From MS Access Help: You'll notice the 1st argument is a string value.

So you CAN teach an old dog new tricks! :D

Dave, do you get the same results if you import to Excel? Just curious.

Have you tried the Query Builder? It's pretty smart.

Thanks for the tip Colin. :D

I don't have ac2016 but it looks like the Quick Access Toolbar. Try playing with it. You used to be able to change it some.

Good. Let us know the results.

Rather that look in another table, why not include the "stock" value in this query and simply not display that field on your form. You could then use the field in the conditional format statement without trying to examine another table/query.

You want to conditionally color a field if another field in a different table has the word "stock" in it? Sounds confusing to me.

Try the InStr() function.