Question about Microsoft Office Standard for PC

# 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

• 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

×

### 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

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.
Microsoft MS Access SQL Certification Practical Training Course Institute...

Posted on Feb 01, 2018

### 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

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

×

×

my-video-file.mp4

×

## Related Questions:

### The base has stopped working with VBA. Does anyone know a solution? 1. Access 2000 2. fillet .mdb 3. eject from the project (project closed) 4. If the transfer form in Design view and open an existing...

First, go to this forum

And now do:

- A backup copy of the file and do not touch the original (do not start)

- Open to make a copy holding SHIFT

- Accession to the menu (top) service Sluzheb.programmy compression and vosstanovt base

go to Start vindous (where programs, etc.)

select Run

enter here the word cmd and click OK

in a black box, write this:

_ _ Path to the file _ _msaccess.exe_ / msaccess.exe _ _ path to the project _ _ / _ the name of the project .mdb / decompile

click enteritis

PS: _ _ path to the file _ _msaccess.exe_ - it can be about this C: \ Program Files (x86) \ Microsoft Office \ OFFICE11

if you HP instead of Program Files (x86) write Program Files

+

do not write the way his hands go wrong. a copy of the address bar when you reach the desired

and paste (there is inserted, but not CTRL-V, and from the context menu ... well, it's on the right mouse button)

Also Try the use Access Restore toolbox for recovery. It also helped me

Visit this forum for your solution

Dec 01, 2014 | Microsoft Office Access 2007 for PC

Apr 15, 2013 | Computers & Internet

### What is the extension file name for a microsoft access file?

According to Wikipedia:-

Access Database (2007) .accdb
Access Database Runtime (2007) .accdr
Access Database Template (2007) .accdt
Access Database (2003 and earlier) .mdb
Access Database, used for addins (2,95,97), previously used for workgroups (2). .mda
Access Database Template (2003 and earlier) .mdt
Access Workgroup, database for user-level security. .mdw
Access (SQL Server) detached database (2000) .mdf
Protected Access Database, with compiled VBA (2003 and earlier) .mde
Protected Access Database, with compiled VBA (2007) .accde
Windows Shortcut: Access Macro .mam
Windows Shortcut: Access Query .maq
Windows Shortcut: Access Report .mar
Windows Shortcut: Access Table .mat
Windows Shortcut: Access Form .maf

Jun 03, 2010 | Microsoft Office Access 2003 (077-02871)...

### Hi when we use the opus utility driver that you cab get from Bixolon we can open the EPOS till draw. however we cant open it using VBA (access) we have used the printer code 27, 112,0,50,250 Can you help

Are you a developer? OPOS is pretty much a plug and play driver. there isnt much you can change on it besides the port and how you name the printer. I suggest contacting Bixolon directly

Feb 26, 2010 | Samsung SRP 350 Thermal Printer

### VBA and macros

SLA consultants in India. The training program is intelligently designed by industry experts to provide hands on experience and in-depth knowledge to the participant regarding MA Access database and Visual Basic for application programming. The training will use real time practical sessions and live projects and assignments to offer you a better understanding of both the tools. https://www.slaconsultantsindia.com/vba-macros-programming.aspx

Jun 22, 2009 | Microsoft OFFICE 2003 BASIC OEM ENGLISH MS...

### In Excel trying to compare two ranges

I imagine that the only way is with VBA coding. This is possible if you know programming in Excel (VBA - Visual Basic for Applications).

Apr 17, 2009 | Oracle Database Enterprise Named User Plus

### CODES for entering an I.D number using vba

Try the help built into Excel and give yourself time to absorb it; Excel has some of the best help in the business. VBA may be more complex than you need to solve a data entry problem. If you're trying to add data input masks in a database, why don't you try Access (the help for which is admittedly weaker because database programming is among the most complex of all productivity apps)? I learned VBA from 3 books I rented from a good public library over the course of a project that was about a month long, (because) at some point Microsoft abandoned the idea of teaching it via help screens. Still, you might join a MS developer site and those are loaded with detailed explanations and many other experts. I hope this helps... I feel your pain.

Mar 22, 2009 | Microsoft Office Excel 2003 for PC

### Need Formula

TEXT CASE
Convert to UPPER, Proper or lower
Auto Convert to UPPER, Proper or lower
Stop VBA Being Case Sensitive

SELECT CASE VBA
Select Case Statement. Great alternative to Else If Statements

CONVERSION
VBA: CBool(),CByt(),CCur(),CDate(),CDbl()Double,CDec(),CInt(),CLng(),CSng(),CStr(),CVar().
Example
dDate=cDate("25-Jan-07")
Convert Numbers to Words
Convert Numbers to Dollar Amount in Words
Spreadsheet Converter. Versions: HTML/JavaScript,Excel ASP.Net and Excel Java/JSP. $SQL Database Migration$
Converters. Database Converters, Spreadsheet Converters, Text Converters, E-mail Conversion, Document Conversion, PDF Conversion and more! $CSV Converter$

IMPORTING
Import SQL Into Excel-SQL Tester $Import Excel Into Access$

CONDITIONAL FORMATTING
Conditional Formatting
More Than 3 Conditional Formats
Conditional Format Fonts for greater than 3

CUSTOM FORMATS
Custom Formats
Excel see a cells format as having four Sections. These are, from left to right: Positives;Negatives;Zeros;Text.

To hide zeros cell-by-cell use a Custom Number Format like 0.00;-0.00; where 0.00 is desired format for non zeros. Note the use of -0.00 for negatives.

To hide zeros on the Workbook level go to Tools>Options>View - Zero Values.

Dec 15, 2008 | Microsoft Windows XP Home Edition

Hello,
The standard way of creating a database using VBA, which can be modified to suit your needs is this--> Note: the code (wspDefault.CreateDatabase("Newdb.mdb"...), can be altered to save the database in a folder  such as "C:\NEWDB\text.mdb". sub NewDatabase()     Dim wspDefault As Workspace, dbs As Database     Dim tdf As TableDef, fld1 As Field, fld2 As Field     Dim idx As Index, fldIndex As Field     Set wspDefault = DBEngine.Workspaces(0)     ' Create new, encrypted database.     Set dbs = wspDefault.CreateDatabase("Newdb.mdb", _         dbLangGeneral, dbEncrypt)     ' Create new table with two fields.     Set tdf = dbs.CreateTableDef("Contacts")     Set fld1 = tdf.CreateField("ContactID", dbLong)     fld1.Attributes = fld1.Attributes + dbAutoIncrField     Set fld2 = tdf.CreateField("ContactName", dbText, 50)     ' Append fields.     tdf.Fields.Append fld1     tdf.Fields.Append fld2     ' Create primary key index.     Set idx = tdf.CreateIndex("PrimaryKey")     Set fldIndex = idx.CreateField("ContactID", dbLong)     ' Append index fields.     idx.Fields.Append fldIndex     ' Set Primary property.     idx.Primary = True     ' Append index.     tdf.Indexes.Append idx     ' Append TableDef object.     dbs.TableDefs.Append tdf     dbs.TableDefs.Refresh     Set dbs = Nothing End Sub
Hope this helps! Please let me know if you have any questions.Thank You,Raph30

Apr 10, 2008 | Oracle 10g Database Standard (ODBSEONUPP0)

### Eager To Learning MS Access

The easiest and fastest way to learn the basics of any of the main office programs is with multimedia tutorials. Ranging 5-10 times faster than text. More can be learned in this way in a shorter time.
In regards to VBA, if you only want to work with macros and scripts within an application, a minimal knowlege is all that is necessary. If you are wanting to use VBA across applications, you will need a little more depth of knowlege (at least in my case) is needed. May I suggest Microsoft's 'inside out' series of books. It looks intimidating but you only need the section you are studying.
There is something special about getting tutorials and learning information from the actual program manufacturer. They are the authority and free.
Okay, my suggestion is to first go to Microsofts website and view the tutorials available for your application: MS Office tutorials
Then, if you find your thirst for knowledge unquenched:

• Third party online tutorials are often quite good. But often the depth knowledge like VBA will turn into a 'tips and tricks' rather than the foundation needed.
• Get some of the multimedia learning, all it takes is a few 20 minute segments. Titles like Mastering Access 2003 by Magic Media, includes VBA.
Learning some of these applications can be very daunting. It is estimated that your typical user will use only around 10% of the programs capabilities. And they keep adding capabilities! Anyway start easy and work your way up to the complexity you want.
For the other users that have similiar problems, the real answer is to learn the above. But to convert numbers to words you need to redefine the field as text, and enter numbers.
And if you are setting up a search criteria for multiple text boxes using IF condition, it depends on what you are comparing. If you are comparing to a set quantity it would look something like this: IF field/text box = "Fixya" THEN performed action. Endif. If you are comparing two or more text boxes to each other it may look something like this: IF field/textboxA = fieldtextboxB or fieldtextboxC THEN action Else action. Endif

Hope this helps!
Ted

Dec 30, 2007 | Microsoft Office Access 2003 (077-02871)...

#### Related Topics:

265 people viewed this question

Level 3 Expert

Level 3 Expert