Search results

  1. B

    Disable a control VB question

    Great - Thanks! Its working well Bones
  2. B

    Disable a control VB question

    Hi All, I have a Form which allows a user to input. I want the user to use a certian order when filling them out. for example if "audStart" is not filled out then preceeding controls are disabled. When they do input data into "audStart" the next Control is Enabled. Does any know how to do this...
  3. B

    synchronize linked tables to sharepoint

    Hi All, I currently I have a query linked to a sharepoint site (for read only). When the query changes I try to synchronize the linked query with the sharepoint site. Using the link table manager it says its updated up nothing on the sharepoint site is changed. I believe that if I change a...
  4. B

    Listbox and SQL

    try using it in a query
  5. B

    Get number of users currently using an access db

    Run an Audit Trail (search the forum) and then a query by user name.
  6. B

    open pdf based on form fields

    you should be able to use the code and tweek it a little. If you want attach the file and I will look at it.
  7. B

    open pdf based on form fields

    I think you might need to try this one: Private Sub Command2_Click() Dim tbFile As String Dim Path As String Dim Ext as string Dim FFile As String ext = (".pdf") Path = Me.route 'this assumes that county is your field name tbFile = ("c:\LandAcq\County\") FFile = tbFile & path & ext...
  8. B

    open pdf based on form fields

    try this code: Private Sub Command1_Click() Dim tbFile As String Dim Path As String Dim FFile As String Path = Me.county 'this assumes that county is your field name tbFile = ("c:\LandAcq\County\") FFile = tbFile & path OpenFile (FFile) End Sub and Private Sub Command2_Click() Dim...
  9. B

    run mp3

    Thanks. Bones
  10. B

    A beginner Access problem.

    What airline to you work for? I work for an airline and kind of know what your talking about. Email me.
  11. B

    Outlook contact problem

    I am not 100% sure, but in order for you to update your contacts Outlook must be running. I think this because my IPOD video has an option to have my outlook contacts loaded. If outlook is not running I get an error message. Hope this helps...
  12. B

    run mp3

    do you know what the control is called?
  13. B

    Email more than one report

    DB7, I was just trying to email 2 reports, not combine them. I don't know if its possible. No one seems to have an answer.
  14. B

    Email more than one report

    a little. This codes emails any files I have in C:\temp. I just need to know how to combine them. aby ideas? Private Sub cmdEmail_Click() Dim Count As Integer ' ********** First place all of your files in an array ************** Dim DirectoryFiles() ' This must be above Sub Main...
  15. B

    building a db

    you need to zip it and then post it Bones
  16. B

    building a db

    I bet if you post what you have, someone will finish it. Bones
  17. B

    Highlight Search results

    Anyone else have any suggestions?
  18. B

    Multi Select Box's

    In your query under critera, use: date()-31 and date()+31 Hope this helped
  19. B

    Highlight Search results

    Thanks for the idea. I will keep search though.
  20. B

    Highlight Search results

    Good Day All, I have a wild card search query (Like "*" & [Forms]![search]![Text0] & "*") that works very well. I want to be able to have the phrase that user types in highlighted when it returns the search results on a form. I found the following thread that asks the same question using...
Back
Top Bottom