[microsoft:access] Forum Topics

Heya I have to write a script within MS Access 2003 using Visual Basic for Applications to read in data from a textfile and insert it into the table. I began my programming path using dot.Net C# and started database manipulation using Sql Server. So this is kind of like …

I want to connect My Access Data in my Web Page. Is this possible? If yes, can you tell the way to connect. IS THERE ANY WAY TO USE ADO CONTRAOL TO CONNECT MY ACCESS DATABASE IN A WEB APPLICATION. CAN YOU PLEASE GIVE ME THE BASIC GUIDE.

i have written a vb.net coding for linkin my vb interface to my access database...its all the same....but some linking codes i wrote work,for other forms,but sum don work... this is 1...its a form to add staff in my system [code=vb] Imports System.Data Imports System.Data.OleDb Public Class Form1 Dim ds …

I can open most of the FileMaker files on our network. But all of a sudden I've been getting errors when I attempt to open a couple of the files that were working fine all these years. When I try to open these problematic FileMaker Pro 5.5v1 files, I get …

I need help,i have a problem,i cant seem to insert from my vb interface to my access database...for example the access field is a fate type......how am i supposed to do it?,like if i enter my date like 24/2/08,it ll go in database,i tried my oledb.varchar,oledb.dbdate also does not work....can …

Hi friends, Please send me process of making a project [B][U](backend Ms Access and front end visual basic)[/U][/B]running on LAN. I tried but i got message [B]file already in use[/B]. If not possible tell how can i identified which IP(user) use that programme. Thanking you Pardeep

I want to the format of Dt Picker with link microsoft access. I write in format property dd/mm/yyyy. and the month is show, but this didn't link access . why?. any body help me to how the format link of Dt Picker with access. This project is important for me....... …

hi all, Can anybody give me code for connecting vb 6.0 to ms-access 2007 with connectionstring Regards Guest11

As a beginner VB 6.0 user, i have tried to make a simple database-link VB project. There were problems when i used a Microsoft Access Database which have some combo-boxes field (made by look-up wizard options). Is there any way for me to make the combo-box field in the database …

hi all, I have developed one application in vb and database MS-Access2003 it works properly if i use ms access 2003 or earlier version but if i run this application with latest version of database than i am able to view the data from database but not able to insert …

Hi friends i want a help from u friends my application is using ms access forms as front end and we are using vb for coding i have a form consists of a combo box and a button named export,when we select an item from combo box and click on …

Guys I know there is a way of only writting 2 lines of code in VB.Net when Connecting to a database that are [ICODE]DataAdapter.fill(Dataset, "Tablename") [/ICODE]and then u can have all the buttons required such next, delete, previous, last and so forth without adding them but I dont know how …

Hi, first of all sorry if I post this in the wrong section. Cant find where is the VBScript Section. I'm new to VBScripting. What I need is the VBScript to count the number of record in my MSAccess table. I tried [ICODE] total = "SELECT COUNT(*) FROM Product" [/ICODE] …

Hi there, Just joined the community! Been having trouble all day with the following select statement and MS Access database: [SELECT * FROM client_referrals WHERE client_id = 1 AND ((date_of_referral >= #9/21/2008#) AND (date_of_referral < #9/28/2008#)) ORDER BY referral_lastname ASC] The [((date_of_referral >= #9/21/2008#)] section of works, so all dates …

Hi, Im not really sure if this is in the right forum but it is about MS Access so i thought here was as good as anywhere. Basically i am trying to make a front end for an ms database - and to be totally honest i dont know where …

Please help me with my project When the form loads it will connect to serial com and retrieve the number of chinups from a PLC and store it a variable called 'int' there is a textbox in the form called 'txtname' and a button called 'ok' My question is when …

Hi, I have created a login form that has adminid and password.. I use visual studio 2005,database access. login form work smoothly when i enter the correct adminid and password but never display an error message if wrong data was entered or no data was entered. I need a help …

I am trying to setup a page on my website with a text input box and a command button. A user will type the serial number of their product and click the button...the result I am looking for is a message telling them if their product is in warranty, out …

Hi, first of all sorry if I post this in the wrong section. Cant find where is the VBScript Section. I'm new to VBScripting. What I need is the VBScript to count the number of record in my MSAccess table. I tried [ICODE] total = "SELECT COUNT(*) FROM Product" [/ICODE] …

Hi, I am using an excel sheet containing around 200 records and linking it to my MS-Access database through the Link Table option available in MS-Access. But I need to change it everytime when I go from one system to another as the path of the Excel file changes. That …

Hi All, I have a huge MS Access database in which requests are added at regular basis as in almost every minute.I have to modify the data type of one of the coloumns in this database,but i cant copy the database to my system and make this change and then …

Hi, I am trying create a query that counts all records which have the field Hypotension=1 (which is Yes), but I only want to count the same customer once. For example: My table has 3 fields: RecID (primary key), MRN, and Hypotension RecID Cus# Hypotension 1 6 1 2 6 …

I am trying to work on VIEW command of SQL. Whenever I write the SQL as [code=sql]CREATE VIEW PartOrder AS SELECT PartNum, NumOrdered, price FROM part;[/code] I get an error message "Syntax error in CREATE TABLE". I dont have any problems in writing SQL commands but whenever I mention CREATE …

how to transfer a database from ms access to ms sql 2005 through a button clik event in c#

Hi friends, My problem is i am unable to find out records within a specified date. I am describing my programme detail i have a column in ms access table name [B]travel[/B] column naem doj data type [B]date/time[/B] format short date ' dd/mm/yyyy in visual basic i took two datepicker …

Can anyone tell me if there is a way to add Access to a purchased copy of MS Office 2003? It is a company pc with only MS Office standard installed and since this version didn't come with Access I would like to legally install it. Does anyone know if …

I need help to make a Access user system. I'm very new to VB and am trying to make a system that allows a number of users to register and have individual username names with specfic passwords. I've never done this before so any help will be greatly apperciated, even …

Hi Folks Iam trying to insert values into my access table using c# and iam at my wits end My Access table has the following fields Country State Curr VAT and Exchange I have made them all as text for ease of use in the access database this is my …

Hi, I'm hoping somebody can help. My browser(s) seem to be giving me some problems. For example. If I search for "hijackthis" I get decent search results. Only problem is... If click the links provided from the search, I am re-directed to full ad pages that are relevant to my …

Hi All I am creating a database archiving tool,in which a user can delete all the data before a date he would specify.But the problem is i am not able to create a delete query which can delete a range of data. I had created the following query [CODE] <% …

Hi Guys I hope you can help share some light on my problem. Basically, I have a MS Access table...ID, firstname, surname, Address1, Address2 etc What I want to do is Select all from table but only show one record where more than one person lives at that address .. …

Hi guys.... hope someone here could help me, im creating a program connected with a database (i used MS access) the i want to add a search function on it... any of you guys could share some codes that i could use as reference would be greatly appreciated... you can …

Hi All I am creating a database archiving tool,in which a user can delete all the data before a date he would specify.But the problem is i am not able to create a delete query which can delete a range of data. I had created the following query [CODE] <% …

Hi friends, I have problem of selecting recordset between a specified date. I am giving my coding detail below. I took a field in Ms Access table table name-travel fieldname - doj datatyoe - Text and vbcoding dim db as new adodb.connection dim rc as new adodb.recordset db.open"Provider=Microsoft.Jet.OLEDB.4.0; Data Source='d:\tmgmt.mdb'" …

Can anyone steer me in the right direction here as to how I go about creating a form in access based on more than one table.

[B][/B]Please help me out with this. Crystal reports entertains the MEMO field from ACCESS in three ways (uninterpreted, RTFText and HTMLText). Is there a way in which I can print the object in the MEMO field because I have the tables and diagrams in this field. and they don't print …

Greetings! I would request your expert help with suggestions on moving an existing database from FileMaker Pro v.8 to MS Access. How can it be done and what are the pros and cons of doing so? Thank You, Regards, nsb

Hi, I want to create a form with 2 textboxses(starting number and ending number) and 1 button. When i click on button it is going to list all the records between two numbers in a report. How can i do this? Thansk

Friend of mine is working on making a Bank Database in Microsoft Access. After trying different validation format, we failed to get exactly what we wanted. We did the setting for "Account Number" as "AutoNumber" & set the format in the way, that every time the new record gets created, …

we are able to query successfullu from a Column called "ParentUUD" (without space) using query "SELECT Name FROM PartVersion WHERE ParentUUID='"+ str(lstUUID[0]) +"'" we have a column whose name is "Parent UUID" (with space) We are trying to query the column from PYTHON. we are getting error.I think the error …

Hi.. i am running a multiple forums with many subdomains based on different country, we are using ASP script using MS Access database. I wish to get someone to make some modification , so that when the MS Access Database in the subdomain forum get updated, it will also automatically …

Hi, does anyone know if there is a backup SQL statement in MS Access to backup the entire Database?

Hello Fnd I want to be Know How to Interact Ms-Access Using c/c++ Pls kindly send ur Answer To my email <email snipped>

Hi I'm having a problem where when I open up My Computer I try to acess my documents and it opens for a moment then I get the pop up error message, sometimes the screen doesn't even load it just has the flashlight looking for the file. When I try …

Hi All, I have put together a service delivery application in Access that needs to send SMS messages to technicians in the field. Any ideas on how I may achieve this? Regards

I've just joined Dani Web - I work in the computer industery but all my knowledge is hardware based. i am, Secretary of a Cricket league and I want to arrange/design a database for Player Registration to ensure that each player for each team will have a unique ID number …

Recently some of our users have been having trouble using our VB program that gets data from a MS Access database. When checking those users PC's, we find that by going to MS Access on those machines, and the TOOLS > Macros > Security , the security level is medium, …

im having problems accessing some web pages they randomly load with "failed to connect" & error loading page etc, using both firefox & IE im not sure what it is have run various scans & issue hasnt been fixd also noticed that iexplore.exe is running is SYSTEM even tho i …

I have following query... [code=sql]SELECT * FROM tblAccount WHERE intRegionId in ([@intRegionid]);[/code] if i put hardcoded values like [code=SQL]SELECT * FROM tblAccount WHERE intRegionId in (2,3);[/code] It returns value but if i try to do it with parameterized query such as SELECT * FROM tblAccount WHERE intRegionId in ([@intRegionid]); & …

Hi All, I am developing a report generation web page in which i have a text box in which a user would enter a value and i have to extract similar data from my MS Access database. I have tried using wild card % but it is giving an error. …