Search results

  1. S

    Procedure for AutoCorrect Function

    I turned it off so my margins would not change and so far it works. I would like to build a procedure to turn them off in my startup under Load, then back on in my Unload. I have used this procedure to turn off Document Deletions and Action Query. It works great, but when I try to add...
  2. S

    Merge it with MS Word

    Thank You so much! I going to give it try! Shannon
  3. S

    Merge it with MS Word

    I have been trying to create a macro that will select a query, start Merge it with MS Word, than perform a macro in Word. Is this possible? Any help would be GREATLY APPRECIATED! The ending product is a letter with the export data while keeping the format. I can do it but my users will not...
  4. S

    export a table to another database

    Thank you for all your help!
  5. S

    Assigning an autonumber to a subform

    Sorry if this has been answered before, I looked through and didn't see anything like my problem. Here it is: I have a subform within a form. The form is based off of my Clients Table just so they can see who they are billing. The subform has a Client ID, as does my Clients table...
  6. S

    Copying a table from multiple databases

    I have one main database and many secondary databases. These database are on different computers that are NOT connect by a network. I would like to have them send a table from their database via internet and have me upload the table into the main database. Making one big table that I can run...
  7. S

    export a table to another database

    Will that work when there will be 10 other computers involved? I have 10 salepeoples in 10 different cities and they all have Access. Once a week I want them to send their tables to me via e-mail and I append them in one big table. Then I can run calculations and totals. I don't want them on...
  8. S

    export a table to another database

    I have never linked table before. What I am looking for is to get a table from one computers access to another computer access via by downloading a file into the other computers access. Will I still be able to link them? Thanks!
  9. S

    export a table to another database

    What I'm going to have are many tables from databases going into one big table in another database. So what I invision is a command button (excuting a macro) to export that database into a file (?). Then the person maintain the big database downloading it into the database. Any ideas? I have...
  10. S

    Importing info from Excel

    Thanks, but I decided to recreate the whole form. It was more work but this way I don't have to worry about if the data valid or not.
  11. S

    IIF Statements

    Thanks you so much! It worked perfect.
  12. S

    IIF Statements

    I am trying re-create this Excel Formula into access Code. =IF(B43="53 Foot",(5000000/+IF($A24="Millimeters",(+B23*C23*D23),(+B24*C24*D24))),(4000000/+IF($A24="Millimeters",(+B23*C23*D23),(+B24*C24*D24)))) Thanks for the quick response!
  13. S

    IIF Statements

    I need to included two IIF statements in one. I can't use the AND because it is based on different results. Any help is much appreciated. Thanks Shannon
  14. S

    Importing info from Excel

    I have a very complicated form created in Excel that I want to import the information into Acces after they are done inputting. Does anyone have any ideas?
Back
Top Bottom