Search results for query: *

Hi, We are building a document control tracking database and need some help. Our document number is in the following format: 2-DEP-000 Where DEP gets replaced by 3 digit department code depending on which department wrote the document. And 000 gets incremented by 1 for each new document from...

My company announced 6 months ago that they are relocating to a new city. As would be expected many people decided they do not want to relocate (I happen to be one). Many people are leaving the company each week. As more people leave more work is placed on the remaining employees. Because...

using access 97 table structure sdate date item text histqty double histfcst double sdate is always a sunday date (thus 1 week seperates each record). example data: sdate item histqty histfcst 7/4/04 10001 500 300 7/11/04 10001...

using Access 97. I have a form which contains several combo boxes. The user may select any number of combinations for the combo boxes (ie. select someting in 1 combo box or in 2 different combo boxes or in all of the combo boxes). Then the user clicks a command button which opens a report (in...

Using Access 97...A consultant built a form that allows user to select year then week. After those selections they click enter and the database copies the required data to a temporary database on the users hard drive. Everything works as it is supposed to. However, in the recent weeks it...

Hi, I work for a very large consumer goods company. I started in December of 2002 as a Data Analyst. When I started they had reporting systems that were very complex and non-user friendly. My initial "assignment" was to modify/create data reporting systems for our department. I have done...

When the database opens the frmDataEntry (Record source = tblLog) opens in Dataentry=true mode with two fields automatically being populated: "requestdate"=date() and "autonumber" populates. The form is essentially a request form where the users enter infromation about a specific request...

I use Access 97. I have a table (tblJoinedData) which contains data I need to perform a complicated calculation on. Basically the table contains data for the following (given in field names): Item Loc Month (ie 1-12 numeric field) Period (ie P1 - P12 text field) PP SR AP PP_AP (This...

Hi, I have other Access 97 databases that this works fine in. But I can't figure out why it isn't working here. I have a form frmBusinessUnitReveiw which has two combo boxes on it. Here is the Row Source for each: Combo 1 "cboBusinessUnit" SELECT SOP_MASTER_FILE.[Business Unit] FROM...

I have a form which contains 3 combo boxes (cboProdDate, cboLocation, and cboItem) and a command button that opens a form frmupdate2. Here is the on click event procedure: Private Sub cmdupdate2_Click() On Error GoTo Err_cmdupdate2_Click Dim stDocName As String Dim stLinkCriteria As...

Using Access 97. I am trying to find an easy way to build a temporary subset of data for each user (to exist while the user is in database only) based on a date range the user selects from a form. My initial thought is to have a command button on the form that runs a macro called getdata. the...

Using Access 97 I have a form that the user can query table based on timeframe. (ie: pull data for 2/01/04 - 2/08/04). What I want to do is to take that data from the query and make that the record set for everything else that happens on the form. I want to do this to speed up the rest of...

Using Access 97. I have a form wich contains several other "subforms". I say "" because they are not subforms in the sense that there are any link master fiels/child fields. I am using it more as a hide/show this form based on a group value. My problem is, I would like...

using Access 97. I have a form which has a subform with a tabcontrol on it. The tabcontrol has subforms on each tab. My problem is when viewing the main form - the fields do not appear in the order that they are in the subform. masterform contains subDC subDC contain subcat subcat is a...

I use Access 97. I have a form that basically has 3 subforms. Each subform contains a tabcontrol with multiple subforms. When I open the main form - it is very slow to open. It seems as though it is running through each tab on each of the 3 subforms before opening. I saw post about adding...

Using Access 97. I have a table that represents our fiscal year in 4 fields. FISCAL YEAR Day Week Period Here is an example of the data: Day Week Period Fiscal Year 12/27/03 26 6 2004 12/28/03 27 7 2004 12/29/03 27...

I'm using Excel 2002 and Access 97. In access I have a query that combines 3 tables. And limits it to 6 weeks worth of data. In Excel I created a pivot table using the access query as the data source. The pivot table works fine if I hard code dates in the criteria of the query (ie. between...

I'm using Excel 2002 and Access 97. In access I have a query that combines 3 tables. And limits it to 6 weeks worth of data. In Excel I created a pivot table using the access query as the data source. The pivot table works fine if I hard code dates in the criteria of the query (ie. between...

Hi, Using Access 97. I have a field that contains text only. When I have a value of a word with double vowels, access is putting the accent mark over the 1st vowel. ie. ENTREE becomes ENTRÉE I have a form that uses a combo box from this field - that does not put the accent mark. Thus...

Hi I have a pivot table whose source data comes from Access 97. My Row is Item My Column is SDATE My Data is: sum of histfcst sum of histqty sum of abs What I need to do is add two calculated data fields: FA - which would use the following formula: 1-(sum of abs/sum of histqty)...