Visual Basic :: How Can I Save In Run Time Back To Access?

How To: Save Uniqueidentifier Back To SQL Server 2000
Dear all,

I'm writing an VB6 application to retrieve an uniqueidentifier from table. Then I update this uniqueidentifier to another table in which one of the columns is also an uniqueidentifier type. The update succeeds but the content changes and the uniqueidentifiers are not the same.

Does anybody has idea to update uniqueidentifier column thru VB6. I know that there're uniqueidentifier datatype in VB.NET. But for this case, I need it in VB6.

Thanks in advance.

Let's see my configurations...
App: VB6 /w SP5
OS: Windows 2000 Standard /w SP4
DB: SQL Server 2000 Standard /w SP3a & DTS Package

Edited by - ferguscham on 9/19/2004 8:40:32 PM

How Do I Save 3 Textbox As A .txt File And Then Load Them Back Into The Same Textboxs
How do I save the stuff in 3 textbox as a .txt file and then how to load them back into the same textboxes?

this is what I have so far
Private Sub Command1_Click()
With CommonDialog1

.CancelError = False
.InitDir = "C:Documents and SettingsAdminDesktopCV creator"
.Filter = "Text Files (*.txt)|*.txt|"
.ShowSave
End With
Open CommonDialog1.FileName For Output As #1
Print #1, "text1:" & text1.Text
Print #1, "text2:" & text2.Text
'etc
Close #1

End Sub

How To Save Text From Multiple Textboxes/loading Back
Hi, I'm a total newbie because I'm mechanical engineer by profession,

I need some help:

I have :
txt1.Text
txt2.Text
.
.
.
txt9.Text

I need to save all this values into a single file (i can do this already using the CommonDialog) and then LOAD the file, read the values and reassigning/display each to its respective textboxes. ie

txt1.Text = ???
txt2.Text = ???

I don't know how to do the open/read/assign part.

Basically I'm just trying to add a 'save all input' and a 'load input from file' function in my program.

How do i do so? Simplest possible way please. Thank you.

If This Is The Code To Load A Listview From A File, How Can I Save It Back?
VB Code:
On Error Resume NextStatic z As IntegerDim temp2() As Stringz = 1Open App.Path & "db.txt" For Input As #1Do Until EOF(1) Line Input #1, temp temp2() = Split(temp, ",") LV.ListItems.Add , , temp2(0) For i = 0 To 5 LV.ListItems(z).SubItems(i + 1) = temp2(i + 1) Next z = z + 1LoopClose #1
Anyone know? each column is on a new line, and each row is seperated by a ","...

How To Make VB Go Back In Time??
When in debug mode, and stepping through the code line by line, how do you make it go back up a line please?

I saw this used by an instructer in a course, but can't remember what he did!

Cheers!

Paul.

How Do I Set The Time Back To Midnight?
I am writing some SQL scripts in SQL SERVER7.

Having used Oracle PL/SQL for my entire career, I am in the process of having to learn quickly.

I've done okay, but I can't figure out how to set the time component of a datetime to midnight (that would be 00:00:00.00 right?).

What I want to do is specify a date (for example GETDATE() or GETDATE() - 1), BUT I need the time to be midnight so that I can then add or subtract time from there.

Can someone write me a sample line that I could try out.

I'm really at my wits end......

Thanks,
dina

Back Ground Change On Run Time
Mambo vipi jamani? I've a image component of my form, what i want to do is, be able to change the background while the form is on run time. If possible, using a commondialog box to open the image files(.jpg, bitmap and all suported files.)

Sending Shape To Back During Run Time?!
In my program, when an option button is clicked, a shape is drawn and a lable goes ontop of it. When I desighn the form, I can set the label to transparent background, and all you see is the text and the shape behind it. In my code however, when I try to get the same effect, it doesn't show the text, no matter if I put the text on the from first, or after I draw the shape, all you see is the shape. I need help please, any would be great!

Converting Double Back To Time Format
Hi I would like to find out how i can convert a double back to time format. I know how to convert time to a double.
When i convert 01:00 to a double it gives me this answer: 4.16666666666667E-02 When i try to reverse it suddenly a 01:00 becomes a 01:10

The formula i use to convert the time is
((Hours * 3600) + (Minutes * 60)) / 86400

pleas help?!?

Access 2000 Front End With Access 97 Back End
Hello,

I was wondering if anyone knows or has experience with this scenario:
I have an Access applic written in Access 2000. This is the front End. The Front End is connected to the Access 97 Back End. Does anyone know if there is a significant differene in performance with respect to this scenario instead of using an Access 2000 Back End? I can not test this at the moment.
Thanx.
Johan

How Can I Clear All Val. In A Form So Next Time It Opens All Values Are Set Back To 0
I have an order screen that is on a from but I want it to be able to close after an order is taken and when it opens back up to have everything cleared and set back to 0 or "".

I know I can do that by doing a form.hide and form.show and setting all my textbox's back to "" and clearing my listboxes...
But I was hoping there would be any easy or better way to do this since I have about 30 things in it that will need to be cleared...

It's an MDI Child fom if that helps called frmOrder

Is There A Way I Can Time A DesignMode Session, To Revert Back To NORM, In 5 Minutes?
Is there away that I can execute a timer when I switch to the design mode and have the timer set for 5 minutes to revert back to the regular Mode? I'm going to have the macro attached to a tool bar button. I've written such a code before, but can't find it. I remember how to do most all of that, including switching back to normal mode, but I NEED THE CODE, to switch to Design Mode.. My way of getting back to norm, is not real pretty, to think about, but it works just fine. - As I said, I just need to know how to get in, with code. - It is fine with me, to switch to the design Mode, with the DesignMode tool bar button, if you know of a way to have a timed return to normal, that is triggered by that action. I know how to run a timer as a seperate action, that will revert me back, but the problem with that is, I might forget to trigger that proceedure, as I won't be forced to.

The resaon that I need this, is so when I make a quick code modification to a users workstation, I won't have the possibility of getting caught in a DOWN MODE, cued by me forgeting to switch back to the normal mode. - instructing my user's on how to, is not full proof, as a few tend to forget how, and end up loosing considerable time with their tasks. (stuck in a mode(ha, ha) of being too embarrassed to ask for help.

Thanks from: TboltFrank, for any and all Knowledge and/or ideas(-:

Access As Back-end
hi fellas,

My boss asked me to implement a new local netowk vb application, which using Access as back-end(basically, the senario is there are 4 computers in the local network, and one within Access DB will work as back-end and others 3 will retrive data and upload data to the DB. so, my question is how to do it and what could be the limitations for this application?

Thanks in advance!

Can't Get Back Into Access
I have a access 2000 database that locked up on us. When we rebooted and tried to get back in, Access said that it needed to repair the database. But when we click "Yes" to repair, it tell us that the password is incorrect and won't let us in. Any help out there?

Bill

From Access To Excel And Back Again
I am relatively new to vba and I think that the questions that I have are probably pretty easy. I am writing a progam that will take data out of an access db and bring it into an excel spreadsheet. The access db is created in AutoCAD and has a whole bunch of fields, most of which don't concern me. One of the fields is a node index, which is a unique Id for each node. I need the users of my program to be able to select one or more runs (which are made up of many nodes) from a dropdown list. There is a field for run names also, which I think will be helpful to select the appropriate records. The selected records need to be brought into and existing excel template. I only need to bring in five or six differnt field values for each record, and I need them to go into the appropriate cells in the template. After the data is brought into excel the users will modify it. I then need to get sent back into the appropriate spots in the access db so that AutoCAD can use the modified data.

My major questions are:
1. How can I select the data from access from only certian fields that have the same run name. Also when the data goes into excel the it has to be sorted by highest node index number to lowest

2. How do I rearange the data to go back into access, or can I somehow use the node ID number to reference the record which the data is supposed to go into.

I have attached a database and the template if that will help.

Thanks for any help

From Excel To Access And Back
I'm no programmer, just trying to do stuff for the first time. I figured this should be easy but after a few hours trying with the "help" topics, I just can't do it.

I need Excel to make some complex calculations on values stored in in an Access Database.

I started with a very simple example to learn how to do it. I succeeded in opening an Excel File and putting numbers in a cell.

But, I am just not able to get a value from a cell and storing it in a field of the Access Database. This is the code I have in a command button in n Access Form.

Private Sub calculer_Click()
On Error GoTo Err_calculer_Click

Dim oApp As Object
Dim fichex As String
Dim result As Single

fichex = "C:Mes DocumentsFontainelogiciel de prixEssaisbox2.xls"

Set oApp = GetObject(fichex)
oApp.Application.Visible = True
oApp.Parent.Windows(1).Visible = True
oApp.Worksheets("Feuil1").Activate
oApp.activesheet.cells(2, 2).formula = 100
result = oApp.activesheet.cells(3, 2).Value

Recordset("données").Fields![surface].Value = result

IT IS THE ABOVE LINE THAT DOES NOT WORK !! tHE MESSAGE I GET IS THAT THE ELEMENT WAS NOT FOUND IN THE COLLECTION.

'Only XL 97 supports UserControl Property
On Error Resume Next
oApp.UserControl = True

Exit_calculer_Click:
Exit Sub

Err_calculer_Click:
MsgBox Err.Description
Resume Exit_calculer_Click

End Sub

I am sure someone can help me.

Thanks,

Marc

How Do I Get A Value Back In Access Using SQL In The VBA Code?
Basically, I this SQL statement in oine of my VBA subs

Code:
"Select MAX RenewalDate from tblTransaction where tblTransaction.CERT_NO = " & rst!CERT_NO
And I want the field I get from that SQL to be assigned to a string variable called DateHolder. Is there a quick and easy way to do this? I just can't find the syntax to do this.

How To Back Up An MS Access Database?
Well that is a very newbie question. But I need to be 100% sure on this. I did a basic search on the forum and I didn't find any help. Due to the latest rumor/news that a worm is circulating around, I need to make a back-up of a MS Access Database for a friend. They don't even know what version of Access they have or how big is the db. I looked up Google and i think I might have found it.

Here's what I know:
Their db can't be that big since the company isn't that big. I mean if they are a big company, they should have an IT Dept. to do this kind of work.

In order to back-up the db, no user or program must be using it. Pretty much close the db. Copy the desired db and paste it to the back-up disc or drive (same thing as making a 2nd copy of an ordinary file).

if they are using user-level security, I should make another copy of the workgroup information file. Problem is that I don't know what that file is. i dont know what is the usual name of the file, where is located or what the file extension is. *edit: Well i figured out that the file extension is .mdw

Well any help/comment is gladly appreciated.

Mshflexgrid Back To Access
is there an example where the data in mshflexgrid can be exported back to a new table in access? any sample / help would be appreciated. thanks... newbie here.

Back Up Access Data From VB
Hi there.. I want to back up a Access database(.mdb) to a diskette from my VB application. the database is 300kb and does not grow but changes everyday..

thanks
Jacques

Access Front-end - Back-end With ADO Connection!
I have an Access 2000 database named orderentry.mdb split into also orderentry_be.mdb. I know that if I have multiple clients that want to use a single Access database I need to setup front-ends with each computer linked and connected to the back-end.

In the past, I originally made a Visual Basic program that connected directly to the back-end with ADO. It was fast and worked well!

Now in the present, I tried to make my VB program connect to the front-end with ADO. It now works 3 times as slow! Did I have the connection right in the first place? Should I have everyone connect to the back-end like before or will it make it slower?

Any help is appreciated = THANKS A BUNCH!

Sincerely
Stephen

Back Up Access Or Sqlserver Data From Vb
Friends
I have developed a program which is connected to the database.
now i have one form in that i have placed one command button.
if the user clicks the command button the backup of the database should be taken and it should be saved automatically in the current folder.

is there a way for the above???

thanks
sathysudha

Back Up Of Access File Zipped.
Gurus,
To take a back up of the Access file (Database File), the logic I followis that I copy the entire database into another location

ex. app.path/DataBank/myMdb.MDB has the master database is copied intoapp.path/Backup/myMdb.MDB

Now after the back up is copied I want to zip the file

app.path/Backup/myMdb.MDB
using winzip

How To Back Up A MS Access DB Using VB Code And Using Pkzip To Zip It
How do you use pkzip in VB to zip a database and then save the zipped dB to the a: drive??

Access Database Back-up From An FTP-server...
Hi...
I have a problem... I am currently making an web-application using ASP.Net... It's has got a very simple, home-made chat function on it... When new users wants to register they have to fill in a form, the information from that form is then saved in a recordset/table... Does anyone know how to access an Access 2003 database on an FTP-server (with user-id, and password), and change the information in this.. Alternatively, I would like to be able to download the database to my own hdd (and to upload it back to the server), 'cause then I could easily manipulate the information in the database... I am using Visual Basic 6.0

Any answer would be very welcome...

I would do something like this to access my db on a local machine (please tell me if, what I am currently doing is "wrong", 'cause I've seen people do it very differently on this site... (it works fine though)):

CODEStart up module:

Public sub main()
Dim dbfBrugere As Database
Dim tblNyeBrugere As Recordset

  Set dbfBrugere = OpenDatabase(App.Path & "rugere.mdb")
  Set tblNyeBrugere = dbfBrugere.OpenDatabase("nyeBrugere")

  tblNyeBrugere.MoveFirst
  'And then whatever code I need to
  'manipulate data in the individual forms.

Adding Security To A VB App With An Access Back End
I am looking for some advice on how to get started in setting up security for a VB app that I have developed. Using VB6, I want to capture the user's WinNT login Id and compare it against a user list in the Access DB to determine whether access should be granted or not.

Any help in getting started would be great. I can capture the WinNT/2K Id but I am not sure how to use it to secure my app.

Thanks,

soups

How To Back-up And Restore Access Database Using VB6?
I want to backup and restore MS Access (XP) data base using the visual basic6.0. User has to perform both these operation through the front end. I am using VB6 and ADODB connecion to connect to the Access. And also i want to back-up and restore the log files of the same data base. and also pls tell me how to compact the data base? I need a full code for these prolems? I hope a favourable response from u all.

Comparison Of MS SQL Server With MS Access For Using As Back End.
What are the advantages of using MS SQL server over MS Access for using as a back end?
Can you please send som cases where only MS SQL can be used and not MS Access?

muralirajan

Is A MS-Access Back End Royalty Free?
Hi all,

I was wondering if a back-end written in MS-Access would be royalty-free.

I found a few posts on this forum mentioning that it is but no real proof or source to check. I searched the Microsoft site as well. It is not mentioned that it is royalty-free.

Does anyone know where to verify?
Cheers,
Laurent

Back Up All Access Database's In The Apps Root In VB6
Hi All,

I would like to back up all the Access databases that may be in my apps root.

Until now I have been working from 1 single database but have now updated and the user can now create new databases when running the app.

Since I wont know what the names of the databases are that the user creates Im not sure how to back them up?

Here is what I have at the moment, this works fine for the single known database, can anyone help me use some kind of wild card to save any access.mdb in my apps root.

Many thanks
C

Code I have at the moment

Code:
Dim BackupDir As String

Dim fso As Object
Const file = "MYDB.mdb"
On Error GoTo errHandler
BackupDir = App.Path & "Backup"
If Len(Dir(BackupDir, vbDirectory)) = 0 Then
If MsgBox("Invalid Directory Location. Do You Wish To Create This Directory?", vbYesNoCancel, "Warning") <> vbYes Then Exit Sub
MkDir BackupDir
End If
If Len(Dir(BackupDir & file)) > 0 Then
If MsgBox("File Already Exists. Do You Wish To Replace It With The Current File?", vbYesNo, "Warning") = vbNo Then Exit Sub
End If
Set fso = CreateObject("Scripting.FileSystemObject")
fso.CopyFile datapath, BackupDir & file, True
MsgBox " Files Have Been Saved", vbInformation
ExitSub:
Set fso = Nothing
Exit Sub
errHandler:
MsgBox "Backup failed: " & err.Description, vbCritical

Developing Vb 6 App For Terminal Services With MS Access Back End
Hi

I am developing a visual basic appliction for which i need initial guidance. what i want to do is to install the application on the remote server and then provide the same eve file of the app to all the user , so that they can access the application at the same time. for this i am thinking of a standalone app.
But i am a bit confuse about connection and record sets.

There level of openeing( Private or public), at form level or module level.single record set at module level that recieve queries from all forms and then execute them or declared record set for every form.

and the connection (private or public) for each form or a single connection for whole application.

i am new to this , so plz help me out

Getting Menus Back In Access Security [Not Resolved]
Hi Team

I'm working on Access security.

Currently the autoexec macro calls a function to set the database security properties such as "AllowFullMenus" and "AllowBypassKey" to false. This works fine.

I have an admin button that resets the db security properties to true and displays the Database window by calling DoCmd.SelectObject acTable, , True. This too works fine.

But even though this button sets the DB properties such as "AllowFullMenus" and "AllowBuiltinToolbars" to true, I do not have the right click menu, I can not get back the any of the toolbars, and f11 does not bring up the database window.

Does anyone know what I'm doing wrong?

FW

Writing Data In A Datagrid Back Out To Access In VB6
Hello everyone.

I have a small database with less than 1000 records composed of 6 fields. I am able to display the entire database (with scrolling) in a datagrid in VB6. I am also able to modify any of the fields within the datagrid. My question is:

Is there a way to write the entire Datagrid back into the Access Database as a whole?

Any help with this would be greatly appreciated.

VB Front Access Back End. Connectivity Prob
Right now I am only adding to a table tblAddasset and nothing else. Maby someone can help me out with what I am missing.

In my declarations I have
Dim conn as New ADODB.Connection
Dim rs as New ADODB.Recordset
Dim Cmd as New ADODB.Command

Then in form load I make a connection as follows
Conn.ConnectionString = "provider=Miocrosoft.Jet.OLEDB.4.0;" &_
"Datasource="cproigramfilesDB.mdb"
conn.open

.Then I want to use the Add Item button and use code below

'to check my connection I use
1.If conn.state = adstateopen then MsgBox "Connected"
2.cmd.commandtext = "tblAddAsset"
3.cmd.commandtype = adCmdTable
4.Set rs = cmd.execute
5.if Not rs.EOF then rs.MoveLast
6.rs.AddNew
7.rs.Fields("name").Value = txtNAme.text
enter other fields as well
8.rs.update

What happens when I run this is I get the message box telling me I am connected but then i get an error message as below
"The connection cannot be used to perform this operation. It is either closed or invalid in this context." I debug at line 4 above.
IF I Ommit this line or comment it out I then get the error
"Operation is not allowed when Object is closed" for line 5.

I dont understand because MsgBox is telling me a have an open connection
PLEASE HELP ME!!!

Back With 2 Listboxes In MS Access - Exchange Items
Hi everyone,

I am developing an applic. usng ms access 2003.
Lastly, I opened a thread for help about using listboxes for selecting and unselecting items by moving them between lstAvailable and lstSelected.

I stroke the solution with the help of various co-form members.
I am back with this same situation where I have a little problem..

When you see the attachment printscreen graphic, you will see that i have an error occuring with the following red code in fact:

' open the recordset.
'MyRS.Open "qrySelection", conn, adOpenDynamic, adLockOptimistic
MyRS.Open "qrySelection", conn, adOpenDynamic, adLockOptimistic

With MyRS
If .EOF Then
MsgBox "No item found to move.", vbOKOnly, "inforGT"
Exit Sub
Else
' find the record for the selected item.
.Find "StaffCode = '" & SelItem & "'"
' set the Yes-No_Fld of the selected record to "Yes".
.Fields("Selected").Value = "Yes"
.Update
' make sure the list boxes have the current values.
Me.lstAvailable.Requery
Me.lstSelected.Requery
End If
End With

If anyone has the strength to help me gaain, thanks a lot.

How To Save And Access Images, Sound And Video Files In MS Access Database.
How to save and access images, sound and video files in MS Access database using front end as VB.

Can anyone help me ?

Thank You.

MSAccess/VB Help With HTML Code To Send Data Back To VB/Access
Hi

I'm using MS Access and Access VB to build HTML pages on my local 'intranet'
from blocks of code/text stored and calculated in Access. What I really need is some code and means by which the HTML form can communicate back to the main application (VB or Access). Could be as simple as updating a flag that user OPER99 opened/viewed page REPORT123(.html) at 01:30. Also need controls so when clicking on buttons/images their choice is sent back or stored for sending at a conclusion.

I'm struggling with some bits but would be interested in some fresh opinions.

Free Scroll Access To The Back Window ( Grid - ListView)
hi all ,

here is one more question,

can we get free scroll access to the back grid window while the CMD file creation dialogue box is up ?

what i am doing here is i am creating one CMD file ( kind of txt file ) suppose i need to create 100 CMD file depends on the order so after creating one text file it show me the Dialogbox "CMD file 1 is creted" after click on Ok it show me the next dialogbox and i am not able to access the back page is this posible to access the back screen ( window ) in this case ??

thanx and regards ...

Tranfering Variables Form VB6 To Office Access Or Excel And Back
What is the best way go transfer variables form VB6 to Excel or Access
VBA then tranfer them back to VB6?
I have been tranfering varibles from VB6 to office 2000 Access or Excel by
saving the variables to a file on my hard dirve. I would use the VB6 to
save a variable to a file. Later on when I want to use that variable in
Access or Excel 2000 VBA I would open up that same file and read it
into VBA. In this case my variable is a path name created in VB6. My orginal VB6 program may or may not be running when I use that variable in excel
or Access VBA.
This method works but don't know if it is a convential way of doing
it. So what is the proper professional method of doing this task? What
is the most easy way of doing this task? What if someone had a series
or array of variables to tranfer? What would be the best method to do that?
thank you,

Shed Some Light - I Will Give You A Whack On The Back, I Mean A Pat On The Back.
I was about to edit one of my posting but it said tread has been close. Anyone knows why?

Long Time To Save...
Any one know why the *!?* it takes so long to save my Word 2000 template? I have
tried doing some of the suggestions I have found like:

1) export all vba modules, save the project, import the modules, save,
compile project, then save again. It helps a little with the size of the
template, but the macros still execute slowly and it still takes a while
to save the document

2) in a copy of the template that does not have the macros...import the
macros

-----
It takes a long time to save the document, a little bit to open the
document, and it really gets slow when running the macros. Sometimes, it
will run the macros at light speed, then the next time it is run--SLOW!

Mark, if you are around I am still on the same project. As far as the
email thing with the template, I decided to send an email to the user that
has the path to the document, instead of the attachment.

Thanks in advance.

Tired and at the end of the week...Andy

Save Textbox Value For Next Time
Excel 2003 w/VBA 6.3

Have a form with several textboxes in which a user will insert values.
The names of all the textboxes start with "txt", e.g. txtLotNum.
During the course of running the program I purposely "clear" (see below) the values from all textboxes. However, I would like to retain the value of one of the textboxes, so that when the user starts the program again after closing, that value already appears in the textbox on the form. Cuts down on data entry.

Code:
For Each Ctls In frmEasyLyteQC.Controls
If Left(Ctls.Name, 3) = "txt" Then
Ctls.Value = ""
End If
Next Ctls

Long Time To Save
I have what I don't think is to large of an excel file, about 1 meg, that has around 3500 lines of code in it along with 10 worksheets. What bothers me is that when I save the file it takes about 15-20 seconds to perform the save.

I was just wondering if this is typical and there is nothing that I can do about it or does someone know a trick?

Thanks,
Derek

Excel Save Time?
Hello, Everyone:
I have an Excel application running to collect data, which will save itself and also save as copy to backup the data. When the data sheet is almost full ( close to 65536 rows), it needs to about 25 seconds to finish all the process. I don't know whether it is stable, which I means the save time is always around 25 second. And never go beyond 30 seconds. If if it beyond 30 second, my new data will come and cause some problem. Would someone be kind to let me know whether the Excel save time will differ or not. I also have two VB programing running in the same time. This computer is just for this application only.
Thank you very much!
Charlie

Save A Time-variable
Hi,

My Visual Basic project is connected to an Access-database. The user can give in a time in a DTPicker. I want to save this time in a variable and then wirte it to the database. I used a 'variant' variable to store this time-variable.

But in the database is this time saved along with a date. How can I prevent this, and thus let VB save this variable as time without date?

Thanks..

Do I Need To Save My Table Every Time?
Hello, Everyone:
I have a Access data base. Every half second a new data entry will be added to my table. So, do I need to save my table every time? If I need to save the table every time, how can I can make sure the saving process should take no longer than 0.5 second? Would someone be kind to help me out?
Thank you very much!
Charlie