Search results

  1. A

    Deleting Files on exit

    I currently store temporay word files on each users C drive (c:\access info\forms\*.doc) and i want to delte these files on exit from the database. could anybody please advise on how to do this. Thanks
  2. A

    Deleting Files on exit

    I currently store temporay word files on each users C drive (c:\access info\forms\*.doc) and i want to delte these files on exit from the database. could anybody please advise on how to do this. Thanks
  3. A

    Automatic File naming

    I have created an access database which one of it's functions is to create a word form and insert data. (all works well) now i would like to develop the form so it saves automatically in RTF (all formating is present) and assigns the file name from three concatinated fields/bookmarks. could...
  4. A

    returning file info from folder

    I have see nsomewhere on the internet that it is possible to produce a record set from information of files within a folder.. ie file name date modified/created etc. could someboy please point me in the right direction as i need to check alot of files in a short time. Thanks. ps... i'm only...
  5. A

    SQL in VB

    Thanks for the info so far. but i am no having trouble with the exporting of the results to a word doc. could somebody please help me as i am getting he code totally wrong...
  6. A

    SQL in VB

    Thanks for the info so far. but i am no having trouble with the exporting of the results to a word doc. could somebody please help me as i am getting he code totally wrong...
  7. A

    SQL in VB

    Thanks cheers that has worked...
  8. A

    SQL in VB

    I am trying to run an SQL query in vb to return a recordset. i m using the following code (or trying to) Dim Recordset As New ADODB.Recordset Dim SQL As String SQL = "" When i try and paste the following code inbetween the "" it insterts below the SQL = "" statement and...
  9. A

    Creating a report from multiple tables/forms

    Bump.... still need help with this one please.
  10. A

    Creating a report from multiple tables/forms

    The process involved is relatively simple. 1) site is given (nominated) to an external contractor to design & build 2) the date the nomination sent, received and arranged site visit is tracked and measured. 3) initial drawings (planning drawings) are sent in for approval 4) again drawing...
  11. A

    Creating a report from multiple tables/forms

    Could you please help me out. I am trying to develop a DB that is multi user. i ahve not split the data from the forms into separate db's as the users are in different locations and our network can be very slow. part of the requirerment is to produce a drawing approval form, my current...
  12. A

    how do i create a on the fly query

    I want to simplyfi the method of merging data to word. presently i have created a command button to run a make table query and then merge the data from word (template setup). the user has to press the button click yes to the various warnings then input the referance no. followed by more warnings...
  13. A

    Active X error

    I have automated the production of a word form and it works on my laptop but not on another workstation. where it comes up with "Active X can't create object" i have referanced word, and used the code below. Set WordObj = GetObject(, "Word.Application") WordObj.Visible = True...
  14. A

    problem with access

    Yes i have, it kept on replying with the same issue. have also tried creating new database and importing table and forms... still same error.
  15. A

    problem with access

    I have created a temporary form copied from another to work out some coding (new to VB) and then deleted it. however when i now try to access the original form it comes up with an error. stating the 'error accessing file, network conection may have been lost' i have looked in the code window...
Back
Top Bottom