Search results for query: *

I have a form where the user enters the sales order number and then hits a "Print Labels" button. The button opens qryVAN00 which queries the sales order table and filters it based on the sale order number entered. For each record in the query I need to grab the value in the ItemKey field and...

I've got a txtPicture field on a form which is set to: ="\IMAGES\" & [PART#] & ".JPG" On this form I also have the field PART#, CATEGORY and PICTURE. I'm wanting to use this form as a subform on another form. This subform will be filtered by CATEGORY from a combo box on the main form. My...

I have the following tables: Categories with a Category field. Types with Category and Type fields. I have form Items with subform ItemCats. In subform ItemCats I want the user to select the Category and then select the Type using combo boxes, but I want the Type combo box to be filtered based...

I am using POs for one particular vendor that use the following format: Line item #1 contains Part #, description, and finish. Line item #2 contains Customer ID and sales order #. Line item #3 contains a period as a separator on the page. Each of the above is entered in the description field...

I am trying to print labels to a network label printer. I'm using the printout command as follows: DoCmd.OpenReport "VanDykeProductLabel" DoCmd.PrintOut , , , , [Forms]![frmVanDykeLabels]![QTYLABELS], False The label report specifies the network printer. [QTYLABELS] is the qty specified by the...

Here's my code: Dim nm As String, nbr As String, due As String, ord As String nbr = ActiveCell.Offset(0, 1).Range("A1") due = ActiveCell.Offset(0, 9).Range("A1") ord = ActiveCell.Offset(0, 13).Range("A1") nm = "X:\WOVEN PRODUCTION\CRIMP & WEAVE INST & ROUTINGS\" & ActiveCell &...

Here's my code: Dim nm As String, nbr As String, due As String, ord As String nbr = ActiveCell.Offset(0, 1).Range("A1") due = ActiveCell.Offset(0, 9).Range("A1") ord = ActiveCell.Offset(0, 13).Range("A1") nm = "X:\WOVEN PRODUCTION\CRIMP & WEAVE INST & ROUTINGS\" & ActiveCell &...

The code I have is below. The Shipment form has the field [LOC] which is one of a few set values (ie. RAW, SV, NB, or FB).These values represent the names of fields in the Parts table. Once the form is updated I want to use the value of [LOC] to reference that field in the Parts table. How do...

Here's the code I've got: Dim QTY As String, q As Integer, p As Integer, ITEM As String ITEM = InputBox("Enter unit part #:") DoCmd.OpenForm "frmBOM" DoCmd.ApplyFilter , [Forms]![frmBOM]![PARENTPART] = ITEM If [Forms]![frmBOM]![PARENTPART] <> ITEM Then result =...

I have a list of ship-to addresses from a customer. The last field contains the number of packages to ship to each location. In order to import this into my Fedex software, I need to have each line represent one package. Therefore, I need to duplicate each line in the original list by the...

I've got 2 tables; Employees and Timesheets On a form I want to display a list of the employees on the left of the screen and the timesheet entries on the right. When the user selects the employee, the correct entries show on the right. I want to be able to add to the timesheet entries. I...

Is there a way to show text in a date field on a report? I want to be able to put "N/A" in a date field if the field is null. Thanks Edwin

I am trying to sort and group a report based on 2 fields; we'll call them date and type. I want to sort and group as such: sort by date and group by month with each month on a separate page. for each month i want to group by type with each type going on a separate page. The result would be...

OK...I am able to use the following to populate fields in a record of the subform: [Forms]![frmOrderEntry2]![Order Details]![QTY1] = where [Order Details] is a subform that has the table OrderDetails as the data source. How do I go to the next record in the subform? Edwin

Here's the code I've got: Private Sub Command13_Click() DoCmd.OpenTable "WalMartOrderImport" DoCmd.RunCommand acCmdSelectAllRecords DoCmd.RunCommand acCmdDelete DoCmd.Close DoCmd.TransferText , "WalMartOrderImportSpec", "WalMartOrderImport", "P:\Edwin\Excel\walmart order...

I recently installed MS Office 2000 on a new computer running Windows XP. Whenever I try to create anything in Access using a wizard (Table, Query, Report, etc.) I get the error "ActiveX component can't create object". Help!! Edwin

I created a database in Access2000 that I have been using in Windows 2000. The database exists on a network drive and I access it through a shortcut on my desktop. I am switching to a brand new computer with XP Professional on it. I've installed Office2000 on this new computer. I've copied...

When I go to open this particular file, it asks me for the password which is fine, then loads nothing...even the name of the file doesn't show in the top of the window...not even under the Window menu. However, when I go to close Excel, it asks me if I want to save changes made to the file as...

OK...I'd like to know if I can access Platinum's files from within an MS Access 2000 application I've written. My application right now requires that I enter the orders into it and then it generates production & shipping schedules, shipping paperwork, etc. I'd like to be able to pull the order...

Here's what I've got: A B C 1 PART1 1 ONEONE 2 PART2 1 TWOONE 3 PART3 3 THREETHREE 4 PART3 1 THREEONE 5 PART4 1 FOURONE 6 PART5 1 FIVEONE Assume that G1 = PART3 Assume that G2 = 1 I want to be able to lookup G1 in Column A, then lookup G2 in column B...