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!

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

Recent content by djwatts

  1. djwatts

    Export to Excel

    Thanks for your help M8KWR, I really am restricted to generating the SQL clause on the fly as it is particularly complex. With a huge selection of fields for people to filter on a number of tables. The quick n easy solution for me was to keep it using a datasheet form and running the...
  2. djwatts

    Export to Excel

    Sure, I was thinking somewhere along those lines. What would be the best way to build an SQL query at run-time and save it so it can be exported? Thanks for your help
  3. djwatts

    Export to Excel

    Hello, I need to find the best way to export a selection of data to excel. Using the docmd.transferspreadsheet command doesn't seem to be an option as I need to export filtered results. At the moment this data can be viewed on screen using a form in data sheet view. This is important as I...
  4. djwatts

    Outlook object library

    Thanks for the help, its the late binding that I needed to get it working.
  5. djwatts

    Outlook object library

    Hi, I've got a database that uses the outlook object to add calendar entries and send automated e-mails. This works fine in Access/Outlook 2003, however I need it to support Access/Outlook 2000 aswell. In the project references I have the Microsoft Outlook 11.0 Object Library Microsoft CDO...
  6. djwatts

    autopopulate and update in form

    I assume that both the EmpID fields are the same data type also? Try changing the DLOOKUP to:- DLookUp("[Wage Rate]","tblEmployees","[EmpId] =" & Forms![HoursForm]![EmpId])
  7. djwatts

    autopopulate and update in form

    Did the DLOOKUP return the correct value? Have you tried editing the data field in the query manually through dataview? Some queries won't let you edit related records. It shouldn't really matter whether you lookup in the table of in the query.
  8. djwatts

    Security stop access to a button

    You could try opening the object in edit mode and see if an error is generated that you can capture and trigger an error message:- DoCmd.OpenForm "Form1", , , , acFormEdit
  9. djwatts

    autopopulate and update in form

    Are the data types in both fields the same? The data type for the wage fields in the Employee & Hours tables need to be the same... Try running: MSGBOX DLookUp("[Wage Rate]","tblEmployees","[EmpId] =" &[HoursForm].[EmpId]) And see if it returns the value that you're expecting. This...
  10. djwatts

    autopopulate and update in form

    Yeah I think DLOOKUP is what you need, something like. tblHours.wage = DLOOKUP("Wage", "tblEmployee", "[EmployeeID]=" & CurrentID) Should be able to put that as a control source property for a txt box etc. Where CurrentID is whatever your using to specify which employee its for. If CurrentID...
  11. djwatts

    Help with a QBF

    Are you using 'OR' or 'AND' between the two field criterias? Have a look in your SQL view and check this, sounds like its searching for:- ByLine1 = Like "*" & [Forms]![QBF_Form]![RepName] & "*" OR [Forms]![QBF_Form]![RepName] is NULL AND [rather than OR] ByLine2 = Like "*" &...
  12. djwatts

    On Timer Event - Modify MsgBox Properties

    From my experience the msgbox command seems to halt execution of code until a user response is given. You might be better off using some customised forms with no borders etc, that look like msg boxes. Then the second form could have its own timer property set. Just a thought
  13. djwatts

    A different OWA problem

    When I try and access the url it prompts for the username saying "connecting to: exchange.domain.co.uk" whereas in my test environment it shows "connecting to: domain.co.uk" All the IIS settings point to the domain and not the computer name. Could this be anything to do with the problem??? Thanks
  14. djwatts

    A different OWA problem

    Sorry, forgot to include - No we're using Symantec AV with the exchange agent, have tried removing this but it doesn't seem to effect the problem. Thanks for your help Regards
  15. djwatts

    A different OWA problem

    Hi again, Sorry for not getting back - i've been off on annual leave. i've looked at the article you mentioned above before, it seems to refer to problems relating to ISA, we're not using that product. Also we haven't enabled FBA yet, want to get it working normally first. do you have any...
See more

Part and Inventory Search

Back
Top