Hello Guru's, I've got an append query that transfers data from an excel file into my tables as needed. The way the excel file is generated must have...

Hi, I'm fairly new to this so any help would be much appreciated. I have a master table (A2K7) in which summary details are entered (via a form) by users. ...

Is it possible to install a credit card reader and have it used against a particular record in an Access table?

I have a form that has a multi-select list box and a subform used to enter new records into the table used to populate the list box. When, using the...

Dear Experts We run databases originally created in Access 97, but now use Office 2007. We ran Compact and Repair and somehow the database has been deleted,...

I borrowed some code from a Microsoft template basically to have a combobox at the top of the form so if the user want to jump to a different record they can...

About a year ago at a client I started getting Disk or Network Error occasionally throughout the day. Did a lot of research and could never really find...

Hello all! I'd like some advice/comments on a situation I am facing: I have moved to a new job in new department. In this department we work as consultants,...

Ik heb het aan met Shirley

Hello, I have a form with a subform in it and I would like that subform to only show as a form, not as a datasheet. How can I do that? Thanks, Caroline

I am using Access 2007 with an MS SQL Server 2005 backend (via linked tables). One of the SQL tables is tblDepartments. Two of the SQL fields are the Primary...

I am using Access 2007 with a MS SQL Server 2005 backend (linked SQL tables). I am trying to set up a combo box with 2 fields from tblDepartments. One field...

The wizard to collect data via email does not allow formatting fields (input mask). The choice of items is listed below. Can I create List-/Combo-Boxes?

I have a database that gets new information put into the tables every month. I tried to create a delete query that would delete all the rows in all the...

How do I send an email to everyone in my Access Database (assuming I have email addresses for everyone in the database)?

I have a macro used to update tables daily. Is there a way to automatically run the macro or queries at a specific time. I would like for them to run nights...

Use to be I could open a database, work in it then close it and open another one. Now when I close the database, Access closes completely. How do I get other...

Hi Guys, The first part of this question has to do with the design of the database. The form I need to dsplay has roughly 60 cells. Each cell holds a color...

In Access 2007, when I right click on a field in a table there is no longer an option to type in my own filter. How can I do this now? e.g. I wanted today...