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

Thanks for all your help on this really appreciate it!! Sorry to keep asking questions here but I am pretty much a novice when it comes to VBA in Excel... what would the final code look like? Am a bit confused as to where the code from your last reply fits in. Thnx (again!!) Roger

Hi, Thanks for your answer but actually I was hoping to have the pix inside the workbook somewhere. Is there a way to do this? Thnx, Roger

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

Nice quip about 1982. Anyway, for all kind of reasons, I cannot adapt my database design at this point. Furthermore, I looked at it in detail, and I am pretty certain it is ok. Thanks for your help, but if it is not possible to do this, so be it. It was only meant to make it easier for the...

In the on load event of each form put: docmd.maximize

Thanks, Jim for all your help! But........I am still struggling :( My form is a subform within a subform and is bound to a table. The form is part of a time tracking tool. The continouos form is where the users fill in their hours. To do this they must specify in box 1 (called CompanyID) the...

Jim, Sorry, but I am still confused... I am very much a beginner in Access could you explain a bit more? Thnx again RvM

Can anyone help please?????????????????? Thnx, RvM

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

Hi, in the load event of the form put: me.calendar.today Rgds, RvM

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

Thanks roubin! It worked!!!! Am definetly giving you a star for this one! Rgds, RvM

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

The error message says: Run time error 3021: No current record Thnx for your help Ken!!! I'll try out your suggestion of a query, this might be the answer! Rgds, Roger

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

Thanks for your help! It worked!!!