I want to set the default for my table to be 2009 for my long date in the entry form so that when the user enters the data they won't make a mistake and...

Easy One....but how do you break up a formula in VB so that you can see it on the screen without having to scroll right? -- Heiko K Stugg

Access 2003 My field name is Invoice # which is my primary key - the data type is number - long integer...We are now needing to increase the invoice number...

Hi - I have a field of type Long, the data that goes in the field are numbers like 027987 and 564982 Every time I enter a number with a 0 in front access...

My message is for Jack macDonald: I am trying to create the tables you mentioned. However, the 2nd table tells me to use autonumber in the first field and...

In access 2007, I don't see how to choose long integer for a field, a foreign key for example. Just number. Can somebody help? dennist

Longines Conquest Watch, Best Wris****ch Fashion Watches: http://www.watchess.net/ Longines Watches: http://www.watchess.net/Longines_Watches.html Longines...

My lookup table is sorted alphabetically when I look at it alone, but when it is displayed within the combo box of the the column that is using it as a lookup,...

I have a "Clients" table with about 1000 records. Each record has an autonumber ID which is also the primary key. I have built a simple "Clients" form on the...

Hi, I'm not used to Access at all. I have 2 tables - Customer and appt. I want to be able to enter a Customer Number in a form and if the customer number...

After reading about the evils of having a lookup in a table, I removed all. But now I cannot get the lookup to work in my form. I need to store student names,...

I created a Db to track equipment man hrs and down time. My question and delema is simple, " but not for me " I have a form called " maintenance main" A...

Hi, my knowledge of access is fairly basic but have managed to build a form off a table using the wizards and gratefully searching these posts for explicits...

I’m new to access and I’m trying to make a query to look up rejected items. I’m doing this by date so in the criteria I have “Between And � it...

I would like to make a form that will allow the user to look up a specific record in my DB from a form - I would like to allow the user to type in what they...

When using a lookup table with only one field, is it necessary to add an additional field to be the primary key, or can the field itself be the primary key? ...

Dear list, I have 2 tables: Table1 has SampleCollectionDate; and Table2 has DateGaveBirth, DateStoppedLactating and DateGaveBirthNext. Both tables linked...

I have a form that has a field for an item number and another for description. I have two tables customer and item master. I wish to have the description...

I have been using the lookup wizard, and I realize that some of the options that go in it do not fit, is there a way to increase the size where I write my...

At the risk of being sent to a work camp in Siberia, may I ask what's so awful about look-up functions in tables? The objection seems to be that they store...