Search results for query: *

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

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

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

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

I'm trying to use Subform wizard to create a subform within a subform. The relationship between the two forms are one-to-many, and it is based on a two-field primary key (Info_num and offence_code). But when I cliked "finish", a window pops up saying "Subscript out of range&quot...

I'm trying to build a database of references. There are 5 tables: Article table: articleID articleTitle sourceID Author table: authorID firstName lastName ArticleAuthor table: articleID authorID Source table: sourceID sourceTitle SourceAuthor table: sourceID authorID There are many to many...