Search results

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

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

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

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

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

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

Greetings. As a relative newcomer to Access, I am having trouble deciding on how to design the form flow for updating and creating related records. I'm looking for a variety of suggestions so that I can decide what's best for the user and what's best for screen flow. Here's the structure: I...