Data in a field in a table has some "excess" characters. The characters are not identical in each field but the "excess" characters are preceded by a pound sign. Can I ask Access to trim away all those unwanted characters after the pound sign? How?
I am not a code writer but I think there might...
Is it possible to link a table in Access to a table in Word so that when the table in Access is updated, the table in Word would automatically be updated too? I can't seem to establish a link between the Access table and the Word table and am wondering if this is possible at all.
I would like...
I am using Office 2000. In MS Word, Can I put graphics onto labels like the Avery products?
I tried searching the previous posts but came up with no results. Maybe my searching techniques are as needy as my labeling techniques.
Any help would be appreciated.
Thank you from snow covered Ohio...
My old computer HP Pavillion is about 7 years old. I believe that a Scandisk operation was interrupted by simply turning off the computer. Now the computer refuses to find the operating system ( WIn 95)
In the settings - there is no primary hard drive recognized. I can enter the setting for...
Hello,
A somewhat used but not old computer was given to me. It is running XP home edition. When I open google to do a search, the computer begins typing characters in the search criteria field. It types words like "They" "New", "You","a" without any input from the operator. I can simply select...
Recently my computer has been getting multiple copies of an email from a sender known to me whose email I actually do want to get.
I am using Outlook Express. About 2 weeks ago I set up a message rule to simply block all email from this sender. That of course, blocked everything from the...
dunnjt (TechnicalUser) Jul 29, 2004
For the last several weeks, this problem(rounding and too many decimal places) has taken a back seat to other items more pressing. However, now, I am still having the same problem with a rounding and decimal problem and am desperately looking for a...
Am using a subform based on a query based on a table. I have set the appropriate field properties in the table to Currency & 2 decimal places.
Here is the problem. When there is a decimal value (usually 2 places) in the Quantity field( E.g. 22.39) Multiplied by another decimal...
It's been a while since I tried emailing from Access. Is it still necessary to put a report in Word before it can be emailed? The report I want to email has horizontal and vertical lines on it separating columns and rows. Will RTF in Word process those lines correctly so that the emailed...
My brain must be becoming petrified from too much Access. I just can’t get my head around what should be an absolutely super-simple program.
A table called “Material” underlies the form where the user can enter/edit the materials and the quantity of each material used on a specific...
Can a fax be sent from Access without going through Word? I want to fax a permit application but when I send my report (The permit application) to Word to fax it, the document is displayed in a table showing all records instead of just the one record for the current permit application.
Can...
A client wants to finally get rid of the pencil and paper time card management process. I don't want to reinvent the wheel here. Can anyone point me to some basic Access, employee time card management software, preferably, freeware or shareware? No frills, no benefits management needed, just...
I wanted to upgrade the memory in my Gateway, Profile 2. The technicians where I took the computer did not know how to get the case open without possibly destroying the machine. I don't want the machine rendered inoperable but I would like to upgrqde memory. Does anyone have a clue how to get...
A friend recently bought a box of floppies but didn't notice that they were formatted for a Mac. He asked if these floppies could be used on a PC or did they have to be reformatted on a PC before they could be used on a PC?
So the question is this: is a Mac formatted floppy useable on a PC at...
A report called “Work Ticket” is based on a query which in turn is based on a table. There is a field in this report that displays the “Job Price”. This is the amount charged the customer. Everything is working just fine but I would like to print the Job Price on some, but not all of the Work...
Is there something I am missing? I want to create a simple Public folder in Outlook 2000. The Outlook program won't let me even "see" how to create such a folder. Any suggestions? Maybe there is another group to handle such requests. In any even. thank you.
Jerry d
I need to create a report with multiple page lengths for each record returned from a parameter query. Currently, the report prints a "Customer Copy" and a "File Copy". The contents of both pages is identical except for the phrases "customer copy" and "File...
My 3 year old computer is running Win ME. When I startup the computer everything is fine. However, the longer the machine is on, the slower the machine runs, the clock looses time (an hour or so overnight) mouse skippping is a serious problem. If I restart the machine, all is well, for a...
How can I email from Access, reports or forms that have both text (records) and scanned JPGs (the Form behind the text)? I can email the scanned form as a JPG but then can't include the records. I can create the form in Access instead of scanning it and include the record information but then...
Using the data type "number" in a field does not allow an entry such as 5/8, or 3/4. Since calculations must be performed on this field, the field must have "number" properties. How can I get Access to accept fractions in the conventional n/n format and still be able 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.