Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. GinaStar

    Vista to Xp on a peer to peer network via a hub

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

    Vista to Xp on a peer to peer network via a hub

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

    Vista to Xp on a peer to peer network via a hub

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

    Access 03 double listbox and subform, suggestions please

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

    Access 03 double listbox and subform, suggestions please

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

    Append Query, show all dates in range even if no data exists

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

    Append Query, show all dates in range even if no data exists

    ...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&quot...
  8. GinaStar

    Append Query, show all dates in range even if no data exists

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

    Append Query, show all dates in range even if no data exists

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

    Append Query, show all dates in range even if no data exists

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

    Dsum not showing data if currency amount is a negative

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

    Dsum not showing data if currency amount is a negative

    ...tblConpay.guidDRID, tblDataDriver.strNAME, tblConpay.curHaul, tblConpay.guidPER, tblConpay.dblTicketQuan, tblConpay.curBroker, [dblTicketQuan]*[curHaul] AS gross, tblConpay.strDeductType, tblConpay.curDeductAmt, tblConpay.strDeductDesc FROM tblDataTruckInfo INNER JOIN (tblDataDriver INNER...
  13. GinaStar

    Last Updated Date Stamp

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

    generic Apply Filter code not working :/

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

    Crosstab - Grouping headers in Access 97

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

    append/delete query used to archive invoiced statements

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

    append/delete query used to archive invoiced statements

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

    setting default value based on values of two other fields

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

    setting default value based on values of two other fields

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

    append/delete query used to archive invoiced statements

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

Part and Inventory Search

Back
Top