How can I change this code to make the "Occupied" field null? This is just a small part of a larger peice of code but this is whats causing my...

How do you reference a specific field for update on a continous form? Suppose I have three fields: ID, F1, F2 and the continuous form may have 20 records. ...

Table 1 Recpt# Auto Num Pri Key Unit Table 2 ID Auto Num Primary Name Dep date Dep # Dep Type (chk, etc) DepNum (Number on...

Is it possible to make forms, or parts of form read only so that anyone can see the information entered, but can't change the information entered. -- puzzled

I'm looking to pay for some consulting help from someone with knowledge of Quickbooks and specifically creating an iif file for importing data into...

Hello All I am about to convert a fairly complex A2K mdb to A2003, and was wondering about the best way of enabling the new mdb to fax reports directly. If...

Hi There, I see that Access has some pre made masks to cover some of the things I need, but I'm wondering how to do something else. How can I make sure that...

Hi I have several domains that they are separate Forrest One of these domains installed Exchange server 2010 Between all the domains I've created as a one-way...

How can I specify a validation rule that will perform the following changing validation. Example: Number in field must be between 8 and 12 for this...

Hello, I receive a file from our IT Department each month called tblHBI that has the following fields: Month (i.e. 5/1/10, 6/1/10), Measure (Falls. Infection...

Hi All, I would like to know if it is possible to renumber an auto number field, I know this is scoffed upon and goes against the principals of database...

Is it possible to clean up a date field where someone was keeping an excel sheet and no we are moving this into Access but the date field is a mess For...

Greetings, Using Access 2003, my objective is to turn a list like this: Asset ID | Parent Asset ID 1 | NULL 2 | 1 3 | 2 4 ...

Antonela Vujevic" wrote: test test Access Queries Conversation List Friday, April 16, 2010 12:14:56 ...Asked By on Thursday, December 10, 2009 5:43:02 PM....

Could someone tell me what the vba code is to hide or disable the add new record button on the navigation bar? I do not want to set the "allow editions"...

I created an inventory query in Access 2007 much like the Northwind 2007 query, but the fields that are supposed to calculate a total are returning nothing...

Hi, I have a 'continous form' which gets its data from a table. Im using a form for ease of use by the operator and data is displayed in text boxes. My...

Hi, I'm a bit stuck on part of an assignment. I have to design a database for a company that is user friendly for beginner Access users. Here is the part...

I was wondering if it is possible to implement an error handling feature where the user is alerted he is attempting to import duplcate values to a primary...

Has the missing object properties bug been fixed in Ac2007 yet. Is there a download available. I know you can right click bar -view by - details but this...