Search results

Hey folks, Like the headline says, I'm having trouble finding the right coding. I have a form that users fill out and I want a hint box to pop up over/under the cursor when they are hovering over one of the text input fields on the form. I have found the OnFocus, OnClick, etc but nothing...

Ok so I have a table that has Customer Contacts logged into it. One of the fields in the table is Owner_ID. This field is a text field that contains the salespersons name that is the current "owner" of that account. Because of the business that I am in, this field can change many times within...

Ok so what would be my completed formula...because when I just add "EXT":\ 99999;;_ to the end of mine I get !\(999") "000\-0000" ext":\ 99999;;_ which makes my phone numbers all convert to (___) __6-5497 ext: 83215

Ok so in excel I have some numbers that are stored as text. The reason being that they are zip codes and some begin with 0 and excel doesn't want numbers to start with 0....so when I import these into an access field that has an input mask for zip codes...will it convert these correctly since...

Ok I have an excel spreadsheet with over 6000 phone numbers that I need to import into a table. I have set up my field with an input mask to display a phone number as (xxx) xxx-xxxx. I have also set up my excel spreadsheet to have the numbers set up like 1234567890 to make it easy to throw in...

I know that I need to have relationships between these tables. My problem is when I get external data from an excel sheet it forces me to either 1) create a new table or 2) import into an existing table. It is not letting me map the fields in the excel sheet to fields in my multiple access...

though my actual application contains 6 tables, I will give an example with 2 to simplify my question: Say I have a simple DB with a Company table and an Employee table....the only attributes are CompanyID (autonumber/PK) and CompanyName for the Company table and EmployeeID (autonumber/PK) and...

As said above change the field size of that value and select either Single or Double depending on your needs. If you are not going to do math with the field you could always just use Text instead of Number

I am looking for a book to help me with Microsoft Access. I would rate my expertise with the application as intermediate, so I am not looking for a beginners guide or dummy's guide. I am building a database prototype for my company to keep track of customer information for marketing purposes...

Ok I am right now making a simple Vendor/Product database to create a line sheet for some sales folks. I have 3 tables: Vendors, Products, and an associate entity Vendors_Products to relate the two. I have a form currently that draws the Vendor Name (primary key) from the Vendor table and the...