Search results

Hi I am opening an excel file and refreshing some tables (list objects) on 3 different sheets. so... Dim appExcep As Excel.Application Dim objActiveWkb As Excel.Workbook Dim objActiveSht As Excel.Worksheet Dim objLo As Excel.ListObject Set appExcel =...

perfect thanks you

Hi I am trying to create some dsn less connections for my linked tables (sql 2005). I'm using the below with a username and password declared. Dim db As Database Dim T As TableDef Set db = CurrentDb db.TableDefs("CBF_master").Connect = "ODBC;DRIVER=SQL...

very pleasing. :) thanks

hi probably going to get grief for this but here goes.... i have 2 questions :) question 1 firstly is is possible to have a subform that you can use ctrl + mouse click to select multiple (non-continuous) records? question 2 for the lines selected in my subform i want to be able to delete...

hi i am trying to add selected list box items to a temp table (insert into) so on a button click i have... Dim tmpTbl As String Dim lbx_Sel As Long tmpTbl = Me.txt_tmpTbl.Value 'loops through ListBox to test if it is selected For lbx_Sel = 0 To Me.lst_select.ListCount - 1...

brilliant. it's working fine now. thanks.

ahh good spot it's still failing on the same line though. getting an : Expected end of statement error??

thanks for the reply... sql = "update CBF_master as a " & _ "inner join " & tmpTbl & " as b " & _ "on a.Year = b.dt_year " & _ "and a.Customer = b.Customer " & _ "and a.StockCode = b.StockCode " _ "set a.Jan_FVol = b.Jan_FC, " & _ "a.Feb_FVol =...

there is no duplication (i hope) i have a forecast table. i load a customers excel file into a temp table. then once the account manager has made any changes to the tmp table i want to update the forecast table with the temp table values where the year, customer, stockcode match. should the...

hi all i'm trying to update a table with the values from another table. In SQL it works as in my example but it doen't like this in access. it has to be in vba as the source table is dynamically created. sql = "update a " & _ "set a.Jan_FVol = b.Jan_FC, " & _ "a.Feb_FVol =...

Hi I'm getting an error : A new error has occured. Run-time error 3622 "You must use the dbSeeChanges option with OpenRecordset when accessing a SQL Server table that has an IDENTITY column." I've tried adding dbSeeChanges (in red below), but i then get an Invalid Argument Error. Can anyone...

thanks i've been tasked with creating an asset register of our it assets. i REEEAAALLY don't want to have to go round to all 250 pc's and manually get the hardware/software info. WMI. will check it out now.

hi is it possible to get information about pc's, servers etc on my network i.e. hardware, software, computer name etc. it's for an asset db and i really don;t want to have to go round to each machine and get the info. thanks

success... For Each ctl In Me.Controls Select Case ctl.ControlType Case acTextBox If Not Left(Me.Controls(ctl.Name).Value, 1) = " " Then If Left(ctl.Name, 7) = "SafeHaz" Then For i = i To 9 If...

' ************************************* ' ***** OPEN FORM ********************* ' ************************************* Private Sub Form_Open(Cancel As Integer) NexusDataB_bulk_Initialiser End Sub ' ************************************* ' ***** STORE NEXUS B INITIALISER ***** '...

actually i'll be setting the value of a checkbox, but it's the same principle. the checkboxes are called Me.chk_hzd_01 Me.chk_hzd_02 .... .... Me.chk_hzd_09 i want to say me.Controls("chk_hzd_0" & i).Value = -1 OR 0

its a sub in my form

yes i get this error object doesn't support this property or method.

hi instead of me.myTextbox1.value i want to reference the text box like this... i = 1 Me.Controls("myTextbox" & i).Value it's so i can assign values to specific text boxes. can it be done?? thanks.