Recent content by GinaStar

I've been doing more research and it looks like it will do what we need it to. Also, we have gotten it up and running thanks to a new computer tech guy we found. Our other computer guy, who originally built our old computers died of a heart attack about 3 weeks ago, that's why we've been so...

Upon further checking my computer, I need to make a change on the info...Our version is *NOT* Office XP - it is Office 2003! Grr...my computer is running Windows XP/Office 2003 and her new one is Windows Vista and it had Works on it. We've got to get Office for it. Sorry about that! Same...

We had an emergency yesterday, the office manager's computer crashed (and it is the one we do payroll on!) and we had to purchase her a new one. The only one we could find that met the specifications of what we needed was loaded with Vista. All the rest of our computers (3) currently run XP...

Thanks so much!! this gives me a direction to head in. Regina

Am just upgrading to Access 03 from Access 97 and still figuring out what it will do. Am not sure if this will work. Suggestions please? Here is what I want to do and how I am trying to do it. I thought possibly select case statements or the limit the values of a combo box or the double...

I got it working! using this: Set db = CurrentDb Set rs = db.OpenRecordset("tblPayAlias") With rs If Not (.EOF And .BOF) Then .MoveFirst Do While Not .EOF intAlias = 65 'ascii value of 'A' datTicketPost = !datTicketPost...

Duane, that is what I am currently using, but it only seems to work properly when I have only 1 week of payroll. If I have more than 1 week's worth of dates, it uses the same dates for each week instead of showing the proper dates. I have your unbound crosstab headers using column alias that I...

the pay dates are only fixed as to the range Saturday to Friday, not the particular dates. No, the driver does not get a check printed for the payperiod, but I do want it to show on the report as a zero value (for as long as that driver is employed, by which I check a datTerminated date field...

will try your suggestions. Yes, there may be weeks where all drivers off (ie: week of Christmas Holiday when we shut down completely), but we don't usually run a payroll report for that week. That applies to our company only, may not apply to other companies if I ever get this database to the...

Current query is based on a payroll table that has PayPeriod, Posted date, data. I need to show a value for PayPeriod/Posted date in a date range, even if no data exists for that date. This is used to set a column alias for an unbound crosstab report. Date range is always 7 days, running...

the reason that I'm having to check for nulls twice is because when a contractor has no values in that column (ie: health insurance)then just the nz was leaving a blank field. when I used the Iff(isnull()) then it was also leaving just a blank field for the empty columns on ones who had data...

Am trying to do a Payroll Year-To-Date report. The report is showing everything except the expenses properly. The expense column can be a positive or negative cash value. The negative cash value can be for assorted deductions such as drug testing, tires that they have charged, etc. The...

I wanted to do something similar in my database. I wanted it to update 'last active date' in several tables, but not if I was just looking at the records. I have several update queries that run in the background on the 'after update' but only when I key in a specific control. I can key new...

am trying to set up a 'generic' apply filter module. What I want it to do: look at the open form and get three values. The value I want filtered for, the box I want it to apply the filter to, and the type string (may be date, may be text). Using the 'tag' property of the txtbox I'm using for...

I have a crosstab query/report with dynamic headers that doesn't quite do what I want it to do. The report works great for showing *all* of the units for the county, but I want it to just show the units on each particular county. Have searched faqs and done search here and elswhere online. Any...