Hello I wish to change the color of a form depending on the value of a variable. If the var "SigOther" is true then I want the form to be pink else a light...

I have a small table in A2007 that has only a few fields in it. Date, Location, Accepted, Count (these are the ones that matter) I need to do a query that...

In Access 2007, on the "Getting Started with Microsoft Office" page, I want to clear all of the file names under "Open Recent Database" on the right. ...

Hi All, New to Access .. so please bear with me. I am trying to make a form .. so far so good ..its got all the data I need. I just cannot see to make the...

Hello, I have a query in which I have a prompt on last day. For some odd reason when I enter in any range containing the date 10/1/09. I don't get the full...

I have a mental block! I'm trying to extract data from Sage accounting system into a new database, but I can't for the life of me find the option in "Get...

Repeating myself from other post: "I've got little experience in HTML and no experience at all with ASP. Beyond that, I've got lots of limitations with what to...

I acquired a Database done in Access 2000. I need to make some design changes but I can't. Seems it was saved a certain way. Anyway around this?

Is there a way to have a query or a report automatically run from a calcuated date that does not have to be entered from a start date que? I have a date in my...

I am using Access 2003 and have set up a database on a server. Users login to the database to do data entry they stay loged in all day. There are aprox 25-30...

Hi, I work for a mailing company that address personalised letters/envelopes ect but i am having a problem when sorting a table by text fields. If i sort my...

I want to create a databse that will be accessible thru the web, for updating and viewing information using a webpage, how would i go about doing this? the...

I have a field that is populated as follows Gillard, Robert J : Retail The surname always has a comma after it and whilst there is not always an initial...

We have a database on a server which is edited by 4 people daily. It has recently had an increasing frequency of requiring a Compact and Repair to the point...

How would I calculate the difference between two dates and, have the calculated difference show up as a value beside each date. I'm thinking I would have to...

I have browsed this site many times and have posted a couple of times and find most of the information helpful. However, I am still new to Access and don't...

I am interested in developing a form which is conditional. I'll explain. I am a doctor and I want to design a database to keep my billing from...

I was used to 'good' old dBase 3+ and Clipper and dont recognize anything in Access! I have a simple requirement and would appreciate any help and advice. I...

I have already pulled a list of students into Access (The sample is only part of a list of 1362 students) I have a barcode scanner to scan the student ID...

Hello Group. I have a form (frmMain) and on that form I have used the tab control- pge1, pge2, pge3. On these pages I have subforms. I would like the a...