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 derfloh 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: *

  1. Aristarco

    Miscellaneous functions for SQL

    PHV: That's it, then! We were using Access 97 (was it 97?) until the office mongers acquired Access 2000 around year 2005. Then they cancelled any work in Access. To boldly code, where no programmer has compiled before!
  2. Aristarco

    Miscellaneous functions for SQL

    kjv1611: I put the lightbulb that makes it a tip. Is it not there? [sad] 12 years of not using this forum made me rusty. Thanks for the advice! strongm: Whoa! Awesome! Never used Join() nor Split() functions. It's been a long time since I programmed in Access. My area shut down that job function...
  3. Aristarco

    Miscellaneous functions for SQL

    thread705-74658 In 2001 I said here I had 2 functions I made to ease the creation of SQL strings. Then forgot it and now I come back -12 years later!- and find some of you wanted the functions. So I better post them before forgetting it and returning in 2025, ok? '***** Find separator symbols...
  4. Aristarco

    Buttons in toolbars disappear when program turned off

    I'm using Office 2003 in a notebook and when add buttons to the toolbars (standard, web, etc.) they remain at the bar as long as the program is open (Word for example). I close the app, then maybe later, maybe immediately after closing, I open it again and the buttons I added are missing. I...
  5. Aristarco

    TRANSFORM and subqueries

    I have sort of an inventory of codes. Every code belongs to a group of records belonging to different types. Lets say code SC_025 has some records of "Works" type, one of "Actions" type and a couple of "Projects" type. The transform query results in something like this: Code | Actions |...
  6. Aristarco

    TRANSFORM and subqueries

    I've tried to make a subquery with a transform query inside but it seems it's not working. Does anyone know if this is a forbidden/non-implemented thing in Jet SQL? My code look like this: SELECT FQ.AnyField FROM [TRANSFORM FieldX SELECT blahblahblah... PIVOT yaddayadda... ]. AS FQ To...
  7. Aristarco

    How to update a field based on a value entered in another field?

    Um, too vage the info you give. You might need to add 15 to the serial conversion of the date, then transform it again to date, simply by nesting the functions. If you want it the hard way, you could make a public function that returns the 15 days later date and use it in the textbox, like...
  8. Aristarco

    Large Report - Access to PDF

    I think it is indeed a problem of available memory. To the very best of my knowledge, PDF conversion is made in memory, then written to disk. If you can split the report to make let's say batches of 1000 pages, you can later merge them in a single document with Acrobat Professional. I do so when...
  9. Aristarco

    Printing to a plotter

    I think a better solution to this might be (I haven't tried but think it works) is printing to PDF in a proportional size, like 11"x17". Then print to the plotter using the scale to fit feature. For this you need to make your report fit an 11x17 (Tabloid) sheet but since you now have it...
  10. Aristarco

    Data bound fields in Illustrator?

    I hate MS Office. I DO hate MS Office. But 'till now, I haven't found that useful function that lets one make a label/letter/envelope with links to a DB or spreadsheet or any data source and print all the mail our office must send. Now, I've made a document with Illustrator and I have to...
  11. Aristarco

    Char Map ActiveX?

    I have some cartographic fonts from ESRI, and I'd like to have a char map embedded in my app, so the user picks the marker. I've solved the problem using a listbox containing chars 33 to 255 and showing them in the font selected from another listbox. Still, I'd like to have a grid, just like the...
  12. Aristarco

    Char Map ActiveX?

    I'm working in a small program where the user should be able to pick a char from a font so it can be used as a marker in a map (like a star, a smiley, a flag, a car). I've found a control to be used with vb .net, but I'm not using .net and I don't want exessive features. Just a char map-style...
  13. Aristarco

    TabStrip object not working

    Thanks VBslammer. I think I'll use that. In fact, the data sources I needed were stored in a combo box, so you selected one and the recordsource in the form changed, and so the Forms 2.0 textboxes were filled with the new info, but I thought it'd be more user-friendly to have the sources as tabs...
  14. Aristarco

    Exporting tables via VBA

    If you want to make the user save the tables in external files, you'll need a common dialog control to open a "Save as" dialog box. Then you'll need the transfer methods as PHV said. To boldly code, where no programmer has compiled before!
  15. Aristarco

    TabStrip object not working

    Hi there! I've never used a TabStrip object in Access VBA, and I can't make it work properly. I know it is not a container and that everything in the control's field is really in the form. So I made a tabstrip, put some controls over it and when executed, the tabstrip is covering the controls...
  16. Aristarco

    Morphing an object into another

    Thanks. I went to the page and didn't work. I'll try later. I think I should use something like Elastic Reality software or those apps used by the guys at pixar. Maybe I should contact the Matrix FX team, hehehe. Thanks anyway... To boldly code, where no programmer has compiled before!
  17. Aristarco

    Excel spreadsheet to Access Table

    What I want to do is to open a spreadsheet and store the data in a recordset, so I can transfer it to a table in an *.mdb file. I'll try your code. Thank you very much. To boldly code, where no programmer has compiled before!
  18. Aristarco

    Code to advance a multiline textbox??

    Excellent!! Application up and running. Thank you very much. I owe you a drink man! To boldly code, where no programmer has compiled before!
  19. Aristarco

    Excel spreadsheet to Access Table

    Hi there. I've been using the next code to tranfer an excel spreadsheet to Access so I can make relations, etc...[code] DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel97, "MyTable", "MySheet.xls", True [\code] But now, I have to make it in VB 6.0, so my utility is...
  20. Aristarco

    Code to advance a multiline textbox??

    Hi there. I'm using a multiline text box to hold messages from a socket, the way MSN messenger does. The problem is, everytime the control updates (i. e. receives a new message), the last text can't be seen until scrolled manually. I've tried sending Ctrl-End to the box with SendKeys but not to...

Part and Inventory Search

Back
Top