Search results for query: *

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]

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

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]

Here's a sample of one sub:- Sub Part1Hr() ' W.Chong Application.ScreenUpdating = False 'Application.Run "FifteenMnthCCheck" Dim MSNCount As Variant MSNCount = 0 Dim LoopCount As Variant LoopCount = Range("PartCalcsHr!A4") Worksheets("PartCalcsHr").Select Rows("7:65536").Select...

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

It works! Cheers macropod! :oD Will [hammer]

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

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

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

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

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

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

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

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]

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]

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

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]

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

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

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