I am a student trying to convert a secured 97 access database to access 2003. I am having a few problems. First, I was sent a copy of the shared database and...

I am developing a database with 135 fields, many of which must output right-justified with leading zeros with the sum of the characters entered and the zeros...

I start with tables x and y. Link DIST and OBS1 I get query1 with a select query. I want to get Query WANTED. I've tried NOT linking. TABLE...

I am trying to figure out how to set the default value of a field called email. I want the default value to be pulled from the inputed data in a field called...

Hi, I am creating an inventory database that tracks server parts. (Specifically I have 8 servers, the parts within each server vary.) I want the quantity of...

In Access create a date/time field with format dd/mm/yyy hh:mm:ss ampm In VB.net update field with Now() function. Date appears correctly but time is always...

I have a field in table . I need it to automatically enter the date anytime any of the fields in the Memberfile table is changed. But I don't need or want it...

Hi, I am creating a database for server parts. My company has 8 servers onsite at one of our largest customers for the sole purpose of using the parts in...

I have set up a database with a members table and a payments table. I need to be able to apply payments to an individual member... all goes well until members...

I have a numeri field that is set for two decimal places. However, when I enter a number 6.80, it rounds up to 7.00. Does anyone have any ideas /...

I keep getting this error when I try to use the report wizard from a query result table. I am a novice access user, and I haven't been able to find this...

Hello all, I am having trouble linking to an excel worksheet. One column is predominately numerical but must be linked as text. It is formatted as text in...

I have a table that has one field set to a number data type. As part of the values input process, I need to enter values leading with a zero as the first...

I am creating a new table for 225 fields. I have ~140 entered, but when I try to enter any more fields a warning pops up and says that the "property value is...

Greetings, We have an Access database that was originally designed back in Access 2.0 days. It's since been added to and convert numerous times; today it's an...

I've seen in some websites where you enter your email address, it validates that the address you've entered is in a proper format : or (in...

I’ve got a design problem (at least I think it is) that I’m hoping someone can give me some guidance on. Say I’ve got a database I’m using to tracking...

Creating an order and storing it I want to create an order, so the person picks name from one table, cutomer from second table, and then products from...

How can I change the length of a text field programatically? TIA, Lou

Hello all! I'm trying to get my table to show decimal values. In the table design view, I set "Field Size" to decimal, and Decimal Places to "4". However,...