Search results for query: *

I've got a largish spreadsheet that I imported from Access. I'm using the values in the spreadsheet to calculated averages on another worksheet. The problem is that the imported data has a large number of blank cells. I want to convert those cells to 0 when I use them to calculate the...

Excel newbie, please forgive me if this is obvious. I'm calculating a variance column as (A2-A1). Negative numbers display fine, but i'd like to display positive numbers with + in front of them, in other words like +4.02%.

I'd like to open a form with docmd.openform ...acreadonly..., then make a single field on the form editable. Is this possible?

I'm building a program to track promotions within our company. One of the requested functions is for the program to automagically send an EMail to payroll when HR has recieved all of the paperwork necessary to approve the promotion. I've got the code to compose and send the EMail completed. I...

Management has decided that they would like to see some of the data from my Access database exported to an Excel spreadsheet. I can handle the data export with no problem, but then I find myself opening up the spreadsheet and spending 15 minutes retitling the column heads, bolding and coloring...

Designing a report for our quarterly bonus program. Table layout, field names, etc were set up before I got here, and can't be changed for various reasons. We have five fields in the table which can get set yes/no. What I want to do is count how many of those five fields are set to "yes", and...

We've got 5000 stores. Each store is assigned to a region with 10-12 other stores. The problem is that stores are constantly being reassigned and moved to different regions. For reporting purposes, we'd like to be able to tell which region a particular store was in at a certain point in...

This is confusing. I'm using Distiller 7.0. I want to set up a watched folder. Acrobat help says to click Settings -> Watched Folders. Sounds easy enough. I click Settings in Distiller, and there's no option for Watched Folders. I see Font Locations, Edit PDF Settings, Security...

I don't even know which forum to post this in, so I'll start here. I upgraded my system last spring - Asus K8N mobo, 2 SATA drives, 1 IDE drive, 1.5 gig of RAM, ATI 9800 video card, ask about any of the other stuff if you think it's important. The systems been giving me problems since I put it...

I frequently get the error message "The Microsoft Jet database engine could not find the object 'whatever'" when I'm trying to import or link to an external file. The workaround is simple, I just rename the file to something short and simple, and the Jet db engine is happy. I'm wondering if...

I'm working on a database which has me typing some survey results into a database. My problem occurs when a few of the values coincidentally appear to be in a sequence. After the second or third number is typed in, Access decides I'm making a sequential list and helpfully fills in the next...

I've got a database with about a dozen users entering records. Records can be fairly complex, with 20 or 30 minutes spent on entering each one. On occasion, a mistake is made and a record needs to be deleted. Obviously, I'm leery about giving users the ability to delete records without some...

I'm trying to set up a simple error logging routine for my project. I call an error logging function, passing along the relevant variables, and the error logging function uses a DOCMD.RUNSQL INSERT INTO command to shove the data into the appropriate table. The problem I'm running into occurs...

I have a table with a single field. I need to loop through the table from beginning to end and send the value of that field to another function. Simple, right? I try not to let my ignorance prevent me from offering a strong opinion.

Got a strange error popping up in my Access DB. I've had three different users experience it today. They get an error message saying "You cannot exit the program at this time. If you are running a Visual Basic program etc etc etc" The messagebox has an "OK" button, but all clicking that does...

I've got a form with a linked subform. The subform displays continuous records. I have code in the main form that looks up data in an external table with dlookup, then adds it to the subform with: Forms![frm1].Form![subfrm1]![Field1] = txt1 Which works just fine until it's time to add...

I've got one of those USB key drives. Win XP wants me to open up the "safely remove hardware" box and stop the drive in XP before I disconnect it, which is a PITA. I can see where there might be a problem if I pull the drive out while it's being accessed, but will anything scary bad happen if...

A question about definitions. If we look at a table in datasheet view, we call a row of data a "record". A column of data is called a "field". Where a row and a column intersect, we have one specific little piece of data, and we call that a....? I keep thinking we've got a name for that...

I'm setting up a subform that lists continuous records. I'd like to set up something similar to what Access displays when when you're viewing a datasheet with linked tables. In this case, Access displays the datasheet with a "+" over in column one. Clicking the "+" opens a smaller cascading...

I want to place my front end on a network drive and have my users copy it to their local drive before they use it. Is there any way to have the front end check which drive its residing on at runtime? Essentially, I'd like to have the front end display a polite error message and exit unless it...