Search results

Thanks, John. That's kinda what I suspected, but I couldn't find anything in the Access Help. Wayne

I'm using MS Access 2003. I'm wondering whether Now() gets calculated once during a query or once for each record that it applies to. For example, consider the following query: INSERT INTO tblLiaEdiHeader ( CommunicationHeader, ImportDateTime ) SELECT DISTINCT...

I'm using MS Access 2003. Not sure if this is a dumb question, but ... When I save a query in MS Access 2003, it has the annoying habit of reformatting my query. For example, if I enter and save the following code in my query screen, SELECT DISTINCT a.CommunicationHeader AS...

I'm using Access 2003. Is there any way to define a table text column so that, if data is entered that does not fill all the allotted space, the table will automatically pad that field to the right with zeros? Or does that need to be done when the column is actually populated? Thanks. Wayne

Thanks, Ken. This sounds promising. I had no idea Access could do all this stuff. Can you provide any other details? Is this "endless loop" inside an Access function or macro? When the loop snags a job record that needs to execute, how does that execution happen? I've never used macros...

Thanks. I wasn't even aware of the Windows Task Scheduler. Looks handy. Now I know.

Hi, I'm using MS Access 2003. Not sure if I'm in the right forum, but I'd like to know whether it's possible to automate the daily load of a csv file into an Access table from a network folder, and perform other scheduled processing similar to what a stored procedure might do during a daily...

I'm using MS Access 2003. I have a textbox control txtAmountOutstanding whose Control Source is as follows: =[txtActualAmount]-[txtAmountSettled] (txtAmountSettled is itself calculated from data in a subform). I'd like to be able to programmatically insert a Settled Date into another field...

Thanks. This works, except that it initially always displays "1 of 1". (If I then click the Next button, it corrects itself.) The Form_Current event definitely needs this code, but I think I also need this code somewhere else after all the retrievals on the subform (and its subforms) have...

I didn't tell all of the story. The form I'm concerned about is actually a subform that displays only a single record at a time. So when the user sees the master alongside the child, it would be nice to inform the user the number of child records belonging to the displayed master record. Right...

I'm using MS Access 2003. Is it possible to move the navigation buttons from the standard position (bottom left of the form footer) to, say, the header? As a second question, is it possible to extract the information from the navigation buttons so that I can insert that data into a heading...

I'm using MS Access 2003. I have a tabular form that simply runs a query and displays data. Before the query fires, I want to display a parameter-collection form so the user can filter the results before they appear. The SQL would grab the parameters from the open parameter-collection form...

Looks like just what I need. Thanks!

I'm using MS Access 2003. I'd like to be able to search all non-table objects in a given MDB for a given text string. Is this possible? I want to know which MS Access objects contain the specified string. (I haven't seen anything in the menus that looks promising.) My intention is to...

If I chain the reports to open one-by-one by adding a single command to each report's Close event, I can get them all to open, in turn. As long as a report is open, does it retain its connections to the database engine? I would have thought that as soon as it dumps its data to the screen, it's...

There are no combo boxes or list boxes on the reports.

After adding my third report to the list of reports to open (in the function), I get the following error: Is Access keeping the Jet connections open after displaying each report? (The third report was the simplest report of all.) Any ideas on how to resolve this? Thanks. Wayne

Thanks, Bob! Just what I needed.

I'm using MS Access 2003. (Probably a dumb question ....) I'd like to open multiple reports simultaneously when I click on a given Switchboard item. (The reports are really a set--one should not be opened and printed without the others.) So what's the best way to do this? Do I run some...

Beautiful! Thanks, Bob. BTW, do you think the DoEvents command is necessary? (I've seen differing viewpoints on that.) Wayne