I am working on a simple database with two addresses. One address for a bill to address and one address for a protected address. I would like to have the...

Is it possible to restrict the date entry on a subform to dates within a time period defined by a fiscal year entry on the parent form? My fiscal year is...

I want to create a dlookup to look up a District Code =DLookUp("",""," = " & ) tbldistrict has the DistrictCode and District ID tblManagerDistrict has the...

Hi I just added two checkboxes on my main form and on the MS SQL server I also added two fields as “bit� format. Now when I update any data I keep...

I have a database that I got from someone - full of data but no forms or anything else... Some of the data is in HTML format (in a memo field). It didn't...

I don't mean this question to sound snide but; why was the switchboard ever invented? What advantage does it have vs an unbound form with buttons? I am...

First, I would like to thank everyone here that has helped me (and others). I’m sure you don’t get paid to answer these questions, so I thank you for all...

I have 2 forms that I work with: Form 1 is laid out like a spreadsheet where only certain fields are visible. If I want to modify a record I click on a link...

OK, I have posted on this site many times and all of you have been a huge help! I am at the end of my rope with this particular database. I REALLY need...

Access2007, SQLServer 2008 backend, latest SP's: I have a very strange issue. For two of my users, the values of calculated fields (fields that have...

I am trying to create a grid like this and I would appreciate any guidence you ca give... Customer Code: (combo) Customer Name: (textbox display of...

I have a Purchase Order form that has the fields “Assets�, “Reference�, “Office Supplies� & “Personal�. These fields are located in the...

I am in the process of implementing a db that will aloow an audit of updates and users access. My issue is this: I cuurently have an event procedure in the...

This is my first time venturing into Access 2007 programming, but I have done it a lot in VB6 and prior versions of Access. I have a Menu type form that is...

I have created a few tables, queries, forms and report for an application for my office. Out of these forms, I made a switchboard form (I did not use...

Hi: I have a main form which contains a subform. In the subform footer, I have a text box to calculate the sum of annual cost. When I view the subform,...

Hello All, On the On Enter event of a control, I have code to save the old data before a user changes the control. It worked good. But lately I realized that...

( NOT MY STORY. ITS A LETTER A FRIEND ON FACEBOOK HAS WRITTEN TO ME TODAY) Hi Fawzia, My story goes back to the year 1996. I was in class 7 studying...

Hi Friends, I have a Call information data table. I have created a form based on this table. In my table and form I have Name, Address1, Address2 …....

Hello, I am trying to create a form where there are fields in the table which include Order#, Oper#, Mach#, etc.. I also have another appended table with...