Search results

I had tested that, and it did not make a difference.

Interesting though that setting a WhereCondition during DoCmd.OpenReport allows the code to be in Report_Open and work just fine.

Nice to see you here.

I found a workaround: in frmReports where the report is opened, add this: 130 DoCmd.OpenReport TempVars!ReportName, TempVars!ReportView, "", "1=1", acNormal I wonder if this behavior is a bug, or by design.

In Report_Open I have: Me.Filter = "EmployeeID = 1" Me.FilterOn = True For example, you can paste this in Northwind Dev edition rptSalesByEmployee. Set a breakpoint on the next line. Observe that FilterOn is still False. Why is that? And the report is not filtered. I know there are other ways...

Make sure you have the latest video drivers, and also select a common default printer (e.g. MSFT Print to PDF).

@Colin: Is MSFT aware of these problems? Apparently there are at least 2 bugs with their preferred browser control.

Welcome to the forum. We're looking forward to your questions.

"selAlpha is an option control" We have to use precise language. Access does not have an "option control". It has an Option Group, and such group can have 3 styles, including one with Toggle Buttons. It appears that's what you have used, and indeed a Toggle Button has a Caption property. When...

is selAlpha a Label control? There are only very few control types that have a Caption property.

As to the "Why" question: Your first statement: If Me.selAlpha & "" = "" Then Is interpreted as: If Me.selAlpha.Value & "" = "" Then The & "" part is often used to convert a Null value into an empty string, so that empty string can be compared to "", and the result is True. Compare that to...

Hi Shimon, I read your post where you wrote: "I’ll try to strip the personal data and upload it." I'm working on an Anonymizer that does just that. It's not ready for prime time, but I could send you a test version if you like. My email is tom7744@cox.net

> The Boolians are flags that identify which programs an individual is a member of. They are here for reporting purposes only. So if there is a new program, you're going to add a new field, change the queries and forms and reports? That's certainly job security, but not the way a Relational...

Check your Windows language settings in Settings > Time & Language > Language & Region. Do the same thing for Office language settings in File > Options > Language.

Please give us the EXACT error message(s). One way to do that is to post a screenshot.

On a copy of your FE, can you import the relevant Azure linked tables so they are now local tables, and try again?

Isn't it MUCH better to delete the existing rows and append the new rows? Dropping and recreating a table seems very wasteful. After dropping a table, the tabledefs collection has changed, and that may explain why it only works the first time. You need to run CurrentDB.Tabledefs.Refresh.

For another perspective on inventory functions, take a look at the Northwind 2 Dev Edition template, and this video where Kim Young discusses the inventory module.

I wonder if it is actually a bug that you can index a Long Text field. It makes no sense. It is still true that you cannot ORDER BY a Long Text field, right?

That relationship is no good. Right-click the line and select "Enforce". Only then will it actually do the job of making sure all GroupMembers have a valid ReservationNumber.