Search results

Thanks Wayne, But now when I run it I get a pop box asking for the parameter value. Should I set the parameter value(forms!frmMain.cboticketnum) to variable and set the variable value each time I run it? Jim

Hello, I'm trying to change the row source of a listbox using VBA. My listbox is set to show column heads and multi select is set to none. I copied my sql( actually two of them, one for each of the info I want to show) from a query that returns the proper info but when I set the row source in...

Hi, I read the FAQ but still can't get it. I keep getting an Access error "Access can't find frmMain". Here's my set up. I have a main form (frmMain). On that I put a tab control(tabctl59). On the second tab I dragged a form(frmRef2) that I created by itself. On frmRef2 I placed a...

Thanks for the reply. I tried using a different name, Holder as date, but it didn't work. I'm going thru the forms looking for a field named date. When I tried using Now it worked fine. There must be something called date in there somewhere. Jim

:confused: Hello, I'm receiving error 438 "Does not support this property or method when I try to set my Today variable = Date(). Here's my sub Public Sub GetDaysWorking(StartDate As Date, TermDate As Date) Dim Start As Date Dim Term As Date Dim DaysWorking As Integer Dim Today As Date Today =...

Thanks, excellent help. :)

Wayne, I removed the space between the single quote and the double quotes after the select and before the variable and it seems to be working fine. That only took me about 3 hours. :) :)

Hi Wayne, no I'm not using a mask. But, here's what I found. I'm using this code to write to my table. CurrentDb.Execute ("INSERT INTO tblIndex(ticketNum, IndexNumber)" & _ "select ' " & ThisMemberTicketNum & " ', " & NextIndexNum & " ") There is a leading empty space when the code...

Hello, When I type in criteria into the criteria field in the QBE the query doesn't return any data. Here's my set up. I have one(1) record in the table tblIndex field 1 = pk field 2= TicketNum.......... = A220074 field 3= IndexNumber....... = 2 In my query I selected TicketNum and IndexNumber...

Hi, is there a way to jump to a function or procedure when I'm working in the VBA editor window? Thanks

Thanks, I'll try it. Ilike the idea for the archive table, didn't think of that.

Hello, I'm creating(attempting to create) an access db to track members that receive referrals for jobs. I can't nail down the table relationships. I have my Employee info table with all the member info. The way it goes is this: Members Sign every Monday(they write down their Ticket Number and...

I use bound controls whenever I can. However, in this instance it wasn't an option so I decided to use this work around. I placed this code in my control's On_Exit event. Dim Oldvalue As Variant Dim Newvalue As Variant Dim Holder As Integer Holder = Nz(Me.txtEmpID_SI, 0) Oldvalue =...

Hi, I'm using an unbound textbox(txtPhone1) to show data(Phone1) on my main form. I populated txtPhone1 using this Me.txtPhone1_SI = Me.cboLastname_SI.Column(4). Me.cboLastName_SI is a combo box that is based on a query that I use to fill all the data on my main form. My main form doesn't have...