I used to get a warning message before deleting a record. I no longer get a message, it just deletes the record immediately upon clicking the delete button....

I am trying to get a field to turn red if the condition is "High" I tried using the conditional formatting and it does not work. I also tried using the below...

When a record is deleted from a table, a number appears in the form field where the record use to be. Is there a way to remove the record without having to...

Hi All, I am at hair pulling out point!!! I am a fairly new user to Access and am trying to create a combo box that lets you select records from a drop...

I am trying to create an service order entry database and am having trouble. The template provided by Access is way too complex for what I need. I'm looking...

I need a total to calculate on my main form from numerous entries in a subform. For example I have a customer with several workorders. Each of the workorders...

I am creating an order entry-type database and am having problems bringing totals from my subform footer (which works fine) into the main form. I have used...

I have a combo box in a form. The row source is a sql statement defineing a query of 9 fileds. The bound column is value 1, which is an integer value. The 9...

I am trying to convert the entry in a text box (which is a std date 01/01/08) to Julian date. The format for the Julian date is: 108001. So, in the end I...

I have incorporated the code below that Tina suggested... I followed the instructions below to add 3 combo boxes to a header of a form with the details...

Here is my dilemma...I have a table with 4 Qtrs of data...so, for each Widget there are four data points. I have a form that shows the widget and the $...

I have 2 combo boxes. I select the first one and all the name choices are available. I choose JOE, I then move to the 2nd Combo Box and select it, I want...

I am trying to use a value (two values, actually) from a given record on a form (form1) to display another form (form2), in datasheet view, that displays...

I am trying to create a form that will show all the interactions with all contacts for a particular company. The database structure is like the following: A...

I've found the RunningSum facility for Reports but can't find a way to do it with a sub-form - can anyone advise please ? Thanks DK

Hi, I need to print and save a report in access97 automatically as pdf... I saw this code that is done by Ken Getz and Paul Litwin, when i add the last part...

Hi guys, I have a subform that is viewed as datasheet....In that subform i have 3 combo boxes....When i copy some records and try to paste them, (ex:4...

I have a form I use for entering the detail line items of Purchase Orders I have done. There are several fields for entering the account number used for...

i have form design reg amt amt total 1 50 10*50=500 1 100 100*50=5000 1 200 200*50=10000 2 2 ...

Hi all, reg amt amt total 1 10 10*50=500 1 100 100*50=5000 1 200 200*50=10000 2 2 2*50=100 2 ...