64-bits nummeric data type
Cash drawer and MS Access
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.
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.
Disappearing List boxes
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
How to Decide Which Data Type to Use in a Table Field
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
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
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?
splitting complex column data
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
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
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)
Introduction to Data Types
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.
Make a messagebox
When I open a quiry, I would like to get a msg box with the following:
Do you want to find the entries by: Starting date (date feild), Teamnumber (nummeric feild)?
Then the quiry makes a list of the found entries.
Is it possible to make a combobox for the starting date? I have about 30 students starting every week, so in 30 entries the date will be the same. Make some kind of dropdown-list of the known starting dates, without listing them all. The list will not have to go further back than a month or so
AutoNumber Data Type
The AutoNumber data type stores an integer that Microsoft Access increments (adds to) automatically as you add new records. You can use the AutoNumber data type as a unique record identification for tables having no other unique value
text data to numeric data
I have one table has a column called evaluation ( text data type ), and I want to take the data and convert it into a number data type in another table or a query , something like the following
excellent=90 to 100
accepted = 60 to 79
under 60 is failed
Explaining Data Types
Databases consist of tables, tables consist of fields and fields are of a certain data type. A field's data type determines what kind of data it can hold. Every database has data types for text, integers (integers are whole numbers, i.e. numbers without a fraction) and decimal numbers and so does Access. But Access also has some data types that are specific to Access, like the Hyperlink, Attachment and Calculated data type. In this article I will describe the Access data types and give an explanation of their use.
Exporting and Updating exported data
a newby here so be gentle. I am trying to work out how to export data that has two bits of info. A serial number and a status. This I have done with an update query but I now need to put the data bsomewhere then update it every day with the same query. Some of the serial numbers will be the same every day and some will be different. Where and how can I do this. For example serial no 1 is not used today and the same for serial number 2. But tomorrow serial number 1 is used but 2 isn't therefore the list after two days will only include serial number 2 as number 1 being used will remove it from the updated query information
Form for entering data into linked Table
I have a linked table called "dbo_tblNotes".
dbo_tblNotes has the following fields:
id (Data Type = Number, Indexed = No)
note (Data Type = Memo)
addDate (Data Type = Date/Time)
uid (Data Type = Text)
private (Data Type = Number)
I am trying to create a form that I can use to enter notes and comments. Any notes that are entered would be stored in the "dbo_tblNotes" table under the "note" field. I only want the form to be used for entering or changing notes.
I have tried creating a form based on the "dbo_tblNotes" table but I am unable to enter anything into Notes. It only displays the notes for each record.
Converting text to date
I am importing data from a text file, some of the imported data are dares, written in the following format:
The problem is that the data is stored as text and not as date type of data, which makes it difficult to do mathematical procedures on that type of data
is there a function/way to convert that to "real" date data
Error saying Type Mismatch In Expression
I am trying to run a query on two sets of data that are the same data type yet I get this message.
Introduction to Data Types
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.
Relational database structure - Handling Types
This issue has always proven to be a challenge to me when designing a relational databases: Types
For example: You are entering in data for a person: Name Address, etc. Each Person is of a Certain "Type" ('Friend' or 'Co-Worker' for example). In this case, to keep it simple, each person can only be of a single type.
interests, birthdate, wedding anniversary, etc. while a Co-Worker type might have a completely different set of items: Work days, hobbies, married, etc.
Note that the datatypes for each item may change. Some may be Boolean, others dates and still others, simple text. Based on the Type chosen for the person, Iwant to enter in information for each item, specific to that type of person.
Real challenge: I want to be able to add new Types of people without modifying my data structures and new Items that correspond to each type. Then enter data for item for each person of that type.
So for example:
Exporting and Updating exported data
I am trying to work out how to export data that has two bits of info. A serial number and a status. This I have done with an update query but I now need to put the data bsomewhere then update it every day with the same query.
Some of the serial numbers will be the same every day and some will be different. Where and how can I do this. For example serial no 1 is not used today and the same for serial number 2.
But tomorrow serial number 1 is used but 2 isn't therefore the list after two days will only include serial number 2 as number 1 being used will remove it from the updated query information.
Any help would be greatly appreciated as my head now hurts having had this problem for 2 days now.