Search results

  1. T

    Report.FilterOn is not working

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

    Report.FilterOn is not working

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

    Hi from Sydney

    Nice to see you here.
  4. T

    Report.FilterOn is not working

    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.
  5. T

    Report.FilterOn is not working

    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...
  6. T

    Forms not refreshing when navigating between them

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

    Solved Web Browser Controls : A never ending struggle.

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

    Hello from UK!

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

    Syntax error "="

    "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...
  10. T

    Syntax error "="

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

    Syntax error "="

    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...
  12. T

    Hi Shimon, I read your post where you wrote: "I’ll try to strip the personal data and upload...

    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
  13. T

    "DROP TABLE table" works once then fails later on.

    > 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...
  14. T

    accidental shut off my machine lead to erro

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

    accidental shut off my machine lead to erro

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

    "DROP TABLE table" works once then fails later on.

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

    "DROP TABLE table" works once then fails later on.

    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.
  18. T

    VBA Alternative to a Slow Query Chain

    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.
  19. T

    Is there a tool that analyses a table then reconfigures the data field size to be optimum?

    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?
  20. T

    More Advanced Query Assistance

    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.
Back
Top Bottom