|
Hello everyone,
I have a Visual Basic 6 project that uses an MS-Access database for storage. I want to be able to backup this working database either on demand or at a certain time each day.
What I have in mind is this. Let the user pick where they want the database stored by using a form that will let them choose the drive and folder for the backup. If they don’t choose a folder or one doesn’t exist. The application will create one for them on the desired drive. If there is no existing .MDB file in the folder the application will use the structure of the working database and create a blank one using the same table and field names from the source database. And will proceed to populate the target database with information stored on the source database.
So I have two separate questions:
1. How do I create a folder on a specific drive using VB code?
2. Using ADO create a new database by reading the table structure of the source database, and save it as a new .MDB database file?
Thank you,
Quecumber256
|
|
|
|
|
You can use the FileSystemObject[^] and its CreateFolder[^] method to create the directory.
If all you're doing is making a backup of the entire database, why not just copy the .MDB file to the backup directory? CopyFile[^] method...
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
I'll try this tomorrow. It looks like it will do the trick. I'll provide the drive distination using the drivelist object.
Thank you,
Quecumber256
|
|
|
|
|
Hello,
I'm looking to create a program using visual studio.net / vb.net that will read a .csv file, and then be able to printout the results from a printer.
Can anyone direct me to some articles that will assist me?
Thank you,
Rashar
-- modified at 11:14 Thursday 2nd February, 2006
|
|
|
|
|
Load teh comma separated values into a datagrid and print it with this?[^]
'--8<------------------------
Ex Datis:
Duncan Jones
Merrion Computing Ltd
|
|
|
|
|
Hi everybody.
I'm developing an application using VB2005, (VB.NET VS2005) and how could I
create a Form that Resizes Based on Screen-Resolution and the controls resize proportionaly.? 
In Visual Basic 6.0 I used to loop through the collection of controls.
There is something more automatic and easy in NET? 
Thanks people!
Demian.
"I have always wished that my computer would be as easy to use as my
telephone. My wish has come true. I no longer know how to use my telephone."
-Bjarne Stroustrup, computer science professor, designer of C++
programming language (1950- )
|
|
|
|
|
Demian Panello wrote: how could I
create a Form that Resizes Based on Screen-Resolution
Maximizing the window would be the easiest solution. 
Demian Panello wrote: and the controls resize proportionaly?
You should play around with the Anchor and Dock properties of each control.
|
|
|
|
|
But I have normal windows, (not maximized).
And if the windows fit 80% of screen in 1024x768 I want the same proportion for 800x600.
And the controls should change to keep everything proportional.
Demian.
"I have always wished that my computer would be as easy to use as my
telephone. My wish has come true. I no longer know how to use my telephone."
-Bjarne Stroustrup, computer science professor, designer of C++
programming language (1950- )
|
|
|
|
|
Well then you should change Form.Size in your form Load event handler. You can get the screen's size by doing the following. The code assumes your calling it from your Form code (notice the keyword Me). It also grab the correct screen in case you are using dual monitors.
Screen.FromControl(Me).WorkingArea.Size
As far as keeping your controls proportional, you should set the Anchor and Dock properties on each of your controls in the designer. That way they'll adjust automatically when the form gets resized.
|
|
|
|
|
I am not sure if this will answer your question, but here is a fairly useful article regarding resizing http://www.codeproject.com/vb/net/pflvb7.asp[^]
To address your question more directly, if we assume your development box had a screen resolution of 1024x720, and your application form was 800x600; thus a ratio of 78%x83%. Why can you not get the screen size from the screen object, and set your window size by calculating that ratio?
do you need to investigate an online backup[^] company
|
|
|
|
|
How can i set default property for my own ACTIVEX control.
TEXTBOX is having default property TEXT
TEXT1.TEXT = "HELLO"
is same as
TEXT1 = "HELLO"
How can i do so with my ACTIVEX. Please help me
Yog
|
|
|
|
|
Having default properties is actually considered poor practice. I know MS is guilty of it and went nuts with it in VB6. If the .NET world, that practice has finally been reversed (though it's still supported because of die-hard VB6 people who demanded it). The reson for this is that it is not obvious what the default property of a class is and makes for ambiguous code when it's used.
But, in VB6, this[^] is how you do it.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Hey all
Still working on that AD logon script. I've got everything the way I want it but I cannot find out for the life of me how to pass a variable from vbs to delphi5.
Example:
I want to pass variable UserName to delphi5 as a parameter in a console app. I have UserName = objNet.UserName and after i retreive the username, I then execute the external console app.
Once i begin to execute the console app, I want vbs to pass UserName as a parameter to delphi5.
Any ideas?? I'm stumped
"A child of five would understand this! Send someone to fetch a child of five!"-Groucho Marx
|
|
|
|
|
The Delphi app has to be written to accept a command line parameter. After that, it's easy. Just pass the value as part of the command line to launch the Delphi app.
C:\somepath\MyApp.exe somevalue
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
:-DExcellent. Thanks much!
"A child of five would understand this! Send someone to fetch a child of five!"-Groucho Marx
|
|
|
|
|
is there any method to make end user to just select value from combobox
and not to write any value in it, other than style property since
using style property restrict me to dynamically change selected value depending on some condition using codes
|
|
|
|
|
you could overload the WM_CHAR (not sure about the name), ,but i think that even at runtime, changing the ComboBox properties is still the best thing to do...
TOXCCT >>> GEII power
[toxcct][VisualCalc 2.20][VCalc 3.0 soon...]
|
|
|
|
|
To change the properties on run time
|
|
|
|
|
|
Hello!
My aim is to write a text on a picture box image which is working okay but what happens after drawing is the text is getting disappeared on the image because of refreshing. How could I maintain a persistent text on the image?
Thanks!
Here is my sample syntax:
PictureBox6.CreateGraphics.DrawString(GetLabel, GetFont, GetBrush, SetX, SetY)
Love is not a diversible reality!
|
|
|
|
|
You have to either draw the string to an image that the picturebox is showing or override the Paint event of the picturebox and put the drawstring code in that, so when the picturebox is told to redraw itself, it has the code to redraw the string.
Controls and images are not "draw once and forget about it". The images of controls do no persist themselves. You have to supply the code to redraw the image AT ANY TIME.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Hi, I am inserting current date and time in separate fields for every record inserted or modified. The records are correctly updated in the access database. However, the same is not reflected in the datagrid where the inserted or updated data is displayed. The date appears correct, but the time appears as some date. Please help.
With Best Regards,
Mayur
|
|
|
|
|
I have a chat app that use a webcam. I am taking a screenshot of the preview window in order to get the image. Only problem is, if the window is hidden or say minimized, my images come back as big Black square..ughh
Anyone know how to get the window to keep painting itself when its hidden or minimized?
Any help would be appreciated.
Thanks
-Jason
|
|
|
|
|
Hidden windows never the get told to paint themselves by Windows. You can try sending a WM_PAINT message to the target window handle, but there is no guarantee that it'll work anyway. If the window determines that it, itself, is obscured, it won't waste the time painting those regions.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
how to convert a varchar value into varbinary at runtime
iam using vb 6.0 as frontend and sql as backend
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
