Recent content by cstickman

Thanks Minty and ridders!! It worked like a charm!!

Hi Minty, I have no idea what you mean. Do you have any example? Also, it is an unbound form if that helps.

Hello fellow Access users, I have a listbox with 2 columns that populates from a query depending on a drop down that the user selects. I need to capture all the results from the list box which can range from 1 to 100. I thought I had an idea on how to do it, but it does not work. Below is what...

Thanks!! That worked perfectly.

So I came across a new error while using the query in a liat box. Run-time error 424, Object required. Here is the code: Dim dbs as DAO.Database Dim rst as DAO.Recordset Set dbs = CurrentDb () Set rst = dbs.OpenRecordset ("qrymastercalls", dbOpenDynaset) Me.lstfd.ColumnCount = 7...

That was it!! One was a short text and the other a number. I changed them both to number and it worked. Thanks!!

Ok, here is what I have: Query 1 - labeled (qryareacode) Select tbltempaccountnotes F4, Left([F5],3) AS AreaCode From tbltempaccountnotes Where tbltempaccountnotes.F4 Like "" & "Call")) Query - labeled (Query1) Select tblareacodes.AreaCode, qryareacode.AreaCode From tblareacodes INNER JOIN...

How do I go about doing that sub-query?

Hi Everyone, I am trying to get a DLookup to work in a query. I have the following: Expr1:Left([Phone],3) The first part takes the 11 string phone column and gets just the area code. Then I have an area code table and I want to associate the state with the area code. So here is what I...

I am back and tried the WHERE clause, but am getting a run time error 425 - object required. I did the WHERE clause as a function as I thought that would be the best to cycle through the txt fields. Function code which is saved as globals Function BuildWhereClause() As String...

Ha, well look at that it worked. I did not even think about that, but it was a learning experience. Thank you very much as always!! The next step will be to add the customer name with the WHERE Clause. I am going to try and play with it first before reaching out for help.

This is what I have that is producing 1, 1, 1, 1, and 1 Option Compare Database Const MaxAcctCount = 5 Const AcctTextBoxPrefix = "tctacctnum" Private Sub cmdadd_Click() Dim RS As DAO.Recordset, SQL As String Dim I As Integer For I = 1 to MaxAcctCount SQL = *SELECT acctnumber FROM tbltest...

Unfortunately no, my work has strict policies on our machines that block a lot of stuff. I could do it at home, but I only have Access 2007 and I am not sure it would work at all on 2007.

Yes, it just displays 1 in all the text boxes and does not do the 1, 2, 3, 4 and 5.

pbaldy Thanks for responding. I tried the RS.MoveNext and same results. You also mentioned you would not populate this way. What would be a more efficient way to populate the text boxes?