Getting Started

access is truncating data from a linked table?
I have linked tables between excel and access 2003 that contain cells with text. In excel they are formatted as "general" and in access they are formatted as a memo field. However in the Access table, it truncates the data to about 250 characters. I don't appear to have an input mask or a format defined - but I... 4 Jun 2008 17:43

Sending text box content to a memo.
Hi there, I want to ask you which will be the best way to make the database. Maybe the way I am thinking to make it (with option buttons and so on is not the best). And if possible a bit of how can I connect the text with the memo and the two option buttons with the other two text boxes. The form I am tryin... 6 Jun 2008 08:43

Fill in the blank
I want my form the fill in the blank field(s) dependant upon what has been selected in a previous field. I have Table1 (unique numbers for permits) and Table2 (all inspected permits). There are 3 fields that are common to both Tables: LdaID, LdaName, LdaLocal. When I input the LdaId on the form (or Table2), I w... 5 Jun 2008 01:54

combo box same on form page
Hi, i have created a combo box that lists first name, surname, address of employees. I also created text boxes which look up this information to display it on the form. This all works great. But when you go from one record to another the combo box is stuck on the same record - it enters the same employee de... 5 Jun 2008 14:15

How to edit the field list?
I am fairly new to Access and I have been given the task of adding fields to an existing form in a database that was created years ago by an unknown party. When I click on Datasheet View, there are dozens of columns to the right of the fields being used, with labels such as Combo86, but none of these show up ... 4 Jun 2008 17:12

How do I get ACCESS to calculate years, months, days for a birth d
I can't figure out how to get ACCESS to calculate years, months, days for a birth date. I want to take the current date, a birth date, and have ACCESS calculate how old some one is and give me the age in YEARS, MONTHS, DAYS format. ... 3 Jun 2008 20:08

Adding a new subject to all my tables
I am a new user to Access and I am hoping someone can help me. I have created a database on research subject for a study. I have 14 tables in my database that have all my subjects listed in them. The tables are set up by the month the subject comes in for the tests. Since the subjects did not start the study at... 6 Jun 2008 17:26

On current
is there some way i can track what events might be causing the on cuurent event to fire on a given subform. it appears that the subform's current event fires before the main form's. then in my app the on current event on the subform is firing at least 3 times again before it settles down. i'm guessing some of my ... 4 Jun 2008 08:08

what is service quality?
I need further study on what service quality is about and how to link it with my assignment about a world class hotel in Dubai called Jumeirah. where to get the best information in athens and around the internet that is not biased. Can you help me please the best that you can......... Thank you very much K... 3 Jun 2008 20:08

Rounding
I working with an access database that someone else created. Everytime I enter a number it automatically rounds it to the nearest whole number (ie 3.25 would appear as 3.00). What would I change to have the number I entered appear? ... 2 Jun 2008 13:27