[microsoft:access] Forum Topics

Hi, I am trying to amend a single record in an Access database, the SQL to find the record appears to work but .... when it updates, it does so to every record in the table. Any suggestions why this might be? :-| Thanks, Stephen

Dear Crunchie, Hi there i am a newbie here and i am surferring the "Hotoffer" problem also. it's prompt alot of adult pic when i am working, hope you can helpme on this. I have followed the step that you instructed in early. but the "hotoffer" still there.... the following …

how is access used versus mySQL? i know access isnt much of a web database but what are its advantages/disadvantages over mysql?

Hi All, I hope you can assist. We have a computer (AMD Sempron 2200 with 80GB HDD and 512MB RAM) running Windows XP Pro and Office 2003. It is connected to a Windows Small Business Server 2003 domain. Everything appears to work fine except for the Database Documenter in MS …

Hello All, I need a script/code to connect my database without DSN and my database is in MS Access. So any body know how to create DSNLess Connection String for communicate with the database then please help me ? Thank you Harry!

Using access and visual basic A company has been using a program written in VB using Access tables for sales order processing. The data model they have is as follows. Customer customer No (PK), customer name, address etc Order order No (PK), customer name (FK), date Order_line (order No, stock …

Logfile of HijackThis v1.98.2 Scan saved at 4:56:56 PM, on 4/3/2005 Platform: Windows XP SP2 (WinNT 5.01.2600) MSIE: Internet Explorer v6.00 SP2 (6.00.2900.2180) Running processes: D:\WINDOWS\System32\smss.exe D:\WINDOWS\system32\winlogon.exe D:\WINDOWS\system32\services.exe D:\WINDOWS\system32\lsass.exe D:\WINDOWS\system32\svchost.exe D:\WINDOWS\System32\svchost.exe D:\WINDOWS\system32\LEXBCES.EXE D:\WINDOWS\system32\LEXPPS.EXE D:\WINDOWS\system32\spoolsv.exe D:\WINDOWS\Explorer.EXE D:\Program Files\NavNT\vptray.exe D:\Program Files\MSN Apps\Updater\01.02.3000.1001\en-us\msnappau.exe D:\Program Files\Java\j2re1.4.2_06\bin\jusched.exe D:\WINDOWS\system32\LXSUPMON.EXE C:\Program Files\Ydvq\Pyywyd.exe D:\Program Files\QuickTime\qttask.exe D:\windows\system32\ngrkep.exe D:\WINDOWS\system32\exp.exe D:\WINDOWS\system32\wintask.exe …

i am working with VB6. i used ADODC recordset. in my Form there is some text box and command bottom. it is about Student Data for example. it can view and add new record. i want a view after adding new record.so how can i refresh DataBase record from Access …

hi folks, i am creating a database in access 97. I have designed 5 different forms which are all linked to the same table. the forms share some of the same fields but not all, except for the admin form which sees them all. my forms are made up of …

Can someone please help me? I somehow got this search toolbar and i cant get rid of it. First i went into add/remove programes in the control panel and uninstalled it from there. Then about a day later it came back :eek: So i tried the same thing again, add/remove, …

Over Christmas I've taken on the task of putting together a database for work; I don't have a deadline but it would be nice to have something to show in the new year. The database I am intending to build is to track the location of wheelchairs in the hospital …

Wasn't sure whether to put this in the beginners section or here, so sorry if this is in the wrong section. basicly i'm trying to create a simple login page (not too simple obviously). basicly i use the query shown bellow to gain the userID: SELECT UserID FROM tblUsers WHERE …

Hi, I am working on a project that entails one beast of a database. A friend asked me to write a program into which he could catalog all of his cards by sport and then further by player, team, manufacturer, etc. The tools I will be using: 1) MS Access …

Hello. I have created a logon form in Microsoft Access and now would like the let the user know if the caps lock key is pressed. Instead of when the form is loading.... i would like a message box to display after the form has loaded and when the button …

I change query parameters in my code. i want the query to change her Sql property to new sql with new parameters. Set QueryDef = CurrentDb.QueryDefs("q_QueryName") QueryDef.Parameters("[Param_1]") = stringvalue_1 QueryDef.Parameters("[Param_2]") = stringvalue_2 QueryDef.Parameters("[Param_3]") = stringvalue_3 QueryDef.Parameters("[Param_4]") = "#" & Format(timevalue_1, "HH:mm") & "#" QueryDef.Parameters("[Param_5]") = "#" & Format(timevalue_1, "HH:mm") & …

hello people, i need some help on visual basic, i am currently using the lastest edition of visual basic and access xp, my tutor said if i want to access both of them i neeed to download a serpark from microsoft, 'SP5', do you happend to know the link to …

hi there, i ve got a visual basic project that is being linked to an access database. i ve already got a search function working to populate text box's with the information from one table in the relational access database. i am using the ADODC control to connect to the …

Dear all, I have a question around the issue of using VB6 to access MS Access databases. Can VB6 be used to open access 2002, retrieve data from and input data into a table? The following code keeps on giving me the message of "Unrecognised database format" error code 3343. …

Hi all, I've been looking at forums, I've got my hands on phpBB... (it was free!)... yet not sure about it... does alot of things I don't need.... and is a pig to alter the layout, styles etc. (my being useless with php is the main cause for this!). So, …

I need to transfer email addresses and email from one computer to another. What is the easiest way to do it? It has windows 95 or 98 on the one with outlook 97 and I want to transfer it to a new computer with outlook 2003 running xp pro. Can …

Hey guys, I am a beginner at MS Access and I was wondering if anyone knew of any good sites that hold good examples and methodologies using MS Access. Let me know. And is it better to learn MS Access before attempting SQL? Thanks.

Dear All, I need assistance with a Win XP computer on the network. I runs MS Access database applications. While working in database mulitple applications open especially blank outlook and access window pop up and slow my computer down. Can you please, help. Thanks.

Hi guys, I am writing to ask help as I have problems of modifying the outlook expresses on different computers so that they could share the same WAB. The situation is like this: I have two computers(Computer1 & computer2), both have outlook express. But only Computer1 has all the contacts. …

Hi guys, I am writing to ask help as I have problems of modifying the outlook expresses on different computers so that they could share the same WAB. The situation is like this: I have two computers(Computer1 & computer2), both have outlook express. But only Computer1 has all the contacts. …

I have a user that has asked if a Access 2003 file can be saved to be used by Access 97. I know it has not been known to be backwards compatiable but is there a way? Thanks thebum1128

hey when ever i make database project then when i make connection using odbc and afterwards with jet the error message is flagged saying unsupported file format. what should be done with that? please tell me.

Hi all....im newbie here ;) ;) Actually im looking for software under Decision Support System like Expert System, Management Information System etc..any software as long as it relate to DSS..if u have the software or know where to download it..please let me know :lol: :lol: Tq very Much

sir i am designing a web site.sir when a customer regiter in my site and order a product.then how i can extract customer order information from microsoft access database. can u send me ASP report source code.

epsos referred me to this board,looking for someone here to do a project for me on MS access,quite basic and examples of the project are online which i will PM you,please PM me or reply to the thread if you are interested,of course we will discuss details of payment for …

recently we had a power surge, and the next morning when we came in we realized that all the filemaker databases had been wiped out. I know this isnt much to work with but im not sure where to start in recovering it. any advice?

Hi all, I have a three part question with each inhingent upon each other. 1. Is there a function in excel that isn't global that will call the time and date? I'm using an IF function to drop the date into a column when text is input into the cell …

I am using the toggle field codes option to populate a report from a Word document. I have not been able to get this option to do multiple parts of a scenerio (ex. Does this condition exist? If yes, than do this. If no, do that.) If more information is …

hi.. I have just started learning VB .. I wrote the following code.. If s = rs.Fields(0) And se = rs.Fields(1) Then ... end if where s is declared as an integer and se as a string .They are got from the user during runtime.. field(0) and field(1) are the …

[font=Times New Roman][size=3]I have been experimenting with developing an application in FoxPro 7.0 for my personal use

Hi Peeps, I am new to this forum, I am trying to create a weblog to allow users who are registered in a database I create in Access to create a blog entry which will be displayed on the screen to every one. I have created the database i Access …

hello guys, i have a manipulation screen using Jinternal Frame which is a child frame accessed from the main frame. the child frame has save command wherein updates for a specific record is made. i use ActionListener event in the save button but i dont know exactly what codes will …

The computer is a Dell Optiplex GX270, running Windows XP Pro., and Office 97 Pro. I've had Office 97 running on this computer for a few months and Access was fine. I went to open it and got an error saying it couldn't be opened because there was no license …

I have Microsoft Office XP SP3 installed on an Windows 2000 Pro PC. It works great except for when I'm attempting to run one query in Access XP. This is a query that is based on imported data from Excel 2000. The query was also built from Access 2000 (Office …

hi all, i am creating forms and tables in access using vb code. when i click on ok in one of the forms i want it to open up one of the tables(in acess) and compare certain values. i tried using open "table" for random as #1 .......... but it …

Hi all Im new to programming and was trying to read/write/add/edit records in an access db. I have managed to read the data into a recordset(using adodb)but can i edit/add records to the recordset before writing back to the db if so how? a pointer in the right direction would …

Hello all~ Currently I am writing an ESL book that is a compilation of modern day terms/phrases in American English. I have put all of the information that I have gathered into an excel file and would like to search the internet for examples of the terms/phrases used to include …

CODE HERE A FOLOWS: namespace ODBC { #include <stdio.h> #include <stdlib.h> #include <tchar.h> #include <windows.h> #include <sql.h> #include <sqlext.h> #include <odbcinst.h> //-- #pragma comment(lib,"odbc32.lib") #pragma comment(lib,"odbcbcp.lib") #pragma comment(lib,"OdbcCP32.Lib") //-- #define IS_SQL_ERR !IS_SQL_OK #define IS_SQL_OK(res) (res==SQL_SUCCESS_WITH_INFO || res==SQL_SUCCESS) #define SAFE_STR(str) ((str==NULL) ? _T("") : str) //-- enum sqlDataTypes { sqlDataTypeUnknown = …

I am having problems making my code access the primary key, and to print information out to screen in a C++ program that I Am writing. Need some help PLEASE ! The Primary Key Name is ID1. HERE IS THE CODE #include <windows.h> #include <stdio.h> #include <conio.h> #include <iostream.h> #include …

My second. I was told that it is possible to create a button on a vb form that will either print out or display the entire contents of an access table... saved in access97. if this is true how? please :eek:

Hi all I need my project working on LAN For this i need Locking technique in VB through DAO Concept Via MS Access For Example, When i am trying to update a table, then another should not able to update record in same table. thanks Tiwari

Hello, I'm new here, and new at using Access... grrrrrr... To start off, I want to create a database for all correspondence, i.e. invoices, quotations, etc. etc. 1. Is it a good idea to use Access for this? 2. Any tips pleaseeee? Best wishes!!!! :p

I am new to php and i want to know if i can use microsoft access as the db??? instead of mysql??? please help?? :-|

I have Windows 2000, Service Pack 4 currently and I need to update my Microsoft Access 2000 to 2002 for a class that I'm taking. I'll try to ask this in the best way that I can. If I get the 2002 Office upgrade, do I also need to upgrade …

I have a table. I will add thousands of records to this database each year. It’s essentially needed to maintain inspection records. Each problem found get it’s own record. Its possible to go into a building and come out with 20 or more problems (20 new records). Records older than …

First of all it's free... [url="http://www.edmunds-enterprises.com/linux/cart.php/ba/pdtl/product/123"]http://www.edmunds-enterprises.com/linux/cart.php/ba/pdtl/product/123[/url] So far I've found it to be a better program than MS Office 2000, are there any pros and cons I should know of as far was word processing, spreadsheets, or presentations go? Edit: I don't know much about MS Access since it's been …