Solved

SAVING DATA TO A VISUAL DATAMANAGER DATABASE

Posted on 2000-04-04
2
151 Views
Last Modified: 2010-05-02
I HAVE A DATABASE WITH THE FIELDS "SURNAME", "NUMBER",M AND "ID", AND WOULD LIKE TO KNOW THE CODE TO STORE A NUMBER TO A LOCATION RANGING FROM 1 - 10.

I.E.
TYPE IN A NUMBER INTO TEXT1.TEXT AND THEN PRESS A STORE BUTTON, THEN TO SELECT THE LOCATION, PRESS THE BUTTONS RANGING FROM 1 - 10

E.G.
TYPE IN A NUMBER, PRESS THE STORE BUTTON, AND THEN THE NUMBER 2 BUTTON, AND IT WILL BE STORED TO LOCATION 2 IN THE FASTDIAL DATABASE.


THEN BE ABLE TO RECALL THIS DATA IN THE SAME WAY AS A TELEPHONE FASTDIAL WORKS.

I.E.
PRESS A BUTTON RANGING FROM 1 - 10 AND IT RECALL THE NUMBER IN THAT LOCATION

E.G.
PRESS BUTTON 1 AND IT RECALLS LOCATION 1'S NUMBER AND NAME INTO THE DISPLAY. WITH SURNAME BEING DISPLAYED IN TEXT3.TEXT AND NUMBER IN TEXT4.TEXT
0
Comment
Question by:Warsteiner99
2 Comments
 
LVL 10

Expert Comment

by:caraf_g
ID: 2683113
PLEASE DON'T SHOUT AT US!!!!!
0
 
LVL 1

Accepted Solution

by:
riduce earned 100 total points
ID: 2683163
dim fdNumber as String

Private Sub butStore_Click()
Data1.RecordSource = "select * from [FastDial] where [storenr] = '" & text1.text  & "'" & " order by [storenr]": _
      Data1.Refresh: _
Data1.Recordset.Edit
Data1.Recordset![storeNr] = Text1.Text
Data1.Recordset![Surename] = Text2.Text
Data1.Recordset![Number] = Text3.Text
Data1.UpdateRecord
End Sub

Private Sub butFastDial_Click(Index As Integer)
fdNumber = butFastDial(index).index
Data1.RecordSource = "select * from [FastDial] where [storenr] = '" & fdNumber  & "'" & " order by [field7], [field5]": _
      Data1.Refresh: _
text3.text = Data1.recordset![Surename]
text4.text = Data1.recordset![Number]
End Sub
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction While answering a recent question about filtering a custom class collection, I realized that this could be accomplished with very little code by using the ScriptControl (SC) library.  This article will introduce you to the SC library a…
Enums (shorthand for ‘enumerations’) are not often used by programmers but they can be quite valuable when they are.  What are they? An Enum is just a type of variable like a string or an Integer, but in this case one that you create that contains…
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…

947 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now