Recent content by ianforest

Hi there, I have added a "record notes" table to my access application. Basically, when someone clicks on the "add note" button on the main form, a form will open allowing them to add notes for that particular record. I've done the table, the relationship, and the form, however I need to...

Well the bookmarks are working great... however... Can I format the bookmarks? For example, i'm passing a couple of time fields, dates and currency and would like some control of how they appear in Word, but alas they just appear in a format I don't really like. Can you control their appearance?

I'm planning on making a change to my database by adding a form which allows me to do the following... On the form itself I would like a combo box or a list view (preferably) which shows 2 columns, contract ID's and Client Names which are stored in a table. When a particular record is selected...

Good guess Miss Marple! And your suggested change worked an absolute treat! :D I did however have to remove the trailing "." from your code suggestion as the "." caused a compile error. There's a big cheesy smile in Hove tonight.

Ok a slight deviation from the original plan - rather than doing a mailmerge i'm inserting the data using bookmarks instead. I am using the following code: Dim wrdApp As Object Dim wrdDoc As Object Set wrdApp = CreateObject("Word.application") Set wrdDoc =...

Hi Richard, Ok, I decided to give it a whirl, with unfortunately not the results I was expecting. Here is the code I used... strFilename = "S:\My Documents\Ian\DISCOfever\Sample.doc" Dim objWord As Word.Document Set objWord = GetObject(strFilename, "Word.Document") ' Make Word...

Hi there, Having searched this forum for many many weeks looking for information for my access project, one of the many queries I have come across from other users is how to merge access data from a currently loaded form/record into Word via a command button. Every plea from every user has...

Actually, I don't think i've done this right, but here's the goal I wish to achieve. I have 2 tables, one containing contract info and another containing client info. I have the 2 related using the client name field. I have a form which is based on the contract table which contains a drop...

Hmm ok. 1. I want to store the value as it can be one of 4 things: Contract Sent Contract Confirmed Complete Cancelled 2. I didn't realise there was a question in your reply asking me why I don't want to use a continuous form? I don't even know what one is anyway, so is there any point in...

And in English?! :confused: I think when you start tinkering with Access it makes you write in a different language :) I don't get it...i'm a complete noob. Is there anyway you (or anyone) can create a very simple working sample so I can look at it???

Hi folks, i'm a total access noob so please be gentle :) I am creating a contract management database, but instead of going into specifics about it, i'll keep what I want to do very simple :) I have one table with 20 fields or so, one of which is a date field. When the database is opened, I...

Don't reply...I did it myself :o

Obviously there's some layering system in place akin to dealing with objects in Corel Draw. Some of my buttons dissapear when I place other objects around them and fill them. An option group for example, if I choose a fill colour, any buttons 'inside' it would dissapear. Is there a way to...

In my bookings form, I want all the fields to be greyed out (i.e. non editable) unless an 'edit' button is clicked, and then greyed out again when 'save' is clicked. Obviously, I don't want any entries greyed out when adding a new record. Is this easy to do? How would I do this? Would it be...

Wonderful...worked perfectly!