Hi I have a form which is bound to a query with some bound controls. On the same form I also have a list bound to the same query. How can I sync the...

Hi, I'm using Access 2007 and a couple of older but excellent books (Using Access 2002 and Developer's Handbook 2002) with no success, so I come to the...

I've created an Invoice form which seems to work pretty well for creating invoices, but now the Office folks would like to add some functionality. Right...

Is there anyway to specify addtional grouping headers and footers on forms similar to the way you can on a report? Thanks in advance

I want to give my users a form where they will give some information and a query will be run based on that. However, I want this to be a bit more dynamic...

Hello, I need to purchase a document scanner to scan documents hopefully directly into an attachment field in Access 2007. Is this something that Access can...

If you have a column in an Access datasheet where the name is larger than the data, it would be nice to be able to make the column header wrap or be able to...

I use forms to produce a letter containing some standard info and the client's name and address in a box for a envelope window. The user just enters a...

Hi, I’ve having trouble with my skip pattern. It seems to work ok for the most part, but my big problem is that it doesn’t seem to reset itself for the...

Hi Is there an issue with PARAMETER in Access 2007. i have an application which runs perfectly well in 2002 / 2003 but when we run a function in Access...

hi, i've created my form and have a query that runs within a subform. This is working fine except that the same query runs in a separate window also. How do I...

I have a textbox where its doing % change from two other textboxes. And sometimes the other two other textboxes have 0 as values and it won't be able to do...

1. I would like to have a form with a dropdown box listing all the tables in my database. 2. When a new table is created, it will automatically be added to...

How do I Convert a Date to Character in MsAccess ? I'm an old Foxpro user and I know there was a command called - DTOC ( date to character) Could anyone...

I have a student database which I would like to be able to get different data for each school year from, it's a DB mostly based on pulling out statistical...

I have a combo box which is to display records not in another table. tblEDLog has 180,000 records and will continue to grow tblProcesses tracks processes on...

I have created a form based on two separate tables. One table holds names the other table holds data. I need multple to use the database and to have the...

In the old 2003 version, all I had to do was put the number in the record section at the bottom and it would go to it. That no longer works on the 2007...

I want my data should be entered (in text box object) only in capital letters irrespective of Caps Lock status. Is it possible??????

All, Below is a the standard code I use in a combo box. Dim rs As Object Set rs = Me.Recordset.Clone rs.FindFirst " = " & str(Nz(Me!, 0)) If...