Search results for query: *

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!

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

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

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

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

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

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

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

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

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

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

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

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

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!

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

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!

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!

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

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

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