Question about Microsoft Office Standard for PC

1 Answer

MS Access 2003 Development - Format Problem

Hi! Just to let you know, I am not a novice in Access, but the databases I have developed have been simplistic and have not included any VBA programming. I have, within the last 4 months begun to use macros. I developed a database to track employee training. Employees are required to read certain assigned documents. The documents are constantly revised and therefore have revision numbers. I am transferring 100,000+ training records from an APPX application into my ACCESS database. I want the revision levels to appear in a decimal format in the Employee Training Record - example: 2.0, 4.0, 0.20040101, 0.20050304, etc. The Employee Training Record is a report in Access. The training records are stored in a table. The report is based on a query. I have tried numerous variations of formatting, but the best I have achieved is the revision level displaying in the report like 2.00000000. However, the 0.20040101 revisions always round to 0.00000000. The APPX application transfers them in a number format. I have not been able to change them to a text format, which is how I believe they would display properly. Can you help?

Posted by on

1 Answer

  • Level 2:

    An expert who has achieved level 2 by getting 100 points


    An expert that got 5 achievements.


    An expert who has written 7 tips or uploaded 3 video tips


    An expert who has written 3 tips or uploaded 2 video tips.

  • Expert
  • 58 Answers
Re: MS Access 2003 Development - Format Problem

Hi, the difficulty to solve your problem is that we are not familiar with Appx. I have faced this problem numerous time, but usually it was from Excel to Access. Now if you can transfer it to Excel then you can change the format in Excel to Text and import it into Access. I have also read a little of the Appx manuals and it says there that you can work with ODBC, are you using it? ODBC will create a connection between the APPX application Database and Access, you should be able to do your queries directly from the ODBC connection without the need to import the table. Here is a PDF manual of how to set it up from their website: I hope it helps, let me know and I will try to do my best to solve your problem. Daniel

Posted on Aug 13, 2007

Add Your Answer

0 characters

Uploading: 0%


Complete. Click "Add" to insert your video. Add


3 Points

Related Questions:

1 Answer

I have a database in mdb format that will not open. When I try to open the file I get an error: The Microsoft Access database engine stopped the process because you and another user are attempting to...

You can use Recovery Toolbox for Access developed for recovering data from corrupted Microsoft Access databases. The MS Access recovery tool is capable of repairing MDB and ACCDB database files.

For more:

Dec 01, 2015 | Microsoft Office Professional 2007 Full...

1 Answer

Repair MS Access database without having program installed

Use Recovery Toolbox for Access developed for recovering data from corrupted Microsoft Access databases. The MS Access recovery tool is capable of repairing MDB and ACCDB database files.

For more:

Oct 18, 2015 | Microsoft Office Business & Productivity...

3 Answers

Access database 2003 problem with a copy of database file. How to fix?

You say corrupt, in what way exactly? Do you get any specific error numbers/messages?

Have you tried Access repair program? Compact and Repair. If not, use it. But ensure that you made a backup, it is necessary because all the recovery tips can make the damage even worse.

Also try Jet Compact Utility. This tool created by Microsoft and it is much like Compact and Repair, but more successful in repairing.

If no one of above advice helps, then perhaps you need more powerful solution. In this case try to run a good third-party. I would recommend Recovery Toolbox for Access. It must help you.

Feb 23, 2015 | Microsoft Access 2003 for PC

7 Answers

MS Access database recovery

Have you tried creating a NEW MDB, and then IMPORTING the objects from the Crashed/Corrupted MDB?

This will SOMETIMES serve to rescue most if not all of the corrupted entities .

You can try:
eRepair Access is a powerful Access database recovery solution for damaged *.mdb and *.accdb files created in Access 2000 and above. Having such a tool at hand immediately after a database file corruption incident may save you a great deal of time, nerve and, of course, an ample amount of money that would otherwise be paid to third-party recovery services. With eRepair Access, you don't need to depend on anyone and entrust your Access data (often quite sensitive) into somebody else's hands. You don't have to wait. You don't have to call it a day knowing that the damaged Access file will not be restored (if at all) until tomorrow. With eRepair Access, you can be back in the game within minutes!

For more information:

If doesn't help, look here:

Feb 05, 2015 | Microsoft Office Professional 2007 Full...

4 Answers

Access 2007 corrupted database

back up files on external hard drive!! mirror hard drive, will keep corrupted file, it might cause further problems. you have lost some critical files, but you might have isolated a virus . Move on, do a clean install, after reload the backed up files one at a time.

Jan 11, 2015 | Microsoft Office Professional 2007 Full...

1 Answer

I want to learn that how can i connect my HTML page with my DATABASE created in MS ACCESS so that i can fill my table in HTML page directly-

1. You can use Pages option in MS Access. The page in MS Access is the web page in MS Access which allows you to access database in MS Access database.

2. You can use MS Office Front Page application and use the Form builder and connect your database in that.

3. You can also use Google Apps Business Solution for this however the database will not remain in MS Access but will remain in Docs online.

4. You can use .net application developer for this as well but needs expertise in that.

Mar 09, 2010 | Microsoft Office Standard for PC

2 Answers

....where to download ms access

Ms. Access is part of Microsoft Office and you cannot download for free.
But you can download Ms Access database viewer from here

Jul 29, 2009 | Microsoft Office Access 2003 (077-02871)...

2 Answers

Hi all i want to launch a form when i click the data base file in MS access 2003 (the form is created inside the mdb file of access)


on MS Access 2003:
goto Tools Menu --> Startup --> select your form for "display form/page" dropdown
uncheck the "display database window checkbox and display status bar checkbox

Hope this helps.


Apr 01, 2009 | Microsoft Access 2003 for PC

1 Answer

IT industry inflation

Nowaday, you can see the effect of IT technology anywhere, from a shopping center to Industrial works.IT is the knowledge of Data and connections between these data and other Tools, and don't forget that Databases are the most important tool for development. Anyway, Software development in present situation is useful and it has lot of money inside of itself! Be sure that working in this field is full of money and of course you should has many many hard excersice and also you should like it, in the other hand, at first you should like it then work with it. I provide some useful links about software development which could help you, check them:

Good luck

Mar 16, 2009 | Peachtree Software Peachtree Complete...

1 Answer

MS access - how to insert a function in a access table

Have you reached resolution yet? If not I would be happy to help otherwise, I would be interested to know what happened. It sounds like you need to call the date (today) for the appropriate balance to come in automatically - assuming you have a table holding this data. Thanks for rating FixYa!

Feb 06, 2008 | Microsoft Office Access 2003 (077-02871)...

Not finding what you are looking for?
Microsoft Office Standard for PC Logo

243 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Business & Productivity Software Experts

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers


Level 3 Expert

18257 Answers

Sudeep Chatterjee
Sudeep Chatterjee

Level 3 Expert

3267 Answers

Are you a Microsoft Business and Productivity Software Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides