5,053 Topics
 | |
| | I'm still new to Microsoft Access so I don't have a great understanding of its workings but have spent the past couple of months working on a project to manage the company's telphone bills. I'm essentially compiling the usage from every company phone each month into a final table by …  |
| | Hello everyone. I am working on my final project at university for C++, and I got stuck a little. I have an array inside an array. And I want to access that inner array's member and print it with cout. Here is the code: [code=c] void standings(userClub uc){ cout << … |
| | Hello! I was looking for some help with something I'm trying to accomplish with MS Access. I have data set up in the following manner: [CODE] CUSTNBR|TRANSYTD| RPTDATE --------------------------- 1 | 7 | 5/28/2010 1 | 10 |12/31/2010 1 | 2 | 4/29/2011 2 | 8 |12/31/2010 2 | 6 … |
| | I have a report based on a query that uses parameters (Date datatype). In the report header I have some other data that is also generated using the parameters (Same parameters). This data is generated programatically and I use a dialog box with date in it. Now, I want to … |
| | Another day, another IE flaw! Just when you thought it was safe to go back in the Internet Explorer water (mainly as Microsoft told you it was after [URL="http://www.microsoft.com/technet/security/bulletin/MS10-002.mspx"]releasing[/URL] yet another [URL="http://www.itwire.com/content/view/24364/1231/"]patch[/URL] to fix yet another vulnerability) comes the news that actually, would you believe it, but Internet Explorer still …  |
| | Hi, I've created a MS Access (2007) database storing details of a charities clients. Is there a validation rule/piece of code for the following: FIELDS: Date, Time, Duration, Room CODE FOR: Not being able to select a room if it is on the same date and time/duration? I'd really appreciate … |
| | Hi i am trying to write dataset into excel using oledb connection. I get an error "The microsoft access database engine could not find the object 'testTable' Make sure that name and path is correct". I understand that dataset is not in the excel thats y i get an error … |
 | Hey, I'm working on a project where we have to stream files from a server app to clients. I have it all working nicely, but we have a special client type that cannot save files to HDD, not even temporarily. I can get the byte stream from server to this … |
| | static void Main(string[] args) { string[,] fp = readFilePaths(); OleDbConnection con = new OleDbConnection(); OleDbDataAdapter da; DataSet ds = new DataSet(); con.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:/Documents and Settings/kyalanur/Desktop/Nav tool/PCGDataManager.mdb;User ID=;Password=;"; string sq = "SELECT * FROM History"; con.Open(); da = new OleDbDataAdapter(sq, con); da.Fill(ds, "History"); for (int i = 0; i …  |
| | I need to access my browser cache specifically, the cache in Camino browser and Opera browser. I need the commands to get the cache, or any other method to obtain the cache. Thanking you in advance, I remain Mike Levinson |
| | I am currently using microsoft access 2007 and vb.net 2008. The problem senario is this: I have a database-table that contains two columns, items, and the price of each item. I tried to drag this table to the form as a checkbox tool, but only one checkbox1 was diplayed. The …  |
 | I have made the mistake of adding a large amount of comma separated data to a specific field in a certain table without adding spaces between each! (Stupidly didn’t realise the associated application requires spaces!) Now I am trying to create a query that can add these spaces in automatically …  |
 | Hello I m using ComponentOne C1 Flexgrid in my project. Scenario is i have an Order Detail Table and an Order Delivery Table. when form loads grid show three rows with a checkbox in its 1st column. what i want to know is the logic i need to use is … |
| | I have two tables, Episodes and Seizures, with their respective Forms. On Episodes, I have a button the user clicks to open the seizure Form and its internal working is below. The problem is when the form is opened and filtered by parent form, the seizure form instead of filtering … |
| | okay so i figured everything out for my project except how to get this simple select statement to work. i have a table named [B]Car[/B] that i LINQ'd from a Microsoft Access File. please help. i want a button to display the Car database according to the SQL statement. thank … |
| | I am creating a database in MS Access 2010, I have 6 tables. My question do all 6 tables need to have either a direct relationship (primary key to primary key) or Primary Key to Foreign Key with each other? |
| | i don't know if it possible or not if i want to like this : Actually, i have one form "Product" In Form, i have two comboboxs , first name cboProduct that have Row Source "CPU;RAM" and second name cboSeries. what i want to do is when i choose a … |
| | Hi, I'm supposed to create a little program that will allow you to select a range of dates and graph prices based on those dates. The data would come from an Access table. I know Excel allows you to pull in data from Access, but I'm not sure how to … |
 | Studying for Security+ and can't find a straight answer. Thanks in advance :) |
| | I am gettig "could not find installable isam" while connecting to access 2007 databse the code that i wrote is: Public Sub MyConnection() constr = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Contact_management\Contact_DB.accdb;Jet oledb:database password=abcd" con = New OleDbConnection(constr) If con.State = ConnectionState.Open Then con.Close() End If con.Open() End Sub i installed office 2007 via network. … |
 | Code for connecting to Microsoft Access databse, opening and closing connection |
| | Hi I want to figure out a way to update multiple rows that depend on a couple of variables. I don't really know the syntax in SQL, but I know what I would do in C, so maybe if you could translate this... [CODE] switch (x) case 0: switch(y) case … |
| | I love my Office 97 (I fear change And won't pay bill gates hundreds of dollars for an upgrade to office 2007). I installed office 97 on my new Vista computer. Everything works (word, access powerpoint, excel) except outlook. i get an error message that says "cannot start microsoft outlook". … |
| | I'm sure many of you who use Pandora wonder why it hasn't been sucked up by Microsoft, Google or Apple. For those of you who don't even know what Pandora is, it is a internet radio station that uses algorithms to fit your music tastes. How does it fit your …  |
| | hi, I wants to do register function in window form application microsoft visual studio 2008 and insert the data into microsoft Access 2007 table by using C#. Below is my codes: [CODE] SQLStr = "INSERT INTO RegisterEmployee(EmployeeName,Password,Gender,ContactNumber)" + "VALUES ('" + SQLStrCmd.ReplaceStr(nameReg.Text) + "', '" + SQLStrCmd.ReplaceStr(passReg.Text) + "', '" … |
| | I have a table for Account Transaction. For each transaction a user must select a transaction category. These are stored in a second table which has a categoryID, description and a text box with only two values {'Income', 'Expense'}. Now in the report, I am grouping by Income/Expense. However, I … |
| | I was hoping someone could offer me some help please I am new to using asp.net .I want to create a web form with two comboboxes ,one text box and a button .I have multiple tables in ms access database with same structure , col1 and col2 . I want … |
| | Hi I was hoping someone could offer me some help please I have a form with two comboboxes ,one text box and a button .I have multiple tables in ms access database with same structure , col1 and col2 . I want to insert text box value into column1 in … |
 | Can't get rid of this sucker! Microsoft Security Essentials is the only antivirus that has detected it and "deletes" it every time if pops back in but for some odd reason it can't completely get rid of it. Malwarebytes has just detected after I reinstalled and I am posting log …  |
| | Hello, List below is a query that I need to somehow be able to modify so my results do not double the tblWorkOrder.iWorkOrderID rows. The reason it's happening is because the INNER join for the tblTechnician causes it to double the iWorkOrderID's when there are two or more technicians that … |
| | I'm making an application associated with MS access for its database... I set one of the field to text and the other to object for images..but the object suggest to insert pictures through paint.. [COLOR="Red"]Is it possible for animated images(gif) in ms access? I'm getting stuck with bmps... [/COLOR] -------------------------------------------------------------------------------- … |
| | I have no idea what is going on here, first, the code: [CODE] #pragma once #include <stdio.h> //#include <stdafx.h> #include <allegro5/allegro.h> //#include <allegro_image.h> class DisplayController { public: int bitmapx; int bitmapy; // ALLEGRO_DISPLAY display; ALLEGRO_BITMAP *crosshairs; ALLEGRO_EVENT ev; ALLEGRO_EVENT_QUEUE *event_queue; void display() { this->event_queue = al_create_event_queue(); al_register_event_source(event_queue, al_get_mouse_event_source()); al_wait_for_event(event_queue, &ev); … |
| | I am trying to read a long integer value from an Access database, do some math to the number, and save the result back to the database. I've never had a problem doing this with VB6, but with C# it is throwing an error when it tries to Update the … |
| | hi, now I wants to insert some records into table in Microsoft Access and C#, below is my codes : [CODE] SQLStr = "Insert Into RegisterEmployee(EmployeeName,Password,Gender,ContactNumber,Position) " + "Values ('" + SQLStrCmd.ReplaceStr(nameReg.Text) + "', '" + SQLStrCmd.ReplaceStr(passReg.Text) + "', '" + SQLStrCmd.ReplaceStr(genReg.Text) + "', '" + SQLStrCmd.ReplaceStr(Hptxt.Text) + "', '" … |
| | HI can some one Help in my graduation project im making database access connection this is my class ___________________________ Imports System.Data.OleDb Public Class DataBaseConn Dim conn As New OleDbConnection Dim comm As New OleDbCommand Dim s As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data [COLOR="Red"]Source=D:\G-project Crab\GP\GP\Database1-2.mdb"[/COLOR] Sub adconn() conn.ConnectionString = s conn.Open() End Sub …  |
| | I am using Microsoft Visual Studio 08 version on a computer where I do not have admin privileges. After building my project, I want to put the .exe into the Visual Studio 08's VC folder in order to run dumpbin from the command prompt, but it won't let me copy … |
| | Hey all, I have split an Access database not on the server. I have decided to VBA code the links, however I have reached a stall when attempted to VBA code the update query; updating the remote table with data from the local temporary table. I have tried multiple things … |
| | Hi, i am currently doing a system for the rental video. I am new to java coding.. Problem is how to add data to access database using java coding in method? Thank you. |
 | I have two access database, one was old access from 2000 and the other is 2007. the problem is there are some feature that are in 2000 but not in 2007. so, i want to merge the two database together so that i can use both the old features and … |
| | Hey everyone can I get some help please. I read through a few threads with the same problem as me but i can't seem to get the answer i'm looking for. I'm doing a school project and I need to save a Access DataBase that I have created in C#! … |
| | Hello, I think I've acquired a virus(es) in the past few days. Some of the symptoms: - Programs missing in the Start > All Programs. I can still open them if I go into the C: drive and look for them. - Some of the icons on my desktop disappeared. …  |
| | Hi, i've googled and found out that the max storage of MS Access 2007 is ~2GB. My database suppport attachment, so hypothetically, if the attachments after insert >2GB, how can I allocate more storage to the db? is there a way? |
| | [QUOTE]Hi all I am using Vb2008 Express and an Access DB. I would like to Display a note from a column in the Notes_tbl to a text box this from an Access database. Here is the code that I used but it does not do the job. [/QUOTE] [ICODE] Dim … |
| | I'm not sure if this is the right place for this, but I'm having an issue I'm trying to solve for a customer, and it's not going well. Searching online I'm seeing this has been a common problem for many people, but there aren't really any solutions that I can … |
| | Hey every one i need some help please! I am trying to save a Database through c# but cant seem to crack it. I read a few threads but every one explains how to save an existing DB. In my program I am creating a new DB in c# then … |
| | i can't use vba in access because when i write: Dim db as[space]->error it seem error space . how do i fix it ?i reinstalled it already but it's not working . thank you |
| | hi i have some question to ask everyone . 1.How make open form in full screen ? 2.Example: I created two completed forms,frmLogin and frmStudent and saved it name "Student".what i want is when i open saved file,i want it only show frmLogin auto(full screen) without choose a form from … |
| | One of my computers recently crashed. Fortunately, the .pst file was saved so not all is lost. However, I am considering [I]not[/I] installing Microsoft Outlook on the new computer. It seemed to take over too much of my system. A couple considerations: (1) If I install Outlook Express instead of … |
| | I have two projects in Microsoft Visual Studio 2008, but I can't access the objects/namespace from one with the other. here is an example from my GCController project: [CODE]using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Runtime.InteropServices; namespace GCController { [Guid("9949f4f1-92e6-4709-85a8-12c816b6ceb4")] public interface IGCController { // ... // } …  |
| | Hi, I have been dealing with and for the most part continuously removing the rouge windows security virus. I am still getting google redirects so I am guessing it has never been fully removed. It has been manageable up until a few days ago when my computer was running extremely … |
The End.