Recent content by 5tr0ud

Thanks. You refreshed my memory, and I did something similar to your code, but put it all on the subform. Thanks again.

Does anyone know the coding to use behind a toggle button on a Main form, in which the user can toggle between making the subform visible and unvisible? Thanks.

I put the new table in the back-end and closed the file. Then I went to the front-end .mdb and used Tools/DatabaseUtilities/LinkedTableManager . . . I could not see the new table listed, in order to link it. Perhaps I needed just to continue with this process, relinking all tables and complete...

I've imported a .txt file, creating a new table in the .mdb file of a split MSAccess database. How do I link this table (with the others) to the backend .mdb which contains only tables? Using Tools / Database Utilities / LinkedTableManager, I can see all the previously linked tables but not...

Dear PHV . . . I spoke too soon . . . and realized what you meant. My module had the same name as the subprocedure it contained. So I changed one of the names, compiled, re-ran the program, and SUCCESS. THANK YOU!!

Don't quite understand. My module is named RetentionUpdate. The code behind the button on the form is: Private Sub cmdRetentionUpdateModule_Click() RetentionUpdate End Sub Can you further explain? I also looked at one of your suggested links . . . FAQ222-2244 in the MSDN Library re...

I developed coding behind a button on a Subform. When clicked, it would update the Subform and the Main Form. But it would not let me save the change in the Main Form. So I put the code in a Module and slightly modified it. It compiles OK. What code do I use to CALL THE PROCEDURE when the...

I had to slightly modify your code -- (Me.[MyField]) and create another variable to pass in to field in the Main Form, but IT WORKED! I am truly appreciative, since it will be the basis of modifying the format of strings in the future. Again, THANK YOU!

I have a string [FirstSem] of "20041" (first semester of 2004) which I want to format to be more of a date field (8/2004). Likewise, "20042" I would like to format to 1/2005. Here's pseudocode that may explain what I'm trying to do. If (Mod(FirstSem, 10)=1, "8/" & Round([FirstSem]/10, If...

Here's something to try . . . At least one of your subforms in design view may have extended beyond the scope of the size of the page (when you open the Main Form). This will cause all subforms to adapt to the longest length.. . and affect where the tabs are, when you open the Main Form. Open...

I've had the same problem, with forms jumping vertically as I go from tab to tab. Look at the toolbars you have on each form. Go to View / Toolbars/ and you probably have Form View, and/or Formatting (FormsReports) clicked. If one subform has a different number of tool bars showing than...

I've created a subform-6 (read only) which summarizes 5 other subforms. This is what the users wanted. It's working very well, but one user now wants to add a field to this (read only) subform, in which she can indicate Yes / No. However, she cannot directly enter data in the field. I've...

Mike, I appreciate your suggestion and personal experience. What I did do is put a shortcut on everyone's desktop to the .mde file on the network. However, in the same folder is the back-end .mdb file, as well as the other .mdb file that contains the linked tables and other objects (forms...

In a module, I'm trying to loop through all the records in a table, and change the number fields with 0 to an empty string (""). In the loop, I get a run-time error about a data conversion error, in trying to convert a Number to a String. The run-time error occurs where the code is yellow...

Mike, thank you for your clear description. Your suggestion is the first option I wanted to try. However, we have many more forms and reports to develop, and would be daily copying the front-end to the users' PC (about 6-10 people). Do you still think this would be the best way to do it? We...