Search results for query: *

I have the following table (Table1) in an Access 2003 database: PART# WHLOC #LOCS PART1 R1SH2 PART2 R3SH1 PART2 R1SH4 PART3 R4SH3 I need to run a query to populate the '#LOCS' field for each record with a number that indicates how many locations each part resides in...

I have been researching and testing and still cannot seem to figure this one out... I have to convert this Excel formula to work in an Access form: =(MAX(D1:D6)-MIN(D1:D6))/(MAX(D1:D6)+MIN(D1:D6))*100 My form's unbound text box controls: D1, D2, D3, D4, D5, D6 Formula would be entered as...

Hi all! I've been away from Access for a long while now, so please bear with me. I've been searching the FAQ's and threads but cannot seem to find this answer; please pardon me if this has been answered elsewhere and feel free to point me to the correct thread. I am using this code on an Access...

Hello All, I'm hoping someone can help me with a problem. Some background: In Access 97, I have a form with multiple text boxes, of the 50 or so TB's only about 6 are bound to the results of the query underlying the form, the remainder are 'unbound'. This has worked flawlessly for a few years...

Hi all! I have a Acc2000 database running with the main window hidden and all forms 'pop-up'. I have one form, based on a query, that is giving me troubles with record deletion. Before going to the hidden window setup, my users could simply use the 'record selecters' of the form and right...

Hi All! I would like to create a new, empty table (structure only, no data) from three other existing tables. For example: I have table A which has 25 fields and table B which has 35 fields and table C which has 20 fields. I want to create a new table of 80 fields all of which are named and...

Hi All! I know this should be easy and I've searched the forums and FAQ to try different configurations, but I cannot get this to work on my Access 2003 form. Please tell me what I'm doing wrong. I'm trying to auto-check a check box based on a selection chosen in a combo box. On my form, I...

Hi all! I have a command button, in the header of a form, in an Access 2003 database that performs copy/paste operations for me; It does this very well. My only issue is that when I close the form after doing a copy/paste operation, I always get a "Microsoft Office Access" message: "You copied...

Hi all! I have used the "On No Data" event on a few Reports before, but does anyone know how to do something like this for forms? Thanks! - Turb

Hello all, I was wondering if anyone could help me out on this. Is it possible to have an If/Then/Else statement determine which query a form should use as a record source? I know I can use the If/Then/Else statement to open a different form with a different query as record source, but I...

Hi All! I have a form that I have created that will print out onto label stock. This form's record source is a table in the Db that contains a series of MAC addresses. This is where I run into problems... I can't seen to figure out how to make just the 'top' (sorted ascending) mac address (a...

Hi all, I have been trying to get this statement working all morning and I'm at a loss, could someone help please? I've this statement If Me.ORDTYPE.Value = PDC Then DoCmd.RunMacro "Macro4" Else DoCmd.RunMacro "Macro1" End If under a form in my Db. What I'm trying...

I have this script to close a window based on it's name (no, I didn't write it. I'm not that familiar with VB): Set objWord = CreateObject("Word.Application") Set colTasks = objWord.Tasks If colTasks.Exists("this window") Then colTasks("this window").Close End If objWord.Quit Is there...

Can anyone help with this? I am trying to figure out how to close a window (not a DOS or command window) using a batch file.

... for not being able to use user input parameters in a summing query? I have this: SELECT MPC00.TS_NUMBER, MPC00.CLAIM_RCVD, MPC00.RINV_AM_PD, MPC00.MODEL_NAME, Sum(DSum("RINV_AM_PD","COSTS")) AS TOTAL FROM MPC00 WHERE (((MPC00.CLAIM_RCVD) Between #8/1/2006# And #8/30/2006#)) GROUP BY...

All, I have a table that has a field where the values are entered as "##-?###" (ie 05-C155). The letter character is a designate for an area of the production floor here; there are five different areas represented, C, M, S, I, and R. Is there any way to create a query that would allow a user to...

All, I have to create a query(?) that will export to an Excel spreadsheet, but I'm not sure how to set it up to filter by the following criteria: The query has to take multiple user selectable options including a 'to-from' date range, a null/not null/all selection (based on a table field), and a...

Folks, I am at a loss and thought I'd request the assistance of the pros on Tek-Tips. I have a database that is split front-end & back-end, I've made Access 2000 mde's for the users and have them installed on the users desktops; the Access 97 back-end resides on the LAN. This Db is accessed by...

All, I have been trying to make this work for several days now and am at my wits end. I have an Access 2000 DB that runs minimized. I have an autoexec macro that controls the sequencing. The macro calls a couple of batch files (in succession), then runs a series of append queries before...

All, I've been trying to accomplish this and can't seem to find a direction to go even after searching the FAQ's and this forum. Can someone please get me started or at least point me in the right direction? I have a table structured like the one below: FIELDA FIELDB FIELDC FIELDD FIELDE STB...