Search results for query: *

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

Hi Linda, Thank you very much. You have made my day! Kuan

I've got one record in my table that displays "#delete" for all fields. I cannot remove this record. Each time I try to delete it, it behaves as if it is deleted. But when I open the table again, the record is still there! And the weirdest thing is that the correct value of each...

Hi JerryDennison, I got it! All I had to do was to delete all the records and subforms and start from fresh. Thank you very much! I'm so happy that I don't need to carry this problem into the weekend. Have a nice weekend! Kuan

I got a new problem (or the old problem in a new form) this time. I created an autonumber primary key in the master table, linked it to a long integer field in the child table. The one-to-many table relationship seemed fine. I again created the subform using subform wizard. When I try to enter...

Thanks a lot for the response. Now I know what the problem is. But how do I link a subform using an autonumber? The form is used for data entry. Does it mean that the person has to first find out what autonumber is created in the master table and then type it into the subform? Kuan