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 Rhinorhino 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: JesOakley
  • Content: Threads
  • Order by date
  1. JesOakley

    Want Excel to prompt for save *only* once manually changed

    I have some spreadsheets which I mainly use for reference, but when I exit I'm prompted to save whether I do anything or not. Yes; there is some macro code in there which is undoubtedly doing this and which I don't really want to change. What I would really like to do is reset the 'dirty' flag...
  2. JesOakley

    Code to validate live webpage

    Hi folks, I've scoured the net trying to find something that does this, but I can't find anything that seems to work. My basic problem is that I'm not a vbscript programmer and don't really know whether the values I'm passing to the functions are correct and what return values I should expect...
  3. JesOakley

    Script won't run from Windows scheduler

    Hi to all you scripting gurus out there. I have a problem with a small script which I have seen all over the net (including in these hallowed Tek-Tip pages) which should tell me if a service is running. The script is called from a bat file with the line Cscript D:\perl-src\ProcessRunning.vbs...
  4. JesOakley

    cell ref in filter macro

    Hi everyone. I have a monthly task which requires i apply a complex series of custom filters to a spreadsheet and extract the data. I thought it would be cool to automate the filters to ensure consistency. Most of the filters include date-filtering i.e. in the current month, before the current...
  5. JesOakley

    rounding values declared as single

    Hi folks. I am looping through a text file, accumulating a certain value on each record into a variable defined as Single. The values are quite low, but to 2 decimal places. Can anyone explain why when I say sngAmount = sngAmount + csng(strAmount) it manages to add 61.85 to 18.30 and come up...
  6. JesOakley

    using a charlist with instr

    To be honest, I can't believe I've not been able to find the answer to this question either in Tek-Tips or on the net, but I can't, so I am looking for the Tek-Tips experts to put me straight! I simply want to find out if a string contains any of some specified characters. I have tried If...
  7. JesOakley

    User Defined Types - assigning at group level

    Hi. If I have read in a 40 char fixed length record into a string, can I move this value in one go into a field defined as a 40 char UDT, where the UDT is made up 3 fields; 30, 6 and 4 chars respectively? It seems madness that you have to do every element individually. I have tried the following...
  8. JesOakley

    Split function to create mixed type array

    Hi . I'm trying to use vba to open a .csv file out of excel, and use split to load up the various elements into an array. The elements can be text, numbers and dates. I've read on the net that i can declare my array as an object, and then convert when i want to do something with them. My problem...
  9. JesOakley

    Excel formulas 'following the data'

    Probably a stoopid question, but I can't seem to find the answer anywhere... I have a column of data values (numbers) in column A, and a cumulative total going in column B, using =if(a3<>"",a3+b2,b2) in B3, kinda thing. My problem is that if I drag the number value from A3 out of the column e.g...
  10. JesOakley

    setting derived values on table

    yes, I know this is a bad idea, but the table is an old one and the fields can't be changed, so... I have a x-ref table that has two text fields (A and B) and a primary key derived value (C) that is the other two added together. I have ploughed through oodles of help files, masses of tektips...
  11. JesOakley

    Parent form

    I have a form which is potentially called from a number of different forms. I want to close the form automatically when the calling form closes, but not when one of the other potential forms closes. How can I tell which was the real parent?
  12. JesOakley

    question on main/sub form record source

    Hi guys, perhaps you'd help me out with this: Form A has subform B. the properties of the control on A say that the link master is cboPart (a combo box on A) and the link child is Part (a key field on B). The combo box looks up on the same table used in B, so B should always find records...
  13. JesOakley

    Displaying public array variable in text box

    Hi guys, no doubt i'm being entirely dense, but in a module I have 'Public fred(9) string' and then on a form I have 10 textboxes with the control source being fred(0) to fred(9). I don't understand why i'm getting #name? in the boxes when i run the form. Anybody care to put me straight? Any...
  14. JesOakley

    Where is my CD drive

    Hi, Does anyone know of a way (using vba) to tell which drive letter equates to the CD drive? My back-end db is running off CD, but some users have C drives partitioned into C and D drives.
  15. JesOakley

    Programatically linking to dbs on a CD

    I have a split db, with a number of possible data databases (same design, different data). I wanted to allow my users to select which set of data they wanted to use, so I adapted the Dev Ashish 'fRefreshLinks' code to allow this. When the datasets are all on the local hard drive, this works...
  16. JesOakley

    Find record in another form

    Using data in one form, I wish to find a record in another. It looks like FindRecord is the answer, but I'm not sure of the syntax for the 'front end' of it to make it do the action in the remote form. Can anyone help? I thought something like forms!frmRemote.FindRecord(varWhat,,true,,true) ?

Part and Inventory Search

Back
Top