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

    conflict designing Forms using both Acc2000 and Acc2002

    thank you for your help. Sorry for the delay (my son just graduated) i have all the latest service packs and updates. What i've done is re-create the queries and forms, this time being careful to compile when i worked in ACC2000. when i work in ACC2002, i first convert the database to ACC2002...
  2. isitrans

    conflict designing Forms using both Acc2000 and Acc2002

    Hi I compiled it in Access 2000 and it still fails on Acc2002. I tried converting it to ACC2002 and compiling and that fails. The weird thing is that each form opens fine separately, but when I combine them into one form with the second as the subform, that combined form crashes. Any other...
  3. isitrans

    conflict designing Forms using both Acc2000 and Acc2002

    Thank you. I will try compiling it. I tried on my Acc2002 computer and it wouldn't compile. I will try compile on the ACC2000 computer.
  4. isitrans

    conflict designing Forms using both Acc2000 and Acc2002

    Help. I'm updating a database created a few years ago in Access 2000. My new computer at work has Access 2002. I've also been working on it from home using Access 2000. Now there is one form that has a subform that crashes even just opening it but only in Access 2002. It works fine and the...
  5. isitrans

    outlook trouble but outlook express works fine

    we just upgraded our server at work to win 2003 server but are now using win 2003 server smtp pop3 to host our own email. (we had been using exchange server 5.5) some accounts seem to be having problems getting email in outlook. however, when we use outlook express with the same settings, it...
  6. isitrans

    large Quark Doc with large eps files prints gibberish

    Thanks BD but... we have tried just printing one page. the document is 100 pages with eps files in the text files. The eps files were created with Chinese text from our Chinese Quark so that our client can print from Quark. the printer just spews out pages and pages with one line of gibberish...
  7. isitrans

    large Quark Doc with large eps files prints gibberish

    Hello, we're trying to print a large (100pages) Mac Quark doc that contains lots of eps graphics to an HP 5000 with 88mb of memory. The printer starts spewing out pages and pages of gibberish which at which point we cancel the job. Any help or suggestions? Thanks, Cathi
  8. isitrans

    wireless access point to wireless access point?

    hello i have a linksys wireless g router at home. The signal is very weak in distant parts of the house. Is there some way to extend the range without using wires. (i'd rather not have to tear up walls or run cables.) What i'd like is to have some type of additional wireless router or access...
  9. isitrans

    sum of just some records in a query

    Thank you both for your help i wasn't available to work on it yesterday, but i will try your suggestions today and see what it happens. regards, cathi
  10. isitrans

    sum of just some records in a query

    hi i tried it but still got an #error the checkbox is a field from the query but prints on the report. could it be something with updating or might i have to name the [Estimates] more specifically\? thanks, i really appreciate all the time and thought you're giving me regards, cathi
  11. isitrans

    sum of just some records in a query

    HI paul no null values the table is set to use $0.00 as a default
  12. isitrans

    sum of just some records in a query

    HI Paul here it is (copied and pasted ) =DSum(" [Estimate]","ISIQRange"," [Approval signed?] = -1") This is the one with "" only for the query name I checked for typos but i think this is all correct. The query is named ISIQRange (copied and pasted)...
  13. isitrans

    sum of just some records in a query

    Thanks paul and michael paul: i tried "[ISIQRange]" with both the "[ and just the [ and just the " and none of these worked. gave me #error Michael: i tried Me.RecordsetClone but it didn't work. i'm not sure if i used it in the right context or with the proper punctuation...
  14. isitrans

    sum of just some records in a query

    Hi Paul thanks so much. changing to -1 worked. however, i still have a small problem. i'm using "[ISI Quotes Table]", as the source and that's returning a total for all the estimates in the table. i want to total only those estimates that correspond to whatever quote numbers that i've...
  15. isitrans

    sum of just some records in a query

    Help. I have a report created from a query that shows quotes for a range of quote numbers showing 5 fields: Quote # (this is an autogenerated number) Date Client Estimate (this is in currency) approval signed? (this is a check box for yes or no) In the header, i have a text box showing the...
  16. isitrans

    win 2000 pro setup failure ...help

    thanks to both of your for your help. i kept trying the recovery console, removing network cards, memory chips,and now it works. it may have been a conflict with my network card. i get to windows, i loaded the network card driver but i can't get on the internet. oh well, that seems like an easy...
  17. isitrans

    win 2000 pro setup failure ...help

    i tried upgrading my athlon 1200mghz, 13gb hd from windows me to win2000 professional. i selected the ntfs option. the computer gets to the window where it says "please wait, is setting up mice, keyboard,etc. The screen may flicker..." it gets about halfway, the screen flickers about 5...
  18. isitrans

    data in forms doesn't match data in table

    thanks for your help where do i find the forms recordset and where do i find the reports recordset regards, cathi
  19. isitrans

    data in forms doesn't match data in table

    Hi i'm very new to programming and access thanks for help i have a quotes table and (a child) job table, which relate on the quote # field. I have client table which relates to different fields on both quote and job table (for person who requested quote on quote table) and (client project...

Part and Inventory Search

Back
Top