Search results for query: *

Thanks PHV for your response. I know an outer join can return values from non-matching records, but i will prefer to be alerted to ensure Product data is updated when required. Regards

I create a monthly report from two tables (product data and mortgages) using an inner join query on product type column. Product data table contains static data whilst mortgages contain transactional data. There are instances where new product types have been created during the month and...

Can anyone please tell me how to insert the current month in a column of an Access table created using a macro.

While importing a csv file into MS Access 2003 to create a table, property not found error message came up. Can anyone urgently help to resolve this error? Thanks.

Hi Randy, thanks for your suggestion, we have tried the option of copy and paste into a new spreadsheet, the code is always copied along. Regards

can anyone please advice how i can remove/delete VBA code from Excel worksheet. The codes are no longer needed and i do not have the password to edit the codes

thanks everyone for your insighful and invaluable contribution.

I have a MS Excel dataset and of one of the columns contain both number and text data types. Is there a MS Access data type that accepts number and text formats as i will like to create database table using the excel dataset? Please note that MS Access version is Access 97.