Search results

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

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

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

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

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

Hello, I have a routine that sets the name property of an image control to a string variable representing the directory path, the value of a field, and a file extension. The code resides in the FormCurrent() event so when the user clicks on the next record, the image control updates. Works...

Hello Access world: I have an attachment representing my current challenge...use VBA to manipulate SQL or VBA to manipulate the DAO or ADO Object Model to obtain the results outlined in the attachment. I am using ACCESS 2010 and VBA as the development tool of choice. Being new to SQL, I...

Hello..first time I've used a forum..here it goes. I have some VBA code in a click event that Creates a table then attempts to create a form with the new table as the data source. After execution, a form is created but no records are visible and the record selector shows 1 of 122. Any...