Search results

I have a report that displays details about insurance policies, including the monthly cost of each. It lists a person's name and all the policies that each person owns, and then totals up the monthly cost. I want to change the "Total" slightly. Right now it does a Sum of the values in the...

I'd like to know how to select a checkbox on all the records in a form's recordset at once. For example, I have a continuous form with a checkbox on each record that I want to use to select which records to print in a report. I plan to filter the form to only show the records I intend to...

I have created a report using the Label Wizard to print nametags, 8 on a page. Each nametag has an event logo, some shared text, and then an individual name of an event attendee. So if there are 50 records in my table, I get 50 identical nametags, all with an individual event attendee's name on...

Perfect! Thanks.

I have a report that counts up records in a text box on the report footer. For example, I count up the number of males listed in the report by using this code as the controlsource of the text box: ="Male = " & Count(IIf([Gender]="M",0)) I want to be able to count the number of people that...

OK, I think I've figured out that it may have something to do with the acDialog option to the openform command. I tried opening the form with DoCmd.OpenForm "frmEnvelopeEntryForm" , , , , , acDialog and that opens it as a popup, since adding the acDialog option sets the popup and modal...

I want to attach some VBA code to a button that opens a form in PopUp mode, but I want the form's default PopUp property set to No. The reason is that I want to use the same form for entering data from 2 different areas of the database, and I want it to be a popup in one location, but not in...

OK, it looks like I've figured out a workaround, but I don't know why this way works and the other doesn't, so an explanation would be appreciated. So, when the claims entry form is opened (by clicking a button on the main form, frmCustomers), the customerID field is populated from...

When I open the form, I set it to open in data entry mode, and then I set the value of the CustomerID field.

In my database, which tracks insurance policies and claims, I have a form where I enter in the claim information. I'm trying to have a combo box where the rowsource only shows the types of policies that the client has, and not the rest. I've attached the following procedure to the Form Open...

I'll give the custom toolbar a try. That's a pretty good idea. Moniker: Sorry, I don't think I was very clear. What I was thinking I would do is create a query on the table that's already being used for my main form. That query would show only the records that I have "marked" with a check...

I think you'll want to use Cascading Combo Boxes. I had a similar question a while back, and found that there's a lot of info already out there about them (once I knew what they were called). Just do a quick search.

I think this one will be pretty easy, but I'm not finding an answer. I just want to create a button that will do the same as clicking Records, Filter, Filter by Form. I've gotten the button wizard to give me buttons to apply a filter, and edit a filter, but not filter by form. On a side note...

This is kind of a weird question. I downloaded and imported a table with cities and zip codes in it. All the city names are in upper case. I want to use the city names in that table as the row source for my City text box. But in my database, I store city names in Proper Case, with just the...

Perfect! I changed the formopen line to this and all is great. DoCmd.OpenForm stDocName, , , stLinkCriteria, acFormPropertySettings = DataEntry Thanks.

How do I have a button open up a form that filters so that only a "New" record is used as the record source? Right now I use this code to create a directory based on a record: Private Sub Form_Close() Dim strDirectoryPath1 As String strDirectoryPath1 = CurrentProject.path & "\accounts\" &...

Thanks boblarson. You were right. I was missing 2 references. Now here's a question. This database is designed to be used by a number of people. The 2 references I was missing were drivers for a signature pad. Not everyone who uses this database will have those drivers installed. Is there...

OK, so I opened up the database and ran the Autoexec macro manually. The VBA Editor opened and I got the error "Compile Error: Can't find project or library" and the word "Mid" is highlighted. (In Red below) Function Reconnect() 'Dim db As Database, source As String, path As String Dim...

Sorry, you're right. But the error was not exactly descriptive. I get a box that says "Action Failed" at the top, and inside the box it has the following: Macro Name: Autoexec Condition: True Action Name: RunCode Arguments:Reconnect() And my option is just to click "Halt." This is probably...

I'm having trouble getting this code to work on Access 2000? I get a VBA error and all I can do is select Halt. Should it work on 2000? The database is in Access 2000 format already.