Recent content by gpurger

Hi, is there a way in excel 2000 to find if part of the information in a cell is in itallics or not. Cheers G

Thanks for that G

Hi, I am trying to notify users to fill a specific field in if they forget it and can not work out which event to use. Can you please help Cheers g

Thanks, I only am trying to open the doc via Word because I can not find how to open it in Access. Remember it can have any name. Cheers for your help

Hi, I am trying to let the user open a chosen word file. I can activate word but I am having problems displaying the 'Open Dialog' to allow them to choose. The file will be a Word .doc with bookmarks that I want to save to a table. Can anyone point me in the right direction please? Cheers

Thanks for that

Hi, Have tried but can not get it to work. I want it to react as I increment through the records. Code used is Private Sub Continuation_BeforeUpdate(Cancel As Integer) If Me![Continuation] = "hello" Then Me![BtnContinuation].Visible = True Else Me![BtnContinuation].Visible = False...

Hi, I can hide buttons on a form but what I want is to hide/ show it when one of the fields has a specific value. Cheers Gordon

I know thtat you can use word bookmarks to create a doc from access (can not remember how) but can you read bookmarks from word into a table? Cheers Gordon

Are you using this in an access environment or is it exported to an other environment

Thanks for that Gordon

Hi, I am trying to use the property let command but I do not know how or where to call/ insert it. I have a list and want another module to use the result. Code as follows With UserForm1.ListBox1 .RowSource = "" .AddItem "Class and Operation data" 'Adds item to the userform list End...

Hi, The options are: All records or Sub-system (from listbox) records and Date filtered(formula on query) and Preview or Print The report works if I select anything AND Date filtered but not if I miss out the date filter. All queries sort when previewed so I think it is my VBA...

I have a form that the user can select a report using options through 'group options'. These then open up the report using specific queries. One report many queries. The queries are the same except for the filter criteria. I created 1 query then copied the rest and adjusted the criteria. I am...

Cheers for that, already incorporated. Gordon :D