The tables are as follows: tble_query -. 1:n - tble_CCode - n:1 - lkup_CCodeS - n:1 - lkup_CCodeT I have a form that holds "query" information and a...

when i try and edit data in particular fields I get the following error Records(s) cannot be read; no permission on '~sq_cEdit/Delete...

I have a main preprinted form that has a front and a back to it. The front and back of the form require some data fields to be printed on it from the main...

I have a database for people to book on to courses that we run. One of the tables is course Instances eg Course name Course Date Course Time etc. I would...

Hi, I have a table that allows me to look up a cost factor based on 3 criteria. So the table has 3 foreign keys and another column that contains the cost...

I am sorry to have to post again. But I have not had any luck with Conditional Formatting. I have tried: If isnull() and Is Null, "", Not Null, etc. I...

Hi all, I have a bound textbox on a form and the control may contain large number of chars from a table. My method is to set its Can Grow property, but it...

Okay, I'm kind of a newbee to Access. I'll try to explain what I've done thus far and what I'm trying to do. I've put a combo box (named: Artist1) in a...

Hi, I have a form in data sheet view that I am trying to open from a switchboard. So while opening the firm directly opens it in data sheet view, opening it...

Hi, I have a consult in a form, but went I open the form I have the first register in display, I can move backward and forward, but if I try to use the...

hi My table has 3 fields (DivID, DivName, DivCode). I made a query based on the same three fields, sorted by DivName ascending. My form is based on the...

I am sure this is a common question...but I could not find the answer. I have a form where purchases are recorded (stock table) and it has a supplier name...

I'm hoping I can even explain my problem! I have a table of SubTasks and a table of ESLOCS. I have a query qryLatest_SubTasks (based on the latest SubTask...

I wish to set a default for a text box based on the current month and year but I wish the month to be in UPPER case, for example MAY-07. I can get the date...

Access 2000. I need a to assign an Audit number that is alphanumeric and partially auto number and partially assigned by the user. Example: Audit Number: ...

Hi, I am trying to run this code and I get an error in this line of the code. Set rs = db.OpenRecordset(vSql, dbOpenDynaset) The error is: Run-Time error...

Hi Everyone, I have a patient database. My main form is based on my patients table. A subform on my main form has Pt. location which has the fields Area,...

I wonder if some one could tell me how can we add a calendar button on a form to enter date..as we do while we book our ticket online on web...when ever we...

To All: I am really stuck on an Access Control problem and I haven't seen this exact problem addressed in the Access forum so here goes. I’ve written some...

Hello, i need some help with the following code. what i am trying to do is to print a report when a cmdbutton is clicked, but the report is populated...