[microsoft:access] Forum Topics

Real PC amateur... Need help with virus on PC. I've read the diagnositics on forum and completed scans and logs as requested. Could really use help in trying to rid myself of these nasties. First I have a Red X next to my C: Drive, Next when I log on …

Hei, I have an Access database with a querry containing 40,000 rows. When I use "SELECT (*) COUNT FROM Querr" in ExecuteScalar, I get only about half of the rows. However, whem I copy the contents of the querry to a Table, a get the full 40,000 number of rows. …

Hey, I made a VB project which saves and loads data by writing and reading from an MS Access database. One problem is when i run the exe on a different computer i get the "Runtime Error 91 Object variable or width block not set " error. Now I am …

I'm trying to add data from an Excel 2003 worksheet to an Access 2003 table using Microsoft Visual Basic 6.5 (the one that comes with Excel/Office). I'm able to read data from the Access table using the following code that I got using the macro recorder: [CODE=visualbasic] With Worksheets("Pin Data").QueryTables.Add(Connection:="ODBC;DSN=MS …

My programs is using MS Access as its database. If by chance I must use other database like foxpro, must I rewrite my entire program? Or I just need to do minor changes because I change database applications, like for example ("select * from msaccess" to "select * from foxpro") …

I have a from that displays an employees info when selected from a list. The employee then updates text boxes as well as combo boxes to describe a type of project they are working on. I'm trying to add what the employee selects to the Project table. Here is my …

i need to update new records to the database. i created a button and typed the below mentioned code But an error saying,"Current recordset does not support updating. this may be a limitation of the provider, or of the selected loc type" appears. Could you please help Private Sub Command3_Click() …

I am working in an organisation. In this we want to create a database in MSAccess (MSoffice 2003) about the system information about the computers. By using one software we have the following inforamtion in text format. In this, We want to craete the first part as the field name. …

Hi There, I wonder if I could get help with something. I'm working on a DB for employees. Each employee has a position within the company, so, for example, "Staff Manager 1" and "Staff Manager 2" etc. I've made up a table called tblRole that holds the PK and the …

i have a data from Microsoft Access.. now i would like to show it out by Data Report and Data environment... can anyone, teach me how to use data repost and data environment??? thanks.... from vbgirl

hi all, I am facing small problem in access database . I am using MS-Access database in our application and i secure it by setting password to my database. But now i want to acces that database through coding in my vb application but it is generating error. So can …

I support a jet 4.0 database application that is deployed out to multiple users. These users have different types of Windows Operating Systems. There is some support from the vendor for this system, but they are not able to answer all problems. The data files live on a central server …

I have a listbox that contains data from a table in a database. I am using Visual Basic 6 and Microsoft Access. I have the listbox set up when you select a row the appropriate values populate text boxes at the bottom of the form for editing purposes. I am …

i have written a code for storing the data in MS Access 2003,but i didn't see the data in the database,can anyone help me plz.

Hi, I have two functions. The first function fills the first three fields of the first row of an MS_Access table. I want to fill the remaining fields of the same(1st) row in the second function. Presently the second function fills the remaining fields of the next(2nd) row while the …

Hey there everyone! I'm just about to start a database assignment for uni but don't know whether to use MS Access or MySQL. I am an adequate use of both but does anyone know the advantages and disadvantages of them??? Thanks ;)

Hi everyone, Designed a program using Front end VB6, Backend Access and I want to share it in Windows network for a few users. Please mention the procedure and syntax, this is my first program for network users. positively without mapping the shared folder to the users. Thankyou.

Hello, I accidentally deleted a column in my Access database, and do not know how to "undo". The undo button isn't an option, so do I need to do some system re-store or something?

Hi, I am developing one application which requires me to compare date.The dataabse being MS access 2003. When i execute the query in c# it does not show any record ,the date although matches with the date in database. Where is the problem ? The quey executed is select * …

hi, I would like to delete duplicate rows in MS ACCESS. Note: There are no PKEY in Database also the DB allows duplicate records. Please help Regards, DINIL

Hi, my names are Samuel Ikumoinein, i am writing my final year project on Database Management System for Healthcare Solutions. I am now in the system design stage and i have no idea on what software i am going to use or a concrete structural design even though i already …

Hi, I am fairly new at this so please bear with me. I created a table called vehicles with one field called vehicle. I then created a form to "Add a Vehicle" to add a new record which worked great. However, I had to go into the table and mark …

Hi, Frends Now I m Telling You How to insert Image Dynemically in Crystal Report 8.5 for the use in VB 6:-/ I Create an Job placement Software Crystal Report Which has some Fields and Photo of Candidate so First I Create an Crystal Report in 8.5 then Save it …

Hi, I am using the following syntax in VB 6.0 to copy distinct values from strTableName to TableName [code]strOpen = "Select distinct * into" & " " & strDupTableName & " from " & strTableName rst.Open strOpen, db, adOpenDynamic, adLockOptimistic[/code] But I am getting a runtime error "-2147217833". I have …

I am trying to format a form in Access 2003 where users could check off a box and have the home address (already enetered on another subform) auto-filled in the fields that follow. Conversely, if the box is unchecked, users can type the correct address into the fields that follow. …

i am developing a milt-language dynamic website in Classic ASP. the site is in English, arabic and French and the data is all stored in an Access database. my problem is specifically with grabbing the "FRENCH" submenus in a dynamic heir menu: [code] <script type="text/javascript" language="JavaScript1.2" src="includes/stmenu.js"></script> <% cl="Arabic" clF="French" …

We have a filemaker db collecting email subscriptions. We need to export those on a regular basis and import them into a listserv. We would like to write a script to have this all happen on it's own. Is this possible with FileMaker? There is a script in it that …

Hi, I am using Microsoft Infopath to try and create a front end for a access database. I have a data source which stores an id number for the customer. This id number relates to a secondary data source called tblUsers. the id field then relates to the users forename, …

Hi, I am using the following syntax in VB 6.0 to copy distinct values from strTableName to TableName strOpen = "Select distinct * into" & " " & strDupTableName & " from " & strTableName rst.Open strOpen, db, adOpenDynamic, adLockOptimistic But I am getting a runtime error "-2147217833". I have …

I make a project with a access file with back up. But I want to create same file from my project. I mean when I need i make the same file from my project. help me

I am trying to use an existing access db file with my c# app. When I try to connect, it says that: "The 'Microsoft.Jet.OLEDB.4.0' provider is not registered on the local machine." How do I register it/install it/whatever it is I need to do to make it work? Thanks. I …

hi , i have created C# windows application this application in Arabic language i try to store data at db when make save data for first time it work sccessuly but when i run the application after i exit app all data i have stored in db for first time …

Hi, I have a access 2007 database which makes use of attachments. I cannot seem to find a way to sent the attachments by e-mail. My table structure is simular to: ID: Autonumber Att: Attachment Send: Yes/No Eg: ID Attachment Send 1 xyz Yes 2 xyz No 3 xyz Yes …

I am trying to access a .accdb file from my c# app. when i run the app, it tells me that I don't have Microsoft.Jet.4.0 Provider installed. I know that I need the Jet provider to access MS Access files, I just don't know how to get or install it. …

[B]Hi all, Is it possible to programatically "Compact and Repair" an mdb file as can be done manually from MSACCESS menu "Tools"-> "Database Utilities" -> "Compact and Repair Database..." Any help will be appreciated... Rajesh Khanna [/B]

hi, Through VB i would like to delete duplicate rows in MS ACCESS. Note: There are no PKEY in Database also the DB allows duplicate records. Please help Regards, DINIL

im a beginner in vb. i really want some help in using vb. actually i want link my vb interface to data in access using adodb. then how to list data (access) through vb interface according to some criteria that had been set by user. Example: using customer id: 102,103,104,105,106,107,108,109,120 …

Hi, Looking for help. (Beginner) Here's what I have and what I'm trying to do... I have 4 option buttions (A,B,C and D) I have 4 Combo boxes named A,B,C and D, where the dropdown allows matching numbers 1 to 4. (Eg If Option B is selected the relevant ComboB …

I have an Access database that I use to keep track of account and inventory information for my job. I am currently writing a C# app to allow me to search through and pull up the information from a couple different tables and display them. How can I access the …

Can Anybody Put Me Through Out To Add Image To My Database? I've Been Trying But Easy. Get Any Solution Pls Reply Me Or <Snipped>. Thanks.

i need to use access to store my data in 2d array form.please explain me the procedure for that.or tell me, is there any way to create link to another table from a field item.

Can anyone help? I have been fumbling around with a SQL statement for days trying to make this work. I am looking for a Statement that will output a table based on an incremented number. Example Table1: Value1.......Value2.......Incremented Number 14...............null.............1 12..............15...............2 12...............98..............3 15...............14..............4 17...............15..............5 1.................14..............6 5.................98..............7 Example Table2: Value1.........Value2 X030............1 …

Hi, I have developed a complex database in MS Access 2007. The problem is that people from around the country will need to input data into the data base on a regular basis. With the data base being in our head office, I thought the easiest way it to make …

My internet explorer window title says "Hacked by pokemon" and I clicked start and selected run and then typed this in: "rundll32 iedkcs32.dll,Clear" it went away. But after a while the "Hacked by pokemon" comes back up on the window title. Also, when I type regedit in run, a black …

If anyone could help, I would be very grateful. About a week ago I was attempting to install a program which needed net framework 1.1. which is not installed. I had net framework 2.0 but it was corrupted. A used windows install clean up utility to delete framework 2 and …

Hello guys! I am working with an PHP page that will generate an excel file. The flow is all transaction made should be generated in an excel file. Also if there is another transation, the new information will be appended in the same excel file. I have work on this …

Hi All I am working on a Excel VBA proj. I ahve to insert some records in the Access Db. Right now I am forming the query as a string, creating a connection and executing the query Eg: "Insert into Table1 values ('A','B','Comments')" Now if the comments or any other …

I would like to create columns dynamically using VB in MS ACCESS. Help needed.

Can any of you tell me how to exactly change titles of USER Definated fields in this software? Also how do you delete columns in this program...Personally I thought it was like excel only to find that it is not..Any help is greatly appreciated.

there is another problem that i am facing..i got 2 comboboxes filled with values from MS Access and they have values like 1.00,2.00,2.98,3.00,3.25 and 8.00 I want to be able to choose 2 values i.e. one value from each combo box and when I hit click I should get queries …