Search results for query: *

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

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

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

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

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

I have a labor form that I key driver's labor into daily. I have several fields: dblHours, curRate, curLaborAmt. The default value for curLaborAmt should be curRate*dblHours. (not always though, sometimes labor is paid as straight cash, not paid via an hourly rate so have to be able to...

have two tables, a current table and an archive table. The current table is the tickets that have not been invoiced and the archive table is the tickets that have been invoiced. After invoicing, tickets are moved to an archive table and deleted from the current table. have been having...

Combo box is updating table properly when has new city to add on 'not in list' function. Problem is, when return to the box after the addition of the city, the rowsource is not showing the new entry (it's in the table, but the combo box does not show the new listing). I have no idea why the...

was using if/then behind a button to switch from a 'current' to an 'archived' table on a ticket search form. Has worked perfectly since 1997. All of a sudden, will not let me add the record sources upon reprogramming this year (I reprogram every December & upgrade). can email full code if...