I am making a simple payroll program that keeps track of my hours, jobs, descriptions, etc. It also keeps track of the checks I've gotten. I have three main tables: Hours consisting of date, time started, ended, total hours, customer, job, description, Payperiod number, I know this one could be broken down more but that's not what I'm after right now. The other two are two are Checks and PayPeriod each with a matching index for joining. That part works fine. I'm using Flexgrids for my output. I would like to use a combo box so I can look at individual pay periods(1,2,3, Pay Period Index). After alot of frustration, I finally got what I thought would work but it now tells me Microsoft Jet Engine can't find table check spelling or existence done both don't know why anymore. Here's part of whats written the reason I didn't use * was because I didn't want to show period or index columns
If cboViews.Text = "By Period" Then If cboPeriod.Text <> "" Then QueryOne = " Select Hours.date,Hours.[time started],hours.[time ended],hours.[hours _ worked],hours.customer,hours.description From Hours where hours.period = '" & _ cboPeriod.Text & "' Order by hours.date desc, hours.[time started] asc" datHours.RecordSource = Chr(34) & QueryOne & Chr(34) datHours.Refresh flxHours.Refresh Else ErrMess = "Please select a period" MsgBox ErrMess End If End If
Please Help with as little laughter as possible I did not go to school for this nor am I it is for broadening my horizons and learning I've been reading books and trying to figure it out but as of yet I have not.