anduril12
Last Activity: May 19 '10, 11:22 PM
Joined: Mar 29 '10
Location:
-
@NeoPa That makes a whole lot of sense! I'm glad that I understand how it really works now, I think that this will help me allot in my future usage. Thank you both so much, I was so completely stuck. -
@Jim Doherty
Thanks, that works perfectly! I sincerely appreciate your help, it wasn't exactly where I was going (I didn't even know that you could call up a single column) but it's great!
~andurilLeave a comment:
-
For Loop error
I'm trying to create an "For Each...Next" setup where I can go through every row on a table. I need to check a specific column, and depending on that value I have a count running. It seems to work but it keeps raising a "Error 424: Object required" box.
Any Ideas? Btw this code is being executed on a form that displays statistics.
...Code:For Each dr In Tables.FCG10.rows Select Case dr.[field] -
Merging Databases
I have two tables, "Table1" and "Table2" and I would like to merge them, unfortunately I can't create a primary key for Table2.
Now Table1 contains various sections of data "First Name", "Last Name","Addr" and "Phone", Table2 has the exact same columns as well.
What I would like to do is if a record on Table1 and and one on Table2 have the same "First... -
ADezii,
Thanks so much! It worked perfectly! great to have the help :)Leave a comment:
-
Apply Filter as Variable
Hello,
I'm very new to VBA programming, so this is my first attempt at creating a interactive (with forms) database. I have a database of a few thousand records, containing first name, last name, city, state, and phone numbers.
What I'd like to do is have the user enter the First Name into a text box and then the FIRSTNAME column is filtered by that value, thereby searching the database for all records with that first name....
No activity results to display
Leave a comment: