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