Search results

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...

: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 =...

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

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...

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...