Recent content by clayton74

Hi All I have been asked if we can move our Access database to SQL.I have tried importing using Import within SQL this creates the database tables but this does not copy across any primary / foriegn keys that are on the tables. I tried Access upsizing wizard in Access and this creates keys but...

Hi Everybody Hope someone can help me, I am new to visual basic and need a bit of help. I have imported some data from an excel sheet into a datagrid, what I am struggling to do is to pass this infomation into an sql database, I already have the table created called ImportInfo and the database...

Hello All I am trying to create a form that requires authentication from an SQL login to access I have a form with a username textbox and a password textbox and I am trying to allow login ' Open a connection by referencing the ODBC driver. cnn.ConnectionString = "driver={SQL Server};" &...

Thanks Andy

Hello All I have a little program that will email a user once a new XP account has been created. I have a problem with the attachment, this is dependent on the creator having a drive mapped for them to email the attachment. My question is there a way of embedding a word document into my project...

Hello All I have created a short script along the same lines as MrMilson but I was wondering if there is a way I can attach a document to send with the email Your help would be appreciated

Have you tried creating a new admin account with a password, to see if the problem is profile related

Thanks for help, I have managed to sort it out by putting a picture box in

Hello Thanks for your reply I want to be able to draw by hand, very simular to MS Paint Thanks

Hello I am very new to VB6 and have a question. I have a form and in the bottom I wish to have a small 4" x 4" ms paint or equivalent screen, I want to use it along with a basic maths form I have created so my kids can use this to work out the maths question. Sorry for the newbie question

Hello Providing the computername as \\computername Many thanks

Hello I apologise for asking a silly question before I ask it. I have a bit of script, and what I am trying to do is open Internet explorer and input a computername in the address bar, so I can use this as an option to search a users drive. Unfortunatley explorer.exe does not work as it is...

Hello All I have a problem, I need to export data that is stored in AD in the notes tab into an excel sheet. I have searched everywhere but I am unable to locate the code to export the data. Can anybody help me

Many thanks JRBarnett worked well, may I ask another question How would I show the mail before sending, I have the following in my project as a test but would like to view the compiled mail before sending Dim oOutlook As Object Dim oItem As Object Set oOutlook =...

Hello I am new to VB6 so sorry for any dumb questions I have a form that users will enter data, what I need to do is to press a button it will open a new mail using Outlook with the data in the body of the message. I am not expecting anybody to do this for me but I require guidance :) Many thanks