Question about Microsoft Office Standard for PC
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?
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
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
Tips for a great answer:
Usually answered in minutes!
Step 2: Please assign your manual to a product: