Search results

  1. P

    parse text

    I have a text file in this format: Name: Bill Gates address1:One Microsoft Way address2:Redmond, Washington address3:USA and I want it in this format. address1 address2 address3 One Microsoft Way Redmond, Washington USA
  2. P

    Update Query Nightmare

    I have a database that generates customer transactions history but no invoice no is generated for the transaction. I need to generate invoice numbers for each line item to produce invoices for the customers problem being a customer can have multiple items per invoice. How can I update the table...
  3. P

    Deleting Leading Spaces

    I need some help deleting leading spaces before a field "ItemCode" but the Trim function does not seem to work. Can anybody help.
  4. P

    Delete records

    I have a table in acces which is actually a transaction history report file from an accounting program. It contains all the transactions for the last business week. I need one transaction for each item where the cost is different. eg. I have ten transactions for the item chicken breast. of the...
  5. P

    Linking to Foxpro free tables

    I am not sure if what I am trying to achieve is possible but here goes. I want to link to a group of foxpro free tables using VBA reason being the names and the number of tables I am linking to changes periodically so therefore I want to be able to link to whatever tables are within the...
  6. P

    Linking to Foxpro free tables

    I am not sure if what I am trying to achieve is possible but here goes. I want to link to a group of foxpro free tables using VBA reason being the names and the number of tables I am linking to changes periodically so therefore I want to be able to link to whatever tables are within the...
  7. P

    Copy folder

    Hi Guys I need some help with copying a folder from a server to a local computer. I need to copy a foler with dbf files the server to my PC. How can I achieve this. I do not want to use a batch file.
  8. P

    VBA code error

    I got this code from the web it is supposed to open the browse folder dialog box but I can't get it to work it keeps telling me that cannot find project or library and highlights Space$ I an access newbie and I would really appreciate some help with this. Option Compare Database...
  9. P

    open folder

    I have a module a database that creates folders using the value in the fname and lname field. I got some help to create this from this forum I now need some help to open these folders from within access using the fname and lname of the current record. can anyone help me please.
  10. P

    Update Visual Foxpro Free Table

    I need to update a dbf file with data from access using pass through. can anyone help.
  11. P

    Create Folder

    I need to create directories from within access and use the records in the lastname field for the directory names.
Top Bottom