Topics Search

64-bits nummeric data type

64-bits nummeric data type
Views: 0
I'm using Access 2003 and I'm not able to import an integer value larger than 32 bits. Does this problem still occur in later versions of Access or is it possible to import 64 bits integers
Sponsored Links:

More topics

 

Cash drawer and MS Access

Preview
A client has acquired a M-S EP127KLIC cash drawer. It is connected to the serial port of their computer and they want me to open the drawer from an existing MS Access DB form, command button, OnClick event.

I cannot find any references to opening com1 and sending a character to open the drawer in any of the HELP files or the VBA Developer's Handbook. The only cash drawer manual info references BASIC code: Print commands, baud rate, parity, number of transmitted data bits, stop bits, clear to send status, data set ready status.

There are DIP switches in the cash drawer that sets the character that will be recognized when sent, the baud rate, serial or parallel transmission, dead end or parasite mode.
 

Disappearing List boxes

Preview
I have list box on a form that selects the data for various bits of equipment by serial number. What I'd like to do is once that field has been selected, Id like the data in the drop down list to disappear so the focus is on the rest of the data on the form
 

Using Database

Preview
A database is nothing more than a program to store useful bits of information such as names, addresses, and phone numbers, or inventory part numbers, shipping dates, customer codes, and any other type of information that you think is worth storing.
 

How to Decide Which Data Type to Use in a Table Field

Preview
The default data type for a Microsoft Access field is text, but you can specify other data types if you wish. Choosing a specific data type ensures that you will get the best results from your queries and searches. Here are some steps on how to decide which data type to use in a table field in Access 2003.
 

Change a Field's Data Type

Preview
When you first design and build a database, you plan one or more tables, define the fields (columns) for each table and set a data type for each field. For example, if you need to store dates and times, you set a field to the Date/Time data type. If you need to store names and addresses, you set one or more fields to the Text data type, and so on. Here are some steps on how to change a field's data type in Microsoft Access 2003.
 

Memo to Text Data Type

Preview
I have a couple of fields spread across the database named "Notes" which is currently set as memo data type, I would like to change it to text data type.

What I already know:
1. Text data type can only have a maximum 255 characters.
2. Memo data type can store up to 1000 characters.

* I am sure that we don't need more than 255 characters for it; not now not ever, and we currently don't even have 50 characters stored in a single field so the truncation matter is out of the question.

What I would like to know:
1. Could I just directly change the Data Type of All Notes field in our Back end from MEMO to TEXT. Is it safe that way?

2. Is there a possibility of a corruption issue after the change or future use?
 

Modify or change the data type setting for a field

Preview
This article explains how to set or change the data type applied to a table field in a Microsoft Office Access 2007 database. When you first design and build a database, you plan one or more tables, you plan the fields (columns) for each table, and you set a data type for each field. For example, if you need to store dates and times, you set a field to the Date/Time data type. If you need to store names and addresses, you set one or more fields to the Text data type, and so on.
 

splitting complex column data

Preview
I have a complex dataset that contains mulitple labels and all the data is in a single column

The data is organized with these labels. Cell type, Run#, Timepoint
to Give a better idea
Cell type: A or B
Runs: 1, 2, 3
timpoint: 1-11

I want to seperate the data based on cell type and put them into the same query. I first tried creating 2 queries with an if statement for each cell type. When I try and combine these two queries, I always get junk data. One celltype will be fine but the other is always messed up. I then tried to use left join and right join but still the same problem
 

Grouping query

Preview
I have a table called TB which has PrevYear(Data type Currency), Debit(Data type Currency), Credit(Data type Currency), Description(Data type Text), Category(Data type Text). Category can be any of the following; revenue, expense, asset, liability etc.
I want to create a report/query which groups the categories as follows;

Revenue 2009(Debit/Credit) 2008(PrevYear)
Credit Sales
Cash Sales
Subtotal
Expenses
Wages
Travel
 

Introduction to Data Types

Preview
A data type represents the kind of information that a particular field should or must hold. Every field in your database objects (tables, forms, and reports) should have the right type and it is your role to select the most appropriate of them. This helps both you and the user who performs data entry. Furthermore, a good design will cause you less headache when creating calculated expressions. Learn: Techniques of Controlling Data Entry Properties, Strings and Data Types, Text Input Masks, Strings Formats, The Memo Data Type.