Search results

Thank you sir - I will check these out. SLH

I don't see this one already posted, so heeeere we go. I want to be able to link external tables programmatically by using a macro to do the linking. The macro would be fed table names and I want it to make the links, looping back to repeat until it runs out of values/table names. My specific...

Mike and Bob, THANK you for your replies. I will try these when I am in the office tomorrow. I appreciate your replies! SLH

Hello, all, I built a form yesterday that has extended text, and within one of those paragraphs, a piece of inline data. The GOOD news is the data is inserting just fine; the BAD news is that although the data is declared currency from the source field, this inline version inisists on showing a...

Stacey, Let me make sure I understand what you're asking before I write up a storm for the wrong thing! If I understand you correctly, you have a form displaying a record that has associated attachment(s). When that form is displayed, you want the user to see a list of attached documents and...

If you're opening the form with a macro, use the Data Mode argument within the OpenForm action. Set it to "Add" and the form will always open in Add A Record mode. If you sometimes want to use the same form for reviewing existing records, then use a different macro and set the same setting to...

Hi, Chris, The scope of a "maximize" selection is global, meaning that all forms and windows will open maximized, not just the one you meant to maximize. If you want one form to appear full-screen and others not, I would size them in design view as you want them to be, then set the Border Style...

Hi, Bob, Heh heh... No, I haven't gone missing, just travelling on business for a couple of days and focused in other directions. The applet is awesome! I love that it renders dates far beyond the year 2010 shown in the .pdf file. I am also really looking forward to walking around in your...

Re:Looking for Specific Table of Data Thanks for the suggestion - I was so busy trying to export .pdf to .xls I never thought about going the text route! Unfortunately, when I tried that, the only column that comes over as readable is the descriptions of the Sundays. All the data columns with...

Thanks for the suggestion - I was so busy trying to export .pdf to .xls I never thought about going the text route! Unfortunately, when I tried that, the only column that comes over as readable is the descriptions of the Sundays. All the data columns with the dates come over as various ASCII...

Hello all, Does anyone have, or can anyone point me to, tabled data of the Roman Catholic liturgical calendar for Cycles A, B, and C? I found the table online in .pdf format, but I haven't been successful in getting that into an Excel spreadsheet. I am attaching the .pdf table here - if I could...

Following the recent changes here in the U.S. for Daylight Savings Time, I patched WinXP as well as all my Outlook installations. The problem is with Outlook; my OUTBOUND date/time stamps are accurate as is my WinXP time, however my INBOUND messages are date/time stamped by +1 hour from actual...

Yes, it is the standard date/time date plus hh:mm:ss:hh SLH

I have a simple, simple query based on a linked SQL table with a date/time field called "CHANGEDT." All I want to do - as I have done many times before - is to set criteria for that field of Date()-10 (records changed 10 days ago). Every time I get an empty data set, even though I know there are...

I want to execute a delete query on a table of account records. The query contains two tables linked on account number, one with a list of unique records, linked to the other with "many" records to be deleted. For each unique record from table A, I want the delete query to delete all records...

Response to: SendObject Action in Macro Adam, Precede your relative pointer on the TO: line with an equal sign, like this: =[Forms]![frmProposeMgr]![CollectorMail] That will cause the SendObject statement to EVALUATE the pointer, not take it literally as being an email address. By the way...

Response to: GoToControl If I understand your description, you want to click on that button and then, be in a data entry/add a record mode. I think I would elect to let that button and it's associated macro close the form, then reopen it in "Add Record" data mode. Set your macro something like...

Gosh, it's always the simple stuff that seems to trip me up!!! I am writing a macro that needs to start up Snapfile viewer, then based on the login credentials of the user, open a specific .snp file. The file to be opened is determined by a text field in the credentials table that names the...

OK... what am I forgetting? I have a linked SQL table with a Date/Time field called DATE. ALL I WANT TO DO is pluck all the records with a single date from that table. Predictibly, the date field has values like this: 9/11/2006 12:40:46 PM If in the MS-Access query I use criteria of...

Here's a real stumper... I have a form with a subform based on the account number in the main form. This form has been running without a hitch for maybe two years! Now, while updating an unrelated form in the same database, I test the new additions. I get an error message that the main form...