Recent content by a.phillips

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

If anyone requires more information to answer the question, please ask.

Hi, I agree with you that if I set focus to the other subform, the focus should go to whatever object has the tab index of 0. But it doesn't, therefore once it set the focus to the correct object, but it doesn't seem it be working. The problem only seems to be when tabbing from the first...

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

One problem, you said that the data for tests and lifestyle needs to be done as subforms in the visits form. I know that this would work, but the form uses a tab control, and fields from one table would may be in diffrent tabs, therefore would need to be in diffrent subforms (or the same...

Sorry, i got mixed up due to them just been exampels, tests is in a subform, and lifestyle has textbox directly on the main form. Yes your right, the query is read only. Thanks I'll have a read!

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

Thank you. I dont require the code yet .. but would it be possible to delete the file from one of the folder (sub-folder) IF it says exact match? Also can you give me some advice on the best way to develop my skills in vba? I have been using it for a while but still dont fully understand...

Thankyou, that is much easier and very useful! You have saved me a lot of time.

Also, in the SQL string in this part of the code: If rst2.NoMatch Then ' If no match is found do this strSQL1 = "INSERT INTO Subfolder (notes) VALUES ('no match');" DoCmd.RunSQL strSQL1 isIdentical = False matchingFileFound = False What is the best way to say where...

Nanscombe, I understand the code you wrote and it does seem good, but I am getting an error on this bit of code: strSQL = "FName = '" & rst1!FName & "'" isIdentical = True ' Look for an occurrence of rst1!FName in rst2 rst2.FindFirst strSQL It is the bottom line of code that the error...

Thank you, this has been very helpful, I will keep you updated on my progess. Thanks again

Ok, so basically I am comparing 2 folders, to see which fiels are the same, so duplicates can be deleted. There is an update button which gets: The file name Modified date and size of each file in a folder and puts them in 2 seperate tabels. I need the code to compare the data in all of the...

This is what it looks like in the query, but I understand why it is doing this. I would prefer it all to be done in code if possible

Thank you very much for that code, and it seems to work in the imidiate window, but I think i still need the SQL part in as I need to update the notes section on that table. When I uncomment the SQL section it brings up the error complie error, argument not optional, any thoughts on this.