Search results for query: *

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};" &...

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

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

Hello All I have a problem with explorer.exe, when opening windows explorer a couple of times it hangs and takes an eternity to display the drives. The same happens when I use run and navigate to drives that way (i.e \\home\g). If I stop and restart the process it will work OK again for another...

Is there a way of enabling auto-complete to complete anywhere in the excel sheet If I put hello in cell A1 I want to be able to autocomplete when I begin typing in cell C9 Any help would be appreciated

Hello We have group policies in place where internet options are disabled. Is there a way we can view/ammend internet options while logged on as the user using an admin account. If I use runas it seems to give me internet options for the admin account and not the user Unfortunatley we cnnot...

Hello I have a script that lists disabled users in AD, what I am after is to export the list into a text document Can anybody help please Const ADS_UF_ACCOUNTDISABLE = 2 Set objConnection = CreateObject("ADODB.Connection") objConnection.Open "Provider=ADsDSOObject;" Set objCommand =...

Hello I was wondering if therre is a SQL command to view the details of a table, column name, data type, length, allow nulls. I use to have code but I have mislaid it. Any help would be grateful

Hello All We have a problem that you may be able to help with. We have users who have been given new laptops, we also had a script that ran and copies the user local profile. Unfortunatley some users had encrypted there docs and the script failed. Is there anyway apart from been the user or a...

Hello I have a Easynote H5264, one night I powered it off and the next morning I tried to boot it up and all I get is a black screen. The unit powers on but I get no beeps or activity from the HD, it sits there, can anybody guide me in the right direction for finding the fault please

hello I am new to dos batch files, and I was looking for a bit of help. I have been looking at the runas command. I am able to run a simple command line "runas /user:kids\admin "notepad.exe" by running from the cmd prompt but if I put this in a .bat the batch file continues in a loop not...

Hello Is there a command line to start the run window please. Unfortunatly the run window has been locked down and to save me navigating through using the command line I would like to use the run window (changing or halting the policy is not an option) Many Thanks

Hello I have a problem, we have users that have had there machines locked down by Group policies, we have no way of changing the group policies and we need to use the run option but this is unavailable, the command prompt is also hidden. Is there another way of starting the run option. I have...

Hello All We have a group mailbox and we want to move the mail that is received into the Outlook Inbox after 16:00 into a subfolder called OOH. At present we are doing this manually but this is a problem after 22:00 as nobody is available to do this. I have had a look and cant find how to...

Hello All We have a group mailbox and we want to move the mail that is received into the Inbox after 16:00 into a subfolder called OOH. At present we are doing this manually but this is a problem after 22:00 as nobody is available to do this. I have had a look and cant find how to accomplish...