I built a very small database in Access 2003 SP3 on a Windows 7 PC. Everything works fine on My PC, but when I send the MDB file to Someone to view my demo...

I am trying to figure out how to use the Attachment control on a form. On the form, I have a listbox for the user to select a specific record. When an item...

Hi! I have a form based on a table. Both open. The form has a command button (invisible). When I change data on form, update data on table and command button...

How can I get data (from one table) to populate multiple fields of a record when I choose from a drop down list on a table I am working with? For instance, I...

I am sure that someone has asked this at one time or another, but haven't found it out here yet. I have several inter-related databases, some of them have...

Recently I had a problem with MS Access date values between different countries. I had Spanish dates dd/MM/yyyy actually converting as MM/dd/yyyy on the US...

I have a collection of motions I have developed over the years with Microsoft Word. Each one has a number of variables such as name. cause number, date,...

I have two tables that have similar fields (one table - adjnotes - has claim total expenses paid field; the other table - litigation - has expenses paid). ...

Dear Sirs , Could you please explain to me how could I place a question in allenbrowne.com and from where I can view the respond ? Now I have a question and...

Hi! I have a form with a text box where is the result of a calculated average. In this form I'd like to hide a command button to be visible only when that...

Newly upgraded from Office 10 to 12. As an FOG from the old days, I remember hoping that Microsoft would expand on the semenal IBM CUA standards. The little...

Using Access 2000 I have a database used as an attendance register for short courses. There are three tables - one for student details, one for course...

I need to number records in a table by a group. ie. Each account number may have 1 - 5 records. I need them numbered 1, 2, 3, 4, 5, and then the next...

Is their a way to use the current date or calculated date as a column heading?

I have two tables, table 1 and table 2 (i'll keep this in simple english). Table 1 contains contact details of customers while table two, contains the ID No...

Hello, I am creating a shipping and logistics database in Access 2007 to keep track of sales, inventory, shipping costs, etc. We have 4 warehouses that...

I have to create a report for the query below SELECT ClericalMetrics.PS_ID, PerformanceSupervisor.PerformanceSupervisor, ClericalMetrics.,...

Hi, I have a form with a textbox and a combo box. The text box is called CompanyName and the combobox is called CompanyFamilyName. Every CompanyName...

Using Access 2003 a form has been created with a combo box to select the name of a practice. The criteria row in the query shows the form information. When...

I'm inspecting/parsing a user input string, starting near the end and working to the beginning. code: i = Len(strApplication(iRecords, 1)) While...