Recent content by jerryczarnowski

Your 3rd option gave me the idea below...both work. SELECT Table1.ID, Table1.COLOR, Table1.TYPE, Table1.DESCRIPTION, Table2.RPM, Table2.FEED FROM Table1 INNER JOIN Table2 ON Table1.[ID] = Table2.[ID]; Thanks!

I may need to back up a bit. Table1 and Table2 are for example only. Table2 in reality came from an excel spreadsheet and has 5,640 rows and 22 columns. Table1 is a scrubbed version of table2 and was scaled down to the columns of importance. To make things worse, the person maintaining the...

Hello, I would like to create a query via SQL to add two fields and the data from table2 to table1. They both have ID as the primary key. Attached is the visual result. Thanks, JCDFCM

Thanks Steve...it worked perfect

Hello, My intent is to prompt the user for a Cutter ID and utilize the InputBox to capture the user's input and pass it to a string variable representing a SQL statement, then run the SQL. When I run the code below, it asks me for a parameter value for CutterID right after the InputBox...

Hello, I have a command button that opens notepad with a string argument representing the filename. Here is the function below: Public Function OpenNotePad(strFile As String) Dim x As Variant x = Shell("notepad.exe " & strFile, 1) End Function Can I take it a step further and...

Replacing the RecordSource with a different SQL string works just like you had mentioned. I am still trying to figure out how to apply the different SQL string to the current result set which is not a physical table or query. I have an interactive form where the user has eight different combo...

after googling furiously, I've come to that conclusion so I went the direction of creating temporary tables then changing the record source with Me.RecordSource = "Select...FROM TEMPTABLE... Thanks for pointing me in the right direction. Jerry

Hi Pat, Thanks for the quick response. Usually in a select statement the FROM references a table...but in this case when I am not referring to a table or query, can I skip the FROM statement? The idea is for the user to select a Holder Company and LYNDEX is a value in the list...then the...

I have a split form that is loaded with the record source being a SQL statement and would like to update the datasheet section when the user selects from a combo box utilizing the BeforeUpdate or AfterUpdate event. I would like to apply a new SQL statement (in the event code) referencing the...

is it because updating a field performs a write to the disk as opposed to a query producing a result set in RAM? I will experiment with referencing a control on a form in the recordsource query...I'll try to google some examples unless you happen to have an example handy. Again, thanks for the...

If I understand, what you are suggesting is to insert the expression in a query or a sql statement that can be used as a record source for the form. In this case, I am using a sql statement as the record source when the form is loaded...should I modify the sql statement and requery? I chose the...

Hello, I have the following chunk of code from 2010 and would like to know the equivalent in 2007. Private Sub cmdPallet32_Click() ' show pallet button green - represents active pallet Dim lngWhite As Long, lngGreen As Long lngGreen = RGB(34, 177, 76) lngWhite = RGB(255, 255, 255)...

Could anyone tell me the equivalent in 2007 of the following: In 2010, I have a field of data type integer called LotSize and another of the same type called CycleTime. I then have a field of calculated data type called TotalCycleTime which uses an expression and produces a result type of text...

Thanks again, looks like I need to explore expressions more...didn't realize how flexible they are and how many places they can be used. I will experiment with the SQL.