Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. rvmams

    Excel Convert text to number (multiple sheets)

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

    Sorting within subtotals

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

    Excel: show different pix based on cell value

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

    Excel: show different pix based on cell value

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

    Excel: show different pix based on cell value

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

    continuous form combo box filter

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

    MAXIMIZE FORM ON OPEN BY DEFAULT

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

    continuous form combo box filter

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

    continuous form combo box filter

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

    continuous form combo box filter

    Can anyone help please?????????????????? Thnx, RvM
  11. rvmams

    continuous form combo box filter

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

    How to set the current date as default in a calendar control

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

    removing security mdw file.

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

    Need help with changing SQL!!!!

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

    Need help with Calendar Control limits?!!!

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

    Need help with Calendar Control limits?!!!

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

    Help with table row level security

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

    combo boxes, tables & "Me.Bookmark = rs.Bookmark"

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

    combo boxes, tables & "Me.Bookmark = rs.Bookmark"

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

    Combo box problem

    Thanks for your help! It worked!!!

Part and Inventory Search

Back
Top