Search results for query: *

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

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

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

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

We just split our Access2002 database, and now have an .MDE file on the server. A few questions: (1) How do we change a Table's structure/property in the .MDE file? (2) How to maintain\update the .MDE file? I've kept a copy of the original .mdb file (before splitting) and have started to...

On a Main Form, which has several linked Subforms, I've created a ComboBox to search and display the selected record. I've been able to create this using the following code. PROBLEM: It will select the first record with the specific last name, but will not allow advancing to the next record...

I'm developing a MSAccess2000 database. I've created a subform, based on a query, and I'm trying to loop through one field in all the records on the subform. The subform is a 'continuous' form, which lists 1-10 records for each person on the main form. I've put the code in the OnCurrent and...