Search results

I guess then if I want to use the acDialog to pause the start form I have to make a form out of all the options?

Thanks Kiwiman, I will give this a try.

I am trying to open a view of some linked Excel spreadsheets with an option box using the select case statement. When I try to use the below code for the case statement I get the error "Wrong number of arguments or invalid property assignment." on the the docmd.OpenForm code. This code works...

Thanks Paul, it does the job for me.

It works fine for me on a button but when I use this code on an unbound textbox called CountRecords and open the form there the textbox is blank. I have attached the images in Design view and Form View. The table has 326 records posted to it at this point. Private Sub...

Thanks Paul that worked well. Can you tell how I can put this result in a text box? I tried me.textbox.value = Table_RecorcdCount("CompletedMonthlyTransactions") in the before update event and it didn't return anything.

Sub command42_click() msgbox Table_RecordCount "CompletedMonthlyTransaction" 'MsgBox Table_RecordCount "TableName" End Sub

Thanks Paul, This gives me a Syntax error

One of the things I tried was caused a variable not defined. Private Sub Command42_Click() Dim rs As DAO.Recordset Set rs = CompletedMonthlyTransaction Table_RecordCount End Sub

I would like to get two table record count results to two unbound textboxes on a form. My need is to compare record counts on two tables to make sure they are the same before proceeding with a month end process. I have located a function through this site that is suppose to return a record...

I have severl queries based on a linked Excel files that when all the information is present the user is able to run the query from a control on the form. The query appends this data to a history table. These queries have multiple lines and one of the fields have numbers from 0 (incomplete) to...

Thanks Paul, I will do that.

I had this working fine until I had to add another column of data to the spreadsheet. Now I get and error 3265 Itme not found in this collection. When I click OK I get Error 424 Object required. It seems to die at the End With statement. This particular query only has two lines of data and they...

Thanks Bob, That did the trick.

I have a form based on a query of a table. The first textbox 1 is a general ledger expense description and textbox 2 is the actual general ledger account number. I changed the first text box to a combobox with a rowsource of a Chart of Accounts table (unrelated to the form query) with two...

I have linked some XL workbooks to my database. There is an amount column that is formated as Currency in Excel but when I look at the structure of the linked file that column comes accross as Text. My history tables all have that as fields property as Currency. When I try to append data to one...

Thanks for responding Bob. I tried that and it didn't seem to work either so I went back to the spreadsheet I was appending to and found when I removed this WorkbookOpen() code it worked fine. I believe now my issue is with Excel not Access. Sub FormatBisconer() Sheets(1).Select 'Create...

With the help of this site I developed this code to append a query to an existing spreadsheet. The problem I am having is Row 1:1 is a label row in the Excel spreadsheet so I need this data to start a Row 2:2. I tried changing to .Range("A" & i + 1).Value after the i but that didn't do the...

thanks for looking at my problem. The linked table property for that field is numeric Double. When opened the fields not already populated are #NUM. This is the same with the Queries. The fields are generated in Excel with a lookup to a table that forces unfound lookup to "". This is the...

I have a queries built on a linked Excel file. The Excel file has a vlookup field that is forced to "" if there is an error. In the linked files, in Access, these numbers show up as #NUM and I believe are creating me grief when trying to export the queries back to Excel. I get an error 3349...