[microsoft:access] Forum Topics

Hi there. I'm looking for a bit of advice. I have a lookup table (tlkOrganisations) which has only one field (apart from the ID) and it list orgnisations. I'm using this for a field within a form so that I can use it as a lookup combo. The advice I'm …

Hi everyone. New to this web forum. Just looking for some help here. I am using Microsoft Visual Web Developer 2005 Express. I am wanting to create a page of names. This page of names will need to point to a template .aspx file, and insert criteria into 3 GridView …

Hi, I wondered if I should set "replication ID" for field size for the foreign key? The field size is courently set to "long integer". What is bether to use, why and what is the difference? Thx for your help.

hi! i m nu to VB pl.explain how to connect VB to Access data basic using ADO control, if any other way, pl do help me. than u.

Hi, I am managing a website. About 5000 people regsitered in my database and i send them newsletter. Uptil few months back i send newsletter through 30-40 different emails with group of emails in MS-Outlook. But it's realy now time-taking plus technicaly many invalid addresses are now there. So lots …

Hi friends, I designed a simple application based on MCQ's with Access as Database and DAO as the method to connect to the database. The problem is that the application is working fine on my system but on any other system it is giving an error "ActiveX object can't create …

OleDbConnection cn = new OleDbConnection("provider=microsoft.jet.oledb.4.0;data source=C:\\tblImp\\db1.mdb"); cn.Open(); DataSet ds = new DataSet(); OleDbDataAdapter da = new OleDbDataAdapter("select * from tblImp", cn); da.Fill(ds, "tblImp"); tablecontrol.datasource() = ds.Tables[0]; tablecontrol.DataBind(); table is not populated with data from access database. help me plz.

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 would like help with MS access iif statement. I want to group courses but day offered e.g Monday, Tuesday, Wednesday, etc and by time offered e.g Monday: 6:00 PM - 9:20 PM. I have an iif statement which should convert the letter (day) to worrd e.g, M to Monday …

Hello all. I am looking for some guidence please. At the place I work, there is a database which is accessible by three users. They have a front end exe file which connects to a MS Access database with several tables in it. The info is used for logging incomming …

Can anyone plz give me code for searchin multiple records stored in Access db and displaying them?!!? The code i wrote displays only 1 record.

How to open a dialogue box for loading a text file (when button is pressed) in MS-Access.

Please help I am posting HJT log. Thanks Logfile of Trend Micro HijackThis v2.0.2 Scan saved at 11:01:13 AM, on 8/26/2007 Platform: Windows XP SP2 (WinNT 5.01.2600) MSIE: Internet Explorer v7.00 (7.00.6000.16512) Boot mode: Normal Running processes: C:\WINDOWS\System32\smss.exe C:\WINDOWS\system32\winlogon.exe C:\WINDOWS\system32\services.exe C:\WINDOWS\system32\lsass.exe C:\WINDOWS\system32\svchost.exe C:\Program Files\Windows Defender\MsMpEng.exe C:\WINDOWS\System32\svchost.exe C:\WINDOWS\system32\brsvc01a.exe C:\WINDOWS\system32\brss01a.exe C:\WINDOWS\system32\spoolsv.exe C:\WINDOWS\Explorer.EXE …

Ok, yes this is an assignment. Yes It's due tomorrow, and yes I have spent countless hours trying to do this, my head is fried I start work in less than 6 hours and it's due in approximately 17hours time. Main problems: - I need to generate a Primary Key …

OK, now this problem relates to the same one ive been having with the invoices, "Transfering records", that I posted. If i have a text filed, lets say activity, which contains the user activity on a form, (Eg user clicks "Send Report" button and "activity" changes to "Report Sent" - …

I have the arrays EMP (EMP_ID(PK), Name, PROJ_ID(FK)) PROJECT (PROJ_ID(PK), name) SALARY (SAL_ID(PK), date, amount, EMP_ID(FK)) I have done the appropriate relations and i want to take something like this: wesuppose that EMP name is George and the project is storage then i take something like this: George storage 22/2/2007 …

Hi, Ive been [B]using Access [/B]2003 to build various databases on. These databaces however are effectively full products for certain functions. Eg of what I mean: I am busy building a database for a panelbeater. The system is able to capture client details, capture quotations, create invoices, control appoiontments, control …

Hello. I am an experienced pseudo-tech who does Novell support, misc hardware fixes, MS-Office guru support and lots of MS-Access VBA. I stumble thru and don't soar with the eagles as some do here. But then again I work mostly for lawyers and the one-eyed man is king in the …

hi all: I am a newbie , trying to connect my access to vb.net express edition I wrote the following code: Imports System.Data Public Class Form1 Private Sub btnLoad_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnLoad.Click Dim con As OleDb.OleDbConnection con.ConnectionString = "PROVIDER=Microsoft.Jet.OLEDB.4.0 ; Data Source = "C:\Documents …

hi all! I need to set precision to the left of decimal. For the number field i have to set the field precision such that the nos should be in a format as 0001,0002,0003------------------.9999. Thanks

hi ive been trying to insert specific data into a certain textbox from an access table, ive managed to pull the information from one field onto a listbox but i cant grab specific data and load it onto a textbox: here is the code, if anyone can help please that …

Hi all.. I am having a table named "login" in MS access.. I am connecting it to a java application with th help of the following code.. Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); System.out.println("Driver loaded"); // Establish a connection connection = DriverManager.getConnection("jdbc:odbc:ESMDB"); System.out.println ("Database connected"); String result=""; st = connection.createStatement(); rs = st.executeQuery("SELECT * FROM …

Hi, I have a parameter queery which asks for "Name " . I want to Enter a few characters and find similiar full names to it which are in the field "Names". For example: If I type chr it should find out "christine" Pleae help Best regards Nadeem

[code]Set rstDeps = CurrentDb.OpenRecordset("SELECT Members.OrgID, Members.ID, Members.Member, Members.PrimaryRep, Members.MembershipType " _ & "FROM Members " _ & "WHERE (Members.Member=True AND Members.OrgID=" & !OrgID & " AND Members.MembershipType='" & !MembershipType & "');")[/code] This is my query in VBA in MSAccess. I just want the number of people that fall into those …

hi, im having problem with my current project which is to insert values from variable into fields in access database. i know how to insert values from textbox into access but im having problem using variables.can anyone please help me?

Hi there. i'm having trouble joining tables. I'm using Access database. Initially, i have 2 tables called thresholdTable and Configuration. In the thresholdTable, there's a column called 'Config' and i've linked it to a column called 'Confuguration' from the Configuration table. Right now everything's working. However, i added another table, …

Hi everyone: I have MicroSoft Word 2000 and has this error: "Error 1919 configuring ODBC data source: MS Access Database ODBC error 6 component not found in the registry, verify the file MS Access Data base exist and that you can access it". I uninstalled it and it won't let …

I am using MS Access 2003 to link to an Oracle 10g table utilizing Oracles 10g ODBC driver. When I view the data everything is fine except for the datetime field (which is also an index on the Oracle side). Access shows a value of "OLE object" in this column …

Hello, I want to use C# to select a random number from MS Access database table. <SELECT TOP 1 userID FROM users ORDER BY NEWID()> seem to work only with SQL Server.

Hello members I reading - Looping through a recordset (MS Access Query) that has 49 records. Note: the query is generate on the fly(dynamically). The processing is supposed to exit the loop at EOF but it keeps processing indefinitely (sort of an infinite loop). Does anybody know why this is …

can anyone show me to login page code?? i did my registration code already.. now i need the login page the userid and pword read from my database access then the user can log in to another page.. i need the whole code. as simple as possible.. thankyou very much. …

I am getting the list items from a access database to a list box in my form. But it is showing the list items in a line for each items. As the list box is a narrow one, i cant see the whole line. How can i see the whole …

Dear Friends, I have been working on a VB.net project on VB8 with ms access as backend. While finding certain data by entering primary key in the form i.e. id i experienced a problem. While displaying the values which are null in the database like wise tel1 is null then …

Hi there, Got a couple of questions for you. I have this form and in it there is a field called "Qty Requisitioned". I want a pop up box to be displayed if the qty requisitioned is greater than what the figure is in stock. How would I go about …

I am a new user of FileMaker Pro. I am converting an MS Access database and am stuck on including multiple tables in a format. How is this done?

Hi there, I have a combo box that contains 10 names. For eg. I select John's name. It will retrieve his left250 value from Access database. It will then display as a label. I've managed to do this so far. However, when i add in a new name in the …

Hi everyone, I'm using ADODB to connect to an access database and it is working perfectly. but I don't really know that it is going to work when more than one person tries to reach the database at the same time...is it possible? moreover, does everyone has to set up …

Hi, I have an Access database that I have to create text files, fixed length field width, from a table - actually 3 text files from 3 tables. There's a module that does all 3 for me and puts them in the right place. How can I call that module …

Hi All, I want to store Student Name & Birth date in the database. How should I store it into database so that I can retrieve it back evenif the system date format is changed(It should retrieve record for dd/MM/yyyy date format also i.e. not only for default date formats). …

I have stored procedure in MS SQL and I want to deliver value from form (value of textbox) in MS ACCESS. CREATE PROCEDURE sp_DeleteOwing @OwingID int AS INSERT INTO Arhive SELECT MemberID, ArticalID, OwingDate, GETDATE() FROM Owings WHERE OwingsID = @OwingID DELETE Owings WHERE OwingsID = @OwingID GO I tryed …

I have inserted searching through passing parameter likewise. In search form there is only one textbox to pass the value. But there are three field names which are associated with that text box. For example: I have searched by passing phone number But there three field name tel1, tel2 and …

I want to stop users from being able to save a duplicate record in my Access database. I thought of using RecordsAffected, but I can't figure out how to get it to work. [code] SelectSearchString = "SELECT * FROM Breakdown WHERE BFrom = " & txtFrom.Text ' & " AND …

HI all ..... I am beginner of VB. net. I m developing a vb.net application program to store, update and search contact information and address. I have completed the data. I have used ms access as my backend. I enter data like wise; [code=vb.net] Dim con As New ADODB.Connection Dim …

I have stored procedure in MS SQL and I want to deliver value from form (value of textbox) in MS ACCESS. CREATE PROCEDURE sp_DeleteOwing @OwingID int AS INSERT INTO Arhive SELECT MemberID, ArticalID, OwingDate, GETDATE() FROM Owings WHERE OwingsID = @OwingID DELETE Owings WHERE OwingsID = @OwingID GO I tryed …

hi everyone; in my program I need to sort the recordset according to specific field, however it gives an error like "Run-time error 3251: Current provider does not support the neccessary interfaces for sorting or filtering" rs_data.sort = "k_baslangic" 'is not working.. btw my connection code is Set conn = …

[code] Adodc1.RecordSource = "Select * from brecord where month_borrowed = " & _ "'" & frmonth.txtmonth.Text & "'" Adodc1.Refresh Rptlibrarysystem.Show [/code] is my code alright do i have to set code in data environment or data report im using ms access the problem i'm having is printing a certain date …

I want to create new table in Access database during the runtime of my VB code. I am developing a "Library Management System" using VB6. At first i have used SQL statement to do the job. But it worked for once & then it stopped working. No error message was …

hi friends! From my Microsoft Access form I would like to hyperlink to a pdf document. At present each record contains a document name and a full file path to where the document is stored. I would like to open adobe Reader and view the specified document. please give me …

hi, im using msaccess as database. can u plz tel me how to delete records using vb (it should serch nad delete) tkx

I have a large amount of data on a page in IE6 window that when I try to convert to Excel 2003 using the built-in onverter on the page produces a file that is more than 255 colums wide so I lose approximately 50 columns of data. Is there a …