Search results for query: *

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

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

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

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

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

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

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

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

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

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

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?

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

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

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.

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

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) ?