Hi, there's a Logo Mascot quiz making the email rounds that was slickly designed in Excel, and our boss challeged us to figure out how the author did it. The spreadsheet matches a typed entry to 5 columns of answers (five to cover all the possible spelling variations), if it is right it puts a...
Hi,
Looked at the doCmd.OpenReport in the one database, but up front they called a control for lstReport (the report box) and named a string CONACTION. I tried editing my button with the doCmd.Open Report arguments and it didn't recognize the keywords. I think I am missing a control on the...
Hi, this is a real beginner question...I know some SQL but not Visual Basic.
Have a form frmReport with listbox lstReport, tried adding command button with wizard to open report, how do I tell the command button to "open report selected in lstReport"? The other databases I'm trying to learn...
Hi, I tried searching for answers and these questions are probably way too basic:
1) Does it matter where on a report you put summary calculations, can the summary math be in the report header, or does it have to run "chronologically" after the data?
2) I have to edit someone else's...
Thanks Remou! you were right, the ones that were off were 3 decimal places in the original data and got rounded up by the time they made it to the report calc..such a basic thing to overlook (too many trees blocking my view of the forest!!).
Kerry
Hi, I inherited some customized access reports and one of the sub-sub reports is not doing the math right, I am stumped. The calculation is =[QuantityActual]*[Cost] and the formats for all 3 fields is Fixed, 2 decimal places. It came up with the following:
qty cost Calculation
.13...
Hi, very new at trying to use Access SQL, need to compare 2 tables of employees, say "Fac" and "Hr", where the Badge Number is the primary key, and look for mismatched pay rates, but only for the same 2 rows/records that are linked by key. This query showed the two tables linked at Badge Number...
Is there a way to print the list of installed programs you get from Add/Remove Programs (besides screen print to Paint), maybe get the same list via the Command Prompt? We're trying to do an inventory of what's on our 150 computers...Thanks!
Hi, hope I understand your question correctly, if UserA remote desktops into a win2003 server, they can use Start Menu-Control Panel-Mouse-Pointer and pull down the themes to find an extra large etc. cursor. Change screensaver timeout by Control Panel-Display-Screen Saver. I tried this on my...
Hi, I'm setting up a home network for training, installed one single server (80 GB HD 3 GB processor 512 MB RAM) and put win2003 standard edition on it. Right now it's networked with 4 computers together with a router to a broadband connection, with IP addresses assigned automatically. So far...
Hi,
We were thinking of adding another 4412LD+ console upstairs (at x130) then switching the Operator position between x100 and x130, depending on where I was working each day. Saw that the "CAS" operator is factory set to 768. How do I get in and change the "Dial 0...
Hi,
I've been recording our greetings for the Auto Attendant through a computer microphone as a wave file then uploading them in Messenging. The audio sounds good thru the computer speakers but when it is played thru the Merlin there's noise and distortion. The factory recorded Merlin...
Thanks all, I followed Franke's detailed instructions and it works like a champ now, for both the day and night services. I'm almost looking forward to Monday now - we'll see how many customers have the patience to use the directory and transfer to extensions, and how many will just punch 0 for...
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.