Recent content by kuanli

FancyPrairie and SBendBuckeye, Thank you both very much! Opening the form in design mode worked!

Thank you so much! I've spent days on this and I was just about to give up. Thank you! However, I've got a new problem this time. The code ran through with no problem, but when I opened the form to check, my change to rowSource was not there! Did I not change it? Or did I not save the change...

Thanks for the reply. I want to modify the rowsource of a control in a form. I got something like this: Dim appAccess As Access.Application Dim strDB As String Dim strFormName As String ' Initialize string to database path. strDB = "c:\AA_xx\Workplan.mdb&quot...

Could someone please show me how I can modify the rowSource of a form in aother database using VB? I'm in desperate need. Thanks in advance.

I have the following VB code: Sub trial2() Dim appAccess As Access.Application Dim strDB As String Dim strFormName As String ' Initialize string to database path. strDB = "c:\AA_xx\Workplan.mdb" ' Initialize string to Form name. strFormName =...

Thanks for the reply, but I still don't know how to do it. I think I'm missing something very basic here. I can do this (DAO): Set dbs = OpenDatabase("s:\Workplan-final.mdb") dbs.TableDefs("Table1").Fields("Name").Name = "Lead" Or I can do this...

I need to modify the value list of a certain list box in some forms. I know how to do it for the currentProject. But I need to do the same modification for forms in about 30 different databases. How do I do that? Thanks in advance. Kuan

The design of the tables and forms are the same but they hold differrent data. Basically, there is one database for each employee.

The problem occurred after I changed all the field names of the underlying tables of the forms. I have about 30 databases. Each has a table and a form and they are identical. How can I use some kind of code to change all the form controls so that they are linked to the changed table fields? Any...

I have all the field names in the tables changed, but now all the forms are screwed up. "#name" is everywhere. I figured out that I need to change the control source to match the new names. But there are way too many to change by hand. Please, please help! My boss wants this ASAP!

Thanks a lot! It worked! Kuan

I have 30 databases, each having one table which are identical in design (They hold different data for different people). Now I need to change some field names for all tables in all databases. I wonder if there is a way to do it instead of typing the new names again and again. Thanks in...

Thanks Robert. This is exactly what I want.

Thanks for the reply. I'm afraid UNION won't solve my problem. UNION can get rid of duplicate records. But my records are not duplicates. They contain the same values for many fields except one or two. In addition, the tables are of different structures.

I have a database with 10 tables and I need to put them into one big table so that they can be exported to Excel as a spreadsheet. The problem is that when I use a query to do it, the number of records mushroomed. What I have is something like this: ID field1 field2 field3 1 A H...