Search results for query: *

hi. i've come across the "workbook sharing" functionality in excel 2003, and altough i find it probably very usefull (since we are 4 ppl working on the same excel file), i fear for the integrity of the data. so im looking for opinion-experiences: is it safe? have u ever experienced data loss of...

well u could do a check against a blank cell. as xlbo implies, that would force you to have the data together and neverskip a row, which can be frustrating sometimes. the only solution I found for blank cells was to add a "tolerance" for the number of blank cells found before the program...

okay... i don't know if u are asking simon or me, but if it was for me, basic logic would be right... some comments: that depends: you will probably run the app from datamonitor.xls. yup. that would be the first "loop". also, yup. it is of course a little bit more complicated. this can be...

mmm i think i understand better your need now, although i don't find other way to that but via VBA coding; since you need to run a proccess through a series of files, and you need to proccess that data: . I don't think that a VLOOKUP will help you with that, but i must confess that I tend to do...

FOUND THE SOLUTION! YEPEE well just browsing within the connection parameters, i found the DELETED parameter, wich accepts YES/NO ; setting wether it will filter out the records marked for deletion. "NO" will show the deleted records. --------------- Dogbert Can God write a code so...

well, there is a way to automate that, and it may not be very hard. but you will probably need to work through the data manually. here is a list of what you may do, i hope it helps: 1. the first thing would be opening the data into excel OR using ado to get the data. whatever suits you is...

well, i only stumbled upon the SHAPE recently, but basically it's a way to create hierarchical sql-queries in a different way. here is an example dim cnnconn as adodb.connection dim rs as adodb.recordset With cnnConn .Provider = "MSDataShape" .ConnectionString =...

im using vba with excel, and using a shape command to get info into a recordset. the problem is, i'm getting records that are marked as deleted. that doesn't help with normal queries... help? --------------- Arides Can God write a code so complex he couldn't understand?

hi, im working with vba and excel, and running through a list of items over and over. i know this is quite generic, but i'm not having a coding issue itself,i'm trying to determine which methods should i use in different situations. please bear with my idiocy let me see if i can summarize...

late thx for the warning, finglem, i've been so busy i used vfp for the updating, although now i have the kind of problems with fox that i wanted to avoid... :( --------------- Arides Can God write a code so complex he couldn't understand?

Thx! that is definitively a good a idea. i'm a little short on fox knowledge (usually i work in VBA) but this gives me a good lead... I'll try to get something directly from excel, but if I can't and i can do something interesting with this i'll post the code (AND questions... jeje)...

thx skip... i beleive i have it. in any case, with that odbc driver, could i create a connection from code and use recordsets? Can God write a code so complex he couldn't understand?

np. u should rewrite the whole query. basically, u could put the query into a string; and even use the ARRAY() if it's too large. (although frankly i cannot fully understand how that one works) BUT, as Skip says, u don't need to recreate the query, u can use shtobject.querytables(1) or, if...

hi!!! need help with viewing/editing records from visual fox tables. i have some experience with VBA but almost NONE with recordset handling & stuff. so my q. are: 1. what driver should i use (for ex, for ACCESS i used ADO 2.6 or 2.7) 2. some coding example would be LOVABLE

i got this from another post, i think that from Mike... theese are ALL the constants for excel. #DEFINE xlDialogSetBackgroundPicture 492 #DEFINE xlDialogAutoCorrect 485 #DEFINE xlDialogFileSharing 481 #DEFINE xlDialogVbaMakeAddin 478 #DEFINE xlDialogActiveCellFont 476 #DEFINE...

or: dim rngObj as range set rngobj = Range ("A1:B2") for each c in rngobj.columns next c there are several ways to determine the working range. this is another, which cycles through ALL the columns on the sheet Dim c As Range For Each c In ActiveSheet.Columns...

some addendum, if you want to check if the number is an integer (for example) u should FIRST check if it's numeric if isnumeric() then if isinteger() then

i don't know if i can help but i'll try... 1. to "refresh" queries, u should only use the REFRESH method 2. if u want to change the criteria of the query, u can do this by changing the .connection property 3. if u want to change the fields that the query projects, then u should want to delete...

Hi, weird question here. I have a spreadsheet that uses Mic. Query for listing information. now, this information is edited so i need to change original DBF Tables with the new values. right now, i'm putting that information into an excel spreadsheet, and from a separate VFP program i do the...

this is an example of what i've been tryin im working on a class that receives FIELD and SUMUP field is the name of the pivotfield i want to modify, SUMUP is a boolean. tried that as a text too, but to no avail opivottable.pivotfields(&field).subtotals(2) = sumup I created opivottable this...