Search results

Hi, is it possible enable and disable a usb port via vb? An example of using this would be if I had a light plugged in a usb port and the code would turn it on and off. Thanks

I am using Access 2003 as a front end, and SQL server management studio 2008 as back end. I recently migrated the data from Access 97 (where the tabbing order worked fine). In 2003 I have a problem with the tab order. If the user presses enter I want it to skip to the textbox in the subform...

I have a database with Access 03 as the front end, and SQL sever 2008 as the back end. I have a form, which uses a query - named 'visit_main' as a record source which used many linked tables, here are 3 example tables it uses: Visit Visit ID (PK) Date of visit PtID Demographic ID Tests...

Dim rst1 As DAO.Recordset Dim rst2 As DAO.Recordset Dim strSQL As String Set rst1 = CurrentDb.OpenRecordset("HtoROrignial") Set rst2 = CurrentDb.OpenRecordset("subfolder") Do While Not rst1.EOF Do While Not rst2.EOF If rst2("Fname") <> 0 Then strSQL = "INSERT INTO...

dim filename as string Dim strSQL As String filename = Dir("Y:\Document_name\test.doc") strSQL = "INSERT INTO tbl_filename (filename) VALUES ('filename')" DoCmd.RunSQL strSQL Hi, above is an example of the code I am having problems with, it is currently entering 'filename' into the table...

Hi i was just woundering if anyone has seen this before, and if so could you explain what it does. Thanks Const strcJetDate = "\#mm\/dd\/yyyy\#"

Hi, I am using send keys to password protect an excel document. Here is the code once the spreadsheet is open: With oXL .Visible = True .Workbooks.Open (sFullPath) SendKeys "(%F)(a)(%l)" SendKeys "g" SendKeys "password" SendKeys "{ENTER}"...

Hi, in the database I am working in, there is a function, in a moduel, which puts the first letter in the first 2 words in uppercase (used for a name), e.g. john smith would become John Smith. I want the code to work for more than 2 words (the number of words will change). How would I addapt...

I am currently running all of my databases off Access 97. We want to move all of the information over so that it is stored on SQL Management studio 2008, but will run off the access 2003 interface if possible. What is the best way to do this? Are there any tutorials, or programs out there...

I am trying to convert the date in a table (table name - 2009-2011 event records) with the field name 'Date of registration' with the data type numer and layout YYYYMMDD, into DD/MM/YYYY, does anyone know the code to do this please? I have tried other codes off the internet such as...

I have wrote up an example of the problem I am having: The following forms are on the database: Frm_Main_Menu Frm_Search_Customer Frm_Customer_Details Frm_Add/edit_Customer_Details From the form Frm_Main_Menu there are links to, the form Frm_Search_Customer, and to the form...