[microsoft:access] Forum Topics

I had created one project using Ms access as backend.I have four forms in it.I cant able to create exe for that project.When i click make exe it is not responding(when i click the task manager it displays that not responding.im using xp os).Can some one help me pls....:sad:

I need help in setting up a connection string from MS Access to Pervasive SQL.:rolleyes:

Hello, Being a novice at MS Access and the help menu being of no help I would like yours. I have a form that has combo boxes with the pull down information entered in under Row Source Type as a value list. The value list shows what I wrote in …

Have gotten the select statement and Update statement to work separatly, but need them to work on the same page and cannot seem to make it happen. Here is the current state of things. Any help would be appreciated. [code=asp] <% Dim conn,rs,strsql,sql_update,ssn,cps strsql = "Select SSN From CWCT07 where …

I hope someone can help me decide what is happening with this. It recognizes and carries out the select statement, will redirect to the proper place if entry is valid/invalid, but will not insert anything into the database. I first wanted an timestamp but am trying to troubleshoot backwards and …

what is the best way to develop a database for a survey? How should I name the columns in the database? I have an survey to develop and some of the questions have up to 80 answer options + quantity for the options. For example, I have a list of …

table : kisiler name surname points ----- -------- ---- ali elli 1 ali elli 5 ali elli 5 veli kollu 3 veli kollu 4 adem bacakli 2 ali elli 4 veli kollu 5 Q ; how can i get result has been showed below; ali elli 15 veli kollu 12 …

Please help me, about make class module to manipulation database ACCESS (*.mdb), so i can execute SQL statement like SELECT, INSERT, DELETE and UPDATE database itself.. I made my own project sample VB6.0 with no class modules at all, i thought my code/script not very powerfull.. Can you help me??? …

Hi there, I am trying to import a dbase file into an access database. Is there a way of doing this at a command level? I can do it using recordset but it's extremely slow. Pls help. thanks in advance. Please I need a code. Newvbguy

Hello, My work is a data base in acess 2000. In a form for a combo box I have set the rule 'No duplicates' to avoid duplicates as the primary field of the form is a differrnt one. However as the form carries many fields after this thers is no …

Hello, I'm a novice at microsoft access and I'm trying to make a validation rule to limit what can be entered in a field for hours worked. I set the field size to decimal. I set it up to have 2 digits to the right and left of the decimal …

My name is Dan. I enjoy online communities because it's a give and take type of concept. The learning is quick and exciting as well as enjoying others company. I'm currently joining to find an answer to a thread I just posted about microsoft access validation rule, but I will …

Hello, I'm a novice at [URL="http://www.daniweb.com/techtalkforums/thread67883.html#"]microsoft[/URL] access and I'm trying to make a validation rule to limit what can be entered in a field for hours worked. I set the field size to decimal. I set it up to have 2 digits to the right and left of the decimal …

I have been using a program that I wrote years ago. It is an Excel sheet that collects data from a MS Access database using queries. Everything was fine until this year (2007) My old queries work but none of my new ones.So I made a copy of and old …

I get a "too many indices" message when I try to access a sequel table via MS Access. Is there a work around for this.:rolleyes:

I ahve a client that exports an mdb file to a server folder from Access and their website auto updates with this information, it there a way to expot a file from FM8.5 that will do the same? TIA mac

I want to use an MS Access Database as a back-end. I am trying to: [B]Use data in one field (column) of my Access database as the items in a listbox[/B] Example, "Customer #" is a field in my database, i want to show all of the customer numbers in …

Hello, I've got a question, I want to use an acces database on a server. I want to use VB 6 to connect the database ussing the internet. Is this possible and how?? I don't want to use a VPM connection. André

i hope to find help pleaz i want to criat a complex Report by geting data from access table database thanks

Hi im having trouble creating a MS Access Databse using ASP. Scenario: When a user registers, i want to be able to create an MS access database. Here is a little code im using.. [code] <%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%> <!--#include virtual="Includes/adovbs.inc"--> <% Dim sDatabaseName sDatabaseName = "\access_db\MyNewDatabase.mdb" Sub CreateAccessDatabase(sDatabaseToCreate) Dim catNewDB ' …

I wrote a PHP script to "Access your Outlook application using PHP". Actually I wanted to access my Microsoft Outlook Calender to be accessed on web. I have tried for the following link [URL]http://www.programmersheaven.com/articles/Bogomil/art.htm[/URL] But I was getting the error Warning: (null)(): Unable to obtain IDispatch interface for CLSID {0006F03A-0000-0000-C000-000000000046}: …

I am writing a VB.NET 2005 Win Form that is used with scanning a barcode. I have an Access db that I need to compare a barcode value in a textbox with a matching value in the datagridview. I am thinking I should write a loop to locate the same …

05)What is the purposes of the Followings? These are located in device manager list………………Under [B]System devices[/B] [B]a) [/B][B]ACPI Fixed Feature Button[/B] [B]b) [/B][B]ACPI Sleep Button[/B] [B]c) [/B][B]Direct Memory Access Controller[/B] [B]d) [/B][B]ISAPNP[/B][B] Read Data Port[/B] [B]e) [/B][B]Microcode Update Device[/B] [B]f) [/B][B]Microsoft ACPI- Compliant System[/B] [B]g) [/B][B]Numeric data Processor[/B] [B]h) [/B][B]PCI …

Hi, I am creating a table in MS. Access from VB and bydefault the text type field "Allow Zero length" properties is NO. and I want to make it YES through VB coding. Is it possible to do that. THANKS IN ADVANCE. Manoj Jain.

I would appreciate any help with the following problems : Cannot open system restore - tried safe mode %systemsroot%\system32\restore\rstrui.exe - Cannot access or delete emails in messenger. Cannot access defrag ! Here is my HJT logfile :-Logfile of HijackThis Logfile of HijackThis v1.99.1Scan saved at 19:37:07, on 06/02/2006Platform: Windows XP …

I'm trying to make an event procedure in VBA that will compare the same field of two records for a conditional statement. Here is some psudocode of what I want:[CODE]If myTable.thisField[currRecord] == myTable.thisField[currRecord+1] then // Run a Query[/CODE] Does anyone know the VBA code for this? Thanks.

Hi All! I've already got the code to create a full Access database from code, but the problem I'm having is that I need the property AllowZeroFill to be enabled in some sections and I'm also having problems getting the AutoIncrement to work. Here is the code I have so …

Hello. I keep getting this message in my taskbar that says "Your computer is infected!" Critical System Error! System detected virus activities. They may cause critical system failure. Please, use antimalware software to clean and protect your system from parasite programs. Click here to get all available software." I got …

:cheesy: Help... I am not exactly a novice, but I am. I have been secured to develop an Access database for a very small organization. There are a total of 13 members who will be updating and pulling reports from this DB, so I am not overly concerned about heavy …

[COLOR=#0000ff]Hi. Im doing a program that connects a form to access database. Problem: I have a button that saves all the new information entered in the text boxes I have. When I click SAVE it shows a message that "A new record has been added to the database" but when …

Hi! I am creating a database for a class. It is supposed manage the hospitals Drug inventory as well as the patient's information and what patient is on what drug. I created a drug table (with drug_id, num_in_stock, and num_prescribed) and a patient table (with patient_id, name.. blah blah blah) …

I have a very simple table in "MS Word" (all fields are text fields) and I want to transform it into an "Access" table. How can i do it automatically? Is there any macro or a programm code that would allow me to do it automatically? (In the future I …

I'm new to FileMaker Pro and am very very puzzled. The words E-Mail Campaign Manager suggested it would have powerful tooks to send e-mails. However, my staff seem to be unable to find a way to sort e.g., for all "journalists" in "Taiwan", and then send emails to all the …

Hello everyone This is my problem- I am a C# student and I wrote a program for a address phone book. So when my teacher offered extra credit- I accepted- but the catch is he's not going to help at all. He said we can use any source but him. …

[COLOR=navy]Hai everyone I am a Bsc Computers Final year student from one of the best known colleges in south India ' ANDHRA lOYOLA COLLEGE ' . My name is Kenneth Clement , 20 year old . I am doing my final year project on GBMS-Guards Booking Management Systems using Visual …

If you read this, please help me asap, its urgent! I need to comunicate with a access database as a background operation in my program. I have to read off x nr. of records from the database and write a status back. HOW do I do it? Does anyone have …

Name: kediemetse NickName: saralinkie Weight: Mmmm Heish Ok, 60 Location:SA Age:33 Hobies: I like reading novels, gardening, golfing, going out with my Son to meets some friends, listen to Gospel, R& B is not the bad idea and listen to jazz. Favourate Movies: Ag Nigerian Movies, Ahaa James Bond, Jackie …

Hi, how can i display images in a form in Ms Access 2003. I have fields in a table and path of images. Thanks

[COLOR=#555555]Good Afternoon All[/COLOR] [COLOR=#555555]I’m very new to creating access databases. I am attempting to great a resource library of all the Books, videos and files that I have to manage. I have created 2 tables and a form with a Sub form attached to it. What I am hoping to …

Hi Folks, I'm trying to pass a string between two different forms in ACCESS with code, and I'm having some difficulty tracking down the proper way to do this. Assistance in completing this task is greatly appreciated.. Thanks in advance! - Jordan Here's what I want to accomplish: [B]Form 1: …

Hi guys, I've got a database which frequently need to be sent over the internet so that other users can update their data. As the database is huge with more than 30,000 records, it's really hard for other people to download it as they are on dial up. Is there …

I'm trying to disable IIS in Windows XP Pro so that I can install Apache 2.2 and develop PHP scripts locally. However, when I try to access the "Services" shortcut in Control Panel -> Administrative Tools, I get the message: "Windows cannot access the specified device, path, or file. You …

I have NO idea what is wrong with my computer. It's a Compaq Presario (CV735? not sure.) Anywho, when the computer starts up the taskbar doesn't load any icons and when I click the start button nothing pops up but the button stays pushed. When I try to click my …

I'm try to let a form have a drop down bar (linking to a field in a table) which when any name within it is click it will display on the report that area

Hey all, I'm using Access in conjunction with C# and ASP.net 2.0. I can't get the following query to work in Access, and I have no idea why it's throwing a syntax error. Any help would be appreciated. Thanks! [code]SELECT a.name, a.origDate, b.firstName, b.lastName, c.priority FROM afmMain AS a INNER …

Hey all, i am new to these forums and was wondering if anyone could offer some advice/help Currenlty we have MS Access databse which was created well before i started, this database has all our work instructions mixed into it. Unfortunately it isn't the easiest thing to navigate and seeing …

I'm creating an app with an Access database backend, and I seem to have encoutered two problems that I can neither explain nor solve. 1. When I run the app, there is a blank record that I can neither edit nor delete, and I am forced to click to add …

Is there a easy way to import emails from outlook to a access table? I know I can go file, get external data, etc but I am looking for a macro that will do it or some code for a button to do it. Thanks in advance for any suggestions …

I need help. I need a MS Access Database to submit for my final project in my Database Design class. Does anybody have one they could discuss with me?

We're using Access 2000 and have 9916 entires. I've been told we're limited to 10000 entries. Is it so? If so, can we upgrade to a new Access? Or, must we go to a more sophisticated database? What's a body to do??