Search results

Hi, Is it possible to generate a word document from access ?. If yes, then how can i do it ? Thanks for the help Joy

Hi, I created a relationship but i don't see an index. was wondering if the index is created internally and not displayed. i basically need an index on a column which is also a column for the relationship with another table, hence i don't want to create an index on the column if the database...

Hi, When i define a referential integrity between 2 tables, does the access database automatically create an index for the relationship ?. Thanks Joy

Thanks bob, will use it in the form then....Thanks

Thanks Bob, with the instructions i was able to capture the user id during the insert, need to know how can i use fOSUserName() in the default value for the field property, Thanks.

Hi, I need to capture the windows user name who modifies the data in the form/table, is there a function or command to capture it in access 2007 ? Thanks for the help Joy

Hi, I am writing ddl statement for creating tables in access, i would need to provide a default date for a date column, how can i do this in a ddl statement ? In the table design window in the gui, i can do it by providing the default as "=format(now())" but it seems not to work in the ddl...

Thanks Paul

but....how, can i do the export/import in access 2007?

Hi, If two developers are working on two seperate databases, is it possible to merge the work done in both database together, that i mean to say is, can we export the form/report/query from one database and import it in the other ? Thanks Joy

Thanks bob

Hi, I have a column called "lastModifiedDate" in a table, i would need the form to automatically capture the date and time when any of the data elements are modified in the form, also i don't want the user to modify this column in the form, is this possible ?. if yes, then how can i achieve this...