Search results

Thanks, once again. It worked with a little modification ... 1. Had to delete the text box and replace it with a label because it became an unbound field and I got some errors during run time attempting to set a value to the textbox. Then I tried to set the value to the ControlSource of the...

Thank you. That worked just fine. Two points, though ... 1. When I typed in =Format(Now(),"mmmm d, yyyy hh:nn:ss") Access changed it to =Format(Now(),"mmmm d"", ""yyyy hh:nn:ss") I ran the report, anyway, and it work just fine ... sort of ... 2. The time stamp changes for each printed page...

Greetings. I have a report (actually all of my reports in an MDB) that I want to date/time stamp at the bottom. Previously, I had used the builtin function of Now(). I thought that would give me a date and time value in the format: "month day, year hour:minutes:seconds". However, I noticed...

I have been working on an Access Db for awhile and am very close to being ready to hand it over to the person who requested it. There will be one user and the db will reside on a desktop PC. Here's my dillemma? How do I insure that the user will not have access to the tables? I'd hate for...

Rich, Thanks for the suggestion. About the duplicate post ... my apologies. The system went weird here at work and I wasn't sure if it got posted. I'll see if I can delete it (don't know how...but I'll search around for a delete option somewhere). Thanks, again. SueB

Hi. I want to execute a routine, at database startup time, to relink the backend tables. I have the code for the function, but I don't know where to invoke it. I tried putting a call to the function in the Open Event of the MainMenu (which gets displayed at Startup). That seems to be too late...

Thank you for the correction. SueB

I am trying to conditionally select information from a table to create input for a Merge-Mail document. The output is an award certificate. Sometimes I want to insert some text at a specific location and sometimes I want to insert nothing, depending on a variable/field selected from another...

Hey, Guessing Mac... Good try. The Repaint method (or this an action?) does not apply to the combox control. It does apply to the form, though. However, it didn't work. The form remained invisible. Boy ... I'm stumped. Thanks, anyway. SueB

Greetings. I have three forms that are open at the same time. They are related and cascading. The first form (frmEventAdd) is the anchor. Each event can have many Trials. The second form is frmTrialInfo. Each Trial can have three Classes. The third form is frmClassInfo. These forms are...

Greetings. I'm having trouble wrapping my head around this one. The database is for a Dog Competition Organization. The basic structure of the data is: Dogs compete in a Class. Dogs get a Score for entry in a Class. If the Score is above a certain threshold the score is designated as...

Thanks for the suggestion, Exodus. I think I need to find out why when I create a new custom menu bar the default menu bar is altered, as well. Thanks. SueB

quest4 : Thanks for the suggestion. Can you believe that the 'powers that be' here at work have disabled the online help facility for all Office products. They say that there is a security risk in going out to the internet. It's infuriating. I'll check Access Help when I get home (I have...

Greetings. I am pulling my hair out trying to create a customized menu bar. Eventually, I want to have a customized menu bar and tool bar for report and different customized menu bar and tool bar for forms. I created the tool bar for the report window. Then when I tried to create a new...

Correction to Original Post - Report Footer Greetings. I have a report based on the following query (hang in there ... it's quite long): SELECT Year([tblEvents].[eventstartdt]) AS Yr, tblEvents.eventID, tblEvents.eventname, tblEvents.eventhost, tblEvents.eventcity, tblEvents.eventstate...

Greetings. I have a report based on the following query (hang in there ... it's quite long): SELECT Year([tblEvents].[eventstartdt]) AS Yr, tblEvents.eventID, tblEvents.eventname, tblEvents.eventhost, tblEvents.eventcity, tblEvents.eventstate, tblEvents.eventstartdt, tblEvents.eventenddt...

Any idea why a combobox would not populate? :confused: When the form is opened, it is opened with DOCMD.OPENFORM with selection criteria to send only those records for a particular dog (dogregnbr). The query for the rowsource of the combobox works when run from the query design window...

Greetings. :) I am trying to position opened forms so that they are cascaded on the screen. I have discovered the movesize action (for the DoCmd) and Move property of a form (for Acc 2002/2003). However, if the application is opened up on different monitors (e.g.; 17" or 19"), the relative...

SJ- Thank you for the reality check. I definitely did not remember that this is an International forum. SueB

Did I make some sort of "faux pax" by posting this question to this list? I was wondering because no one is answering my post. I really thought that I would get all sorts of replies. Seriously, if this is in the wrong list, please let me know, because I don't want to get on anyone's bad...