Search results

Ok I am exporting some data to a plain text file and one of the fields I am outputing can vary in the number of characters and I need they to have the same number of characters all the time. Ex: 123.00 => 000012300 456789.00 => 045678900 I had heard of a command, but I can't...

Ok Guys, I have researched this for the last few hours and am at a stand still..... I have some queries and queries of queries etc. that need to be processed via an append query to a new table. Some of these queries require parameters to be passed to them. I have the following code and can't...

Ok, I have spent a bit of time researching this to only find information pertaining to database driven list boxs. Here is the situation: I have 2 list box's on a form 1 contains table columns (brought in by another list box/command button - Done with VBA, also the list box is set to Value...

Ok I have a form with the following fields: cboDesc1 = Combo Box (Contains 3 columns to be referenced : 1 Visible and 2 hidden) txtMemo1 = Text Field cboDesc2 = Combo Box (Contains 3 columns to be referenced : 1 Visible and 2 hidden) txtMemo2 = Text Field cboDesc3 = Combo Box (Contains 3...

Ok I have the following code which keeps producing an Error # 9 : subscript out of range..... Public Sub SaveLineItems() On Error GoTo SaveLineItem_Error MsgBox "I am doing the line items" Dim sSQL As String Dim iLine As Integer Dim iMaxLines As Integer Dim iMonthCount As Integer Dim...

Ok this is driving me batty I have the following Form_Load(): Private Sub Form_Load() On Error GoTo LoadError DoCmd.Maximize LoadError: MsgBox "Error : " & Err.Number & vbCrLf & Err.Description End Sub and I keep getting Error : 0 Yet I can't find anything refering to an error # 0...