Search results

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.

Thanks for the quick response and clarifying the use of Date/Time. I kept cycle time and lot size as integer type and changed total cycle time to a calculated field and plugged in an expression similar to the example you provided...works great, my form shows the total exactly how I want. Now my...

Hello everyone, My problem I believe has a simple solution possibly just dealing with the format and input masks in table design but being a beginner, I am not sure how to use these tools properly to get the desired results for the scenario below: I have a table with 3 columns named "cycle...

Hi Dave, Tried the doevents and it caused a flicker in 2010 but will try it in 2007 at work. As you had said, no harm done and it may be something I use down the road. Thanks, Jerry

Hi Ari, I was able to debug...threw in a few temporary stop commands before and after each sub and while single stepping through, found that the following code causes the Form_Current() event to be triggered twice. DoCmd.OpenForm "Scheduling" Forms![Scheduling].RecordSource =...

Hi Ari, Thanks for the quick reply. I don't know if we are updated to SP3 at work but I will definitely try the debug. I will have to try this out in a week as me and my sons are going on a fishing trip. Will let you know how it goes as soon as I can. Is this the right approach for updating...