Search results for query: *

I have a database that has had several people over the years hold the position of administrator. I myself am starting just starting to get into VBA, but one of the past administrators did use VBA quite a bit, but not necessarily on a completely succesful level. There were many FORMS as...

I'm trying to conditionally format a cell based on another cells content. I have a "Due Date" and a "Rec'd Date" for a part. The "DD" is conditionally formatted to show yellow if within 1 week, and red if past due. If I have a value in the "RD" cell I don't want the conditional formatting to...

Perfect! Much Thanks

I'm trying to use the stdev tool for multiple fields in multiple records. I've got 5 data points per record, and multiple instances when these data points have been checked. I want to get a standard deviation for all of the captured test data. Here is an example of the data for just 1 of the...

I've got a database that is detailed instructions for my assembly operators. There is a table in the database that is a "revision" table. Anytime I make a revision to an individual operator I enter the date that revision was made, a description of the change, and print out a hard copy of the...

Here is the entire SQL for the querry. As you can see it contains other information from the tables, but this information is not what I'm having problems with: SELECT [F53-12 JPH-Operator-TBL].Line, [F53-12 JPH-Operator-TBL].Station, [F53-8 JPH-Job Group To Process-TBL].Operator, [F53-8...

Thanks, but neither of those ideas work. Let me break down the explanation a little more. My database contains assembly instructions for an automotive chassis. In a Job Group table I have a these fields: Process Family Job Group Job Group Description (A general description of what the group...

I've got a number of records under a "group" classification in my table. A field in each record is a yes/no check box that can vary from record to record. When wanting to identify the group in a report by the group name, and also wanting to capture if any of the records within the group...

I'm having the same problem. I removed it from the query and replaced it after the format was changed, and still having the problem. Any other ideas?

I've installed 2004 and the express tools. When I first installed and loaded the express tools, the menu bars were there, but the proper icons were not on the commands. I edited the properties of all of the buttons, and used browse to set them to the proper icon. I did some drawing and used...

I had alias edit on AutoCad 2000 when I used it. Now I have just had AutoCad 2004 installed and would like to have the alias edit function again. Any help please?

I'm attempting to install alias editor on my system. Usually someone more technical would do this, but I'm on a site and on my own. Please help. I've done everything in the read me file shown here: To install the Alias editor copy alias.pgc alias.exe alias.hlp and acet1501.pgc to your...

In preparation for introducing my database to a network where various users would be accessing the database, I've been experimenting with user security permissions. I created an account with an ID for myself and assigned administrator properties to this. While logged on as myself, I...

I'm having a problem, in that most of the queries in the database I'm using don't allow me to update the data in the query its self. There are a couple of the queries that for some reason do let me update data. I don't see any obvious difference between the queries that I can update, and the...

The printer must support the duplexing feature, because we can print duplex from the computer that has that box available to be checked in the options. Should I try installing a different driver?

I'm in an office network environment, and would like to print on both sides of the paper when printing reports. One of our computers has this option available when you use the print menu, but the others don't have that check box in the print menu. Is there a way to turn this on? Most of the...

checked, all users have read write delete abilities. still have problem.

I am using access 2000 in an office network environment. When one of our users closes out a database, his computer is not communicating the information to close the "Access.LockFile (.Idb)" that is opened whenever a database is opened. This is creating an error message and causing us...