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!

  • Congratulations strongm 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: TomYC
  • Order by date
  1. TomYC

    Linked Excel files: problems updating, #VALUE! data type errors

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

    Linked Excel files: problems updating, #VALUE! data type errors

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

    Linked Excel files: problems updating, #VALUE! data type errors

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

    Can Excel reproduce an SQL outer join with a formula??

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

    Can Excel reproduce an SQL outer join with a formula??

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

    How to clone a form with vba behind it, without getting into trouble?

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

    Excel form to open pdf file? Need for Read/Only users

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

    Excel form to open pdf file? Need for Read/Only users

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

    excel/word file creation date (how to access remotely?)

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

    Integrating Excel Worksheet Names dynamically into formula

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

    (IF(ISNA(MATCH along with named range array and sumproduct

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

    (IF(ISNA(MATCH along with named range array and sumproduct

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

    repeat group header (only) when length of detail section forces a page break

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

    can a lookup_array be described by a formula in INDEX/MATCH ?

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

    How to refresh data from listbox on form?

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

    How to refresh data from listbox on form?

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

    How to refresh data from listbox on form?

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

    Report sort ordering by calculated control?

    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!
  19. TomYC

    Report sort ordering by calculated control?

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

    Report sort ordering by calculated control?

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

Part and Inventory Search

Back
Top