5,053 Topics
 | |
| | Hi. I am having some trouble with my computer. Here is a quick review of issues...About a month ago my McAfee AV kept getting turned off. I could not figure out what was wrong. Nothing was found on any scans. I removed McAfee and got AVG free edition. It stopped … |
 | 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 … |
| | Hi daniweb first of all, sry my english. I have a problem with at update code, I was hoping that U can help me, im new to this. i have a code where i get an id from another page, from update.aspx?id=1 up to 6 ATM. my code works fine …  |
| | Dear community, On a quite regular basis, the screen of one of the laptops I use [COLOR="red"]blinks for a fraction of a second[/COLOR]. It does it like with some screen capture softwares when they are triggered. Besides, I'm observing from time to time some strange behaviour: [COLOR="red"]Command windows that open …  |
| | [B]Read a CSV file into a DataGridView[/B] [CODE]'12/4/2011 'Code to read CSV file with headers using 'ACE.OLEDB.12.0 Connection 'The following is a Sampling of <EXTENSION.csv> 'The CSV file contains all the Extension on my Desktop Computer 'The full file has 923 Rows with Headers: 'EXTENSION,DESCRIPTION,EXECUTABLE_PATH '.mde,Microsoft Office Access MDE Database,C:\Program … |
| | 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 …  |
| | I have a server that I just did a clean install on with Server 2008 Enterprise x-64. I have been having issues installing certain applications and unfortunately, I am at a loss as to why. I installed SQL Server 2008 Std, which went fine, but SQL Server management studio will … |
 | HI i am trying to convert a doc file to a pdf file. please see my conversion code below [CODE] private string m_SourceFilePath; private string m_DestFilePath; public bool DoConversion() { bool returnValue; Word.WdExportFormat exportFormat = Microsoft.Office.Interop.Word.WdExportFormat.wdExportFormatPDF; object paramMissing = Type.Missing; Word.ApplicationClass wordApplication = new Word.ApplicationClass(); Word.Document wordDocument = null; try … |
| | Hello I am having some trouble here, I created a Microsoft Access dataset (.accdb) It is being used with some listboxes, comboboxes etc. The problem is when I publish the whole thing the datasets do not publish along with it and my program opens but there are not values. Anyone … |
| | I am trying to create a web app using C# 2005 where I can upload an excel document, store it in memory and read the contents. I have my code working if the file is saved on the hard drive, but i don't want to have to save the file … |
| | i have file that is named record.mdb and i want to open it using microsoft access but when i try i get message that is could not lock file how can i open it  |
| | Hi everyone, Well, First of all m glad to join a community of all master minds. My question is : I have a datagridview and each time i enter values in database the values are not reflected in the datagrid untill i load the form again. I want a method … |
| | 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 …  |
 | Hi guys, I'm not very good with ASP but atually I need to fix some stuff and I'm encountering weird problem when I tried to connect to Access database into my localhost. Actually when I do something like this: [CODE]conn.Open "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & server.MapPath("/cms/db/cms.mdb")[/CODE] I return this error: … |
| | Hello community, I am importing data from access into excel using a data import from a microsoft query using OBDC. I have 3 stores importing their their sales into each row daily. I cumulatively add these in a row at the bottom of each column. The issue I am having … |
| | I'm creating an Excel spreadsheet from within Microsoft Access. This is declared at the top: [CODE] Public OpenExcel As Object Public OpenSheet As Object [/CODE] This is in my sub-routine: [CODE] Set OpenExcel = CreateObject("Excel.Application") OpenExcel.Visible = False With OpenExcel .Application.DisplayAlerts = False .Workbooks.Add .ActiveWindow.DisplayGridlines = False .ActiveWorkbook.SaveAs FileName:="" & … |
| | 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 everyone, sorry to bother. I am new in Visual Basic and I am using this in my final year project as a GUI. My system is an attendance tracking system which requires student to scan their rfid tags to make sure their attendance is taken. A lecturer can view … |
| | 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 … |
 | Thank you kindly for any assistance. After countless Google searches for help or info and nothing found I surrender to anyone who may help please. Ongoing for several months: Dual Monitor system - simultaneously both monitors randomly flash/blink (looks similar to a screen shot flash). This happens at system start … |
 | 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 … |
| | Hello Folks, I am trying to create a Crystal report using data from two Access 2007 tables but it only displays the data from the first table only. when I do same with Access 2003, I am successful but it does not work in access 2007. Please help me to … |
| | Last night my computer got infected with the Windows Fix Virus. The link below provides pretty much an exact description of what has been going on with my computer. [URL="http://reimagerepairreview.com/2011/07/11/remove-windows-7-fix-virus-desktop-is-empty-missing-shortcuts-icons-on-start-menu/"] http://reimagerepairreview.com/2011/07/11/remove-windows-7-fix-virus-desktop-is-empty-missing-shortcuts-icons-on-start-menu/[/URL] I immediately installed and ran Malwarebytes from a USB drive, but it had no effect. I was then able …  |
| | 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 … |
| | hey guys, I'm writing a program and trying to output data to a file and I'm getting this error: 1>------ Build started: Project: GenericProgram, Configuration: Debug Win32 ------ 1> Source1.cpp 1>c:\program files (x86)\microsoft visual studio 10.0\vc\include\fstream(1116): error C2248: 'std::basic_ios<_Elem,_Traits>::basic_ios' : cannot access private member declared in class 'std::basic_ios<_Elem,_Traits>' 1> with … |
| | 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 All I am writing an import program to import data from an access database to a SQL database. The table structure in the SQL and Access are the exact same with the same field names. I was wondering if there was a quick way to get the data into … |
| | 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 … |
| | <%@ page import="java.sql.*" %> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> <title>JSP Page</title> </head> <body> <% String ans=" "; if(request.getParameter("correctAns")!=null) { ans=request.getParameter("correctAns").toString(); } Connection con = null; Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); con = java.sql.DriverManager.getConnection("jdbc:odbc:sid"); Statement st = null; ResultSet qrst; ResultSet rs = null; String id=request.getParameter("id"); … |
| | hello, I am building a site where I want all links to partial page reload using xmlhttprequest and innerhtml. I have done this before, butI always had to have a seperate xmlhttprequest function for each link. So this time I am trying to write just one function, and have the …  |
 | i am having issues with an update query. i normally use SQL 2005 but for this project i am using an access 2007 database please can anyone point me in the right direction, [CODE] Dim con As New OleDb.OleDbConnection Dim cmd As New OleDb.OleDbCommand Try con.ConnectionString = "Provider=Microsoft.Ace.OLEDB.12.0;Data Source=" & … |
 | 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 … |
| | Hi Everyone. I am totally new here and this is my first post.. I have tried many place, since i could get any solution. I have no choice then posting here. basically, i have one delete form, where i will load the firstname from a table in access(hardcode) to listbox. … |
| | 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] |
| | Hi There experts... i am hoping that someone will be able to help me with a problem... I have the following vba code.. some of you that are clued up with vba will know... it is a code i got from the net that allows me to choose dates before … |
| | what is the code to validate my upload pic.. this is the first form [CODE]Imports System Imports System.IO Imports System.Data Public Class ApplicantsInfo1 Private path As Bitmap Private Sub btnExit_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnExit.Click Me.Close() ApplicantsInfo2.Close() ApplicantsInfo3.Close() ApplicantsView.Show() ApplicantsView.pageInit() End Sub Private Sub Button1_Click(ByVal sender … |
| | hi, i'm new to c# programming and i have this problem that i encountered while trying to create a database browser. Here is my code: [CODE]private void button1_Click(object sender, EventArgs e) { string search; search = searchbox.Text; if (search == "") { MessageBox.Show("You have not entered anything. Please enter the … |
| | Hello, im working on a project that works with an access database but i dont know how to edit an existing record... here is the code that i use for reading the database: [CODE]Public Function ask() Dim dt As New DataTable Dim ds As New DataSet ds.Tables.Add(dt) con.Open() Dim da … |
 | I was wondering if there is a code i could add to my applicatio that will delete a data entry from a database. I'm designing a voting application as my project and i want a situation where an access code is good for only one entry. i put my code … |
| | Hi again !! I am making a widows application wherein i have a form containing two datagridviews.. The first one( named dgv1) consists of all the data from the database and a checkbox column.. While the user selects the rows using checkbox, the data are displayed in adjoining datagridview(named dgv3).. … |
| | Hi I have made lots of Access databases over the years but it seems I have fogotton lots of basic principles since I have not used it for ages. One thing I want to do is: For instance when you send an email using Yahoo or similar webmail if you … |
The End.