1,597 Topics
 | |
| | 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 … |
| | 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 … |
 | 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 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 …  |
| | 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 … |
| | 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 :) |
| | 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 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 … |
| | 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 … |
| | 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#! … |
| | 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? |
| | 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 … |
| | Hello, I am working on a program for school and this is my first experience with arrays of objects. I am passing the array of objects into a function, and from within that function I am running another function that takes an individual object from the array as an arguemnt … |
| | i`m working with access 2007, i have two tables SYS_USER, ACCOUNT TYPE. the first table contains (username, password, first name, last name). the second table is only one field (manager, admin, agent). there are two forms (administration, login), the administration form adds a new user, the login form makes user …  |
| | HI everyone... i`m working on access 2007. i have two table called USER, and USER_PRIVILEGES i created a form with bound text boxes and bound check boxes. the text boxes are for the user information(first name, last name , ...etc) the bound check boxes are for (print report, delete, modify … |
| | hi, im working on a small project on access 2007, i have a form that contains multiple textboxes ,and a save button. these textboxes are related to tables, so what i need is a code for that button to save the records in the textboxes in the tables and then … |
| | Hello, I got a problem, I can save my data to access database and in the access database field I set it to date/time. But problem is when I get the value out from the database.. the format is always month/day/year hour:minutes:seconds example today: 5/2/2011 12:00:00 How to get the … |
| | Hi I have a access database that contains foreign characters(Hebrew language). How can i search the values in the column by using c#? This is my code: SELECT * FROM "table name" WHERE column_name LIKE '%שגל%' I'm getting this error: Syntax Error in SQl statement Can anyone please afford your … |
| | Good day guys, anyone here who knows how to easily access image pointers stored in a database in JSP?... here's my code =) ... it already works in retrieving data other than the image... my database contains petid, petname,birthdate,image,petprice.... [CODE] <%@taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%> <%@taglib uri="http://java.sun.com/jsp/jstl/sql" prefix="sql"%> <sql:setDataSource driver="com.mysql.jdbc.Driver" url="jdbc:mysql://localhost:3306/store" user="root"/> … |
| | Hello! I am working with an Access Database (Access 2002) that contains a form that is supposed to import a CSV. However, because some of the integers contained in the CSV are too large for Access to handle (regardless of the number format I select for the field), I'm going …  |
| | Help! i cannot access my ms access database i am using to learn web design. I keep getting different error codes depending on the windows webhosting used. The latest i got was : Microsoft OLE DB Provider for ODBC Drivers error '80004005' [Microsoft][ODBC Microsoft Access Driver]General error Unable to open … |
| | Hi, I am working in the program which is written in Access 2003 database with developer extension. It looks really similar with vb6. It is quick and it does the job, but we would like to upgrade it into vb.net considering that the technology might "abandon" it. So, we try … |
| | HI all, am fairly new here stil and hope to give back as much as i take , in time , experience and wisdom... (the wisdom bit is probably way off for now) I have a set of tables , but one table needs to show the information chosen in … |
| | Hi i'v recently bought a 2 year old packard bell easy note ALP-Ajax C3 laptop with windows vista, i have seen this laptop working and connect to bt broadband and go online before i bought it, but when i brought it home and tried to connect it to my virgin … |
| | Hi, sorry my title isn't very explanatory. What I need to do is to access a variable from a main function, in another function without using a parameter to do so. Based on the nature of the problem you might see why I would do this. (if there is a …  |
| | Hi, I am trying to come up wit a database design for a small school. it works this way: in AC-Year, there are 3 terms with each term having 2 semesters. New students get registered at the start of each term. A student may take entrance exam. if he fails, … |
| | Hello, I need help saving data into an access 2007 database from a program created in vb 2008. I am making a basic "game" that allows you to move a "robot" up,down,left, right and will save the movements/positions into an access 2007 database. I already have the basic movement created … |
| | Hi all and thanks for reading this..... I have a question that I cannot seem to find an answer for, out there in the big ol ether they call the internet, it involves a three stage procedure on a button pressed within an Access form ... [B] stage 1 : … |
| | hi all, i have created a crosstab query and one of the row heading contains a hyperlink field. my problem is that the field is not working, and on top of that it gives corrupted values too. pls help thanks |
| | hi all, i need to do a record search in a form where its Record Source is Operation, but instead of searching the Operation, i need to search different table, say Remark.. i supposed the red highlighted code should be the place to set the Remark table, but how to … |
| | Hi, I'm doing the following code to connect to Access Db. The db1.mdb is placed in c:\db1.mdb. It giving me error "couldn't find file" [CODE]using System; using System.Collections.Generic; using System.Linq; using System.Text; using System; using System.Data.OleDb; namespace CustomerDB { class OleDbTest{ public static void Main() { //create the database connection … |
| | I keep getting the following error when I try to add new record into database (Access 2007) "The INSERT INTO statement contain unknown field name:'login'." I dont whats wrong as the coding looks fine and the field login does exist in the database. Spent whole day trying to find the … |
 | Hey I am trying to do a project on Test Engine. I need to retrieve random rows of questions from access database. I did the following code, but every time I once close and run it again, the sequence of questions is same. How can I change the sequence every … |
| | hi how to do insert ignore in access? is access support this function? [CODE] CurrentDb.Execute "INSERT IGNORE INTO FullDB (IDProc, IDOp, IDTech) VALUES (" & IDProct & "," & IDOpt & "," & IDTecht & ")" [/CODE] or how can i do a search for duplicate record first before insert? … |
| | hi all, How to check if a particular row is exist before inserting it? my table has ID as Primary key, and 2 other columns, say Process and technology.. thank you |
The End.