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

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

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

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

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...

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...

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

I have a group form with extra buttons to print, review a report or close the form. If I use a Macro then I can close the form. I converted the macro to code and I get the error message: A problem occured while Microsoft Access was communicating with the OLE server or ActiveX Control *The...

I have a report which is filtered using the following criteria on a query <=[Deliverables upto T0+ date] How can I get the user input displayed on the form? Cheers Gordon

Hi, I have an option group that selects what is printed on a report. Is there anyway that the user can save their options to use at a later date. Cheers Gordon

Hi, I have been tasked to create a database that will be accessed through a dial-up connection to our server. What I want to know is which is faster 1 Using a seperate table for dropdowns or 2 Using the lookup facility of a table. cheers Gordon :confused:

Hi again, I now have the ability to select a query and have a form open on that record set. The problem is that some of the queries generate the error message : Invalid SQL statement; expected 'DELETE',INSERT','PROCEDURE','SELECT' or 'UPDATE' Code is Private Sub Combo0_Click() sQuery =...

Hi, I have a requirement to filter some queries periodically on the date field. What I want to do is create a form that lets you choose which query to use and filter and not create alot of single forms. The filter will be only be applied whilst the form is open. Cheers Gordon

Hi, I am trying to allow users to filter a report using the 'Filter Attribute' [Feild to Filter]<= [Criteria] This does not work. I can use the '=' on its own but I really want to show all the records below the selected number. :confused: Cheers Gordon

I have a sub form to which I want to apply filter buttons. I have used the wizard to set these up. The problem I have is that when I try to filter the SubForm the MainForm also filters. The forms are based on tables and not queries. Cheers Gordon

Hi, I have one real puzzler for you, (well it is for me) I have a date field on a query that I sort using the following criteria: Like "*02/2005" This works. When I use: Like "*03/2005" it does not work. There are data items related to this date. If I use the <=Date() it finds...

passing and liknking data between 2 forms I have two basic forms, each with a sub and a subsub form. The first is for the main assembly type with a sub form for the serial numbers and a subsub form to track its history, (FrmMainItem) The second form has the same structure but is for any sub...

I have a form (created from existing xl and word tables)that records memos etc. Each new memo is given a reference number in the format: Project Name (this is constant)/year (i.e. 2005) /C+number(restarts at one every year). example: Project/2005/C001. To complicate things the user can add...

I have a report where I wish to display data down the left side of the page and let if start at the top of the same page but on the right hand side., A similar effect as a news letter. Does anyone know how I can do this without using the label wizard. Cheers