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 Chriss Miller 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: *

  • Users: Ryath
  • Order by date
  1. Ryath

    Function/Macro Limit!??!

    Thanks Glenn! Understand what's going on now :o) Just that If I haven't used a function before I tend to just go with instinct! All working well now aswell! :oD Cheers, Will Will [hammer]
  2. Ryath

    Function/Macro Limit!??!

    Dang, Problem... After testing using my combobox with code:- Private Sub ComboBox1_Click() Select Case ComboBox1.Text Case "" Case "Clean Sheet" Application.Run "Clean" Case "Part 1 Hours" Dim rowrefhr As String rowrefhr = 4 Call...
  3. Ryath

    Function/Macro Limit!??!

    Coool!!!! Works! Cheers! Was in one track mind regarding using values in forumulae :oS ... didn't think of doing it that way! Thanks again! :o) Will [hammer]
  4. Ryath

    Function/Macro Limit!??!

    ...= "=IF(HLOOKUP($A7,Constants!$C:$K,94,FALSE)=0,0,IF(IF('Raw Data'!$F7=0,0,((((HLOOKUP($A7,Constants!$C:$K,94,FALSE))-'Raw Data'!$E7)/'Raw Data'!$F7)*365)+'Raw Data'!$C7)>46022,46388,IF('Raw Data'!$F7=0,0,((((HLOOKUP($A7,Constants!$C:$K,94,FALSE))-'Raw Data'!$E7)/'Raw Data'!$F7)*365)+'Raw...
  5. Ryath

    Function/Macro Limit!??!

    Hi all, In abit of a dilemma! What I’ve got so in a spreadsheet is A combobox with an example of the following code (in objects for relating sheet). Case "Clean Sheet" Application.Run "Clean" Case "Part 1 Hours" Application.Run "Part 1 Hr" Case "Part 1 Cycles"...
  6. Ryath

    Excel, Nested IF Nightmare!

    It works! Cheers macropod! :oD Will [hammer]
  7. Ryath

    Excel, Nested IF Nightmare!

    Hey! Thanks for your suggestions! The first one didn't work as you mentioned but I'm trying the LOOKUP at the moment (never even thought of using that even though I tried HLOOKUP) and so far (first few values out of ~800) it seems to work! Will do abit more testing and will get back! Ta! Will...
  8. Ryath

    Excel, Nested IF Nightmare!

    Hey all, Need help with the dreaded Nested if problem as it's driving me nuts! The scenario:- 17 Columns (16 interval dates with 15 month gaps and 1 reference or dead date) Many rows of varying start interval dates and dead dates. To Find the closest match using the dead date to the 16...
  9. Ryath

    VB Newbie Needs Help! Message Box...

    now i'm really confused alex... after pusing the button it says that the accmdfilterbyform isnt available yet!!!.... dumb database!! :/ Will [hammer]
  10. Ryath

    VB Newbie Needs Help! Message Box...

    thx for the quick response... it still doesnt work get an error code 2046 and the command Cleargrid isnt available right now... i think its because the grid can only be cleared when the form is in "Filter By Form" mode. So thats what i mean doing one command after another... the form...
  11. Ryath

    VB Newbie Needs Help! Message Box...

    Hi all, At the moment i have a form with a button that on press will produce a yes/no message box saying that "would you like to perform a new search" if yes it will activate filter by form mode and clear all grids (accmdcleargrid)i think... not sure :/ and if no will just activate...
  12. Ryath

    Grouping, Selecting data from query.

    Hi all, Currently i have a select query which looks like this. SELECT [TBL Base Data].[Aircraft Model], [TBL Base Data].[Unit Description], [TBL Base Data].[Removal Date], [TBL Base Data].[Approved], [TBL Base Data].[Failure Type], [TBL Base Data].[Failure Mode] FROM [TBL Base Data] GROUP BY...
  13. Ryath

    Picture Display Problem (Colours???)

    Hi all, I have an image (photo of aircraft) as a background for a form 16bit 640x680 jpeg format, now, when opening running the database in windows (Setting on 16bit or greater) the picture is fine, but if the windows setting is at 256 colour the photo is a large smudge??... like running in 16...
  14. Ryath

    Access Conversion Query

    run access.... then create a blank database, after that it will prompt you to save the new file, give it a name: then click create. After that go to the menu click on File>Get External Data>Import Then select your database Hope this helps :D Will [hammer]
  15. Ryath

    Grouping data by Month

    Thx, it works.... the dreaded but: is there a way to get it in column format so the date is in the column rather than a row? Will [hammer]
  16. Ryath

    Grouping data by Month

    Hi all, Got a quickey question for you all currently i have data that looks like this:- Date Hours 1/5/99 21 2/5/99 41 18/5/99 15 21/8/99 77 31/8/99 4 etc etc So as observed the hours can be varied from month to month, and some...
  17. Ryath

    Cant Find Command Button For Custom Menu

    Ok.... i found that you can copy buttons holding down the ctrl key... but, when disallowing full menus the commands dont appear in my custom menus ?:/ why is this?... are they default to be part of the "Full Menu" list? how can i change this? if anyone knows :) Thxall Will [hammer]
  18. Ryath

    Cant Find Command Button For Custom Menu

    Hi all, I'm creating a few custom menus at the moment but cant find all of the ones i need available to me in the list of commands, for example:- When in "Filter By Form" Mode the button "Save As Query" is not there, and even the simple "Database Base Properties&quot...
  19. Ryath

    Security Hole in DB with User Level Access >:(

    Hi all, After creating the database and specifying user as : Admin DataInputer Guest Using the Security wizard which creates a mdw and a shortcut ("C:\Program Files\Microsoft Office\Office\MSACCESS.EXE" "Q:\New DB\New DB.mdb" /WRKGRP "C:\New DB\New DB...
  20. Ryath

    If Any Fields Is Null Return No...

    Cool... Thx!!! Will [hammer]

Part and Inventory Search

Back
Top