I am building a purchase order database and I want to have a combo box on my form that when I select a vendor from the vendor field it narrows down the list...

Hi, I'm trying to create an all option in my combo box and I'm getting an error: "Query Input must contain at least one table or query." SELECT DISTINCT .,...

Hi, Is it (in Access2003) possible yo link from a form in db1 to a form in db2? Thanks, Susan

I have a date time field in a form and I need to populate it with the current date and time when a command button is activated. If it was a date time at the...

I am working on a database that has to deal with Attendance tracking. I have a table setup that deals with scheduled hours and any incidences for them...

I have a form with the ID set as an auto number. I have entered test data to make sure it's working. Now, after I delete the test data, the auto number...

I have a large access database that was used with access 2003 and now i'm trying to convert it so that is uses access 2007. However the forms in 2007 when...

i have a mdb with a picture database created 2003 version but when i updated my access into 2007 the form in my picture database got an error as it goes like...

Hi there. I had a question that may seem simple but I'm having some problems. I have an Access DB. One table: Contacts Two forms: Short Contact Form and Long...

Can someone please help me? I created a form called Communicaiton Needs Survey. The form is linked to a SQL server table called Communication Survey. We...

Throuhg the codes below I used to see via a snapshot a report in a form. OFFICE 2007 does not support snapshot any more. How can I get around it and still be...

I built a customised switchboard in Access 2007 and crated buttons using the onClick event. Also I inserted the Date/Time control and got everyting running...

Hi. I have a database where i put in registration numbers for vehicles. In my country the format of the registration numbers is XX 00000. THat is 2 letters,...

Hi All I have a qustion that I am stumped with - I have a table with the following: ID (Primary) CodeID YearID DataSourceID ProvID

Hi all, I have an Access app that was previously on 2000 which is being migrated to 2007. Everything works fine apart from the ordering on one form. The...

I have a couple of forms that when opened are opening in the middle of the form as opposed to the top of the form, which I'd like. This causes the user to...

I had a macro set to run Before Update on a form that worked just fine in Office 03. Now that we've gone to Office 07 it won't let users off the form even...

I have my tab controls working but the boss wants me to make the tabs consistent with the company colors. I can only see the normal and transparent controls...

I have some textboxes grouped together on a form and I want to add a rectangle box with a solid background behind the textboxes. Is there a way in Access to...

In my frmPO, I have cmdOffice. On click: Dim stDocName As String Dim stLinkCriteria As String stDocName = "frmOffice" stLinkCriteria = "=" &...