Search results for query: *

dhookom - The table structure and data types are below . . . PartDesc - Text DrawingNo - Text OrderingNo - Number MeasurementLabel1 - Text Measurement1Min - Number Measurement1Max - Number MeasurementLabel2 - Text Measurement2Min - Number Measurement2Max - Number MeasurementLabel3 - Text...

I currently have a query that creates a table from many different tables in preparation for the report. The table created is filled with information about parts measurements. Each part can have up to 6 measurement labels (could be different for each part - i.e. part 1/measurement label1 could...

I have a query that pulls new and used tolernace limits for parts from two tables. New tolerances are stored in one table and used tolerances are stored in another table. Information about tolerances can be found in either table by searching for the part number. There is an entry in the new...

Sorry that I have not posted a reply to these helpful words of wisdom sooner, but have been traveling way too much these days! I want to thank all of you for your help! I have finally got all the data moved over to Access and am now working on re-creating the reports. I am sure there will be...

harebrain - Thanks for the help! Could it be that Access is doing the same thing? I have tried to do as described and also to import directly to access from the dBase III file and get the same problem. From Excel, I have tried formatting the field as a number, text and general. Neither of...

...application is a shareware item, I was able to only view/export 100 files. I found another program CCVT.exe that allowed me to convert the Clarion *.dat files to dBase III files, which could be viewed in Excel or imported into Access. I have hit two hurdles with this . . . 1) the field...

I have been given an OLD database running in DOS (looks like Clarion - how would I know?). I need to convert this to Access. Any ideas on how to do this (programs, process, etc.)? I really only need the data moved for purposes of creating new reports, etc. Any help would be appreciated! pbt1234

SkipVought - - Did not see that you had dropped the WorksheetFunction porition. Once I did that worked like a champ!!!! Thanks so much to all of you for helping with this problem. I have NEVER been here with a question that someone has not been able to help with. Thanks again! pbt1234

...< 138 Set rngLookUpRange = Worksheets("Inventory").Range("A2:D1000") strLookUpValue = Worksheets("OPSC").Range("B" & (4 + (7 * intLookUpRow))).Value If (IsError(Application.WorksheetFunction.VLookup(strLookUpValue, rngLookUpRange, 4, False))) Then...

...< 138 Set rngLookUpRange = Worksheets("Inventory").Range("A2:D1000") strLookUpValue = Worksheets("OPSC").Range("B" & (4 + (7 * intLookUpRow))).Value myvar = Application.WorksheetFunction.VLookup(strLookUpValue, rngLookUpRange, 4, False) If Not...

...< 138 Set rngLookUpRange = Worksheets("Inventory").Range("A2:D1000") strLookUpValue = Worksheets("OPSC").Range("B" & (4 + (7 * intLookUpRow))).Value myvar = Application.WorksheetFunction.VLookup(strLookUpValue, rngLookUpRange, 4, False) If Not...

I am using Application.WorksheetFunction.VLookup to find inventory values for a specified item. When the item is not in the list I get a cryptic message "unable to get the vlookup property of the WorksheetFunction class". How can I deal with this? I thought I could use ISNULL or " = 0" to...

The problem was with the installation of the printer itself. Apparently the drivers and so forth were no properly installed. Uninstalled and re-installed and everything is fine. Thanks for your help! pbt1234

I need some code that shows me how to input information from an RSLinx topic to a VB variable. Thanks! pbt1234

It is set at "Default Printer". Thanks! pbt1234

I have an access database that is on a shared drive. When one of the users tries to print a certain report it always goes to a network printer and not the user's printer. Even when the user selects the printer on LTP1, the report still prints on network printer. Other reports from the same...

Patrik - - Could not use validation because data is in another sheet. ++++++++++++++++++++ Paul D - - I was able to get this to work by doing the following . . . Private Sub cboBPI_DropButtonClick() Dim LastRow As String LastRow = (Sheets("Input Data").Range("L1").Value) + 3...

I have an excel spreadsheet that contains a combo box whose list fill range is a table in the spreadsheet. In order to make this easy to maintain I would like to be able to set the list fill range to something like A1:A1000, that way as items are added to the table the combo box picks them up...

I have a report that uses a cross tab query to assemle it's data. Each entry has a week beginning date and I use that as the header for the cross tab. Because the report was built using the data that was in the table at the time the headers for the report are the week beginning dates that came...

My thanks go out to scriverb and ohiosteve! With input from both of you I was able to create a means to do this and learn a lot during my testing. I can now capture the dates, store them and show them on my reports. Thanks again to both of you for your input and help!!! pbt1234