Search results for query: *

I have a number that has 8 decimal places (0.12345678). When I use the toolbar "decrease decimal" button to hide decimals places it works fine. But then when I use the "increase decimal" button it rounds the number and shows zeros. i.e 0.12345678 --> decrease twice to 0.123457 --> increase...

The issue I am having is getting the graphs to update when I run a macro that redefines the range. Everything works fine in Office 2000 but not in Office 2003. I have a file that contains multiple sheets: Data sheets = there are many of these which all contain the same rows and columns but...

I have an Excel file with about 20 worksheets in it. Two of the worksheets are named first and last. What I want to do is pull all of the workbook names between first and last into a drop down box. I know this has to be a simple For Loop but I am struggling with pulling the names without...

I have two MS Access databases. One retrieves data, the second is the user front end. The front end calls the first database to run specific queries. One of the users - at a separate location - can run the queries from the first database manually. But when using the front end the macro dies...

The following code takes the items selected in a listbox (PARTNOSELECT) on a form (START_UP) and puts them in a textbox (Text1). It places them into the textbox the following way: "PartNumber" OR "PartNumber" Or etc.... Private Sub Command19_Click() Dim varRow As Variant Dim strText As...

I have data that has dates in the Julian format: 3032 = 32nd day in 2003 = February 1, 2003 99002 = 2nd day in 1999 = January 2, 1999 I would like to break it up into the standard date format, MMDDYYYY. I have been trying to accomplish this task by several If SQL statements but it they are...

I have a calculated field in a report that I need to take the average of. It is not possible to take the average of it in a report so I would like to pull it into a table so that I am able to then pull it back into a report and average it. I know it sounds redundant, but it is necessary. I...

I have a series of checkboxes on a report that read from a table. For each checkbox I have its control source as an If statment that reads if there is an "A" in the table that the checkbox will be set to 1 and if not it will be set to 0. I have a total of 8 checkboxes and each ones...

I have a field that contains data similar to this: 4 F3 8A 2-6 2FL I need to delete only the letters in each cell so that the data would read: 4 3 8 2-6 2 I know that there has to be an easy solution to this, I just can't find it. Any help would be very much appreciated Jennifer

When I run an append query that deletes duplicates in a table, an error message comes up saying,"Microsoft Access can't append all the records in the append query." The error message is just telling me that some of the records will be deleted, which makes sense, seeing as I want it to...

When I run an append query that deletes duplicates in a table, an error message comes up saying,"Microsoft Access can't append all the records in the append query." The error message is just telling me that some of the records will be deleted, which makes sense, seeing as I want it to...

I know this has a simple solution, but I am having some major problems with it. What I have is a table that contains two fields, one called "terminals" and one called "work area." The data in the terminals fields are not unique. In other words, for each unique terminal...

I am working on a database that is being placed on a server to be used by 150 people or so. They are only permitted to view the data, and cannot change it. The problem is that this data is frequently changed by other sources and needs to be imported into the database on a daliy basis. I only...

WhatI need for the user of my program to click on a button on the switchboard and it automatically imports a delimited text file. I know that is easy to do with a macro and the TransferText option, however my problem is a little more involved. Every user will be importing their file from a...