I hope I can explain this correctly. Here goes. I have a query that the SQL code is as follows INSERT INTO CompanyOneYr ( Company, ) SELECT TOP 50 .,...

I'm having troulbe updating writing the code in VBA to update the record when the user click my button. I'm using Access 2003. Please help. Private Sub...

Hi, I have problem with my form. I have combo box, which Row Source is one table (Equipment type). Data from that table are in other table (Register). I want...

I have a form with two combo boxes, that I'm using to search for records in a particular table that is tied to a second form. In order to find the appropriate...

Short of placing an initial dummy data piece to get the form to show, is there a more professional way to have the form show when there isn't data in tables...

Is there a new way in Access 2007 that will allow my data entry personnel to keep hitting the tab key from one page to subsequent pages? Right now I have an...

I created a list box on a form. The list box only shows the information from another table, where the on the form matches the from the other table. This...

Hi: Can you please tell me, if there is a way to lock just specific records in a form? So, for example records type A - actuals, I would like to not have...

i have an access form with a field i want to click a button next to the field which will open outlook express and prefil the "to" field with the email...

I have built a form in MS Access 2007 using design view but when I go to open the form in data-entry or layout views, none of the fields show up. I cannot...

Hi All, I am trying to change the back color of a subform's detail section based on a value from the main form. I am able to change the backcolor of the main...

I followed the direction below and I got stuck on the Form_Current event procedu ImageFrame.Picture=ImagePath. Where eaxaclty am I suppose to put this? I...

Hi I am having difficulty creating a combo box which behaves how I want it to. Main Form I need to access Student...

I have a table linked with Excel, wich is updated from time to time by adding/deleting a new record of 4 fields (the update is made in Excel by saving a...

Over the last few months I created this large database with the help form many masters in this forum. I have one thing left and It really bugs me. I searched...

Im going to try to explain this the best i can, since im an intermediate with Access. I have 3 tables, my main table "Client", then i have the...

Hi all, I have a text box on a sub form which, when the user enters a job number, I want the data on the subform to be filtered to that job number. I've...

How would I set up a sub form in data sheet view to display records in decending order all of the time, rather than the user manipulating the sub form? I...

Hi, I would like to complete and controls on a form, and have a third control be automatically populated from a table where is the primary key. Given...

Hi All, I have a from "Input" which has a subform "Variations" which is not visible. I make it visible with a toggle button and close it with Do Cmd Close and...