Search results for query: *

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

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

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

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

I want to show the tables stored in a database so the user can select one from a list. I used to do this in Access VBA with a dblist filled with the command SELECT Name FROM MSysObjects , but now I need to make it with VB 6.0 and it just doesn't work. I made the connection to the database and...

I've just started using Flash (two days including this) and I'm trying to morph an object into another, but it seems that all I can do is transform the shape of the same object. See, I can morph a square into a circle but I can't morph a man (image) into a woman (2nd image). Is there something I...

My boss has this idea of sending notes to the users just the way Unix does it to informa that, let's say, the server is going to shut down in five minutes, etc. She thinks this can be accomplished by a program she hasn't yet seen, so even when the user's PC is off the message is waiting. Just...

Hey everybody! I've successfully sent email messages from within an Access form using the Outlook.Application object. Now I'm interested in sending ICQ instant messages using an Access form and a button. Does anyone knows if this can be done? I haven't found the ICQ object and properties to set...

I need to make a VB 6 program to show some Access reports so that I don't need Access. This is because we want to give away information in a CD with the same format used in Access, but most of the clients don't use, nor have Access in their computers. So, my boss thinks I should make a VB EXE...

I've worked with data reports in Access for a long time. Now, my boss asks me data reports in Visual Basic 6. However, the migration seems impossible. The data report in Access has 4 grouping headers to show data hierarquicaly. I've just added a grouping to the Data Environment and a header to...

Help! I don't know to use HTML and Access. I see Access can do HTML, but I can't figure out how to make this: I want to show an HTML table with a key as a first column and a Key description as the second. Then, if the user clicks on the key, all the records with the same key are displayed...

HELP! I can't find any info on how a synchronous modem works. I need to talk to my classmates in my MS class today about these devices but the only thing I've found is synchronous comms. Anyone can help??? To boldly code, where no programmer has compiled before!

I have coded some functions I believe you'd want to use. They're all related to strings. One of it, IsSeparator(Char) returns true if the current character is a separator included in a list. Separator can be ,.:;/?" and space. The list can be edited to add or substract characters. This...

I've migrated to Access 2K since it has the capabilities to make a Web Page to access data. But I want to make a sort of a control panel, the way I used to in Access 97 but not to avail. I don't use the control panel manager included since my needs go beyond the functions included in it. So I...

Is there anyway to make an EXE from an Access Application? We hate the idea of migrating to Visual Fox Pro and we don't want to recode thousands (ok, hundreds) of lines to Visual Basic 6.0 not to mention about a hundred reports. Any idea? And also, is it true that Access 2000 can make all the...

My boss says SQL Server is what we need to access the data in the company's server to make an intranet. Aside of a poor project planning, he claims it is the base of the intranet. But I say we can make the data recovery through hyperlinks. Can anyone explain me how can SQL Server help to make an...