[microsoft:access] Forum Topics

[B]How to add and / or delete files to modify a program's installation?[/B] Hello all, this is my first post and to be honest, it doesn't really seem like this is the ideal forum to ask such a question, however I can't find a more relevent forum. Therefore if this …

What if you dont want to clear all the records in a table, maybe a few columns of the table, how do you do that? and secondly can you please give me steps on how to assign a macro to a button.

Hello I'm using an access database for a school project. The point is to get info out of a tag (stored in database). There's a path of a picture stored in the database. When i want to get it out, everythink works. But as soon the picture is displayed and …

Hello, U just started using acces and I need to make a query using multiple tables. I read some tutorials and watched videos but I can't seem to do it right. I have 2 tables: the first one is Login, the second one is Group. Login contains Username, Name, Group …

Hi All, I think this is my first question here. My web application uses an Access database and I'm getting some strange behaviour which might be related to that. Here's the issue: At the end of processing a users request (during which a lot of calculations are done), a record …

I'm trying to display some data from a MS Access database to a data report. It was successful, unfortunately, I need to display it in the format below: [B]emp_name[/B] [B]date[/B] [B]remarks[/B] [INDENT][INDENT][B]date[/B] [B]remarks[/B][/INDENT] [/INDENT] [INDENT][INDENT][B]date[/B] [B]remarks[/B][/INDENT] [/INDENT] [INDENT][INDENT][B]date[/B] [B]remarks[/B][/INDENT] [/INDENT] [B]emp_name[/B] [B]date[/B] [B]remarks[/B] [INDENT][INDENT][B]date[/B] [B]remarks[/B][/INDENT] [/INDENT] [INDENT][INDENT][B]date[/B] [B]remarks[/B][/INDENT] [/INDENT] [INDENT][INDENT][B]date[/B] …

I have 1 tabcontrol with 2 tabpages, each tabpage with 1 datagridview (different tables for each), I load these 2 databases on the form load: [ICODE] Me.AnndepTableAdapter.Fill(Me.HonorDataSet2.anndep) Me.SysdepTableAdapter.Fill(Me.HonorDataSet.sysdep) Dim sql1 As String Dim con1 As New OleDbConnection("Provider=Microsoft.Jet.Oledb.4.0;Data Source=C:\Users\user\Desktop\honor.mdb") con1.Open() sql1 = "SELECT * FROM sysdep" Dim adapter1 As New OleDbDataAdapter(sql1, …

hi all, i want to insert some data into my database (ms access) using c++...for ur info, im trying to do a register user for my login page..i hope after insert some data to text box and click button "ok"....all the inserted data was stored to database (ms access)....how to …

Hi folks: I get the following error when I try to convert sql to access: Microsoft JET Database Engine missing (;) at end of sql statement. The first part works fine but I get the error running second part. Below is the complete coding in vb.net for data transfer. [code] …

Hi all, I would like to ask a question. Is the way that we connect an Access 2010 with a C# application the same. Are we still using the JET ENGINE 4.0? Thanks in advance, Alex

I want to print one colum of the database, we'll call it foo, to a richtextbox, and then match the input in a textbox the user inputs to it. Any suggestions?

I am using MS Access 2003 to connect with VB. I have added all the referencess. Still there is an error in the line [code]If conn = "" Then conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\Automobiles.mdb;" conn.Open [/code] Will you please help me to solve this problem?

Dear Member, I have made my project through MS Access 2007 with a form. I would like to publish that form and database on web as it is so that i may assess it any where. Your prompt response is required. Best Regards,

Hi there? Can anyone plz tell me that how to connect html forms/pages to m.soft acess database?

Hi, When I try to connect a jsp page with MS Access database, it gives an error "[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified " What does that means?

Hello I created a database on Access with two tables, [icode]Table1[/icode] and [icode]Table2[/icode]. My question is, it is possible to join the columns from [icode]Table2[/icode] in [icode]Table1[/icode]? If it is possible. What do i have to do? Thanks

So I have a database (for tracking customer applications through to approval etc.) in MS Access form & and all (but access just isnt the best way to do this for many reasons I wont get into). I have looked at lots of programming language and decide that VB was …

Hi I have a database with many staff members and each staff member has many Customers assigned to them. I want to export customer details to a separate excel file for each staff member. I don't want to have to do this manually as its going to take up time. …

i want to know how connect a microsoft access using java and i want how to call this data base thanx:)

pls help me Write a VB program to capture and view the following student’s records: Matno, StudentName, Dept, Program &Level. Use MS Access or any other database. Note: Divide yourselves into groups

hi i am a new access user and i have been asked to create a database for students in our college. well i never knew i would need to to alot of work but clearly i can barely start. i need to put student details i.e name, age , class, …

I have created a table named "MapDetail" : the FIELDS identify the formname, the name of the textbox , and data to be transferred to that textbox. My form contains a map of city lots. Each of these lots contain a Textbox. My objective is to load each Textbox with …

Hi all, I have problem connecting to remote MS Access DB using asp.net. The MS Access DB i have URL , local path and write access. I have used the following connectionstring : [CODE] //con.ConnectionString = "Provider=MS Remote; Remote Server=http://X.X.X.X; Remote Provider=Microsoft.Jet.OLEDB.4.0; Data Source=c:\\yy\\XXX.mdb;Persist Security Info=False"; [/CODE] Error is : …

Hi, Im Newbie in VB, Need some help/advise here. 1)I dont know what different between Access Databass, SQL severdatabase, SQL server compact 3.5 in term in application? I just need a brief intruduction in when to use them(How to choose between them) 2)In My project, I use database to store …

hello, can you explain me on this the concept or how this will behave because i am confuse on this .. [CODE]Data Source=C:\myFolder\myAccess2007file.accdb;Persist Security Info=False;[/CODE] and by the way is this syntax persist security aplicable to Microsoft.Jet.OLEDB.4.0;?..please help me on this..hoping for your positive responds...

Like below quotes for serial no. for VB.net, do you have codes for ms access? Anil Gamare *********** [QUOTE=Jx_Man;682096]Try This : [code=vb.net] Public Sub GenerateNotaId() Dim myReader As SqlDataReader conn = GetConnect() conn.Open() Dim temp As String Try Dim sql As String = "SELECT MAX(IDNOTA) AS 'KODE' FROM Nota " …

suppose there is name and phone no in ms access database. i want to reterive the selected fields ie, by giving text in textbox and prompt for go command, i want to display that selected data (names or phone no) to display as table in alphabetical order.this should be done …

I need help to create a search button vb.net to search a access database that is binded in vb.net. I want to search for 2 items in the database and display then in the datagrid. the code i done is here. [CODE] Dim da = New OleDb.OleDbDataAdapter() Dim con As …

I was wondering if you could help me out, I'm trying to do a DB Add, Update, Delete program and I was using your program khanhtrung for assistance and got the ADD working perfectly but UPDATE/DELETE will not work whatsoever, this is my code for my delete button, and for …

Hi everybody, I was given a free choice for a project to complete for my class. We have been working in HTML, 3D Max, Flash and C# / SQL Databases this year, so I chose C#, which is by far my favourite thing to work in. However, due to numerous …

Hi I am trying to find customers name that starts with "S" in my access database. If i run the following query in access its working fine. Select Lastname from employees where Firstname Like '*S*'; it displays two records which is right. if I use it in access it..its not …

The program is an inventory control that is suppose maintain store merchandise details in random access files for 3 store locations each location saved to its own RAF. It also uses multiple forms for user to add merchandise, edit/view merchandise details and display an inventory report. Everything is working in …

how can i make this information of booking in acess?

I know that this topic, sending sms for MS Access, is very widely discussed and believe me for its very confusing. My question is the following. I use a MS Access Application and want to send sms messages directly from within MS Access to clients. I also use Outlook 2007 …

Hi everyone, I'm working on a Video Rental system in VB that needs to be binded with tables of information in MS Access. I have 4 tables (Employees, Members, Stock and Rentals) that need relationships with each other. I need to draw information from fields in 'Members' and 'Stock' so …

Hi i have managed to connect vb.net to Microsoft database access but now i am struggling with the code to authentication log in. when i log in to the form i want it to display the user name in the label in vb.net form. Kind regards Ricardo

hi all I am creating a Visual basic gui which shows an databse which has been created by using the microsft access database feature within visual basic 6. here is the problem i am close to hanfing in my project when i try and use the .exe on another computer …

hallo can someone please help me my Access Database ConnectionString does not work on the server [code] string strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|calculator.mdb"; [/code]

Hi, I know many people have asked similar questions but I wasn't able to search for a direct answer. Much like the other questions I'm looking into creating a web page that will allow users to edit/display information saved in a MS access database. For some reason, users have difficulty …

hi there i am building a one page website that i need query data from an access database (visual studio 2008 c# xml). I need to do a sql query displaying customers with possible bookings if any. I have been able to display all customers details but i am finding …

i want to edit records on datagrid,then update into access database! Please help me!

Okay so I have been trying to get this program to work for a long time. Basically it reads a text file then populates a structure that is designed to point to the four locations around that object: up, down, left and right. I believe I have the program figured …

I am using Data Reports throug Data Environment, and using Relational Database in MS Access.. I have prepared the query throuh SQL Builder(in data reports) and the query is running OK , but how can I pass parameter in this query to show the results on the data reports..... my …

Hi, so as I said in a post a couple weeks ago, I am doing a project for my school and I am having some problems at the moment. My problems include, get values from one tab to another in my form and get values from one form to another. …

I have created a Database with some related tables say Customer and order and they are joined with the CustID i have created the main form and the subform and linked them together. My problem is if i say put in the key where they are joined for the 1st …

setting a keyID in new form, then setting image related to keyID - Null problem Hi I am stuck - I am opening a new (child) form in Add mode Setting this childID, from the parentID from previous form Setting childID back to parent form for later reference. Once the …

how to get a top ten marks getter from a teble

I'm relatively new to access and have a problem. I have multiple rows of information on a form, and each of these rows has a few text boxes and one combo box. The combo box needs to have different information in it based on another field in the row. The …

Hi All I am trying to query my access DB using a C# windows app and one of the fields is a type date/time. I have set the field to general date but when i run this query it displays the date and time set to 00:00:00. How can i …

I have an Access database with a contacts table and a location table that is linked to contacts. When i click the add button I want to add a new contact and add that contacts ID to a the location table. The ID is an Autonumber, so when i add …