3,459 Topics
I have database in MS SQL Server 2000 and I want to connect to this database from empty database in MS Access because I want to build user interface to that database and also call procedure and functions in VBA. Can someone tell me how to do this or tell …
hi Friends! i need to open a pdf documents from MsAccess. Please send me the code. Then i need to create a BROWSE button such that BROWSE_BUTTON Text_box When i click the browse button it should work as ordinary windows browse button and when i select some files, the "File-Path" …
Good morning everybody. I need a quick direction here. A column ("Comments") in my spreadsheet that is is supposed to have text values is displaying: "#VALUE!" Note: my input data is coming from an access query. The underlined Below is the data in the "Comments" field in the query (recordset): …
Hello all, I am trying to populate a spreadsheet with data from access query. Even though the recordset(input file) has approximately 49 records, only 1 record is written on the spreadsheet. What am I doing wrong? Below is my code: [code] Set rsin = M.DB.OpenRecordset("qBiWeeklyPeriodCombined", dbOpenDynaset) If rsin.RecordCount < 0 …
hi Friends! i need to open a pdf documents from MsAccess. Please send me the code. Then i need to create a BROWSE button such that BROWSE_BUTTON Text_box When i click the browse button it should work as ordinary windows browse button and when i select some files, the "File-Path" …
hi friends! I'm new to both vb and dataAccess. Now i have created a form in data-access. I need the datas entered in the form to be appended in the access-Table when i click the save button. For eg: Roll NO : Txt box Name : Txt box Sex : …
Hello please help me to calculate this one: I have a table containing this fields (name, project done, hours consumed) example: this is a table of a timesheet [code] [COLOR=green][LIST=1] [*]--------------------------------------------------------------------------- [*]| NAME | PROJECT DONE | HOURS CONSUMED | [*]-------------------------------------------------------------------------- [*]| A | 1 | 5 | [*]| B …
hi, can u plz tell me how to insert date in to msaccess i have text1.text=date what is the sql statement for inserting insert into table_name (datecolumn) values ('"+text1.text+"') this is showing error... plz check with this.. urgent...
I am tryig to match records from a query in access to records stored in a table. I have a littel problem which i am trying to solve? Table1 -manufacturer -model (primary key) -picture Table2 -Deal -price Query1 -Model (this is in a query as it has been split from …
Hi Everyone I m trying to open password protected Database for Data Report applying the following Code in Command Button1. Dim CN As ADODB.Connection Dim RS As ADODB.Recordset Set CN = New ADODB.Connection Set RS = New ADODB.Recordset CN.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0" & _ ";Data Source =" & App.Path & ".\MyDataBase.mdb" …
I am tryig to match records from a query in access to records stored in a table. I have a littel problem which i am trying to solve? Table1 -manufacturer -model (primary key) -picture Query1 -Model (this is in a query as it has been split from other data using …
I have designed a VB system along with its database in Access. They are running prety well. Now my problem is create a shortcut to my VB without me evoking it. I want a full screen to appear.. Thank buddies
See, here I am going to explain for all concerned in this forum, about the two types of Data access objects which you can use in your VB (?). There are so many postings on this subject. The duo is [B]DAO[/B] & [B]ADO[/B]. It is not misspelled acronym like PHP …
I have a MS Access database. If I want to create a function in VB6 that adding data into my data base by typing the new data on textbox and click the button. Is it possible. How do i adding new data to my database? Hope to getting help from …
Hello. The code below is for a program that uses the classis Access sample database called Biblio.mdb . The controls on the form are: 1 commmand button, 1 Datagrid control, 1 textbox, and 1 ADO Data Control. [code] Option Explicit Private Sub Form_Load() txtUserQuery.Text = Adodc1.RecordSource Adodc1.Caption = Adodc1.RecordSource End …
:confused: Hi, i have four tables each capturing data on assets.Each asset is required to have a unique code and serial too.So no entry is supposed to allow a double entry epecially the code and the serial.How can i implement this is in access?Someone knows how to go about it?If …
hey i am new to visual basic programming...just 15-20 days into it... i wanna know how can i use command button to access the ms access files instead of using the data control....how can i do that???? i have tried a lot of things but to no effect .... please …
please help me on how to change a user name and password in a VB project.
hello guys, I have an access database table with ten columns and I want to be to load all the data from my table into a vb.net form. can somebody please guide me how to do this. thank you in advance.
The code i have written (in VB)is : Dim dbMyDB As Database Dim rsMyRS As Recordset Private Sub cmd_Delete_Click() rsMyRS.Delete userlist.RemoveItem userlist.ListIndex End Sub Private Sub cmd_Display_Click() Set rsMyRS = dbMyDB.OpenRecordset("PC_User_Details", dbOpenDynaset) rsMyRS.MoveFirst If nm_txt.Text = rsMyRS!Name Then If rsMyRS.RecordCount > 0 Then name_txt.Text = rsMyRS!Name ip_txt.Text = rsMyRS!ip pass_txt.Text …
my project cannot run when i write it on a CD but on other media like flash disk it is running. give me suggestions please.
Hi I have a problem retrieving the data from access database. I have a list of records for eg. Name,user_name, password etc.(all in access) The problem is ,i want a solution wherein , when i double-click on a name, i want all the details for that particular name. * i …
Hello. In the classic database example, Biblio.mdb, the relationship between 'TITLES' AND 'TITLE AUTHOR' tables does NOT enforce referential integrity. Please explain to me why. I'm kind of a beginner so please make your explanation as simple and clear as possible. Thanks a lot guys!!!
Hi I am currently new in C#, I have finished exercising and studying how to code for console application. Then I plan to do a simple application. I started with a user log in. Where in the form will validate the username and password inputted by the user in an …
please modify for me this program. cant run in a CD but other media can. user name is walba and password is walba. check attachment.
Hi everyone. Am Tonnie and i got problem with my vb-access program i am trying to develop. When my program is in a flash disk it is running very well but when i copy it in a CD it is giving me an error shown below.Please i would like to …
How do i generate one data report fom multple tables.I have four tables each with a primary key.I require a master report for this data in this tables.Anyone know how to do it?Am using vb6 and access.Thanx
I didn't find creating login screens and saving the data in access database difficult... However, I was wondering if there is any other way we could do that, i mean saving the username and passwords in any other file rather than a database and encrypting the same... Rgds Sidz [email]hotsid_rout@yahoo.com[/email]
[TEX] hi every one i have problem in database if i want to create 7 tables by DAO liberary the name of the tables are : vn,itm,ctm,vst,sal,vnd & tin i have created tables as : Set db = CreateDatabase("WORKS.MDB", dbLangGeneral) db.Execute "CREATE TABLE vn(vn_nm text (30),vn_add text (100),vn_bo text (30),vn_tel …
About a month ago I replaced my old 2wire dsl modem with a d-link dsl-2320b modem. When I first set it up I used the wizard and I was up and running and was fast. I'd say maybe no more than 2 weeks afterwards the connection seemed slow and I …
Hi, i have designed reports with access.I need code to call them in vb so that i can print them via an application am developing.Anyone know how to do so?Thanx
I was wondering if anyone could offer a solution to this database design problem. I have very little experience with relational databases in Access. I have only used databases just to get easy data, but now it is starting to get complicated. I read a little on relational database design, …
Hey all. I'm a noob so please be gentle... lol I'm trying to update my access database via VB.NET 2003 by registering new users into the site. I have an INSERT Command and an OleDb.OleDbConnection but can't get it to work... Any suggestions would be greatly appreciated Thanks…
he y pls any one help meee in linking html with ms access.... i have noo idea about how to link html with ms access....
I have a spreadsheet that I populated from an access table (file). when I print the data in the spreadsheet, part of the data prints on one page and the other half prints on another page. In otherwords, I have to paste two pages together to see the complete record. …
How can i access data from MS Access using VB6 (I need the connection code) can u plz tell me the code for accessing tables in MS Access using Visual Basic 6. my access tables are in a server not in my local computer..... plz let me know the code
I just learn how to do a programming with vb6, and i have few problem that i need to get some advise and idea from experts here. Ok I successfully captured a data from a notepad text, and my access database data filed is look like this; Schedule sku size …
I have two snippets of code used in Microsoft Access 2003 VBA. It takes and integer and checks to see if it is in one of five groups; less than 2, =2, 3 or 4, and 5 or greater. Using IF-THEN-ELSE works, but Select case doesn't! Here are the snippets: …
I have a microsoft access program in a flsh disk. Whenever I try to open it, I get this error message: [I][B]Ms Jet Database engine could not find the object 'Msy sDb'. Make the object exists and you typed its name and paths well.[/B][/I] I click the HELP button and …
Sorry this is so long, but I don't know what would be needed to help me. I also aplogize for my messy coding and lack of notes. I am doing a project for a friend, but am having an issue with modfying an MS Access database with a windows form. …
Hi im a new member in this forum.. i really need your help as soon as possible, im doing my final project for graduating, its about doing a website for a hotel in jsp. i almost finished everything, now which im stock in it, and dont know how to do …
How do I display 1 row content in an access report, not all the database content.
I have 2 problems I need your help please: 1- How can I map the result of a select query? let's say that I have a table named "Item" and I need to delete a specific item record from this table. So the user first needs to see the information …
I'm trying to keep a date in a subform. Once the user enters a date and the procedure done on that date, he clicks on Add Record button and all the fields in the sub form are blanked out. I need the date to stay the same so the user …
I am trying to work with MSAccess through the use of ADOBC with VB6. I am having trouble with modifying current values. I have 3 input text fields in the form. FCUIPADDRESS, MCASTIPADDRESSA, MCASTIPADDRESSB. The MCASTIPADDRESSA+B are associated with the FCUIPADDRESS. For example: 204.168.11.234, 192.168.1.1, 192.168.1.2 I also have the …
:?: How do I change the input and display of the dtpicker control to "dd/mm/yy" format. Also how do I store it in an MS-Access database in the same format (ie. dd/mm/yy ) . ... need help urgently! Regards, Swati
New here, and a relatively new programmer in general. I've taken 3 years of programming in high school, including a year learning Python and two years learning Java, with one of those years at the AP level. I was recently hired for a summer job, and my company wants me …
I have code that opens and closes the connection to the database via table adapters every time I update because it was throwing concurrency and other database exceptions left and right. Now, if I try to navigate through the records it throws concurrency exceptions? I can add, edit, delete records …
Hi, a short introduction, oke: 31, female, dutch, married, one little babygirl, to manny computer problems ;) making a access db for my work hoping to find some solutions here kind Regards Shirly Newton
I'm a 58 year old and have been in the computing business in one form or another since 1973. I've run the gaunlet of operator - junior programmer - senior programmer - analyst - dp manager - project manager and back down as IT Support Analyst, MI Analyst etc. I've …
The End.