Search results for query: *

Let me explain . . . I need a way for the users to enter a parent part number (once) and have it populate for multiple dies and their individual specifications . . . I was thinking of a form with subform, where you enter Parent# on Form and it populates to subform where the user enters the...

I have a SQL2000 datawarehouse with a A97 FE used primarily for reporting . . . however, I have a complex report where we decided to create a stored procedure that creates a temp table and use that table for the basis of the report. If there is a way to launch the stored procedure from within a...

Help Why can't I enter data in a subform that is bound to a simple select query. I would appreciate someone to educate me!

DoCmd.TransferSpreadsheet acExport, 8, "XCM101_ICTOTALS", "H:\XCM_RawData.xls", False Using this code to create a worksheet in Excel and dump the data for the XCM101_ICTOTALS qry. However, I get the error External table not is expected format. What does this mean???? Any...

Hello experts... I need to be able to export multiple queries to an Excel workbook and have each query create a new worksheet tab. I can get it to export but the last query is all that is left after it overwrites the one before. Is there a way to create/name a new tab on the fly??? I hope...

I need help! I have a series of queries that are used at month end and need to automate the process of dumping data into Excel. I can get them to export to Excel, but I need each query in it's own worksheet within the main workbook. Here is the code I am presently using, it is in public...

Need some guidance! I have a bound checkbox (Pass) on mainform (01_Audit_Entry) that allows user to check if the parts passed 1st inspection. However, I want to either disable/hide/or validate this checkbox by comparing it to the subform (01_Sub_AuditDetails) when they enter a reason of...

I have a form with a subform (each bound to separate tables) I use a unbound combobox to select the company which then populates the continuous subform with all the complaints of that company (parent/child link). The problem is when I put a QA_Action# in the field in the subform and then...

I have a main form (unbound) and a subform (bound tblMaster_cc) The user selects a company in Combo (cmbCompanyID) which fills in some unbound "info" fields on the form. Then they are to click a button (cmdCreateComplaint) which I wanted to pass the value of the combo box to the...

Any help would be greatly appreciated . . . I have a Mainform (01_Main_Prod_Complaint) that is unbound with a combo (cboCustomerID) (2 columns... Company_ID and Company_Name bound to Company_ID) that uses a query for it's recordsource . . . What I need is for the user to select the company...

Please help I have searched the site and can't find anything on the following . . . I have a form that tracks Cust. Complaints, that I assign a autonumber to. A customer may have multiple "jobs/ workorders" that they have concerns about, each gets own CC# (CustComplaint#). Then...

I have a client that needs to track all changes/modifications to records in their database. He wants to have record of the date and user who modified the record, but I want to keep it hidden from end user. Please help, I am stuck! I use a FE / BE and utilize MS security. Does anyone have...