[microsoft:access] Forum Topics

[B]hey plz help me in connecting ms access from C#[/B]

Dear All I wrote a code to save a data using text box but there are some error like : [B]ArguimentException was unhandled. Cannot bind to the property or column User Privilege on the DataSource.Parameter name: dataMember[/B] My code for saving is : [CODE]Private Sub btnSave_Click(ByVal sender As System.Object, ByVal …

Hello everyone....how could i make my database be in my exe project if im going to make my project a setup one...? what i mean if im going to acess my database (MS Access), there is a path of that database(depending where did i save it) in my code in …

hi all I'm new in vb.net and I would like to get some help in something I'm developing a database application with vb 2008 and my database is MS access 2007 but every time I insert some records , they gone after a few moments . When I insert them …

Hi I'd made a form using visual basic and added a few check boxes. I want to know you save the check box item into Microsoft Access Database when I click on Save. for instance: checkbox1: item1 checkbox 2: item2 checkbox 3: item 3 and in MS Access, I have …

I am trying to generate random images from access database using hashset as it is said to be unique and there won't be any repeated images appearing. But, it doesn't seem to work. How can i get it to work? By the way, i am very new to the concept …

Hello, I have two data comboboxes on a VB6 form "DataComboMasterPolicy" and "DataComboPurchasingGroup" after selecting the first appropriate choice with "DataComboMasterPolicy" I would like for the 2nd datacombox "DataComboPurchasingGroup" to only display the data associated with the user's selection. The data is in an Access 2003 db. My code for …

I am in the process of developing a local website that needs to be able to be logged on and off of without using an active connection to the Internet. I've decided to go with Microsoft Access as the database (if there is a better one for local databases, please …

how can insert an image to a ms-access database with using a java swing form and vice versa

I am a beginning programmer and am having a problem with adding a record to a customer table in a Microsoft Access database. I have worked for hours reading my textbook and troubleshooting to no avail. When I execute this code below the record is not added and I do …

Hey there, I am having a little trouble with my select statement. It works grand until I but a where clause in. then I the follow error [I]Syntax error (missing operator) in query expression 'MacStatus where((Rating =70 ))'.[/I] This is the string I am submitting to the DataBase . [CODE] …

I am using an access db with asp, the db is named patriots.mdb and table is named Users what I have been attempting to do is pass 3 form entries from this page: <form action="verifymeaction.asp" name="frmVerify" method="post"> <input name="UserName" type=text size=30 maxlength=20> <input name="Password" type=text size=30 maxlength=26> <input name="Pin" type=text …

Im having trouble with a running sum for my VAT analysis section of a report. Whats happening is the vat is calculated and rounded appropriately. But the running sum seems to be calculated on the pre rounded figure, is there anyway to rectify this. So i have following figures [I]245.70 …

Hey all, I am having a little trouble with my sql and VB.net I think There it is I want to select records from a customer table which is like what the user types in (So they don't have to be exact matches. The statment runs but I don't think …

ai.. i have try alot of times connecting the database in Ms Office Access 2003 with VB 6. bUT there is error when i try to connect between "record source" in vb with data that i save.Can anyone help me and give me some advise,references or way to solve this …

Hi, I need help. The thing is I’m developing this program and it is like a phone book. I made the interface with visual basic 2008 and the database with Microsoft access. I already made it to put new person’s address into the database and to show it on the …

hi, please assume it is already connected to the access database( it is connected) since i could get all the data out and put them onto a JTable. What is wrong now ... is that i am trying to insert new data to the access db and i got [code] …

Dear Sir, Please give the idea for linking VB with any Database(Foxpro Or Ms Access) and how can we print the required information from it in a particular format?

Hey all, Hope ye are all are enjoying christmas, I was just wondering if someone could help me out I am having a small problem with insterting a Date into Access 2007. I am Using the Now() Function in VB.NET and have change the format to General date In Access …

[CODE]Private sub button1_click( ) Data Set Dim ds as new dataset Ds = new dataset(“student”) Connectionstring Dim connectionstring as string = “provider =Microsoft.jet.oledb.4.0;data source = student”; Dim connection1 as oledb.oledbconnection = new oledb.oledbconnection(connectionstring) Command object Dim command1 as oledb.oledbcommand = new oledb.oledbcommand(“select * from student”) Command1.commandtype = command.text Connection1.open() Comand1.connection …

Hi everyone, please i created a[COLOR=#000000] C# windows application to implement a form with a ListBox, a TextBox, an Edit button, an Insert button, a Delete button, a Update button and an Exit button in the form. I want my C# program to be able to copy the columns of …

Compare field Field1 with Ucase(Field1) return 0 ever.. but I have any register with Field1 in mix case. Why Access retur every igual ?

I'm trying to convert ms access to filemaker pro.

Hello, I have been looking for a data integration / transfer program able to help with Access. I have had some advice but have not found the right software yet. The main feature is being able to migrate important quantities of contacts and data on a daily basis. The migration …

Someone please help! I'm writing a program that enable a user to search for a patient Info when patient number is given. here is the search code snippet [code] public ArrayList searchPatient(String patientNum) { try { String sql = "SELECT fname, sname, location, dob, dor, race, gender, status, initials, idnum …

Hello everyone!!! Can someone help me with this: I need someone to tell me if the code is correct about this: It should create a table, insert something into the table (in this case random numbers), select from the table, and erase the table. [code] import java.sql.*; public class dbAccess …

Hi I need to insert some data from Text boxes in an aspx page into an Access DB but I keep getting a Data type mismatch in criteria expression error. The problem is the Double which I think I have converted correctly. All the other fields are OK as strings …

m using ms access and c# i fetch the data frm the database which includes sr.no. and store in a data table. i thn display the contents using a datagridview. everythin is working fine.. heres the catch i do not want to display the sr.no...how can i make tht particular …

In my website i have to time a test. I am unable to time the test and then register it in ms access database. the time is in seconds. I have no idea of how to use a timer in asp.net using C#. Please help me!

:( I am have been trying to update changes from my vb.net program to an access database file and it simply will not work. I have am using table adapters. I'm not familiar with SQL so i can't go that route. It updates the dataset fine but not the database... …

hey i want to know how can i get a large paragraph from access to an asp page because i am facing a problem that access have size text 255 how can i make it larger? thank you

Hi how do i call a pdf file from a form in ms access please ?

Hello sir, I am creating student attendance tracking system in asp.net. With attendance i need to track students attendance every day and want to generate charts with those data. Charts for Daily Attendance report, Weekly Report, and monthly Report. For this how to design database in msaccess?

Hey all I'm currently setting up configuration for my webpages and i'm having trouble with Admin access. I'm using MS Access to store everyones details, within the database i've created an Admin user. I'm trying to configure the web.config so I can set access to pages for different users, everything …

Having problims adding a picture files to the database. Bot sure where i am going worng, ignore the commented out lines that was my first attempt. A little help please! [CODE] 'If the query found that the name had not been entered before add it into the table If imgUpload.PostedFile …

Hi all I'm having trouble with some of the login controls for my website. I've successfully set it up so when a user registers it enters the details into an Access database. I'm now trying to get the login to work but can't see how to implement this. I've had …

please help anyone.. i have MDE made with MS ACCESS 97 and i want it to work in MS OFFICE 2003, but have some errors... Can anybody help me with this problem???

I have many microsoft access database and saved under file name like 4945.mdb, 4946.mdb, 4947.mdb etc.. Inside each *.mdb, there are data columns like Serial Number, Part Number, Qty etc. Let say I want to create a Query using VB to search one of the Part Number in all these …

I'm trying this: [CODE]$recordset = $conexao->Execute("select * from PRO where CDate(PRO_DTCAD)+PRO_DURAC BETWEEN DateAdd(\"d\", +15, NOW()");[/CODE] PRO_DTCAD is REGISTER DATA PRO_DURAC is DAYS TO EXPIRE But: [QUOTE]PHP Fatal error: Uncaught exception 'com_exception' with message '<b>Source:</b> Microsoft JET Database Engine<br/><b>Description:</b> Missing ), ], or Item in query expression 'CDate(PRO_DTCAD)+PRO_DURAC BETWEEN DateAdd("d", +15, …

HI i am making a window aaplication using MS Access data base........ I have three combobox of Class, section and subject on form, now i want that when user first select class ,then he selects any section corresponding to that class and then from the third combo he could select …

Hello there. I've put together an Access Database which handles opening hours. However I want to be able to update each day individually, but at the moment it updates the entire week in one go. I know that I'm supposed to add some sort of WHERE in my sql sentence, …

I'm having a problem with loading my MS Access Database. I can get it to load but it won't load in a row. My friend told me to try this but it puts all the information in a column instead of putting all the information spread out accross the row. …

I have to write a program that creates a GUI that prompts a user to enter a query, then return the result to the same screen. All the examples I've found in my text book and other course material only shows how to account for a predetermined query. How do …

I am using MS ACCESS, and have 4 tables to update, from 2 different tables/spreadsheet Where table tb1- Client Index, Name, address and zip. tb2- user index, Sales rep, client index tb3- user index, Managers tb4- client index, Sales Target Master 1 has Name, address, Sales target and sales rep …

In defining MS Access tables where a 1 to many relation exists what is the best way to define a table containing the “many” records. For example, a database with orders and line-items might have the “line item” table with an order-number and a line-number which would define a unique …

Hi. I decided to try out the Report Wizard, having only worked with Crystal Reports prior, and when I try to connect to an Access DB with the default OLE DB data provider, I get "Unspecified Error" in the Add Connection dialog upon "Test Connection" or trying to accept the …

I want to process data entered into an Access 2007 form and then append the data to a table within the database. I started with a simple form with a button running a macro which ran an APPEND query, and this was fine until we needed to add some conditional …

Hi i need some help. i am trying to run a process that will move records from one table to the other and i am getting this error msg " Description: Catastrophic failure - Number: -2147418113" in the detailed error log but on the interface m getting something like Error …

Hi All I am trying to connect to access 07 via a windows app using msvs 05 in c#. I have the code which ive adapted from another working app but its now not working. Initialy the form should open an display the data rows in a table called events …

Dear sir, I doing one school project in VB6 with Access database. here I use Data bound grid control for view. and I want know how to calculate hours in DBcrid pls help me.