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 derfloh 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: *

  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...
  16. djwatts

    A different OWA problem

    Hi, No can't access it internally at all (we don't need external access), it just prompts for user name 3 times then says error: access denied. I haven't enabled SSL yet, wanted to get it working with Basic auth first. I have tried using various username combos i.e. username@domain.com...
  17. djwatts

    A different OWA problem

    Hi, Thanks for your reply, I have just checked all the settings in IIS and ESM and they appear to be all correct. The only thing that looks out of place is that we don't have the Exchange-OMA vdir, is this a default folder for Ex2003? We don't really need to get the mobile access working just...
  18. djwatts

    A different OWA problem

    Hello, Bit of a wierd one here, OWA stopped working shortly after it was installed. Haven't had time 'till now to get it sorted out. I've been through so many articles online and none seem to have my specific problem. We are part of a larger exchange organisation, we are a sub domain inside...
  19. djwatts

    Save Comments

    Well I'n new to CGI but I beleive I can use VB, Java & Perl to accomplish this? Do I need to install something to use perl? I'm running Abyss X1 web server on Windows 2003, only cause I didn't have my I386 folder handy to setup IIS. Plan to migrate soon.
  20. djwatts

    Save Comments

    Hi All, I'm an experianced VB & Java programmer but until now haven't really applied this to web pages. For a charity event I want to put a comment box on our site for feedback. Only to capture Name & Comment fields > preferably to store the info in a text file. Is CGI the right route to be...
    • djwatts
    • Thread
    • Replies: 4
    • Forum: CGI

Part and Inventory Search

Back
Top