Search:

Type: Posts; User: fatherjack; Keyword(s):

Page 1 of 16 1 2 3 4

Search: Search took 0.03 seconds.

  1. Replies
    9
    Views
    423

    Re: Pass Thru Query (Access XP / SQL 2000)

    Great, now i feel twice as stupid. /forums/images/smilies/sad.gif

    OK, thanks for the 'SQL Functions you didnt know about' lesson!!!

    cheers Rory
  2. Replies
    1
    Views
    1,093

    Terminate process (VB.Net)

    Hi,

    i have an HR system that links with Office for exports of reports and mail merges, etc. However there are problems regarding the normal.dot document and after the HR application closes there...
  3. Replies
    9
    Views
    423

    Re: Pass Thru Query (Access XP / SQL 2000)

    How stupid do i feel now?


    VERY

    sorry Hans, forgot about the drag/drop onto a report creating controls with the field names. now renamed to txtArea etc and all is well.

    thanks
  4. Replies
    9
    Views
    423

    Re: Pass Thru Query (Access XP / SQL 2000)

    unfortunately not.

    the known_as and surname fields are concatenated in one textbox as
    [MForename] & " " & [MSurname]
    and the NZ function doesnt work in any part of it.

    The area field is...
  5. Replies
    9
    Views
    423

    Re: Pass Thru Query (Access XP / SQL 2000)

    good idea Hans but i get #Error when i put any sort of expression into the textbox on the report, any ideas?
  6. Replies
    9
    Views
    423

    Pass Thru Query (Access XP / SQL 2000)

    Hi,

    i have a SQL server with an HR database and have created a view on the database as:
    SELECT p.staff_number
    , p.known_as as [Forename]
    , p.surname as [Surname]
    , p.start_date
    ,...
  7. Replies
    8
    Views
    742

    Re: CommonDialog API (XP)

    by jingo, it works!


    many thanks Hans
  8. Replies
    8
    Views
    742

    Re: CommonDialog API (XP)

    hmmm, tried something like that before i posted; getting this error

    Method 'FileDialog' of object '_Application' failed

    do i need to add a new reference?
  9. Replies
    8
    Views
    742

    Re: CommonDialog API (XP)

    Hans, how would i reference the FileDialog object? Currently i am using the method described here 473377
  10. Replies
    8
    Views
    742

    CommonDialog API (XP)

    Hi,
    i am using the CommonDialog API to let a user select a file via the open dialog. how do i construct the filter type filter?

    i am lost for the seperator character

    Excel Files...
  11. Replies
    2
    Views
    318

    Re: No Warnings but Errors (XP)

    ideal solution, many thanks.


    <<off to hunt down all docmd.runsql statements and replace them ... >>
  12. Replies
    2
    Views
    318

    No Warnings but Errors (XP)

    Hi, just a quckie i hope.

    i am running an insert statement and rather than annoy the user i am turning off the warnings via:
    DoCmd.SetWarnings False
    DoCmd.RunSQL <<strSQL>>
    DoCmd.SetWarnings...
  13. Replies
    3
    Views
    372

    Re: Formatting whole document (XP SP3)

    it was ticked, nice one Hans, thank you.
  14. Replies
    3
    Views
    372

    Formatting whole document (XP SP3)

    Hi,

    I am not an advanced user of word but feel i know the package reasonably well. i have however come across something that has baffled me and the rest of the ICT team here. I have a document...
  15. Replies
    4
    Views
    425

    Re: Access Object (XP)

    Excellent Hans, thanks. why is there a difference between the Tables collection count and the TableDefs count? the first returns 224 and the other 33.

    there are actually 26 tables and 7 system...
  16. Replies
    4
    Views
    425

    Access Object (XP)

    Hi,

    i am trying to build a database that will analyse other database to give broad details such as a count of tables, queries, forms, reports etc. This is in order to provide an estimate on how...
  17. Replies
    3
    Views
    394

    Re: ActiveX control with no licence (XP)

    got it working now, thanks Hans and Charlotte.
  18. Replies
    3
    Views
    394

    ActiveX control with no licence (XP)

    I am adding to a database that was developed in Access 97 and hase since been upgraded to XP.

    on an exisiting form i want to add a command button that will allow the user to browse to a file to...
  19. Replies
    1
    Views
    284

    Database Version (XP)

    Hi,

    I have a database (Access FE looking at SQL 2000) that is under constant development. Is there anyway via VBA to get to the values stored in the Tools|Start Up|Application Title text box?

    I...
  20. Replies
    4
    Views
    439

    Re: Link to Active Directory (XP)

    I dont want to create an interface as such.

    What I would like to do though is have some sort of data transfer process in place where information can come from our HR system (there are others but...
  21. Replies
    4
    Views
    439

    Re: Link to Active Directory (XP)

    Hans, I understand what Active Directory is, what i dont know is how to get information into it from for example a personnel database and an asset database and so make the information in both much...
  22. Replies
    4
    Views
    439

    Link to Active Directory (XP)

    Hi,
    we have recently had Active Directory turned on (or whatever you do when you go from NT4 to Server 2000!) in our company. Can anyone tell me whether it is possible to link Access directly ot the...
  23. Replies
    10
    Views
    1,324

    Re: Access RunTime (XP)

    OK, some of this is starting to go over my head <img src=/S/confused.gif border=0 alt=confused width=15 height=20>

    Firstly, Charlotte, sorry for posting in the VB forum too, i wasnt sure where...
  24. Replies
    2
    Views
    361

    Create Executable (VS.Net)

    hi,

    I need to create a runtime version of an access XP database and am unable to obtain a copy of the Office XP ODE. Can anyone tell me whether it is possible to create a stand alone exe file with...
  25. Replies
    10
    Views
    1,324

    Re: Access RunTime (XP)

    There ar eno copies available (to my knowledge) in the UK as there were issues with java something or others and the product got pulled.

    Do you know whether VS .Net will create an executable from...
Results 1 to 25 of 393
Page 1 of 16 1 2 3 4