...minor glitches (the internal backup/restore won't work, but that can be easily handled by backing the database it creates up each time she uses it *outside* the program!) until she is ready to upgrade to Quickbooks 07. The only module of Quickbooks she uses is the accounting module anyway...
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...
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...
...As Byte
Dim datPayPeriod As Date
Dim datTicketPost As Date
Dim db As Database
Dim rs As Recordset
strSQL = "Delete * from tblPayAlias"
DoCmd.SetWarnings False
DoCmd.RunSQL strSQL
DoCmd.OpenQuery "qappColumnPay"...
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...
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...
thanks. I will look into that!
I've decided to go for a combination approach. I'm using the asterisk for the delete queries, since it doesn't matter about the primary keys (autonumber fields). I'm using all fields except the primary keys on the append queries and letting the program assign...
actually, yes, there is a reason that we are doing it this way. front end databases and back end databases. Boss was cheap and wouldn't let us network until recently, actually this past year (been using this database since 96/97). had to keep file sizes small enough to fit on diskettes before...
...of those methods and they still wouldn't update. I'm still trying though.
have also tried via vba:
dim lbrAmt as currency
lbrAmt = me!dblHours*Me!dblRate
me.curLaborAmt.value =lbrAmt
(pardon the punctuation on the curLaborAmt.value above, was doing from memory)
that didn't work either...
...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 override the default...
...the queries. and need some advice. will queries work better if put all the fields in (which is the way I previously had it) or if use the asterisk* field and the criteria fields (note: all the field names are the same from the two tables).
there are several queries involved:
one moves to...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.