Search results for query: *

Hi, I'm trying to automatically create a number of checkboxex on a form when it initialises based on data in sheet. The number of checkboxex will vary depending on how many cells in the sheet have values in them. The only way I can think to do it is to create a whole heap of genric checkboxex...

I'm using the built in "Forms" tool in MS Word to create a report template. The template has several tables in it that could be anywhere from 1 row to 50. Rather than create 50 rows straight off I'm trying to dynamacly create rows as they are needed. The last cell in each row has a Text Form...

We are runnning NW6 with Zen 4 and I'm trying to produce a report that lists users, the application objects that associated to them and the last time the user actually used each application. I have setup the Zenworks ODBC but can not find any tables that give the info I need.

I'm trying to set the default driver settings to include duplex settings etc. I've found a TID on Novell (10083141) that says it can be done through HTML code but to date I'm unbale to get this to work (see below). We are running NW6 and HP printers, has anybody been able to acheive this or...

I have a form with about 20 questions and Yes/No option buttons...when the user clicks OK I want to call a procedure to check that all questions have been answered and if there are any "No" answers...I have code that will check all the option buttons but it only works if the user has answered...

I'm sure this is very easy but I just can't find a way to do it....I have 4 checkboxes in a frame on a form, 2 lots of YES/NO. I want the user to be only able to check one, ie yes or no. I've tried using if then for the click event but this doesn't seem to work properly and actually crashes my...

I've got a simple form that displays values from cells in an excel workbook and I'm trying to find a simple way of checking to see if a user makes any changes in the form so I can update the workbook if needed. I can think of 2 ways of doing it but both seem long winded any other suggestions...

I've been working on a small app that calls a command line exe file (see thread222-681160) and I almost have it working now but am running into two problems. Firstly the command line exe file needs to be run from the same location as a DAT file and I've tried copying this DAT file to all the...

I'm fairly new to VB and don't know if this can be done. We have a command line exe file that generates passwords for us and I'm trying to write a VB app so that we can run it without starting a DOS session. I've created the forms in VB with a text box where the user would put in values that...

I know there's lots of posts about working with dates but I can't find away of working out the number of days in month using VBA in excel. I've been playing around trying to use a loop statement to count the days until the month changes but figure there must be an easier way. I did come across...

I'm trying to write a procedure that finds a maximum in a Range and then returns it and the value of the cell to the left of it. I can get the maximum no worries and I've been playing around trying to use the find function to get the cell it's in, then the offset property to reference the cell...

Hi I'm very new to informix databases although have a bit of experience with SQL and have managd to put together the below query that returns a maximum for me. I'm now trying to workout out how to find the time that the maximum occured which is stored in the idrecord.IntialStart column. Query...

Hi use the following query to find a maximum..I'm now trying to workout out how to find the time that the maximum occured which is stored in the idrecord.IntialStart column. Query to find max SELECT (agerecord.Secondstart -idrecord.Intialstart) + int2interval(agerecord.Length) FROM agerecord...

Not sure I'm putting this post in the right forum but hope somebody can help. I have a Informix database that I'm reporting on with three columns I'm trying to do calculations on but am having trouble... agerecord.Secondstart - datetime idrecord.Intialstart - datetime agerecord.Length -...

I'm need to use the Max worksheet function but am having trouble because the range I want to search keeps changing. The first cell in the range is always the same but the last one changes. I can get the cell reference for the last cell ok but can't work out how to define the range using it...

I have a spreadsheet with a command button for each day of the month. I want the click event for each button to be the same. I also want to reference the cell above which ever command button was pushed. Hopefully you can tell from the code below what I'm trying to do (I know that it is wrong...

When I open a CSV file using the code below the dates in the CSV which are in the format dd/mm/yyyy change to mm/dd/yyyy. If I open the CSV file through explorer it's all fine. Any ideads why this would happen??? ***code*** Summary = "J:\Tsdshared\CallCentre\Weekly...

I'm trying to fill multiple comboboxes in a worksheet with the same items but am running into troubles. I've been able to do it if the comboboxes are in a userform but can not work the code when they are in a sheet. This is what I have so far. ***code*** Sub Macro1() Dim ctrl As Control For...

I know a very limited amount of SQL and need some help writing a query that is probably pretty simple. I have written two seprate queries and am trying to join them..I'm not quite sure how to explain it..this is what I have ***Query 1*** SELECT Count(*) AS 'Cases Closed' from SW_HD_CASE WHERE...

I have 10 comboboxes on a form, the procedure that runs for each combobox is exactly the same. Rather than re-typing the code for each combobox is there a way to make it repeat for each...I've looked at for/next, for each and loop statements but can not work out a way to do it. If...