Search results

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

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

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

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

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

I am building a "rolling slideshow" to be displayed on a big screen television. The show includes a number of graphs, freshened systemically at a timed interval and exported as GIF's. The GIFs are displayed via an unbound graphic object on the "stage" form, fed by a table of records containing...

My application sends "Route For Review" emails using the SendObject command in a macro. The macro works just fine, and the SendObject works as expected, except... for the text plugged into the body of the email, which is fed from an UNBOUND field in the database: Message: ="Rationale: "&...

Didn't see this one when I browsed the existing threads... Is there a way to include animated GIF files in an MS-Access form? I've used tons of static images on forms in the past, but never tried an animated image until now. Hopefully it's obvious and I am just having a mental moment! Many...

I have an application that works with our SQL-based collections package. In the SQL tables is a personal history table for each individual user that logs each account looked up w/date and time, etc. In my Access app, I want each user to be linked to his own personal table so that the app can...

I am working on a graph on a form that requires 10 plot points (Bar Graph). This morning I was surprised to learn that MS-Graph has a limit of six plot points????? Sheesh! Am I missing something, or is this limitation for real? Any suggestions on how to get around such a limit? Thanks, shuff

I have a macro that fires from the OnActivate property of a form. The first line "initializes" a checkbox by doing a SetValue=0 before making a series of tests to turn it back on if applicable. I should add that the checkbox is unbound - it's simply used for decisioning on the form while it's...

I have two problems in one query. I've been working on this one for a couple of days now, so I'm ready to say UNCLE! I am writing an update query where the update is conditional on a calculated field - if Unused Credit ([AT03]) is at least 80% of Total Credit ([AT01]), then update field XYZ...

Sometimes it's the pebbles that trip you up... I have criteria in a query that references two dates (text fields) supplied by a form. The criteria is "Between [DateBegin] and [DateEnd]. Now, if the user supplies values for each of these, everything works great. However, what I want is for the...

I'M stumped... I am using a SetValue statement in an macro to take three concatenated unbound values and poke them into a memo field (Bound) on another form. So that the (memo) field will be ready for the next entry on a fresh line, my macro also does a SendKeys {ENTER} following the SetValue...

Sheesh! This seems like a simple question, but I don't know the answer. If I have a pair of fields, such as Score and ScoreDate, and some records have no score but DO have a score date because of a previous global modify, how do I globally modify these records to blank out the date when the...

Through my macros, I am passing via Echo Statements, helpful info to let the user know where s/he is in the series of tasks in the macro. I don't seem to have control, however. For example, it will hit the Echo statement, begin the query following it, but the status bar will not reflect the...