Search results

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

richary, I think I may have mislead. "Sub System" is the field I want to filter on the report "RptAll" and Forms![FrmPrintReports]![LstSelectSub] is the criteria. Cheers Gordon

Please help :o I have the following statement in a 'Select Case' and I get a blank result. DoCmd.OpenReport "RptAll", acViewPreview, , "Sub System" = Forms![FrmPrintReports]![LstSelectSub] Where am I going wrong Cheers Gordon

Thanks for that, very useful, all ready added. Regretfully this is the wrong problem. My fault, did not explain properly. What I want is to display the inputed data in the report heading. e.g. "Report up to and including"&" "& [T0+] Cheers Gordon

Thanks for the help. I have solved the problem by deleting the form and creating a new one. The command works now even though it is exactly the same. 'The beauty of Micrsoft'. :rolleyes: Cheers

Hi Ken, Nothing starting with missing. Gordon