Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by jaggar

  1. jaggar

    Converting a MDE ACCESS DB to a MDB ACESS DB

    I am having problems in changing an access data base from MDE to a MDB. Do anyones out there know or have instructions on how to perform this task? Also once I have made my changes in the MDB data base I will need the instructions to change the MDB data base back to the MDE data base. Thanks...
  2. jaggar

    Converting a MDE ACCESS DB to a MDB ACESS DB

    I am having problems in changing an access data base from MDE to a MDB. Do anyones out there know or have instructions on how to perform this task? Also once I have made my changes in the MDB data base I will need the instructions to change the MDB data base back to the MDE data base. Thanks...
  3. jaggar

    Access DB using Visusal Basic to Export a fixed data file

    Thanks HarleyQuinn for the information. Jaggar
  4. jaggar

    Access DB using Visusal Basic to Export a fixed data file

    Can anyone help me. I have not used Access since 2003. I need to modify an export file. I cannot remember the steps to do this. I used Visual Basic to perform the process. DoCmd.TransferText acExportFixed, "ExprtSpec1", strQname,strFileNames. For ExprtSpec1 I believed I had to click on...
  5. jaggar

    Rounding up to the nearest dollar amount

    How do you code a variable which have dollars and cents amount in SQL to round up to the nearest dollar? Thanks...
  6. jaggar

    Importing a text file from a server to an ACCESS database

    I am trying to import records from a text file (which is located in a folder on our server) to an ACCESS database. My problem is that I have defined the specification file with delimiters between each field. The last field in the record is defined as a 'comment' with a data type memo. My...
  7. jaggar

    Data Base Maintenance

    Can any one tell me how they keep track of their updated objects? Is there a way to print out of what objects has been updated? Thanks
  8. jaggar

    Deleting records from a text file on a server

    I do not want to form a likage with this text file to an Access table, because once I delete the records in the text file, other records will be written to it. Thanks, Jaggar
  9. jaggar

    Deleting records from a text file on a server

    My question, how can I delete records in a text file on the server using ACCESS/Visual Basic ? Code used - when the User clicks on a button in Access the code behind: Dim strAcctFileName As String Dim fs, f, ts, S, a Const ForReading = 1, ForWriting = 2 Const TristateUseDefault = 1...
  10. jaggar

    Restore an access table

    Richard, You are correct. Thanks
  11. jaggar

    Restore an access table

    Thanks, Replace or overwrite please explain the differences. I also would like to know which one would be the easiler to process.
  12. jaggar

    Restore an access table

    I would like to create a form in which a user can click on a buttom to restore an access table from a disk (text file). I would like the data from the disk file to overlay what is in the table. Can this be done?
  13. jaggar

    Queries Help

    I have two query. Each query records has an ID_Number, an ID_code and money amount (Sum UP). How do you compare records from both query. I am writing a report for example, I must compare the two query. Match and duplicate won't do. Query one Query two Records 1 A 200...
  14. jaggar

    Rounding down a calculation for display on the report.

    I created a query that calculates a percent .0200 to a budgeted amount. Percent_Incr = (.0200 * [Budgeted_Amount] + [Budgeted_Amount])what happens in the query I get the correct value without the period and the cents added even thought it has a fixed format. Then when I creates the report it is...
  15. jaggar

    Numeric field text output

    Is their an SQL equivalence to the Visual Basic CStr(Mynumericfield)?
See more

Part and Inventory Search

Back
Top