Search results for query: *

I have an Inventory Control database. One of the tables (Products) has a field (PartNo) as primary key and is indexed "Yes". When I attempt to add a part number that already exists, I was hoping that I would get a warning message to the effect that I was trying to enter a duplicate...

I am using XP Pro with Excel 2002. I have just downloaded Calendar Control 10.0 and when I try to use it, Excel shuts down with messaage "Severe problem encountered", the details refer to dodgy ocx file. Any ideas on how I can fix this please?

I have a form based on one table called products. The form is used to display product details based on a part number selected from a combo box. Whenever I open the form, all the fields other than the combo box display data. I would like to be able to open the form and have all the fields...

I have created a Macro called Alfa and placed it in a number of different workbooks. For all workbooks, control + g runs the macro. If only one of the workbooks is open, the macro works fine, however, if a number of the workbooks are open the macro does not always run properly. What have I...

I have a frequesnt requirement to place a tick in certain cells of my spreadsheet. I have tried a macro that retrieves the tick from wingdings character map and it works fine until I close the sheet down and reopen. It then has a problem of pasting the tick. Is there a simpler way of...

I have a number of reports that when opened, have two problems: a. The report window is not maximised b. Although I have selected Landscape in page setup, it sometimes reverts to portrait. Is there a method to ensure the window, when the report is opened, is always maximised and landscape...

Good Morning, I want to use Conditional Formatting on a report by clicking on the text box that has the condition (eg a number) and then depending on the number , I would like the font colour of all the other text boxes in that row to change as well. I have tried it, but am only able to get the...

Is it possible to use the SUM function to obtain results based on the colour pattern of the cells. For example, I have a column of numbers, the cells have various colour patterns. I need to be able to SUM some of the numbers by a particular colour only and some of the numbers containing...

I have seen so many answers stating the solution is to "add the following code" etc. In the case of a spreadsheet, can someone explain exactly how one "adds code". An example is Paul Brickers solution:- You can try this. In the Format Event for the Detail section put If...

I am going through a simiple tutorial where the example query is: SELECT* FROM Invoice WHERE inv_date between #10/12/99# and #14/1/00# The results I get do not display invoices between these dates. I am using ACCESS 2002, the book I am learing from was published in 2000. Do I have a version...

I am trying to use DMAX in an inventory spreadsheet to allow me to see when a part number was last issued. The sheet consists of a random column of part numbers (some duplicated), the next column shows the dates that they were issued. The next part of the sheet has a master column of the part...

I have data stored in individual rows with loads of conditional formatting . I am trying to write a macro that will take me to the first cell of the next empty row. "End(xlDown).Select" takes me to the last used cell, but how do I go down one more? Would appreciate some help on...

I am very keen to learn how to use VBA, in particular with Excel. I have just purchased "Writing Excel Macros" by Steve Roman but find it a bit difficult to follow. Can anyone recommend a book or method that could apply to someone like myself who needs simple explanations and is...

Is there an easy way to insert a new page in a Word 2000 document. I had a document that I had already inserted page numbers. Is there a way to insert a new page (in between pages 2 and 3 for instance) and have all the pages re-number to take into account the additional page?

Hi, IS it possible to display the results of query on to a form ? I thought of using a list box, but whilst using the wizard it does like the query that i'm trying to use, so i can't finish setting up the list box. Cheers in advance, Chris

HI, I want to design a form that alows me to select a customer and then show all the records for that customer. Thanks in advance chris

HI, I want to create a table from a form, and pass user inputed value at the same time. Can anybody help ? Thanks in advance ! Cheers Chris

Hi, Is it possible to add a lash movie on to an Access 2000 form ? Cheer's Chris