Search results for query: *

Friends, In a form's VB module I populate a list box on the form's open event, based on the ID sent to it in OpenArgs. At certain points in the code I test to see how many items there are in the box. The LstActivities.ListCount property returns the actual count + 1. The list box's RowSource...

Friends, My client's IS person installed a secured .mde file using administrator privileges, then, using a routine I built into the program, linked the tables file which he had placed on a network drive. The dynamic link worked just fine. When he logged off as admin, and had the workstation's...

Friends, From one database I need to scan the tables another to pick out a certain one and grab its name into a local variable. To do this, I create a workspace and open the database. When I've got what I want, I close the database and the workspace, and set the variables to nothing. Trouble...

Greetings, I made adjustments to the table relationships in the backend database and printed out the relationship diagram. Next day I opened the frontend and encountered a bug that I suspected was a result of one of my changes. I opened the backend and -- no trace of the work I had done the...

Hi friends, Can an Access 2003 mde file distributed with the runtime version (installed using SageKey's software) operate under Windows 2000 Pro? Or can it only run on XP Home and XP Pro? many thanks, p

Friends, Is it possible to decompile the VBA code behind a Word document? I tried the simple '/decompile' command switch but it did not work. many thanks, p

Friends, I run VBA code in macros behind form fields in a Word document. In general, this code updates values further down on the page. As an example, when the user clicks on a check mark, the tally field at the bottom of the row of checks is updated. Trouble is that the screen jumps and...

I have a Word document with fill-in forms for performance reviews. I would like to put explanatory material in a table that would be appended to the end of the doc. My idea is to have prompts be hyperlinks, then if a user wishes to know more about the material they're asked to provide, they...

Hi, I have a secured Access 2003 database and I'd like to use the Custom Startup Wizard from Visual Studio Tools to prepare the .mde file. The default 'admin' user does not have administration privileges, so the CSW is failing. I have tried inserting command line options to identify the...

Friends, I researched the question How can I run the Custom Startup Wizard (Visual Studio Tools) on a secure database, and the answer is 'join the workgroup of the secured database, then run the tool.' But I can't find the workgroup administration file. Did they rename it in Access 2003...

Friends, Has anyone a recommendation for a line numbering tool to be used with Access 2003? I have Visual Studio Tools (developer extensions). Is it in there somewhere? cheers, and thanks, p

Friends, I just had to re-install Office XP and since then I can access VBA help by highlighting a term and hitting F1, but when my cursor goes over the search box it turns into a horizontal line with arrows at each end. I tried re-installing the Help component from my CD, no change. What is...

Friends, I'm taking the plunge into the developer territory where I create not just an .mbe file, but a separately-executable runtime version of one of my databases, so that users do not have to have Access installed on their machines. My understanding is that to do this in the past one bought...

Friends, I'm getting a message that OWC10.DLL is missing from my references, when it's right there on the hard drive where it should be. When I use the browse button to re-identify it, it still reports itself as missing. No change in system set-up has occurred since I last worked on this...

Hi Friends, At what point are Access tables re-indexed? Are the indexes refreshed when they are updated, say, via SQL? I am curious about the health of my linked tables. many thanks, p

In my app I need to dynamically link tables depending upon initial user selection from a set of options. We've experienced a sudden, dramatic drop in performance in the link process. While following the code in debug mode today I waited 45 seconds just for this command to complete: If...

Friends, My code asks a combo box to dropdown on got focus. When the form opens (with the combo box as the first value getting the focus) the box's values appear above the control, like a list floating on the form. This throws the user off, as the insertion point is covered by the list. Any...

Friends, When my user double-clicks a file name in a list control, I create an instance of the appropriate application and open the file, based on the extension (.doc, .xls, .ppt). This works when I open Word and Excel, but when I try to open a Powerpoint presentation, I get the following run...

Hi friends, This is another in a long line of postings where we quit Access, but an instance remains active that can only be closed through the Task Manager. I've read through as many postings as I can find, implemented suggestions, and I have searched the MS Knowledge Base, but still this...

Most of the lines I draw on reports are straight along the vertical and horizontal axes. I create them by holding down the shift key when I draw them. At times a line control will get out of whack and appear slanted on the printed report. Is there a way to fix them (snap to grid?) so that...