Search results for query: *

Thanks everyone who has responded. Very much appreciated. I felt silly asking the question but I'm very happy you took the time to respond. Also, from my research since I posted my question, DAO is the best when working with Access as the back end.

There is much discussion/debate about whether DAO or ADO is best for a multi-user split database. Basically, before I get into that subject too much, I need to clarify what I'm using. I have been declaring recordsets as "As Recordset" rather that "As ADODB.Recordset" or "DAO.Recordset" (and to...

Glasgow, Try using For..Next to type the characters one by one e.g. For i = 1 to Len(string) Sendkeys Mid(string,i,1) Next i

I have a project which draws graphics (such as circles) to a picturebox control. This works fine. The width of the picturebox control is set to 15,840 twips which should be 11 inches which is wider and longer than the A4 pages I'm trying to print to. I want to print the picturebox contents over...

Thanks very much for your response. The suggested solution doesn't actually work for the file type input element but the code you gave me is a much better solution for filling out the the other input elements on the web page. Previously I was getting the code for the web page and inserting the...

I am writing a program which takes info from a client side database and fills in a PHP form. There is no problem with most of the common text input elements. However, one of the elements is a file upload input type. My program simply rewrites the code of the webpage to add the appropriate...

Go to thread222-672384 in this forum. I had the same problem.

Sorry for the late reply. Thanks very much. I have eventually made this work. I initially had trouble making this work as I didn't know how to register the library types but I found a program "VBRegTLB6.exe" at vbaccelerator.com which works perfectly.

I have inserted an image control on a form. Showing the initial image when the Form is loaded is not a problem, however, I want the image control to do a kind of slideshow through a series of jpgs. I can do this in pure Visual Basic 6 using the timer to successively load new pictures but when I...

I'm also interested in saving the current web page programatically (where the user is not prompted) but I can't make the suggested solution work. My project does not seem to recognise the IPersistFile. Do I need some other resource loaded into my project eg dll?

Maybe the engine should be 4 eg db1.Open "PROVIDER=Microsoft.Jet.OLEDB.4.0;" & _ " Data Source = " & App.Path & "\databasename.mdb;Jet OLEDB:Database Password=YourPassword;" I don't know though as I am just learning myself. This works for my Access 2000 database...

On a form I have a Picture which I want to drag URL's to from Internet Explorer then use the URLs in my program. To do this, I use the picture's OLEDragDrop event which works fine except that the OLEDragDrop event only gets triggered when I actually click the picture and not when I let the mouse...

Thank-you, Tim. Excellent!

I don't know if was imagining things but one thing that helped when I had problems some time ago with the calendar control was to delete it then replace it with an identically named calendar control. Some code I'd written had passed a null value to it and it seemed to get stuck on that null...

I hope this will help. I had a similar issue which was driving me nuts. I wanted the calendar to default to either (a) today's date if the date field of my table was null (empty), or (b) the value of the date field. It wasn't working but I realised I'd set the "allow edits" property of...

I hope this will help. I had a similar issue which was driving me nuts. I wanted the calendar to default to either (a) today's date if the date field of my table was null (empty), or (b) the value of the date field. It wasn't working but I realised I'd set the "allow edits" property of...

Thanks very much. Would that mean that I would also have to redefine the relationships between all the tables? So basically, after relinking it I should disable access to the database window before I distribute the application?

I've created a password protected Access 2000 database then split it so I've got the forms, reports and code in a front end database and the data tables are in the back end database. However, it is now possible to open the back end database without a password and access the data. I tried adding...

Thx kenndot. Much appreciated. I'll give that a go. I've got a trial version of Install Shield so I'll see if that works and trying it on a different machine should tell me something.

I'm trying to compile my program into a setup file which I've done but when I try to install the program I get the message "The system could not locate the file 'C:\Windows\Temp\mfstqws.pdw\ST6UNST.EXE' (being the uninstall file). What's strange is that (a)I've been developing this program...