[microsoft:access] Forum Topics

This code is to split a Microsoft Access database and re-connect it on launch so that you can use Access on a multi user network...After Splitting the database manually, place the following code in the form that launches when the database is launched...

Hi, I am back with a problem as I promised!! I recently reinstalled my computer and hence I was stuck with the awesomely annoying and non functional Symantec's Norton Antivirus and Internet Security. I forgot to get rid of it and install a program that works. Later last night I …

hello, I am Midhun... I am doing M.C.A 5th semester... I am doing a project in c++ files with graphics.. Is it possible to link the output data to MS-ACCESS... THE output page first consist of [U]MENU[/U] about the program... I am doing the Miniproject titled [U]HOTEL MANAGEMENT [/U]where a …

Hello All. i have just finished coding a small subscriptions project for a magazine. My main challenge now is the package is supposed to send emails to subscribers notifying them if their days are due. email notifications are supposed to be sent to clients telling them of the status of …

I have a website i want to know how to connect my website to the Interent directly.

Hi Guys, I am stuck i need reports in my VB 6.0 small project (Crate Management System, anyone with good tutorials or ready to help me on this one, i have used ADODC and a Microsoft Access Database.

Dear all, I have been preparing an address management system using ms access as backend and vb.net as front end. I have got a problem in using search button. How can I display searched datas in access files in grid. (can i get a code for it if you really …

I face the below error message, when I attempt to mount an Access database "Microsoft Access has detected corruption in this file. To try to repair the corruption, first make a backup copy of the file. Then, on the Tools menu, point to Database Utilities and click Compact and Repair …

Hey guys, I'd like to create an access database for a vaccine clinic I am managing in a large slum here in South Asia. So basically I want to create a form that auto-populates. Say a baby comes in: I open a new form, assign a unique id (probably the …

Good day sir.. i just want to know how to link the access and VB6? and im wondering if how ado works...

Another problem in my program is that I can't get my access database to update. It works on the other fields here is the code [code] Public Sub Lockuser(ByVal path As String, ByVal userId As String, ByVal access As Boolean) Dim sqlConn As OleDbConnection Dim oCommand As OleDbCommand Dim stmt …

Hello there!! i am glad for the help i have recieved before which helped solve my problems. my challenge now is that the following code fails to save to my Access 2007 database. it doesnt give me any errors but it does nothing. i want details i enter into the …

Excuse my English.. At work we have porting some app to MySQL, but there are still some Database in Access 2.0, Access 97, DBF, etc Some important database is "codifica" is in access 2.0, this DB contain to many tables that are used in other DB. I need copy data …

Hi I have a problem in connecting MS Access to my vb.net 2005 form. I want to write code for navigation buttons like movefirst,move next etc and for insert,delete etc operations on records in Access table. Can any one send me code for how to connect for these...

Excuse my English.. At work we have porting some app to MySQL, but there are still some Database in Access 2.0, Access 97, DBF, etc Some important database is "codifica" is in access 2.0, this DB contain to many tables that are used in other DB. I need copy data …

Southeastern Arizona Medical facilities have a grant to install a new network for patient information exchange. Who knows anything about the AZ Access Data Exchange - might be called AMY? What kind of network is needed? etc Dr Sundance

i cant access antivirus website and also microsoft website pls help me

OK, i have a form with 3 controls. 1 x textbox, and 2 combo boxes. The scenario is like capturing students taking courses in a specified week number. e.g. TxtWeekNo CboCourse TxtStudentName 1 Engineering Joe Bloggs 1 Engineering Jay Rock 1 Law Mary Joe 2 Engineering <Nothing to select!> What …

Hi I have problem with packaging and transferring VB6 and MS Access database from one computer where it is designed to another computer. I need some help. thank you.

I am having trouble with textbox multiline when it store to Access database and returning in gridview show one chunk of string. Is there anyway to place each data into each own row? Input: google yahoo msn Output: [url]www.google.com[/url] [url]www.yahoo.com[/url] [url]www.msn.com[/url] But right now it is give me [url]www.googleyahoomsn.com[/url] Here …

Hi all! I would like to use microsoft access permissions in my app. how can i do this, i used 'user level security' but when try to connect to DB in my app. Couldn't. Warm regards Sara

Hi, The database on MS-Access is kept on one machine and i have to access it from another machine.. I have given the following connection string on the client machine. But still it is not accessible. I have shared to Databse folder with full permissions... But, still it is not …

I request, I want I install a program that is supported in Access 2003 in the PC my friend. I don't want however it is transported from there in other PC That I can ensure the not copy of program from the PC of my friend?

Hi everyone! I am having difficulties in terms of manipulating data using datagrid. So my problem is this, I have 2 forms;namely, a form for logging in, then secondly, a form which is similar to an inbox. I have a datagrid in my inbox to call on records in my …

Hello everyone, can someone help me with this please? Create class which will create tables in data base (Microsoft Access). About the tables: number of columns, type of data, lenght of the data. And mantaining the information (the data) in the tables- add data, delete data and edit data. So …

I have access 2003 and sombody send me an access 2007 db . how can I open it?

Hello, We have a number of small access 2003 databases. We will be upgrading to access 2007 and there will be a period when some of us are 2003 and the remainder 2007. Is it going to be possible to use access under both 2003 and 2007 simultaneously? Thanks in …

Hello, I have an access table where I have to import a csv file. I have a very simple code in the Click _ Event Sub. However it seems the code is ok, file gets imported but I get a separate table with errors in import. In that table two …

Hello, My MS Access database includes one table of workshops that are provided by my employer. Each record in this table includes a date field. I would like to create a calendar looking form in which a text field (workshop title) is displayed on the correct date. Any help would …

Hi, I am create one application using c# and Ms Access 2007 which is run on one machine how to run this application on LAN. suppose keep database on one machine how to access database from another machine Regards, Shailaja

How can one update automatically the tables in Ms Access such that once you input an item it is automatically viewed to other tables that are related to that particular table in relationship and the methods used to link Ms Access contents to Visual Basic Interfaces created according to the …

am using Microsoft visual C++ 6, running on window xp. i create mkdir("C:/asd") and store all the files that i craeting during my program. End of the program, the folder and all the files will be delete/remove. I would like to know how can i lock/block the folder and files. …

good day.. i have a problem in accessing my Access database in network.. I made an inventory system... i couldn't run the program simultaneously in two PC. i got this error >>> "could not use.. file already in used"... i thought it can use in network? is my coding have …

hi i am using [B]VB.NET 2003 [/B]and i want to export some data from a microsoft access database into a multidimensional array... how can i do that? i could not find a single example on this...pls help:'(

[CODE]Hello everyone, I am write a program, which have to read an excel file and save it in an access table. The excel file will be upload. The data will be read and saved in an access table named smsbestand. Can anyone one help here is the code: extension = …

Hi, I am getting an error called 'Data type mismatch in criteria expression'. This only happen when I tried to add an item. Can anyone tell me what is the problem with my code? I am using access database.

Hello, Have a Access problem. I have 1 master table with records by Sales Rep ID (80001, 80002, and so on). For each of these ID's, i have multiple lines of records that show their sales (Revenue) by customer like follows: 80001 5,000 IBM 80001 7,000 Staples 80005 6,000 Motorola …

hi....tell me hw to do add any date field to ms access using vb.net. i'm created ms access database field date/time datatype but can't add records to database,. how to get system date without time in vb.net.......

Hi all I am creating an app that utilises and MS Access back end and queries it quite a bit at various times. What I would like to do is bring in an entire table and then query the row(s) i want as I need them. This is what I …

Hi Dear Friends...!!! I am developing a Attendance System in C# using MS Access Database. I want to Count the totall P and A in the Attendance Column... now Dear Friends Please tell me any Query or logic to do the above work...!!! ***P for Present*** ***A for Absent ***

Hi all, I am doing a simple application which is to create a register form which I am not quite sure. To stored the data, I am using the MS Access. Hope that anyone could help me. Thanks Regards LiL_Is

Hi there I have a problem with coding application with relational database in access. I have 3 table with relation to each other with one key. The tables are Faculty, Department and class. I relate each faculty to many departments and using the faculty id as foreign key in department …

I have a problem with creating this database. I want to create the student record system. I have a table containing Individual information and using of ID as primary key. For registering grades I use another table for grades. But here is the problem. Here we have 6 or more …

I have a products table containing the following fields amongst others: Product ID Product Name Product Type Trade Price RRP In my order table & form I have fields that I setup with "look up" data type (this puts a dropdown box on the table & form) that finds data …

I have try to get used to the database -java connectivity with a simple address book application below : [CODE] import java.awt.*; import java.awt.event.*; import java.sql.*; import java.applet.*; import javax.swing.*; /////////////////////////////////////////////////////////////////////////////// //Creates the main window with top Menu toolbar. //This is also the class for the main declaration ////////////////////////////////////////////////////////////////////////////// public …

This is not a homework problem & my first post in 2+ years. I just got asked to do this in C# based on my asp & DB experience & I am tearing my hair out as they want in done in one day & 2 MS videos say to …

i have a problem here with my code, it happens that if i save an ordinary text or number, it is working, but when i try to save time and dates, an error will occur and saying My Error Syntax error in INSERT INTO statement. here is my code. //DECLARATIONS3 …

Could someone please help me with my access database. I have chart I added in a report. I wanted to group the month names instead instead of ordering it by the year month like 31 august 2009 for example. march value in 2007 was 2, and in march 2008 it …

I'm a little confuse with regards to database and how it's used. I want to store my window application's data into microsoft access. Example. I have 3TB TBCurrentpassword TBNewpassword TBConfirmpassword how do i write a program: 1. Store data in Microsoft access. 2. Compare the data stored etc. and what …

how do i create a login dialog box in my database that does this, 1. there are two blank textboxes. one for username, and one for password. 2. when the user clicks the submit button, it will look for a match of the username in the table, then checks if …