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

Brilliant! I wasn't famliar enough with the form's BeforeUpdate property to know that was the right event. Can I also prevent the user from proceeding to the next field? Thanks, RJ

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

Cool guys, thanks. It works! --RJ

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

Papyrus, besides being ugly, is so overdone. I see it everywhere. Every italian-restaurant menu, community flyer, international product, local-TV programming ad... they're all done in papyrus. Look around and you'll see it at least once a week.

What in the world would you ever want to use comic sans for? That's like the ugliest font in the world... besides Papyrus.

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

All I can say, guys, is that you're amazing. It worked perfectly. I created the tblMultipliers as suggested by BobStubbs and added it to the query as suggested by dhookom. I should mention that in the tblMultipliers I had to specify 1 for the Scale so that the value could accept a decimal...

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

thank you all for your help. i guess i was just dense. i thought i had tried every combination of ColumnCount, ColumnWidths, and Bound Column values possible without results. It just took a little more tinkering to get them all straight. I had been confused with 0" Column Widths, Column(0)...

thanks for your responses i will try it and check back in. --rj

EDIT: in the last paragraph above instead of reading 'it just says "3" ' it should read "just says "2" ' no problems with columns not corresponding to one another.

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

I thought it was Shift + Click. --rj