Search results

A 2 part question. SQL related with Spec combo box: SELECT S.Key, S.Spec FROM tblSpecs AS S ORDER BY S.Spec; NotInList code: Private Sub cboSpecs_NotInList(NewData As String, _ Response As Integer) ' MODIFY SPEC ENTRY. 10 Dim db As Database 20 Dim strSql As...

This is from a SAVE RECORD button: Private Sub cmdSaveNewValue_Click() 10 Dim db As Database 20 Dim strSql As String ' Add new tblValues entry for New Value textbox. 30 Set db = CurrentDb 40 strSql = "INSERT INTO tblValues (SpecID, Value) VALUES (" & _ txtKey & ", '" &...

Hi, I have separated the data from forms/reports/etc to facilitate future updates: - Program MDE - Data MDB (if I understood forum threads properly, this is the recommended technique) What is the normal way to deploy these? Do I just provide the user with instructions to link to the...

I don't know if this is possible from VBA. I have a main Part form and a Spec subform linked via Part key. I need to add 6 Spec records automatically when a new Part is added so user can select desired Specs (default value is "n/a" for al 6 entries). Right now I have the Spec entries...

I run the Riley: I'm happy for a top 5 on roadies. And the NASCAR iRacing fixed series: Won my split in the Daytona opener this year. WOOT! Ok, so we were the 10th split of 14 or so, but still, I finished without a single scratch. :) Was up to 2nd after halfway mark at Phoenix, but...

This code: Private Sub txtPart_LostFocus() Dim db As Database Dim strSQL As String Dim lngPartKey As Long Dim lngSpecNaKey As Long Dim intLoop As Integer If IsNumeric(txtKey) And strPreviousPart <> txtPart Then lngPartKey = Me.txtKey lngSpecNaKey =...

What's the proper way of tackling this? Main form - RecordSource=PART tbl - single layout Inventory form - RecordSource=PART tbl - linked to Main form via Part key - single layout Inventory Detail form - RecordSource=INVENTORY tbl - linked to Inventory form via Part Key - continous layout...

I've tried everything I can think of and can't figure this out. This works when RUN from SQL view: SELECT PartID FROM Inventory WHERE [Barcode]=#2014-02-13 02:20:42#; It returns the correct record. This returns a syntax error: SELECT PartID FROM Inventory WHERE...

Hi, I need to execute a specific panel from the bluetooth icon on the Windows XP task bar. Tim Fisher over here: http://pcsupport.about.com/od/tipstricks/a/control-panel-command-line.htm shows how to use Command Prompt to open the Bluetooth panel: control bthprops.cpl I tried it from the...

I don't what to search for (I'm a retired COBOL programmer), so I will describe what I need and hopefully it will make sense to someone. I am making a personal inventory for electronic components. I don't know the specs of components I haven't bought yet so I need complete flexibility in table...

Hi, new to the forum so forgive the use of incorrect terms. I have a Form with embedded Subform, everything works well as far as moving through records. Scrolling through records on main table via Form brings up correct records of child table on Subform, so the link between the 2 tables is...