[microsoft:access] Forum Topics

Hi Experts - I have created a edit web form. It does get populated with the appropriate record by using DataReader.... but I would like to modify/edit data and save it so it is updated in the access database. I have created a SaveIssueButton button and put update sql statement …

can everybody help me... [CODE]Public cnName As Connection Public rsId As Recordset Private Sub cmdImport_Click() Dim a(50) As String Dim c(50) As String Dim ProductID(50) As String Dim i As Integer i = 0 cdbOpenFile.Filter = "Text Files (*.txt)|*.txt| " 'Specify default file name to open cdbOpenFile.FileName = "" ' …

[code][COLOR="Green"]Public cnName As Connection Public rsId As Recordset Private Sub cmdImport_Click() Dim a(50) As String Dim ProductID(50) As String Dim i As Integer i = 0 cdbOpenFile.Filter = "Text Files (*.txt)|*.txt| " 'Specify default file name to open cdbOpenFile.FileName = "" ' Specify default filter to *.txt cdbOpenFile.FilterIndex = 1 …

[code] Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click If (TextBox1.Text = " ") Then MessageBox.Show("Value cannot be null") End If daRates.Update(DsRates, "rates") End Sub [/code] im using vb,net 2003 and access xp i cannot save data and im using oledbconnection etc all is fine if …

Hey guys, i'm trying to create a database in Access, but i'm having problems, keep getting the same error, i've gone through it so many times but cannot see whats wrong with it, i'm getting a syntax error which highlights at the start of the Enrolment table, any help would …

I use data control to link access file by data properties not code. use simple code like move next etc. I use find next to find data. but when i want to find i write the criteria like Name = taher. But i want I write only taher in find …

So I got this code off the internet. The guy who made it said this, "I have done this in SQL Server.If u want to do in Acess Database just create a table name USERS then add two fields name user_name and user_pwd thats it." I tried that and it …

hi everyone! i wanted to know the command to check whether a particular table exists in access or not............ for example, in sql server, we write ("select * from sysobjects where name='table1",con) what is the equivalent command for this in access????????? thanks..................

Hello all, This is my first post in a forum like this, I hope someone is able to help me! :) I found a post from about a year ago that explained how to use combo box parameters in a query, and I was wondering if there is a way …

Hello Everyone, I'm Uploading this Project for the ones who need Help regarding VB's MSCHART CONTROL!!! This Sample Shows : [B]1) How to Show Data from an Access2003 Database on Chart. 2) How to Print Data from MSChart Control. 3) How to "Save As..." the Chart, as .Bmp file.[/B] Hope …

Hello, I am using TransferText to bring a text file into an Access table. Is there a way to turn off the Import Error file that is produced as a result of improperly formatted text? Thanks! Mark

Hello, Can anyone help me add a column to my Access table? I would like the column to be populated with a number that iterates from 1 to the end of the file. Thanks for your help! Mark

hello all friend's, i'm a newbee to asp. it totally harder than PHP ;) . i'm facing trouble when try to delete records from a list.. i take the scripts from [url]http://www.w3schools.com/ado/ado_delete.asp[/url] but i made the custom msaccess2002 database b'cause i had no nortwind.mdb database. dbname = tes.mdb , tablename …

Folks: I am trying to get all NVIDIA users on the list and I am saying NVIDIA* in my SQL statement since there are different versions of NVIDIA.. if instead of NVIDIA* i said 'NVIDIA Quadro fx 4600' i get a list of queries.. but if I said 'NVIDIA*' i …

I have used MS Access to generate a report and can print a particular report history by using macro. Is there a way I can print a specific report of the MS Access report from VB 6?:(

I am trying to import several files to access. I have the code to search the C:\ drive but I need to look thru all the folders also. Below is what I have so far the works. Thanks in advance for any help. Wayne [code] Dim strfile1 As String Dim …

What version of MS access is compatible to VB 6.0??? And any other application beside of access you can suggest. Thanks a lot...

Sumbody please let me know bout this....

Im looking for a good access VBA book. Im advanced in access but completely new to VBA but have done other programming languages like c, c++, java, php and a few others Any recommendations greatly appreciated Thanks

hi!.. first of ol sory for my bad english.... I have a problem: I want to create a database system using MSACCESS and VB6 that will be on 3 computers connected via LAN. 1. the 2 computer will be the registration section, and the last 1 will be the payment …

I am trying to crate a web application for a database (a form and a search+results pages). HOWEVER, I am seriously stuck because I cannot install IIS on my workstation to start working. The university I am at cannot have me IIS installed (it's forbidden) because it would turn my …

Folks: I am trying to establish a connection with an Access DB. To me the code looks right..but I get an error in the da.Fill(ds,"table1") and the error is "Fill select.command.connection property has not been initialized".. i know it means that the connection has not been established properly but i …

I am writing a simple program to update a access database and keeping getting a syntax error and I don't know why. Please help I have been working on this for a while now and I am well and truly stuck! The datatable updates as expected but I cant make …

How can you make a table from a union query in access - i have the union working and producing what i want but i can store it as a view or as a table - i keep getting syntax errors [code] INSERT INTO HgTotals SELECT CollectionDate,HgTotalnglA as AllHGtotal FROM …

I am pretty sure that the VB.NET code is right but I am sure my SQL statements are completely wrong ..can anyone help me figure out my mistakes and as to how the SQL statements need to be framed to get the results correctly from the Access Database ? Thansk, …

hi: I have a problem filling my combo box from my Access Database values.. Can you please help me with this ? Thanks, Kukki. Private Sub Form2_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load Using con As New OleDbConnection("provider=microsoft.jet.oledb.4.0;data source=C:\Documents and Settings\bashkark\Desktop\Copy of USERS.mdb") con.Open() Dim objcmd As …

i am unable to access the items in my control panel such as add/remove programs etc. please help! there seems to be some sort of trojan at work. here is my hijackthis log and my combofix log. i'm not massively technical so basic instructions would be much appreciated. many thanks, …

I am using Access97 and have created an employee database. I am having trouble creating a method in which to get a new number for an employee and open a form in add mode with the new number already populated and then remove that number from the list of available …

Hey guys, I'm new here and actually new to access 2003. I have deal with Vb.net but never access. I actually doing a intern and they want me to build a huge database. All there documents are spread out and all over the place as format of excel. I could …

Hi I like to know haw doI create a form based on multiple tables, all tables are linked. Some table contains drop down lists, I want all info in all tables dispalyed in the form. Help Please

Good Morning, I am developing a C# application whose objective is to save and retrieve data from a Windows Form to a Microsoft Access database and vice versa. What I've done is to add to the project a blank database, with the columns I need to fill already created. The …

Folks: I got rid of the error now.. this is my code..pls take a look at the button1_click function! i dont see any data being entered into my database. :( Your guidance will be very helpful! Thanks, Kukki. Public Class Form2 Private Sub Form2_Load(ByVal sender As System.Object, ByVal e As …

Hello All: I have a program using VB.NET and Access. I have 5 comboboxes and any combination that I choose I get a result. I have 2 problems here: 1. I want to design 4 check boxes in such a way that any1 or combination when selected should give a …

I am trying to connect my login page to an access database. Right now I am simply storing the values inside the database .I am having trouble connecting to the databse itself. Below is the code that I have written using VBScript. What am I doing wrong? ...Thanks in advance …

I am started a new with VB6 Access project. I am connected database with ADODB, DSN Method that Code Given below. '======================In module ============== '=================== Connection With Database =============== '====================================================== Public CNN As New ADODB.Connection Public RS As New ADODB.Recordset Public cString As String Public Sub Main() Set CNN = …

I created a form in Access. I would like to put up the form on our website so people can enter their information. We need to review the data before they get into our database. I am actually stuck about how to publish the form. I thought it was an …

Hello, I have a login form in Access which has a combobox and ac ommand button. The combobox has a list of customernames. On selected the customer in the CBox or specifying a part of the customername, when i click the commbuton i should get another form having a list …

Does anybody know how to extract a link from an OLE embedded link in Access 2000? I have a DB where instead of a hyperlink there is an OLE object, linked to a Word file. I want to easily see what the link is, without actually clicking on the OLE …

Good afternoon, Can a runtime environment connect to and update records in a FM database on a file server? From what I understand, runtime env's package a copy of the actual database and allows someone to use it on a system without FM installed.... Basically, I want to create a …

OS: Win XP Pro Apps: FMPro 9 and MS ACCESS 2007 Database Types: both are Local to my machine Good afternoon everyone!!! --------"Connect to a MS Access DB"---------- I am new at using FMPro 9 (very new after a year of using VBA to manipulate and control MSACCESS db's)... I …

I try to solve this problem: when i add, delete record it working, but for update is not working please someone help me here code: Private Sub UpdateRecord() VarTransaction = VarConn.BeginTransaction Dim VarOleDbCommand As New OleDbCommand Dim VarStringBuilder As StringBuilder VarStringBuilder = New StringBuilder VarStringBuilder.Append("UPDATE tblCl_TrainingType") VarStringBuilder.Append(" SET Type_title=@Type_title,Clarification=@Clarification") VarStringBuilder.Append(" …

How do i create a secure and safe password for my database? I know you can use access to add a password but its way too easy to crack. Any sugestions? thx

In the code below I use the Form_Load to connect to a Access database and load a form and combo box. I then use the cboComp_Click to look for a record in the tblToDo table, If found I load it into the form using the FillFields If not found I …

Hi to all, I want to create an application containing a lot of fields, my problem is the client want to maintain the records of payment and the date. I have created database containing only one tables. How can I handle this kind of database management, the goal is, if …

Hi I am try to use some code that I found on Daniweb forum to display random records from an Access database on a page. The database has a table called tFact, and two columns called ID, and vFact. I can not get the code to work, and I was …

I want to create a code in vb.net 2008 that will delete data from its database table(Microsoft Access). The columns (attributes) in the database table are CWNo, Name, IC No, Nationality, Company, Join Date and Expiry Date. Then it will insert data from a Microsoft Excel Sheet that contains the …

Hi All, I am making a databse for club membership and would like to include photos. I am having difficulty in printing reports that include photos. Can you tell me if this can be done within Access or do I need a seperate package? If I do could you let …

Dear all, as always I am back with yet again a simple question. I have developed an application in vb.net which has VB interface as front end and access 2003 as backend. The application path which I setup initially is : [CODE] Dim MyConn As ADODB.Connection MyConn = New ADODB.Connection …

Hi. There's any Access forum here? Regards, Marco

I have used the Package & Deployment Wizard to put my Visual Basic Program on CD, I then copied over my database 'calculations.mdb' onto the cd also so that the VB program can access the database when installed on another PC. However, the program still searches the same path as …