I am administrating a medical contact database. We want the entries to be alphabetatized by last name, then first name. A query of the databse sorts it this,...

Hello, I am new to access switchboards and have been tasked with displaying linked table information for associates to view for auditing purposes. I am able...

So, DoCmd.RunCommand acCmdBackup doesn't work (not even sure if acCmdBackup is the right one to use) - it gives an error that command isn't available now. ...

I want my main form to be non-updateable, while the multiple subforms that display child data should be updateable...How? -- Jim

I have 2 tables. One is a Service Call table with parts, labor, notes, etc, that has the customer name, address, etc. based the 2nd table, a Customer List...

Hi, I need help with my MS Access form. I have a project where there are 30,000 file #s in excel and I have already exported it into Access. And all...

I am relatively new to database design so forgive me for my ignorance. I have developed a new database for data entry in my department. I keep having the...

I'm sure this has probably been asked here before, and I'm sure there's a simple solution, but I can't seem to find it. Also, sorry this is so long, but I...

An issue I seem to face frequently is the "problem" of displaying the "many" side of relationships in ways which suit my needs. Currently, I have a need (if...

I have inherited an ADP project that implements a dynamic form loading interface. When the app is started, the startup form displays with several choices....

I need to install a diary entry field within a form to record any notes. This is a membership group database and I provide the administration support on a...

Ok, I am not sure why this is not soaking in, but here's the deal I have two tables, the first is job_list and has the following fields: job number, job...

I have a text box with comments in a form that comes from a field in a table. I want to add a 1 in a field if there is Text in the comments text box. How do...

how do i use excel formulas (e.g. days360) in access?

Hi: How to delete all files from a folder in Access Thanks,

Am I going mad ... I am sure that I have done this before .... on a form I have a combo box. For its datasource I have a simple query with 3 columns...

Does anyone know how to toggle between a form and a subform using the Option Group. I have a form, wherein when you select the option button "A" it enables...

I'm writing a mini text editor in an Access form that contains several RichTextBox controls. I want to allow standard text formatting shortcuts, like Ctrl+B...

Hi, I have a subform which has two comboboxes on it. Combobox 1 contains the JobID, and combobox 2 contains all the addresses for jobs. After update of...

Because I am a visual type person and it helps to be able to "spell" out the code in words I understand, I have attempted to follow up on my 10/09/06 post...