Microsoft Office Standard for PC Logo

Question about Microsoft Office Standard for PC

2 Answers

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 gdougher on

  • gdougher Aug 14, 2007

    Hello, Daniel. Thank you so much for your response. Unfortunately, I am not able to make the ODBC connection without a request to our IT group. This would not be approved at this time. I transfer the APPX file through an FTP program. It comes in a .csv file. I have tried both a direct import to Access from the .csv file and saving the .csv to an .xls file and then importing. It appears to me that Access will only round the 0.20040302 type number down to zero (o.o). I can't find a way to get it to NOT round the number. Is that possible in Access?

    Gaye

×

Ad

2 Answers

Talent Magnifer

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    MVP:

    An expert that got 5 achievements.

    Habit-Forming:

    Visited the website for 3 consecutive days.

    New Friend:

    An expert that has 1 follower.

  • Expert
  • 36 Answers

A large couple of solutions to repair Microsoft Access Databases from severe corruption. Both you may choose a paid tool just to save time and energy, or you may go along with an built in solution or a hands-on solution to repair Gain access to Database file.
You can repair Access database using an Access Database Restoration tool which is developed by one of the finest software developers in email and database software management industry. I am recommending this tool as System Info Tools also specializes in after sales service where many other software providers fail.
To know more about dis topic visit our site-
Microsoft MS Access SQL Certification Practical Training Course Institute...

Posted on Feb 01, 2018

Ad

Anonymous

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    MVP:

    An expert that got 5 achievements.

    Guru:

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

    Mentor:

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

  • Expert
  • 58 Answers

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: http://www.appx.com/ftp/appx/documents/manuals/appx/appxodbc/current/appxodbc-manual.pdf 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

  • Anonymous Aug 14, 2007

    Hi Gaye,

    If you can see the correct results on Excel you can change the format of that field in Excel to Text. Save it as an Excel file (VERY IMPORTANT) and then import it to access, when you import it make sure that the field in Access is Text as well. I just tried it and it worked fine on Access 2007 for 0.20040302.

    you can also use Pivot table to create queries at Excel as well, but you have to save it as an excel file first(But thats a whole different issue).

    I think that the first option should work for you just fine, let me know what happened

    Daniel

×

Ad

Add Your Answer

×

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

Related Questions:

0helpful
3answers

How to fix error in database: microsoft office access has detected corruption in this file

Are you suffering from the problems of damaged, inaccessible or corrupt .mdb or .accdb database files? There are several unexpected reasons to corrupt these files like virus infection, software crash or malfunctioning, dirty shutdown of PC, corruption in storage drive and even more.In any one of these above mentioned cases, you can use Stellar Phoenix Access Recovery is considered to be a complete fix. It seamlessly repairs all the corrupt MDB and ACCDB files of MS Access database. It can address database problems from any issue that is caused because of software conflicts, hardware failure, and any problem in database design.
1helpful
6answers

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. https://access.recoverytoolbox.com/
2helpful
9answers

Access 2007 corrupted database

You may try this third party tool programmed with best technology the tool support all windows and MS office versions. You may try free demo version of this software to preview your recovered access database. SysTools Access Recovery you may check How tool works and its user friendly interface make this easy to handle.
0helpful
1answer

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.

0helpful
1answer

Ms access

Microsoft access is a database application that is part of Microsoft Office. It lets you edit .MDB database files. Installing Access also installs the drivers that allow other applications which use the MS Access database format to also open their databases as well.

Not sure what your question means. If you want more information please ask me before rating the solution.
Not finding what you are looking for?

277 views

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

Ekse

Level 3 Expert

13435 Answers

David Shaub

Level 3 Expert

2994 Answers

Mehandi Husain ...

Level 3 Expert

1654 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...