not allowing a international company to choose the currency for the data base renders access unusable for most applications

How can I globally set all the text fields in a table to "allow zero length"? THANKS, Bill.

I have set up a table and I want some of the fields to "auto fill" when I type in the first letter. Much like Excel when you have to type in the...

Hi Guy's i am using access 2003, on my form ,i have textboxs and comboboxes, if there is an entry in one special text box, i want to disallow entry in the...

Once I'm finished and ready for a user to run the program, I know you can set up switchboard to run. Is that the typical way of setting this up? Or is there...

Is there anyway I can attach an alpha number such as "A" to my auto number field? Thanks

I have a query with a birth date that I separated out by Month, Day, Year... here is the SQL for the Query: SELECT & " " & AS Name, dbo_EMPLOYEE.BIRTH_DATE,...

How do I alphabetize an existing mailing list I have created on Word Document?

My drop down list in my forms is in alpha order but when I added new names to the table and sort ordered them, they do not sort order in the corresponding...

I am using Office 2000 on a PC with WinXP Home. I'm a newbie and am using it essentially as a flatfile for name, address, phone#, etc. Although I have...

We are attempting to put all of our songs into power point, want to be able to acess them 3 ways by titles, alphabetical, by first word of song. Don't know how...

When I add data to a field it doesn't alphabetize it. It just adds it to the end of the field. Is there a way to alphabetize it without having to run a...

Hello, I'm trying to change the property of a table column on a remote server using the following code: Private Sub Command95_Click() DoCmd.SetWarnings...

Hello! I'm altering the Contact Management template to better suit my needs. I'v added several new fields and queries, forms, reports etc. with out any...

Hi How do I set the a field default value? Dim var_empid as Integer Dim var_sql as String var_empid = 34 var_sql = "ALTER TABLE Local_gl ALTER COLUMN...

Can anyone possibly tell me why this would not work: ALTER TABLE PARENTS ORDER BY PARENT; With of course PARENTS being table and PARENT being field. Am I...

Hi, looked for hours for the answer but to no avail. I have 1 table containing customer info, one of the fields in the table is one of three types of...

I have a membership database with one as one of the fields. I have an input mask to ensure uniformity of presentation when printed. Recently members are...

I have a query that dump data into Excel but one of the calculated fields on this query: "Max(price)" on the title does not return any column title value...

To Anyone that can advise me, I would like to alternate line colors in a Datasheet view of a table. Specifically, have one line light yellow, the next white,...