Search results for query: *

Hi Everyone, Idea: i'd like to add a memo field to an existing table using a macro (or VBA code). i'd like to be able to select which table i want to add the field to. the reason for all of this is that eventually i want to automate: 1) pulling data from a linked table 2) query/combining it...

Hi Everyone, Idea: i'd like to add a memo field to an existing table using a macro (or VBA code). i'd like to be able to select which table i want to add the field to. the reason for all of this is that eventually i want to automate: 1) pulling data from a linked table 2) query/combining it...

Hi Everyone, Idea: i'd like to add a memo field to an existing table using a macro (or VBA code). i'd like to be able to select which table i want to add the field to. the reason for all of this is that eventually i want to automate: 1) pulling data from a linked table 2) query/combining it...

Hi Guys, i'm an access newbie. I imported a table into access and one of the fields has some leading spaces. how do i trim them? i've tried doing it with a query and setting the putting Fieldname: trim([field_name]) into the field box of the query, but it keeps giving me compile errors...

Followups: Im using Access2k, so how to i set a reference to DAO3.6 ? how do i turn on group mode? Unrelated: is there an easy way to trim a column of data in access? i know it's pretty simple in excel, but im new to access so i cant figure it out.

Hi, Here's something that i've been working on for a while, and that i might know how to do in ASP, but in Access it's stumping me. I'm trying to link up a part number prefix and part code database. they are heirarchical, so there are many Part Num Prefixes for each code, etc example...