Search results for query: *

Hi All, I think this should be simple, maybe you can shed some light. I have a table of invoices where one of the fields is InvoiceDate. I would like a query that shows me which dates (say from the last 30 days) are not represented in that table. Example: I have invoices from 01/01/07...

Hi, Here's the problem: On Form 1, a user will enter a value into a field (Field: Status; Value=New). Later, on Form 2, another user will need to update the field (Field: Status; Value=Updated). How can I force the user to update this field? Is there a way to get Access to look at Field...

Hi all, Here is a segement of an SQL statement that I'm using as the CRITERIA in a query. The idea is to use "Date()-4" as the criteria in the query if the condition presented here is met. This condition is described in words as: If today is Monday, AND (the date three days ago was 01/01/06...

Hi All, Is there a way to copy text out of a datasheet where it can be pasted into another application as simple text? Maybe think of it this way: in Excel, you can copy a series of cells, then Paste Special and choose Values. essentially, this action strips away any of the fancy formatting...

Hi All, I've tried to find the answer with no luck: I have a datasheet form that displays data as any good spreadsheet would. I need to copy data from that datasheet form into another application. The other application is very old and isn't very sophisticated so when I paste my datasheet...

Hi, Is there a way to make sure that all the entries in a combo box's drop down list display in all capitals? The query that populates that list has entries in both ALL CAPS and Proper Capitalization. I'd just like them to all show the same way. The list is based on a query, and the...

Hi, Is it possible for a section footer to ALWAYS be found at the bottom of the page it's on instead of immediately after the preceding section? I suppose I could put the information in the Page Footer section, but then it shows up on the last page of the report, too (which I do not want). Is...

I have a table with information like this: Category CreditAmt DebitAmt Materials 30 0 Cleaning 50 0 Labor 20 0 Income 0 200 Materials 40 0 Labor 60 0 Using a normal...

I wonder if anyone has taken on this particular problem before: There is a particular contract I use in some of my business transactions. There are several blanks in the contract where I fill in appropriate information according to the transaction. I only have this contract in a .pdf format...

Hi: I have created a form with a combo box named Status. The RowSource is a table where each entry is numbered so that they show up in a particular order in the combo box drop-down menu: ORDER STATUS | 1 | Under Inspection | 2 | Offer Submitted | 3 | Under Contract | 4 |...

Hi, I have InDesign CS. Let's say I type the word "Adobe" into a text frame at 10 pt type, then click the Fit-Frame-To-Contents button. The frame will shrink to fit the word perfectly. Let's say next that I decide to increase the size from 10 pt to 14 pt. Now the contents are too big for...

Hey folks, I lurk around in some other design forums and in Howdesign.com I saw a really cool tip that I had to pass along to everyone here. By the way, I use Illustrator 9. As we all know, if you select two objects and click your align button, they will both jump from their spots and align...

Hi everyone, In one of my forms (it's actually a subform) I use a "Delete" button to delete a record. It has a "delete record" macro in the OnClick event. Seemingly out of the blue, this button began to act up. When I click it, I get the usual warning that Access is about to delete 1 record...

Hello Everyone, I am about to send my first major print job to the printer, and I wanted to ask a question to two so that I can reduce the amout of, uh, learning I'll have to do after I send it off. My document was created in Indesign CS, but it contains Photoshop files and Illustrator files...

Hello everyone, A quick question for CS on XP: Adobe has done a tremendous job of keeping the keyboard shortcuts and mouse/keyboard combinations pretty consistent throughout it's applications. However, for those rare cases when the mouse/keyboard combinations aren't consistent is there a...

Hi everyone, Yesterday I opened a .rtf attachement that was sent to my hotmail account by a friend. It opened in MS Word, I made some changes and saved often. When I went to open the file today, Word cannot find my file. Apparently I was saving it to a subfolder under Content.IE5 (one of the...

Hello everyone, It is common knowledge that there are several ways of accomplishing one task using Photoshop. Are there any suggestions about how to choose the best method? An example: An associate and I were asked to take a color photograph and give it an overall brown tint--like a duotone...

Hi everyone, I just got an error message when I tried to save my Illustrator artwork. The message said that "Protected fonts cannot be embedded." This is the first time I've seen this message. It leads me to two questions: first, what are the legal obligations associated with...

Hello, A page on our (Golive) website at work displays information from a Microsoft Access database. The content of the webpages themselves (layout, links, images, tables, text, etc) don't change. The only thing that changes is the information displayed from the database. This changes when...

I have a simple question about some artwork I printed out earlier today. My artword contains a .tiff at high resolution, a gradient, and some black text among other things. I printed it out on a Xerox laser printer (I don't recall which model). When I looked at the printout up close, I...