I need a coach who will guide me through Access 2007. Who will help me: 1. Design the database 2. Implement the database and make sure the program gives me...

I have a SQL statement that has a sub-query inside the WHERE clause. The value of this sub-query changes every week. Wouldn't it be better to calculate that...

I have a datasheet form and I want a field (or better yet, an entire row) to change colors depending on a choice from a Combo Box. It does this using the...

I am having a problem importing from Excel to Access and rounding. Everything is coming in at whole numbers. How can I fix this please? Thanks.

I am using Martin Green's instructions for adding a calendar to an Access form. It works great except if I click on today's date, it enters 12:00:00 AM. It...

I know using multivalue isn't the best solution but I use them in one case to assign multiple keywords to observations found during inspections and need to...

I'm a beginner-level Access programmer now responsible for maintaining a series of databases created five years ago. We operate in an unstructured...

http://www.clickivo.com An easy to use translation and dictionary software with single click. ClickIVO is designed so that you don't have to worry about...

I have been trying to make use of the Access2007 datsheet filtering functionality (those arrows on every column). Here's my situation: Normal database design...

I realize that there is no way to individually color a record in a table, so I created a form with Conditional Formatting to change the background color of...

I have a form that has a USER code (8 unique char) in a combo box driven off the Row Source. The Row Source is this - SELECT Staff.User, Staff.Specialist,...

Hello There! Eighty-three OFWW programmer needs help in converting Get/Put statements from 6.0 to 2005. Any snippets out there? Thanks, Gsm

hi i get the message "the database has been placed in a state by user 'Admin' that prevents it from being opened or locked" error 3734 do you know of a...

I am trying to make a note card with text on the front and back, but not inside. It seems that the Tent Card template would be the most helpful. I have...

We have a good working Access 2003 application. This has to be implemented in Russia. We set the language on Russia in the Regional setting and also the...

I have created an access but would like to distrbute it to our emplees however do not want it to look like it run in access as do not want the users access to...

Hi there I am fairly new at using access database's but i urgently need help with a mitragration project which entails moving historical data stored in Excel...