I need to add a field to an existing form and Access will not let me use the column add feature in data sheet view or in design view.

This is my first use of a function. I have copied a function and edited to suit my purposes. If I use F5 from the function it runs as planned. How do I get...

I am trying to replace a section of numbers with letters. For example, I have a column in a table labeled Store Numbers: 1,2,3,4,5,6,7,8,9,10 ect I want to...

Hi, I need to create a vehicle repair database for a workshop, does any one have a sample database (except for service management database that comes with...

Hi. I'm trying to create a form in Access 2003 to enter data about the kinds of assistance patients need -- dressing, washing and so on. Patients will...

I want to prevent Access from updating fields on a form until I click a SAVE button. I don't want Access to perform updates along the way. How can I turn off...

Hello..I have a form that has 2 bound controls, what I need is to be able to input the new totals in a text box and click update and have the table to...

Hi, I made a table structured as below 1.No Number 2.Date Date and Time 3.Model Text 4.Accept Qty ...

I have a list box that has multiselect set to 1 (Simple). The first time I select some items and then in code iterate through the items to find the ones...

I am starting a weight lifting program working every area of my body and I would like to set up a program in access. Please help!!!!!!!!!!!!!

Can someone point me to a good line by line explaination of how to set securities on my DB. I downloaded a SECFAQ file and it is completely wrong. I've...

i need help badly - im pretty new to this and i have spent ages doing this db for work. I dont know whether i need to adjust it or just plain scrap it. Its...

Is there a way to query by month. For example show me all the invoices for work carried out in November 2006 or any other month for that matter. Currently I...

I have been using ACT for some time and would like to import my ACT database into ACCESS. How do I do it?

I am very new at this, so sorry if this is a stupid question. I have an Access 2003 Database of all my CDs. It has 1 table which has fields for Artist,...

hi all, from browsing this newsgroup, i'm become somewhat familiar with taking Access data and merging it into a Word document using bookmarks. but, how...

What is the best way to set up a database where you may have 20 users? Is there a maximum user’s count to a database? What type of security should you...

I have a serious criteria issue. This is what I have as of right now but it is too wordy. Between And Where is the scernario, this qery will beran every...

Hi whilst working on subforms etc I would liek to refer to a printed list of fields in key tables. How can I print a list of the fields in a table? in design...

I am writing a user manual for an Access project, and I keep using awkward descriptions like "click the upper-left square in the datasheet pane of the form,...