Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Wongy
  • Order by date
  1. Wongy

    Expression too complex error

    Sorry Yes the group ones are OK as they don't exceed the max number of variables
  2. Wongy

    Expression too complex error

    Thanks for you time so far I haven't considered that before but reading the code properly yes you are correct. The default answer is N/A so it shouldn't be a problem.
  3. Wongy

    Expression too complex error

    Hi they are controls on the form. The database is used to quality assure our processes. The form asks questions to do with judgement, decision making, customer service and performance. Each question can return either 1 for yes , 0 for no, and 9 for not applicable The function takes these...
  4. Wongy

    Expression too complex error

    Thanks they are individual variables i.e. question 1, question 2
  5. Wongy

    Expression too complex error

    I have read as much as I can on this in the threads but I'm still not sure how to do this. My apologies if my predecessor pinched the code for function I have inherited a database which has a form where questions are answered via a series of combo boxes with the possible answers being...
  6. Wongy

    AVG 7 freezing my Machine

    Thanks for that I diabled the boot scan and that didn't work a friend suggested that I run Scanreg /fix to repair teh registry and that seems to have worked.
  7. Wongy

    AVG 7 freezing my Machine

    I've installed the latest version on AVG on my Machine but it now freezes just after it boots up. I get about 10 seconds from when it finishes booting up before the machine freezes. If I uninstall AVG my machine works fine. Previous versions of AVG have worked fine. I thought it may have been...
  8. Wongy

    Access automatically execute query at scheduled time?

    If you have the query you want to run as the autoexec macro you can schedule the job using MS Scheduler.
  9. Wongy

    Formating an undefined range in Excel from Access

    Thanks. fiendishly simple but highly effective
  10. Wongy

    Formating an undefined range in Excel from Access

    Hi all I have some code that inserts search results from an access database into an Excel worksheet. I want to put borders around the cells in excel. I know how to put borders around a defined range but the number of rows populated in the excel sheet will vary depending on the number of...

Part and Inventory Search

Back
Top