Search results for query: *

Hi Folks, I'm a VBA newbie and am having trouble with my macro freezing up during execution. The macro is relatively simple, highlighting and revealing certain aspects of the spreadsheet for a presentation (so screen updating needs to be turned on). The delays in the code are intentional. I'm...

I'm trying to develop a database to manage our policy loans for our insurance company. Various times throughout the month many of these loans need maintenance, updating, and editing. I want to create a program that will work with access to give me reminders when this maintenance needs to happen...

Hey everyone... I have a report I've created with a sub-report built into it, but I only want the subreport to print if I have a check box checked within the main report. How can I go about doing this? Thanks.

I have the formula above in a text box in my report, but this formula creates this number for each set of policies per person. Since each report includes many people, the formula creates a number for each person, I need a sum of all those numbers. But I also need each individual number to appear...

Hey everyone. So here's my newest problem. I'm building a database for an insurance company and I'm having some trouble getting a calculation to show up correctly on my form. I have two values... a total funeral bill, and a total amount filed. First I have to compare these two values to get the...

Hey everyone I need a little help with my database design. I haven't worked with Access in a few months so I'm beginning to forget all the intricacies of the software, so I was hoping you might be able to help. I'm trying to build a database to use to pay our bills each month. We pay bills to...

It's listed as a text box in the underlying table, and a combo box in the form.

Hey Everyone... I'm using a combo box to locate a form and ultimately populate other fields, however I'm unable to type information in the combo box that might not already be in the list. When I type it into the box, Access accepts it until I attempt to jump to another record, Then I get a...

Hey everyone, so here is my latest Access question. I work with a database within an insurance company and am currently building some forms to manage our new applications. On our applications we look up the height and weight of our policyholders in a table and assign them a certain number of...

Will different Service Packs for Different users contaminate the database? My database is doing some strange things and I think it might be because one of my users is on Micorsoft SP1 and everyone else is on SP2. Has anyone else run into this problem? Thanks

Ok I've got one for you... Here we go... I've got a database built that multiple users in different groups are using. When one more than one user is in the database, the form will take changes in a very odd way. If I try to update a field in a record, then refresh, it takes that new info and...

That won't correct the problem. It does it even when I use the navigation buttons. Also my users have gotten used to using the mouse wheel. Any other ideas?

So I created a form that is linked to a subform relating to various tables. When I create a new record all of my information is saved properly in the tables, Yet when I go back into my form into an existing record and attempt to edit/update a field, then use the mouse wheel to scroll forward and...

Here is the code for the form... I'm not sure if this happens when I don't use the wheel. I'll have to try it... Option Compare Database Private Sub Command24_Click() On Error GoTo Err_Command24_Click Dim stDocName As String stDocName = "DEATHCLAIMENVELOPEFINAL" DoCmd.OpenReport...

I created a basic database that our company has been using for the past few months, but very recently our input form has been acting strangly. When I open the form, I use a combo box to search for a record. After that record pops up, I update a field called Case Number, then I press enter...

Yea that makes sense... But that means that our staff would need to know each agents specific IDNumber, as opposed to their agent number. They are familiar with the agents based upon their agent number. No IDNumber exists. I was hoping their was an easier way. O well thanks for the help anyway.

I lied. I tried to change the primary key, but I still can't use the old agent number and prevent it from updating the previous records. And yes AlexMidd you are correct, the agent name needs to travel with the policy even if he leaves the company. Any other ideas?

You might have given me an idea to make this work... I let you know, thanks!

We've always reused agent numbers. Is there anyway to prevent it from updating those names?

I've created a query for applications that come through our insurance company. Each application requires inputting a policy #, an agent name, and an agent number. Because each agent has a specific number, I created a seperate table with agent names and numbers so that my form will automatically...