Access 2000 And Visual Basic
I installed the sp5 for me to be able to use Access 2000 with Visual Basic, but I still get unrecognizable database when clicking on Recordset in the properties.
Any suggestions would be greatly appreciated.
View Complete Forum Thread with Replies
See Related Forum Messages: Follow the Links Below to View Complete Thread
Access 2000 And Visual Basic 6
I have recently installed Access 2000 and I cannot connect the control of the database on the toolbox of Visual Basic 6 to an access 2000 database.. the error given being "Unspecified database format". I have tried looking Microsoft Website but the solutions didn't work.
Can anyone suggest what should I download and do?
Reply,
Maltesedog
Access 2000 And Visual Basic
Do you know if an access 2000 program can be converted to Visual Basic? or if I can import an access form to visual basic?
Thank you.
Using Access 2000 And Visual Basic 6
HI...I am a real newbie so please bare with me!
I made a database using access from Office 2000. Easy breezy. Then I made a program using VB6 from Visual Studios thinking I could easily bind my text boxes to fields of the aforementioned database. Well I get an error message saying I do not have permission to acces the database. So I went to MSDN for help and found out that this is a bug so the fix listed was to download service pack 4. I did that and alas it still won't work. Any clues? I appreciate any help I can get. Thank-you.
Access 2000 Project To Visual Basic
I began a project in Access 2000 and I would now like to complete the project using Visual Basic 6. I am aware of connecting to the Access database through the (DatabaseName) property of VB6. My question is, how can I import or convert my Access 2000 forms, modules, querries etc. into the VB6 project.
Thanks
email
Access 2000 Problem With Visual Basic.
I use a lot of Visual Basic code (ADODB) to connect to an access database.
I would figure that if I use the following that I shouldn't have any problems:
Presented in a module:
Code:
Option Explicit
Public gvntUser As Variant 'USER represents data entry clerk
Public gobjNetwork As Object 'works with gvntCPUname to get computer name!
Public gvntCPUname As Variant 'represents computer name
Public vntNameconnection As Variant 'actual name of connection type
Public vntEndconnection As Variant 'actual ending section of connection
Public vntServer As Variant 'Contains variable for vntServer destination
Public vntNamedata As Variant 'actual name of database -
'Call function for loading vendor options in combo box
Public Sub vendor_options()
On Error GoTo Err_vendor_options
Entry.cmbVendor.Clear
gvntSelect = "SELECT VendorName FROM Vendor"
If grstData.State = 1 Then grstData.Close
grstData.Open (gvntSelect), gcnnData
I = 0
Entry.cmbVendor.AddItem "none"
grstData.MoveFirst
I = 1
Do Until grstData.EOF
If IsNull(grstData.Fields(0)) = False Then Entry.cmbVendor.AddItem grstData.Fields(0)
I = I + 1
grstData.MoveNext
Loop
grstData.Close
Err_vendor_options:
End Sub
then in my form I have...
Code:
Private Sub Form_Load
'just fills in the combo box cmbVendor
Call vendor_options
'Sets gvntCPUname Name for user
Set gobjNetwork = CreateObject("WScript.Network")
gvntCPUname = gobjNetwork.Computername
'Sets ADODB connection
Set gcnnData = New ADODB.Connection
Set grstData = New ADODB.Recordset
'Allows access to be opened
Set mappAccess = New Access.Application
vntNameconnection = "Provider=Microsoft.Jet.OLEDB.4.0"
vntNamedata = "mdanderson.mdb"
vntEndconnection = "Persist Security Info=False"
vntServer = "C:ZZ OPERATIONS PROGRAMS"
gcnnData.ConnectionString = vntNameconnection & ";" & _
"Data Source=" & vntServer & vntNamedata & ";" & vntEndconnection
gcnnData.Open
If the Form is Unloaded then I do:
Code:
Private Sub Form_QueryUnload(Cancel As Integer, UnloadMode As Integer)
On Error GoTo Err_Form_Query
If grstData.State = 1 Then grstData.Close
If gcnnData.State = 1 Then gcnnData.Close
Set gobjNetwork = Nothing
Set gvntCPUname = Nothing
Set gcnnData = Nothing
Set grstData = Nothing
Err_Form_Query:
End
End Sub
OK...so my problem presents itself when I have an unexpected error and I have to stop the program right where it is to fix it. When I re-run the program I figure that I should be disconnected from MSACCESS because I have in my Form_QueryUnload subroutine the Set grstData = Nothing - right?
But sometimes that is not the case.
Okay...so no matter how many times I run the program and end the program properly - sometimes I can see MSACCESS.EXE still running in Task Manager.
I know that since the program is a MDI - Multi-Document Interface sometimes that may get separated from the actual .mdb database that I'm running. This causes a problem where if I try to open or run the program from Windows Explorer - nothing happens...I can't pull up the database. I can see the lockfile opened but I can't open the program!
My only solution is to go into Task Manager find the MSACCESS.EXE and End PRocess. Is there a way to do this with code or is my code above incorrect?
Any help is appreciated!
Sincere Thanks,
How To Relink An Access 2000 Db From Visual Basic 6
How can I from VB6 relink an access 2000 database with code? Please help me.
I have an access 2000 database on the same client running Visual basic and want to relink some of the tables in my access db to a new Access db table.
Tried to find a article about this without any progress.
Visual Basic 6 And Database Access 2000
Hi to everyone!!
I'm a newbye! I have a little problem with visual basic 6..
the problem is that: I want to import a database access 2000 (that I've created before) and use it in a little vb program.
the program present a search function (how can I create it??) so I insert in a search field the name of a user and than the program search same things about the user...but when I clic on record source in vb the program give me an error ..."I can't recognize the database"...
how can i solve my problem? please help me!!
thanks,
bye
Administrator of Insanewb.com
Edited by - themanto on 7/1/2002 6:12:45 AM
Transfering Data From Visual Basic To Access 2000
Hello,
I have been coding in Vb for about a month and have come across a problem. I'm attempting to open up a txt file which reads data into vb and then inserts the data into access.
I get an error message which states 'run-time error 424 object required'. Can anybody help? - see code below
thank you
Private Sub Command1_Click()
Dim nom As String, wage As Single, hrs As Single
Dim dbMyDB As Database, rsMyRS As Recordset
Dim SQLStmt As String
Set dbMyDB = OpenDatabase("staff.mdb")
Set rsMyRS = dbMyDB.OpenRecordset("staff", dbOpenDynaset)
picPay.Cls
Open "staff.txt" For Input As #1
Input #1, nom, wage, hrs
picPay.Print nom; wage, hrs
Close #1
SQLStmt = "INSERT INTO staff "
SQLStmt = SQLStmt & "(nom, wage, hrs)"
dbMyDBConnection.Execute SQLStmt
dbMyDB.Close
Print "Complete"
End Sub
Update Access 2000 Database With Visual Basic 6
I have several VB6 forms with bound controls connected to an Access 2000 database via ADO. I can read current data just fine; however, I don't know how to let my user add new data or edit existing data.
I'm sure this is a simple question, but I haven't yet found the answer, so thanks in advance for answering.
Thanks.
Visual Basic 6 To Repair Access 2000 Database
Hello Colleagues,
We have a Visual Basic 6 application on our network that supports 10 users.
Frequently our Access 2000 database gets corrupted. We are using Windows NT
4.0, but in 1 month we will be migrating to Windows 2000. Is there a way
that Visual Basic can repair the Access 2000 database when it gets
corrupted?
Thanks,
Randy
Printing Access 2000 Report From Visual Basic
I tried executing this script from my vb program, but each time it is
telling me that the print option is not available at this time.
The script is used to print a access 2000 report from vb. Can anyone help.
Const dbPathName = "C:database.mdb"
Dim acc As Object, db As Object
Set acc = CreateObject("access.application")
Set dbacc.Application.dbengine.workspaces(0).opendataba se(dbPathName, 0, False)
acc.openCurrentDatabase dbPathName, False
acc.docmd.openreport "test", acprint
Set db = Nothing
Export An Access 2000 Report To Pdf File Using Visual Basic
I use VB 6 and Acrobat 4.
I need to export Access reports to PDF files using VB. I can't use the "Acrobat PDFWriter" because it asks interactively for the file name. There is no way to "export as pdf file" from within Access.
Do you know if an ActiveX exists to do that? Or another idea?
Thanks a lot,
SB.
Creating Reports In Access 2000 From Visual Basic 6.0 Enterprise
Hi
I am currently developing a dynamic reporting utility which will create a report in access then view it with the snapshow viewer. However, the error: The Save action was cancelled is being produced.
I have spent the last 8 hours viewing everything I could find in MSDN, Net and Access Help, to no avail.
I would appreciate it if someone could assist with a solution. I am referencing the Microsoft Access 9.0 Object Library.
Please email me.
Regards
Ivan Dormain
Insert An OLE Image Bitmap In Access 2000 Database Via Visual Basic 6 ADO Controls...
i have quite a problem here...
i have to store a linked OLE Image Bitmap in Access database using my client application developped in VB6...running with ADO 2.6
I must be able to read and write to my table an image that exists on my hard drive.
I can't only store my image path because i have to use a linked image on one of my Access Report using a dependant object linked on this OLE type field which is an image...
If you know how to show an image on a Access Report changing with different field values (image path stored in string field)....please help me too! this could resolve my problem!!
if you have any suggestions or solutions....
i would really appreciate!!!!
Visual Basic 6.0 For Win 2000
Does any one know a bug involving VB6.0 and Win2K where if you install SP3 or greater, then choose to be in the "SDI" enviornment from the TOOLS, OPTIONS menu you get a "SUBSCRIPT OUT OF RANGE" error when loading VB? Not a program written in VB, but the actual VB 6.0.
Visual Basic OS 2000
HI folks!
I am a very dreaming person..Even with my eyes wide open. The other day I was thinking about linux and the kind. It made me dream a virtual visual basic OS. Wait... Im not even thinking about the possibility with the current implementation of VB. You just boot to a kernel which runs bytecodes compiled from Visual basic. Atleast that is what my dream pictures to me. Anyone dare doing it ???
------------------
MsgBox "With VB no one must a baby!",vbExclamation,"HI"
Visual Basic In Word 2000
What I would like to do is bind all the code that pertains to a specific word .doc and be able to send it with the file (email, download, etc). Right now, all of the functions and subs are localized on the computer I create them on. If I email the .doc to somebody, the code is not sent with the .doc. This is a problem for me.
I realize that there is maliscious possibilities in opening a doc that executes VB code, however that is not a concern for me.
Thanks.
PS - I'm running Word 2000.
Edit: Oops, I posted this in the wrong section. Sorry
Visual Basic And Word 2000 How To?
Hi, I made and saved a template,and now I want to fill it from Visual Basic.I used as a reference the example from the following link.
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q313193
If you click on the template link you will see instruction on how to use a template.What I don't know is how to make a bookmark of this kind on word.I also want to know if there is another way to fill in a pre-defined template from visual basic.
Thank you very much!
Thodoris
Visual Basic 6 N Sql Server 2000
pls check the attachment.....
'ive done odbc connection and connection string
'now i have 4 data in my database....2 data with 'no' and 2 data with 'yes'
'i need to count those data separately and and i have to assign it to the chart..
'i dunno whether i count it properly or not...pls check
'i've used timer because need to call data from the database every 1 minute
'after counting the data how do i assign those data to the chart control on the form
Visual Basic 6 And SQL Server 2000
Is there anyone who can help me on this issue?
How to connect a SQL 2000 database NOT through server?
For example, I copy SQL 2000 database "Test_Data.mdf" to
C:DatabasesTest_Data.mdf. Use VB6 code to connect to it.
Is this doable?
Thanks
---------------
I tried the following codes but I encountered errors, e.g.
"Run-time error '-2147467259 (80004005)';
"Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server connection."
or
"Invalid authorization specification" if I delete the "sa"
Visual Basic Vs. Outlook 2000
In my vb6 program I am using a outlook mailitem and I am sending mail with a readreceiptrequest attached to it. I am having trouble with trying to find out if my mail was read or not through my program. if the message was not read then I have to resent it, otherwise I would save it to a database. Any help would be greatful
MrFreeze_22(programmer)
Windows 2000 And Visual Basic 6.0
I have a VB6.0 application that is accessed over a company intranet to 1,000 users. The company has started to roll out Windows 2000 - and the application doesn't work (an error downloading docName.VBD is encountered). As near as i can tell, Windows 2000 file protection won't allow their system files to be overwritten by filed in the VB cab. Has anyone encountered this problem, any ideas?
Running Visual Basic 3 On Windows 2000
We have an application that is written in Visual Basic 3.0 with quite a number of Third Party software. When we run the application on workstations that are using Windows 2000, it runs correctly but the error messages are unreadable. Is there a simple solution to this problem?
Error Handle SQL 7/2000 In Visual Basic 6
Hi…
I am the one of user beginner of the Visual Basic 6 Aplication and Database SQL 7/2000. I have product table with kd_product as primary key. This table display by ADO and Datagrid control. My Question, How to hide this error handle “Violation of primary key constraint …..,Cannot insert duplicate key in object…”(Error SQL ?) to be display on the screen, but the on the screen will show my own error code ?” . Please give me an exsample any code of error handle. Thank ‘U
Interacting With Outlook 2000 Through Visual Basic 6.0
Iam using outlook 2000 and visual basic 6.0.
Now i want to develop a tool in vb 6.0 that will open the outlook 2000 and filter all the mails that has been recd. to some mail id(for eg. careers@something.com) according to some keywords present in the body of the mail and it must move to appropriate folder.
In case the mail has an attachment the tool should open the attachment and filter.
For eg. filtering could be done using some keywords like"j2ee","cobol",etc.
If a mail has a keyword say "J2ee" that mail should be moved to a folder called "Java". Similarly if the keyword is "cobol" the mail should go to a folder called "mainframe" and so on.
Pls help
Excel 2000 Visual Basic Fatal Error
I have a very extensive VB project in Excel 2000 that is under development and for some reason, when I execute the code by activating a command button on the spreadsheet, Excel encounters a fatal error and needs to be restarted. However, if I execute the code from the Tools / Macro menu or from within the VB editor, the code works fine.
It's only when I launch the application by pressing a command button that the error occurrs.
Any thoughts?
Windows 2000 And Visual Basic 6.0 . . . Is There Going To Be Change In Programming?
Hello i was wondering when windows 2000 comes out is there going to be an effect on how programs are made with Visual basics or VC++ Like can visual basic make window 2000 applications or Do i have to learn everything all over again so that you can make programs with that work with windows 2000 or is there no change at all? thanks for your time!
Desperately Require Help With Visual Basic / SQL Server 2000
Hi,
I am new to SQL Server. I am attempting to execute an insert query,
but I keep getting an entire range of errors depending on which way I
choose to do it. Can anybody tell me what is wrong with my code below?
"txtkeyword" is a text box on my form.
Thanks in advance,
Daniel McDonald
Dim mySQL As String
Dim myRecSet As ADODB.Recordset
Dim myConnection As New ADODB.Connection
mySQL = "INSERT INTO tblcustomerfind ( CompanyName )SELECT
tblcustomer.CompanyName"
mySQL = mySQL & " From tblcustomer, tblcustomerfind WHERE
(((tblcustomer.CompanyName) Like '" & txtkeyword & "'%))"
'myConnection.Open "Provider=sqloledb;Data Source=Server;Initial
Catalog=ConSoft;User Id=Administrator;Password=janis01;Integrated
Security=SSPI;"
myConnection.Open "Provider=MSDASQL;Driver={SQL
Server};Server=Server;Initial Catalog=ConSoft;User
Id=Administrator;Password=janis01;Integrated Security=SSPI;"
Set myRecSet = myConnection.Execute(mySQL)
How We Will Connect Sql Server 2000 Database With Visual Basic 6.0
hai friends,
I have a small knowledge of visual basic, basically i am java programmer but there is one problem in visual basic which is given by our company so plz help me
Basically i want a connection between sql server 2000 with visual basic, and the data show on the visual basic form from the database. i do not know how i will do it. So Plz teach me Step by Step so that i can implement on my visual basic problem.
or u send me that code to my email id vbhem4u@hotmail.com or hemantfular83@gmail.com
Thanx in Advance,
I am waiting Yours reply.
Creating A Windows 2000 Service Using Visual Basic
Hi All
I got a exe which i want to make it a Windows 2000 service can any body tell me how to write a service in Visual Basic.Help very much appreciated and if u can give me any links that is going to be great.
Thanks in Advance
Madhu
Interfacing MS Word 2000 With A Visual Basic 6.0 Application (Add-in?) - *Resolved*
The following is what that needs to be done and I would like to request assistance as to the approach, tools and/or code since I have no experience in working with MS Office (from the programming side, of course ) or with creating Add-Ins.
1) The end-user opens an existing word document
2) (S)He highlights some text (could be within a table as well)
3) Clicks a button or presses a key combination
4) The highlighted text changes to the text recieved from below.
........5a) The text as highlighted above is recieved by my VB application along with information on the selected text's font (name, size, bold, etc.)
........5b) The information so recieved is parsed by my application in correspondence with my database and a new string is generated comprising a totally different text of a different font, size, weight, etc.
........5c) The new string is to replace the highlighted text along with the new font, size, etc.
6) There should be no code at all in the "Macros" section of the Document
7) As of now I would be content with MS Word 2000. But it would be extremely helpfull if the above can be made to work in MS Excel 2000 and other products of the MS Office 2000 suite or is also functional in older versions of MS Office
TIA
Regards
Kaushik Janardhanan
Centralizing A SQL Server 2000 Database Using Visual Basic Coding
I had created an application in Visual Basic and Sql Server 2000 as back end. It had nearly taken me a year to complete and my Sql database can be accessed by only one user at a time and data cant be shared in a Lan environment. Can anybody give me a hint or module for to creating a centralized database (i.e., n number of users should be able to access the database at a time). For example the Sql Server Name will change from system to system and we must to able to get it and change according to it.
I will be greatly helpful for u, if anyone gives me a module. For other doubts in Visual Basic please be free to contact me @
mohan170@yahoo.com
How To Connect SQL Server 2000, Crystal Reports 8.5 And Visual Basic 6
Hi guys,
I have been using this forum for a while but only joined yesterday to post this information. Like most people I was having great difficulty in getting SQL Server 2000, Crystal Reports 8.5 and Visual Basic 6 to work together to produce reports for the end user. My main problem was the error 'SQL Server has not yet been opened'. This was due to my report having subreports within it, which nobody anywhere has properly explained.
As this took a good bit of searching and also my own coding to resolve this I thought I would post the end result on here for anyone else who was having the same difficulties.
2 Ways to do this are... Passing a SQL Query to a report or by Passing parameters from a users input.
First of all make sure that the Component Crystal Reports Viewer Control has been added to your project. Next make sure the 2 References - Crystal Reports Viewer Control and Crystal Reports 8.5 ActiveX Designer Run-Time Library have been added.
Now for the code...
Add the following to the general declarations area:
Code:
'****************************************************************************************
' General Declarations for working with Crystal Reports
'****************************************************************************************
Dim crxApp As New CRAXDRT.Application
Dim crxRpt As CRAXDRT.Report
Dim crxTables As CRAXDRT.DatabaseTables
Dim crxTable As CRAXDRT.DatabaseTable
Dim crxSubreportObject As CRAXDRT.SubreportObject
Dim crxSubReport As CRAXDRT.Report
Dim crxSections As CRAXDRT.Sections
Dim crxSection As CRAXDRT.Section
Dim crParamDefs As CRAXDRT.ParameterFieldDefinitions
Dim crParamDef As CRAXDRT.ParameterFieldDefinition
Next place the following code behind the command button, REMOVING the code Way 1 or Way 2 depending on your application.
Code:
Private Sub cmdSubmit_Click()
'****************************************************************************************
' Variables declarations for the Database Connection
'****************************************************************************************
Dim strServerOrDSNName As String
Dim strDBNameOrPath As String
Dim strUserID As String
Dim strPassword As String
strServerOrDSNName = "servername" 'replace servername with your SQL connection server
strDBNameOrPath = "databasename" 'replace databasename with your SQL connection databasename
strUserID = "userid" 'replace userid with your SQL connection userid
strPassword = "password" 'replace password with your SQL connection password
'Open the report
Set crxApp = New CRAXDRT.Application
Set crxRpt = crxApp.OpenReport("C: est.rpt")
'Set the connection for the report.
'SetLogOnInfo is a deprecated method in CR 9, but still works.
'The suggested method for CR9 is to use the ConnectionProperty object.
crxRpt.Database.Tables(1).SetLogOnInfo strServerOrDSNName, strDBNameOrPath, strUserID, strPassword
'This removes the schema from the Database Table's Location property.
Set crxTables = crxRpt.Database.Tables
For Each crxTable In crxTables
With crxTable
.Location = .Name
End With
Next
Way 1 - Passing a SQL Query string
'***************************************Start of Way 1*************************************
'The select query to reutrn the data required
crxRpt.SQLQueryString = "SELECT whatever FROM table WHERE blah blah" 'Input your SELECT query here
'****************************************End of Way 1*************************************
Way 2 - Passing Parameters from a users input
'***************************************Start of Way 2*************************************
' Disable Parameter Prompting for the end user
crxRpt.EnableParameterPrompting = False
' Gather the list of available parameters from the report
Set crParamDefs = crxRpt.ParameterFields
' Loop through all parameters in the report by name, filling in the appropriate parameter with the right value
For Each crParamDef In crParamDefs
Select Case crParamDef.ParameterFieldName
Case "JobNumber"
crParamDef.SetCurrentValue txtJobNumber.Text
Case "POStatus"
crParamDef.SetCurrentValue POStatus
Case "PODetail"
crParamDef.SetCurrentValue PODetail
Case "WOStart"
crParamDef.SetCurrentValue txtWOStart.Text
Case "WOEnd"
crParamDef.SetCurrentValue txtWOEnd.Text
End Select
Next
'Loop through the Report's Sections to find any subreports, and change them as well
Set crxSections = crxRpt.Sections
For i = 1 To crxSections.Count
Set crxSection = crxSections(i)
For j = 1 To crxSection.ReportObjects.Count
If crxSection.ReportObjects(j).Kind = crSubreportObject Then
Set crxSubreportObject = crxSection.ReportObjects(j)
'Open the subreport, and treat like any other report
Set crxSubReport = crxSubreportObject.OpenSubreport
Set crxTables = crxSubReport.Database.Tables
For Each crxTable In crxTables
With crxTable
.SetLogOnInfo strServerOrDSNName, strDBNameOrPath, strUserID, strPassword
.Location = .Name
End With
Next
End If
Next j
Next i
'****************************************End of Way 2*************************************
'View the report
CRViewer1.ReportSource = crxRpt
CRViewer1.ViewReport
'Set the Zoom on the report
CRViewer1.Zoom (90)
End Sub
Way 2 involves passing parameters to your report, this means your reports MUST use these parameters within the report.
Hope this helps out!!!
Integrating Visual Basic 6 With Word 2000 To Create A Report
Hey there,
I completed my Visual Basic Project (using Access 2000 as the backend) a few days ago, except the reports. I'm trying to use Word 2000 to view specific data.
I have created Word Templates with the required Bookmarks. But other than that I am puzzled as to how I am going to solve this problem.
I've created a form that has an OLE object attached to it. The template has been assigned to it (SourceDoc in the properties).
I have a few snippets of code that will transfer this data, but they are not clear enough. Not very good detail.
Can you help me?
suziv83@hotmail.com
Visual Basic Code That Will Change The IP Address Of The DNS Server On Windows 2000
Visual Basic code that will change the IP address of the "Preferred DNS server" on Windows 2000 and XP
On Windows 2000, right click "My Network Places" --> Properties --> "Local Area Connection" --> Properties --> highlight "Internet Protocol (TCP/IP)" --> Properties --> Use The following DNS server address.
1) How do I write a Visual Basic code that will change the IP address of the DNS server as shown above where one would do it manually. What API would I use?
2) How do I write a Visual Basic code that will access the IP address of the DNS server as shown above where one would obtain it manually. What API would I use?
How To Access Visual FoxPro Data In Visual Basic
I have a problem :(
I would like do delete a record in FoxPro data base with Visual Basic 6
I use ODBC kuhinja:
Const povezava = "Provider=MSDASQL.1; Persist Security Info=False; Data Source=kuhinja"
adott1.ConnectionString = povezava
adott2.ConnectionString = povezava
adott2.RecordSource = "SELECT sifra,grupa,naziv,nabavna,vpc " _
& "FROM izdelki "
adott2.Refresh
to view data in datagrid
I delete a record :
adott1.RecordSource = "SELECT * " _
& " FROM izdelki " _
& " WHERE sifra='" & adott2.Recordset!sifra & "'"
adott1.Refresh
Record is marked in FoxPro as deleted ( not yet PACK ) but in Visual Basic datagrid (adott2.refersh ) record is still in it.
How can i execute PACK in Visual Basic????
THX
sorry for bad english :)
What Is The Different Between Visual Basic And Visual Basic Access?
hey!
actually i'm going to do a database to track student attendance, where the student need to scan their student ID card.
which software is suitable for me? Visual basic or Visual basic access?
actually what is the different between these two?
can anyone explain to me?
Visual Basic And Access
i am trying to use visual basic for the front end interface for my access database.
i have set it up and have forms which show and can go through records of customers on a form i want another form which links a specific customer to their cars. I cannot do this and currently when i search through the form which i have made to show a customers cars it shows all of the cars in the database. how can i restrict it from doing this and thus only showing the cars which belong to that customer.
any help will be greatly appreciated.
p.s. the tables in the access database are as follows:
Customer table:
CustomerID primary key (autonumber)
name
address line 1
address line 2
address line 3
postcode
telephone
Car table:
CarID primary key(autonumber)
CustomerID foreign key(number)
make
model
year
engine size
Visual Basic + Access
In Microsoft Access 2003 i have a table which i need to lookup the values of it and insert them into a combo box on my Visual Basic program. I have tried setting up a "adodc" and it works but it doesn't display all the values that can be entered (only the one that is selected). Any help?
Sniperkid
Visual Basic And Access
i am trying to use visual basic for the front end interface for my access database.
i have set it up and have forms which show and can go through records of customers on a form i want another form which links a specific customer to their cars. I cannot do this and currently when i search through the form which i have made to show a customers cars it shows all of the cars in the database. how can i restrict it from doing this and thus only showing the cars which belong to that customer.
any help will be greatly appreciated.
p.s. the tables are as follows:
Customer table:
CustomerID primary key (autonumber)
name
address line 1
address line 2
address line 3
postcode
telephone
Car table:
CarID primary key(autonumber)
CustomerID foreign key(number)
make
model
year
engine size
|
TRACKER
