Search results

@VilaRestal - Unfortunately your VBA didn't work either. Thanks for trying.

Worked like a charm!

Worked! You're the best!

Thanks Bob! I'll give this a go. I think I saw this in one of the pages I was perusing but had closed it.

I have a .CHM help file ready to go and I'd like to place a button in my Access database. I read up on how to add it here initially: http://support.microsoft.com/kb/296231 This didn't seem to work when I pressed F1, and I made sure the file was in the same folder as the database (along with...

Didn't end up using the expression. I used VBA, which helped because I had other parameters I wanted to specify along with the back color.

If it isn't locked then it should validate, not if it is locked. Otherwise it would be checking for a validation that will definitely get an error because it is locked. I actually was checking a control, just was writing fast here and didn't catch that.

I am trying to avoid using two forms. When I do, there isn't a problem.

@VilaRestal - I will try your suggestion tomorrow and get back on the results. @gemma-the-husky - The DLookup did work as expected previously, but not in this situation. I do use the US date, although I am currently overseas. Here is a breakdown of what I am trying to accomplish: 1st Form -...

Just tried it, and it still gives me an error on the first part (even switched). Switched the first part from this: If [Forms]![frmDates2].Enabled = False Then If DLookup("Days", "tblDailyReport", "[Days] = #" & [End Date] & "#") Then 'Do Nothing End If Else MsgBox "No...

I had tried this without success, but I'll try it again, may have been just too tired to realize. I may have to try it but switch the places of the conditions.

AndAlso checks the first statement, and if that is already not true, skips the second. For some reason And isn't working for even though one part is false, so I had planned to use AndAlso.

I have duplicated the form and taken out the piece of code. This works, but I would like to find a method to skip over this if possible.

The route was awkward. There are many interface forms. I merely changed the order so that the date form was first, then hidden, then the reports are chosen. Thanks for all the help!

The problem is that that date field is locked depending on the options selected from the previous form, so no date value will be entered.

I have a piece of code that requires a logical operator like AndAlso in VB.net. I can circumvent this by creating another form, but I am trying to reuse forms where possible as there will be many more to add later. The code is a simple If statement with the first line involving both a DLookup...

I ended up going a different route that didn't involve OpenArgs, and that worked. Thanks for the help!

@jdraw thanks for the reply. Someone had mentioned opening the date form first, but not the OpenArgs. How would I get the value in the OpenArgs to pass to my report? I'm assuming it will look something like this to start with: DoCmd.OpenForm "frmName", , , , , , "OpenArgs"

I have an intricate bunch of switchboards that opens different forms and reports. When I get to reports, you first click a button to open reports instead of forms, then the report of your choice, then a form that has a start and end date, then finally the report selected. Everything was...

I tried both the way I was given and what you gave me, but neither worked. Also tried with the iif() statement, but no change. I did make sure it was EXPRESSION IS as well to no avail.