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.

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...

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...

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...

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...

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...

I'm trying to create a database of flowers images that will display on a touch screen kiosk, and I was wondering if there was anyway that I could create a small templet for a form, then have Access repeat it horizontally across the page instead of vertically like the continous form command...

Hey everyone, thanks for all of the help in the past, but now I'm having a picture problem. When I open a form my picture isn't showing up, instead it only shows the outline of the border and the filename (picture.jpg) inside the image, how can I get it to show the actual image there? Thanks John

Any help to this problem would be wonderful. I've got a list of data that gets sorted into two columns during a query (Filed and Unfiled). Then both columns are printed onto a report, and totaled at the end of the report. The major problem I'm having is in order to get a total in Access, a field...

I was wondering if anyone out there is using Access as an image archive for check processing. We manually input check information into Access, but the process takes anywhere from 1.5 to 2.5 hours. I was hoping that we could use a check scanner to create an image of the checks, and automatically...

I have multiple databases saved onto one hard drive, and I'v applied security to one, by setting up a workgroup file, but it seems to be applying to all my other databases as well. When I change the workgroup in the other databases, it then applies to all the databases again. Is there anyway to...

So I've been having this problem for quite some time, and any help in the issue would be wonderful. I built a database on a shared file server and I just recently secured it. The .MDW file is in my hard drive and I've assigned multiple permissions to different groups and users. My problem is...

I've got a security problem with Access 2002. I just created a few work groups and users, and I assiged them permissions. The database is located on an internal network, and when I open the database from my computer, everything works great. However, when anyone else opens the database, the...

Hey Everyone. I'm trying to hide zeros in my report but I need to make a calculation at the footer of several sections. I've tried to input <>0 in the criteria sections of my query, but I get errors in my calculations. Is there anyway to hide these zeros and still calculate a total? John