Hello, i'm very new to both VBA and Access in general so this may come across as a stupid question.
Basically I have a form which is intended to run a file through a programmer to program IC's. The specific file will vary occasionally.
I have already got the part of the form working which starts up the file and routes it through windows Command line, this part is fine.
But the bit I am a little stuck on is I want to have a seperate button on that form which will simply open "my documents" or somewhere else on the server. This is so that I can select the different program files when neccesarry. This is all. From there i'll try and work out a way have my other button open the selected file each time as opposed to a fixed file name.
So is there any code or techniques to simply have a button open up the file directory window?
Again this may or may not be the simplest question in the world, but I really dont have a clue.
Any help at all would be much appreciated. Thanks.
I'm not a VBA expert but from your question i understand you basicly want a dialog that shows files from a directory so the user can select one. There's a standard dialog for this in windows. Search in the VBA help for 'Open file' or 'save file'.
I don't mind that English is not your first language, but when I ask for more info, I am telling you that what you told me is not enough for me to help. Don't repeat it, I can read. Actually try to answer the questions I asked, or I just cannot help.
Driven to the arms of OSX by Vista.
Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
I need to design my own control by combining panel and richtextbox control in vb.net. I hav googled to find abt combining two custom controls but found nothing relevant. Can anyone plz tell me how to start this?
I am using VS.net 2005. I hv created reports using 2005 and crystal reportviewer for displaying reports. Report displays fine but it displays very slowly. I mean to say, for a normal rpt where there is no calc also it takes 3 to 4 mins to display. Whereas the display rate is fast as compared to client machine.
Any specific reason about it?
Solution will be highly appreciated.
Is there a way to use data that is created from a combination of the current DataGridView cell and a math function carried out by vb, to enter the new adhoc data into the cell and refresh the datagridview to reflect this new data combination?
I haved used a VLOOKUP to select the field i require, however i need to select all fields that appear in this column and put them in a table. VLOOKUP will only selects the first cell in the column where this data appears. How can i get it to loop round all of them?
Last Visit: 31-Dec-99 18:00 Last Update: 29-Sep-22 23:34