Recent content by chazer1

Force mail merged dates to display as mmm-yyyy In the mailmerge document when I right click on the date field there are only the options toggle field/update field code. When I insert @\"mmm-yyyy" at end of the field code it prints this out on the merged documents. I thought I would have to...

When mail merging from an Access 2000 database into Word 2000 date fields are shown as dd/mm/yy in the merged documents. I would like them to display as mmm-yyyy in these merged word documents. The date field is set as medium format in the database table and displays as dd-mmm-yyyy How do I...

Auto Incrementing Numbers Thanks Pat.....this works just great. In access 2000 I just used the copy & paste functions, created a new table (structure only) and then used the paste table as/append data command. Now I have auto incrementing Membership Numbers! Many Thanks

Unable to convert discontinous number field to auto incrementing field Still unable to convert non sequential 'membership numbers' in a field in my 'club membership table' to auto incrementing and keep my pre-existing numbers in this field. I've tried creating a new table and appending my data...

Thanks for the VB script...but I'm unfamilliar with Visual Basic. When I look under the project explorer Microsoft access class objects there is an object called Form_add_a_new_member When I open this the following code appears: ------------------------------------- Private Sub...

In a pre-existing Access 2000 club membership database I have a column called 'membership_No' The pre-existing membership numbers are not all sequential (many numbers are missing) and the field is not auto incrementing. As there is already data in this field I can’t change it to be...

Many Thanks to you all Thank you so much..... I've got it working fine now.

Date Conversion continued... I'm using an update query and I have changed the "strdate" name to be the name of the column that has the dates set as yyyymmdd (in my table dateExpired) like below: cdate(right(dateExpired,2) & "/" & Mid(dateExpired,5,2) & "/" Left(dateExpired,4)) When I try to...

Still having problems with converting numbers to dates Every time I use this expression I get a message saying there is an error in the syntax. Where can I read about the Cdate funtions and what the code means? I'm no expert so it needs to be written for a non techie.

I am working with a SQL club membership database that was setup by someone else. When imported to my PC the date fields are set as text and displays numbers(yyyymmdd) instead of date fields. Membership is annual and determined by month joined and I need to be able to contact members due for...