Search results for query: *

REF: thread701-1454746 I am trying to create a smart number for a user. Currently they are using this system manually and have been for years. They want the "Julian" (Ordinal)date to be used in this format:Year-Julian Date-sequential number. EX: 08-185-01 This would signify that the report was...

Attached is my code (Copied from the internet and modified) for an Access 2000 database. I want to add a new "Analyst" to a table called "Financial_Analyst". I am using a combo box that lists the current Analysts, but if one is not there I would like the user to be able to add an Analyst. The...

We have an assembly line that rebuilds units. In order to get the correct parts to the line in a timely manner we need to know which parts are used in the rebuild. This way we can put a percentage of parts (like 67% of the time we need a new thing-a-mabob) Then in the Bill of materials we would...

I have a database that keeps track of who completed which training and when it is due to be refreshed, etc, etc. Previously, the Cross Tab report was separated by department (Dept) now I want to sort it by Supervisor Code (Code). I copied the code and made the changes so that it related to my...

Hello! I posted this problem in the general database section of the website and did not get any responses. Guess no one looks there. So I copied it here. Hope someone can help. I need to be able to log off idle users on the databases I write. So I looked in the faq section of this site and...

I need to be able to log off idle users on the databases I write. So I looked in the faq section of this site and found exactly what I needed. (faq181-1432) However, when I copied the code into my database it did not work. I receive the following message: The expression On Timer you entered as...

I have a database with a table for drawing information. This table gets joined to the Change Report so that when the change report is printed, the drawing information is pulled from the table and added to the report. There is a record in the drawing table that has "#Deleted" in all the fields...

Hi and thanks for all your help prior to this. Here is my dilemma. -I have an item that has (9)components placed in it. -Each item has a serial no. -Each of these components comes from a particular lot. -All of the components are the same type. -(4) of these items go into the final product...

I have a form that i plan on using to enter data. Within this form I have loaded some command buttons that call up other forms. I would like, if possible, to have the sub forms that I call up have the "SOW" (Primary key in all forms)loaded when the sub forms are opened. Is this possible? [wavey]

Here's the deal. I have a form that has a deliverable date. Then there is a deliverable modified date. What I want to do is, when one fills in the modified date the Modification explanation form pops up. I use a calendar form for the date and I have a command button for the Modification...

We use the database across many departments and users. Some are regulars and some only use the database occasionally. The problem is ... When one of the occasional users has to enter data he/she sometimes writes over another's data. I have placed a command button to click to get a blank record...

I have an executive report that the header bar changes color if the contract deliverable is on-time, green, late to contract, Red and if the contract has been modified for a specific item it turns orange. Now my boss would like to see it change to yellow if the delivery date is within 30 days...