Search results for query: *

Hi, I have a workbook filled with 40+ sheets with numeric data that is stored as text. I am running excel 2003 and of course it does flag it with the little green corner on each of those cells. Does anyone know of a way to convert all numbers that are stored as text to just numbers without...

Hi, I subtotaled a list of values, but within the "category" I would like the items sorted within the list. Here is an example of what it is now: Al cars 2 Al hotels 5 Al planes 3 Sub total 10 This is what I would like it to be: Al hotels 5 Al planes...

Hi, I need help with Excel on the following: I would like to insert a picture on a specific cell based on a cell value. In other words: if b2=1 then on top of A1 there is picture X if b2=2 then on top of A1 there is picture Y if b2=3 then on top of A1 there is picture Z Have been trying for...

Hi, I've got a combo box problem... I have two combo boxes on a continuous form. What I would like to do is to filter the value of my second combo box based on the selected value of my first combo box. I know how to do this when it's a single form, but for a continuos form.... I've got no...

Is it possible to delete an mdw file, without having to reinstall Access? Thnx, RvM

Hi, I have got two tables with the following fields: "tblcompanies" companyid (primary key) companyname "tblprojects" projectID (primary key) Projectname company1 company2 company3 company4 company5 and many other fields (please note that all company fields in this...

Is there a way to limit users input in the calendar control? I would like users only to select Monday and no other day(s) of the week. Thx, RvM

Hi, I want to implement table row level security for my database. I followed faq 181 641. But now I am stuck. I amended my SQL statement to the following: SELECT [Time Cards].[TimeCardID], [Time Cards].[EmployeeID], [Time Cards].[DateEntered] FROM [Time Cards] WHERE [EmployeeID]=^_^; The...

I am trying to make a database to keep track of projects. I have two combo boxes on my form, one for clients, one for projects and a lot of text boxes, for specific project details (budget, milestones etc). The first combo box helps to filter the second one, so that if I pick a client I'll only...

I am trying to insert a chart in a form. The form has text boxes which calculate totals, and I would like to make these totals the source of the chart. The totals are currently not part of any table. I have tried to instead of putting the totals in text boxes, to use fields from a query. This...

Very newbie question: I am trying to create a form which would allow me to view company names, addresses and telephone numbers. At the top of this form I would like to include a combo box, which would help to browse through the already existing records. Problem is: although I can create a...