Recent content by pbt1234

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...

OK, I tried the viewer that was suggested by OlafDoshke and was able to open the files. Since the 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...

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

Tried that this morning, still same message . . . . Thanks again - will keep trying. pbt1234 Private Sub Newday_click() Dim strLookUpValue As String Dim strAnswer As String Dim rngLookUpRange As Range Dim intLookUpRow As Integer Do While intLookUpRow < 138 Set rngLookUpRange =...

Sorry Skipvought I did not see the variant part . . . Changed as seen below and still get same error. Thanks again! pbt1234 Private Sub Newday_click() Dim strLookUpValue As String Dim strAnswer As String Dim rngLookUpRange As Range Dim intLookUpRow As Integer Dim myvar As Variant Do...

I tried adding what you asked and still get the error message . . . Any more ideas? Thanks! pbt1234 Private Sub Newday_click() Dim strLookUpValue As String Dim strAnswer As String Dim rngLookUpRange As Range Dim intLookUpRow As Integer Dim myvar As Long Do While intLookUpRow < 138...

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