1,557 Topics
| |
Hey guys, Basically i want to create a database in Access 2002 that will hold names of functions of a mobile phone. When the user enters a search the databse should query the information held within it, display the appropriate search results. It should be able to serach for precise … | |
Hey there. I have a program that uses access, and everytime i go to install it for some one i have to keep my fingures crossed and hope they have office installed on their pc. Is there a way to run my program without buying microsoft office? (using access database) … | |
I have just started using Access 2010 and am experiencing problems with it corrupting the database. To take one example I have a database with one module in it. Today when I open the module in design view Microsoft Access falls over with the error "Microsoft Access has stopped working" … | |
search button for vb 2010 ultimate in access 2007 database and filtering on a datagrid Hi all! I am trying to make a search button which filters a datagrid. First of all, I have a tab and on this tab a have a datagrid (dgr1). When I load this tab, … | |
Iam developing a small school software. I want to show fees of every student of whole year. Like John(student) I want show his fees that every month he paid at what date and how much. So how should I start please help.. | |
Greetings, I have just went from Access 2003 to 2007.... I have a project requiremtn to output some reports to PDF file format... Don't know how to do it.... I tried doing a little research but.... :-( I am open to ideas... I would like to automate the process so … | |
Hello! Now I am trying to make selection of Customers easier for my user. My user's business involves making deliveries on [B][I]routes[/I][/B]. Every customer is assigned a route number, which references the route in the route table. In my form I want to have [B][I]two list boxes[/I][/B], side by side. … | |
Hi Guys, I want to use the Autonumber function in my table in a specific format. The format is SP10000. And I want Access to automatically number each entry by one with each new entry eg. SP10001...SP10002...SP10003. Please let me know how I can do this as when I use … | |
Hello guys, I am new to vb programming. Can anyone tell me how to access command button of one form onto another? I have one mdiParent form on which i have command button "PRINT" and "Add New Client", I want to disable Print button, when i clicked on "Add New … | |
I have been fighting with this all day and looked at so much documentation and other posts I think I am going blind. I can't find an answer that works. I am trying to read through a set of records until the reference number changes and then return to the … | |
Greetings, I need to have a way to veiw/print reports designed in MS Access in my Delphi application. I have a MS Access 2007 db for the backend of my Delphi2010 application. I have reports I had defined and saved in my Access db. I would like to place a … | |
Hello masters! I have a project and need a bit of your help. I would like to access/get values from certain fields from a database and assing that value to a variable. Database is included into my project along with DataSet. Is there any simple way to access certain field? … | |
I am attempting to create a sorted array for a class assignment but I am receiving a weird access violation error in my debug code. I have double checked all my values and nothing is accessing anything out of range. My code is below. Thanks. [code=c++] #include <iostream> using namespace … | |
Hello all! I'm making a Applicant Record Keeping System. I'm a newbie with MS access. And i'm having a really hard time understanding how queries work. I have three forms: (Sequentially) Background Checking Criteria.. Document.. So, this forms are for one applicant and they have common details. Background Checking's common … | |
| Hello people, I designed this class: [CODE] package aiproject; /* * This class has the task to read the data stored in a file called "fichier.txt" * line by line. * The read lines will be put inside a List called lignesDeMonfichier * Also, this class counts the number of … |
How can I open a Record from a Listbox Using a Command Button? | |
Hi guys i'm trying to just do a simple email/password validation on two text boxes. This code runs but when i type in a correct email address it throws an error "Object reference not set to an instance of an object." on [CODE]AdAcc.InsertCommand.Connection = OleAcc;[/CODE] I'm thinking i may need … | |
I've designed a C# game that makes use of an Access .mdb database file to store variables. The basic idea is that one of the players will 'host' a game, and the other player will join said game, by connecting to the database, reading and writing items into the database. … | |
Hello friends, I am looking for a bit of help. Here is the scenario. I am trying to compile sales data for a number of stores from multiple databases and import them into excel for the current month by day. I have a field for date and sales. The problem … | |
I'm writing a program has access to a database (a database where an other software stores data that users type). This database has several colums, but in my code, i need to use the two columns that describes where the data is from, and the the date when the data … | |
Ok I have a project and I pretty much have no idea what I'm doing. Our project is to make some simplified POS software, in our case, for a restaurant. The form I am currently working on is where you pick food items and add them to a listbox which … | |
Ummm hi, Ive been having some problems with a program ive been working on. I want to insert a new value in a column in a table from a calculation i get and replace the original value. Heres the part of the code: private void button11_Click(object sender, EventArgs e) { … | |
Hi everyone... I just finished making a program for Video Rental in java..its not much..just retrieves the data from the DB and we can add or edit it...it works perfectly. But now, i want it to display the "Client Name" and "Client ID" field from my Client table and "movie … | |
hey im new to microsoft access and databases.im trying to create database with Tables for 1.Researchers(have that) 2.Test performed by researchers (at least 5 different tests)(have that and my 5 test are diabetic,blood type,high blood pressure,positive for drug tests and eye sight) 3.and Results of the tests given by researchers … | |
Guys,i want a small help from you.I have a created a database in MS Access and now i want to connect it to with Java Application by using ODBC Administartor.But when opens it,it doesn't show any driver for MS Access DBs.Do u guys know any driver for that.I'm using Windows … | |
Hello all, I am having what seems to be a very common issue with Vista. I have searched the internet and have found many topics on this problem, but none of the suggestions I have read have worked for me. The problem is, this particular computer will not connect to … | |
Hello, I am trying to query a table for todays date based on this format mm/dd/yyyy hh:mm:ss AM/PM I tried date() but it only returns results based on the mm/dd/yyyy formate. Any assistant is apprecaited! Thanks, Wez | |
[CODE]980 Set rs = db.OpenRecordset("0 - Supplier List") 990 RptLoc = 0 1000 If rs.EOF = False Then ProcessCount = ProcessCount + 1 1010 Do While rs.EOF = False [COLOR="Red"]1020 XL.Sheets("Supplier").Copy Before:=XL.Sheets("Supplier") 1030 XL.Sheets(2 + RptLoc).Name = rs!Supplier[/COLOR] 1040 RptLoc = RptLoc + 1 1050 rs.MoveNext 1060 Loop 1070 XL.DisplayAlerts … | |
Hi. I'm trying to make a site where people can purchase zip files. The zip files will be made on-the-fly. My question is: [B]how do I restrict access to the files? I need to make it where the zip file can only be downloaded once, and it can only be … | |
i'm trying to get data of 30 minutes ago to now.. any idea with the query [CODE]SELECT DateDiff("n",Now(),[TimeStamp]) AS [Time] FROM RIMData_RAW GROUP BY DateDiff("n",Now(),[TimeStamp]) HAVING ((Now()>30)); [/CODE] |
The End.