Search results for query: *

MS Query, then; I'll have to brush up! Thanks

Thanks, Skip; I'll try the latter and take the former under advisement! But I would say that what is any accounting system, if not a set of linked spreadsheet files of some sort? If you're saying Excel is not quite the tool for this, well, then, you may just be correct-- T.Y.

I am looking for some "rules of thumb" for opening and updating linked Excel files. I have numerous files so connected, with formulas such as COUNTIF, SUMPRODUCT, INDEX, MATCH, OFFSET, etc. involved. I'm in the habit of opening all these files together, as that usually facilitates the process...

Thank you zelgar! I'm going to ponder this one over the next week, and try to implement it for a larger data set than for the example I provided. Thus, I can't specify "parent" in the way that your example suggests. T.Y.

I think I am not alone in working in an organization that has contracted for a "web-based" database that appears to be unable to handle relational database items well. Thus, a work-around is needed. Right now I am exporting the report results, running a query in Access, then re-importing to my...

Let me explain! I have an Excel form, with a command button that triggers some action, basically picking up values in a few cells and using that to create a file name, then outputting a pdf of the form. When I cloned this form/worksheet, I of course had to rename the worksheet copy, but then the...

Djienkuye, Andy! Actually, it was even easier than that: ActiveWorkbook.FollowHyperlink FullName, NewWindow:=True

I have an Excel form that uses vba to generate a pdf file, and display it. However for some users I want to place this form/dashboard file in a Read/Only environment and have the button on the form pull up the relevant pdf files (in a loop) that have already been created. My current code...

I am working with excel files, linked. in one cell of one of the files, I would like to display the original file creation date of a different file (possibly in a different location, i.e. with path info). The reason is that I am using my first file as a dashboard (e.g., dashboard.xls), and the...

For some time I have been looking for a way to do the above, in Index/Match or VLOOKUP type formula referencing in Excel. Basically I want my cell formula to reference a file such as FileSource.xls and one of many worksheets that are datename specific, such as 010513, for January 5th of this...

Thank you Skip, and have a Friday afternoon star! I guess I thought that SUMPRODUCT made the array entering unnecessary, that it reproduced an array in an alternate manner-- T.Y.

I have a formula such as the following, modified for simplicity here: =SUMPRODUCT((JAN!$D$2:$D1000<>"")*(IF(ISNA(MATCH(JAN!$D$2:$D$1000,UNITS)),1,0))) I'm expecting this formula to parse a column, and if the cell is not empty, to see if the contents of the cell match one of the elements of an...

My report has a page header with labels such as: 'Last Name' & 'Summary' and in the detail section my text boxes include txtLastName & txtSummary. Most of the time this works fine, but if the length of the text in a particular record's [Summary] field forces the txtSummary text box to create a...

Instead of designating my lookup array with something such as $A$10:$BA$10 in a particular cell, as part of an INDEX & MATCH combination (e.g., =VLOOKUP($A2,'Current Month'!$A$11:$BA$113,MATCH($A$1&" n",'Current Month'!$A$10:$BA$10,0),FALSE), I would like to be able to specify part of this with...

That did the trick, dhookom! I'll try and figure out why it took a domain function, but now everything works without all that hoop-through jumping! Tnx, T.Y.

Thank you-- Quick answers: the name txtDate is because originally, of course, I assumed it would be a textbox, but I haven't been able to get a textbox to work. As for me.txtDate.refresh, that isn't allowed. Under what circumstances can Me.xxx.Refresh be allowed? T.Y.

On a form I have a list box, whose value is a row source from a query: SELECT [Legend Query].Field13, Mid$([Field13],6,2) & "/" & Mid$([field13],9.2) & "/" & Mid$([field13],1,4) AS RightDate FROM [Legend Query]; Basically all this is doing is calling a single value from a table (whose value...

I guess it was a question of sleeping on it and looking afresh the next day. This morning I moved my fields into the detail section (probably where they belonged!) and then I didn't need any grouping at all, and sorted by count. Simpler was better, just like Einstein said-- Many thanks!

Group seems to trump sort! Anytime I group on PrimaryDepartment, I get the entire list, alphabetically, and Sort doesn't affect it. Anytime I group on Count, I lose out on PrimaryDepartment records with the same count. If there is a way I can show you the code for what I have (the report, as...

Now I think I'm a bit confused. And even if I proceed as you suggest here, and "add back" the Count field that I've calculated in a separate query, I'm still in the same boat: I can group by PrimaryDepartment and get alpha ordering, or group by Count and lose any PrimaryDepartment records with...