5,053 Topics
![]() | |
Hi, I am not sure what is the best solution for my problem so I really need your advice. Here it goes... I have an intranet setup at work and I am acessing a web app from let's say IP 192.168.0.40. The intranet computer from which I am accessing it … | |
Hi geeks!! im working on a project (in visual studio 2008) where i need to create a reminder which will prompt every month for showing the actual state of fees a number of customers have left to pay. the project uses access as database and will have a fixed amount … | |
I'm having a problem updating records from my VB.Net application to the database (Access Database). I've tried all sorts of update technique and i keep getting either "syntax error in update statement" or "data mismatch in criteria expression". heres the code i'm using: Public Function save1stsemester() 'this code updates 1st … | |
hi all, i am sending mail through exchange server version Exchange2010. below is my code: static void Main() { try { string owausername = string.Empty; string owapassword = string.Empty; string mailFrom; string mailTo; string mailSub; string mailBody; ServicePointManager.ServerCertificateValidationCallback = CertificateValidationCallBack; ExchangeService service = new ExchangeService(ExchangeVersion.Exchange2010); EmailMessage email = new EmailMessage(service); … | |
FOR FOLLOWING CODE <%@language=VBScript%> <%Option Explicit%> <html> <body bgcolor="aqua"> <% Dim myConn Set myConn = Server.CreateObject("ADODB.Connection") myConn.Open = ("DRIVER={Microsoft Access"&" Driver (*.mdb)};DBQ="&"C:\Inetpub\wwwroot\tizagASP\razor.mdb;") myConn.Close() Set myConn = nothing %> </body> </html> I GOT FOLLOWING ERROR The page cannot be displayed There is a problem with the page you are trying to … | |
I have one of our servers Win2003 EE SP2 out of sudden the following services stop: automatic updates, computer browser, cryptographic services, distributed link tracking client, logical disk manager, secondary logon, server ,wireless configuration , workstation. when I try to start server service it give me error 5 access denied, … | |
![]() | I'm trying to use Microsoft Access to produce a contacts database for a local charity. Unfortunately I can't get my head completely round relational databases. I understand the basics but can't solve a particular problem. Can anyone help? I currently have four tables (Contact, Organisation, Children, SpecialNeeds) that need the … ![]() |
Hi, I have a Vb.Net solution that contains several forms that read/write to an MS Access database. My problem: When I copy my Vb.Net solution and Access database to a new computer, the data source connection string needs to be changed. Currently the data sources wizard sets the connection string. … | |
I need some help to make a order form in C#. My development environment is: Microsoft Visual Studio 2010 Ultimate SQL Server Express Edition 2005 Programming Language C# Sample Database = NorthWind (Tables Orders and OrderDetails) I've create a form for order entry, which contain a textbox for OrderID, a … | |
Hi All, I would like to thank this community for the enormous help to develop my skills. Thanks. I have 2 databases and a single report form and a crystal reportviewer. The User can select the database which he want to work (Each of them belongs to different warehouse) So … | |
Explorer is running in the background and I can't stop it. This has been going on for a week or so. Explorer sometimes runs as two processes simultaneously, one under "New User" and one under "System". I use Firefox 99.9% of the time. Any advice will be much appreciated. Below … | |
I wrote a C# code called parent. When i run the program and try to add parent details to the database( microsoft access 2010), it gives me this error: Exception in DBHandlerSystem.Data.OleDb.OleDbException (0x80040E14): Syntax error in INSERT INTO statement. at System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(OleDbHResult hr) at System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult) … | |
hi, can anyone please check why im getting dataype mismatch error... im using combobox and msaccess db which consist of formNo(autonumber) LastName FirstName MiddleName Address (text) ... if i use address as valuemember there is no error,, but if i use FormNo as valuemember then there this datatype mismatch error.. … | |
Hello Community, I was wondering if there is a way to restrict sub directories from accessing the parent directory (the main directory where all my website file are stored) and from having any interaction with the previous folders (so once there in the child folder they can't leave it eg. … | |
Greetings Techies, My access to Youtube via IE 9 has become intermittent. However, it's fine with Google Chrome and Mozilla Firefox. I have tried disabling the ActiveX Filtering and tried the Compatibility thing too. The JavaScript is enabled and working (I checked it on javatester.org). I have Googled for the … | |
can anybody help me how to make a LAN connection for messenger such as yahoo in a big connection like in hostel? i use microsoft visual basic 6 and microsoft access as a database. pls help me :( | |
Hi there, I'm trying to create a math quiz that reads a series of questions from a sequential access flat file. The file should contain a series of numbers, separated by commas. The first field(value) should be the first number for the problem, the second should be the second number … | |
Being somewhat new to VB.NET, I built a data solution by using wizards and drag-and-drop on forms. My data is in an Access DB and I opened up those tables with Server Explorer and dragged them into my dataset. I connected the tables to datagridviews. Worked like a charm. Then … | |
how to get null field value from access in vb6 in my 2 record field the value is empty but i'm not able to get that empty field in vb6 ... .... set rs = new adodb.recordset rs.open ("select * from table1 where id = '2'") text1.text = rs!name please … | |
trying to create table in Access2007. CREATE TABLE user (id Text(8), last Text(25), first Text(20), class Text(10), dob DateTime); but table is not being created. ERROR: query must have at least one destination field. | |
Hello! I've got a question here that has me scratching my head - I've got a table of IP addresses. Each octet has its own field (OCT1,OCT2,OCT3,OCT4). The first two octets are fixed, and will never change (so, the IP addresses on my table are between X.Y.0.0 and X.Y.255.255). As … | |
Hello, I have been given a class diagram where a variable called light_years must be a const int and stored in the space class, but later on that value must be used in the main file. Below is the space class class space { private: static const int LIGHT_YEARS; public: … | |
I am having trouble getting the codebehind to execute properly. I am new to c#.net, what I have is a web-based log in form that when the user enters their username and Id it will check against ms access to verify the username and password. I am getting this error … | |
Hey Guys, I'm an A level student studdying Computer science, and hence using VB.NET for my coursework. Therefore I'm very novice at VB! While trying to update Data in a Microsoft Office, Access table (Office 2010) - I get this error. (In VB) Bare in mind, I've read all this … | |
Hello everyone. I am building a small database that will hold information about volunteers and their talents. I have created a search form, in which the user can enter a keyword and it will search the tables for any match. Currently I am using a criteria of: Like "*" & … | |
Hello everyone. I have build a simple MS Access database to keep track of volunteer info (contact, address, phone etc). I have a report that displays each record in a list: record1. Last Name, First Name, phone, email record2. Last Name, First Name, phone, email etc... What I want to … | |
I found a tutorial online that so far has been aswesome. I downloaded the access db and so far can read and browse through it. However, when I try to write back to it (btnSubmit_Click), nothing happens. All other buttons work fine, I can still browse, and I get absolutely … | |
Hello , I'm trying to make an Update query but keep getting the following exception : "Data type mismatch in criteria expression" Here is the query : UPDATE PatientData SET PatientData.[Transaction Stop Time]='6/26/2010 1:07:12 PM' WHERE PatientData.[Patient ID]=6 AND PatientData.[Parameter name]= 'Temperature' AND PatientData.[Valid start time]='9/7/1999 12:00:00 AM' additionally, when … | |
Pros: HARDCORE COVERAGE! Easy installation Lots of options dual band USB sharing 4 guest networks per band fast nice setup menus that look good and easy to navigate lots of security support connections are solid Cons: only thing is lack of print server, other than that it's perfect. Other Thoughts: … | |
Hi every one I'm trying to retrieve UserID (which is autonumber in ms access database) using C# and assign it to string u.I'm totally new to C# and trying to get more skills.... here goes.. string connStr, selectCmd; connStr = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=..\\library.accdb"; selectCmd = "SELECT * FROM users WHERE First_Name … | |
hi all, i am not able to redirect/login to my owa page. when i run my code below commandd windoe comes and disappears nothing happens. please seemy code below: Sub main() Dim strServerName As String = "12.345.56.789" ' my owa ip Dim strPassword As String = "password" 'my password Dim … | |
Hi! I'm writing little software just to get some practice in c#. I have listview in form 1 where program displays first name and last name form access database. When admin selects name/surname in listvioew and press show usercard(form2) I have a label in form2 and I want it to … | |
Hi everyone, Im newbie...I have comp problem...Pls kindly help me... T_T I dont know what happened... usually I can install new font ... **Local Disk (C)_Windows_Font** ... and open the WINDOWS EXPLORER to view the font that I already installed or copy paste the font to this folder... Then suddenly … | |
Creating a Report in Visual Studio 2008 In this section, you create a report that draws its information from the sample Microsoft Access database that ships with Crystal Reports. To create a report with secure data from the Your database follow these steps . 1. In Solution Explorer, right- click … | |
# # Based upon the NCSA server configuration files originally by Rob McCool. # # This is the main Apache server configuration file. It contains the # configuration directives that give the server its instructions. # See <URL:http://httpd.apache.org/docs/2.0/> for detailed information about # the directives. # # Do NOT simply … | |
Hi All, I have Code on PC1. and Access DB on PC2 . I have shared Folder on PC . And very much able to access from PC1 with full ownership. Now I was trying to connect Msaccess from PC1 using below code. cnn.Provider = "Microsoft.ACe.OLEDB.12.0" cnn.Open "Data Source=\\192.168.0.1\Public\tels.accdb;Persist Security … | |
I have recently been working on a job with a client who gets their data from county data. The county data is contained in .dbf files. Every year the data is updated and my client will get a CD/DVD from someone containing the county data in .dbf format. Now the … | |
Here is a very tiny program(3 files) has embedded with Smarty template engine. Anyone knows how to remove Smarty completely? I konw the procedure to remove Smarty but failed to rewrite the code into pure PHP. Complete source files as in attachment. **CLICK HERE!!**~~~ http://www6.mimima.com/link.php?ref=FGHkNoDtmB *****************index.php <?php require("comm/Smarty.class.php"); require_once("get_data.php"); require_once("books.php"); … | |
Hi All, Sorry if this isn't the appropriate place to put this question, but I'm new to the forums. My issue relates to ASP and a DSN-less connection. I have a website, which was built quite a while ago using DSN connections to an Access database, which ran on a … | |
Hi, I need a little help here. I'm Using vs 2005 with ms access 2003 database and finding myself how to get rid of this error "Syntax Error on UPDATE Statement" can you take a look at my codes below and tell me what's wrong? Thank you. Public Class Transactions … | |
I have a wireless access point. I can connect to it just fine. I can go to Google and I can type in a search, however I cannot GO to the searches result links at all. I've tried IE and Firefox and both the same. I can search for something … | |
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { response.setContentType("text/html;charset=UTF-8"); PrintWriter out = response.getWriter(); try { int c=0; String u1=request.getParameter("u1"); String e1=request.getParameter("e1"); String user=request.getParameter("user1"); request.setAttribute("u1",u1); request.setAttribute("e1",e1); request.setAttribute("user", user); out.println("welcOme"); Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); Connection con =DriverManager.getConnection("Jdbc:Odbc:db5"); String str = "select * from Table1 where email=?"; out.println("welcOme"); PreparedStatement statement = con.prepareStatement(str); statement.setString(1,user); ResultSet … | |
I am trying to insert new records into an Access DB and getting some weird stuff. I get the data from a DBF table and load that into a dataset table and DataGridView with no problems. Then I loop through the ds.table and insert it into the DB with this … | |
Hello, My name is Dave and I am a C# developer who is having trouble getting into web development. I am trying to develop an application that users can access from the web, enter search parameters, and the application will search text files stored on the server and return the … | |
In MS Access2007, I want to query ([I]q_Notes[/I]) a table ([I]t_Notes[/I]) in which one of the fields ([I]t_Notes.Topic[/I]) is populated from a Combo Box based on a field in another table ([I]t_Topics.Topic[/I]). I will have a table of several hundred records. I want to use the q_Notes query as the … | |
Hi all! I need help with Visual Basic I am trying to build a program in which the user types a question into a text box. Then the program looks for that question in a database (access database to be specific) and returns the appropriate answer from the database. I … | |
IE9 is on the horizon, and there has been plenty said about it. But what about its web development aspects? In this article I look at its web developer tools, and decide whether I'll start using it in my own web development. Like most web developers, I abandoned IE several … | |
Hi i am using java code to connect to MS access using following url jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=C:/login.mdb Now if I need to connect to the run this java code from some other machine in network then how will I write the path "DBQ=C:/login.mdb" | |
Not sure if this is the right place, so forgive me if it isn't. There's a few of us building a huge online portal that contains IT training courses in Cisco, CompTIA, Microsoft and ITIL certifications. We're offering it at the small cost of £5.00/month full access to IT professionals … | |
Hello everyone, I have a problem, i am unsure how to read the data from my Access Database into my vb.net form. I did some searching but i didn't manage to find anything useful so i would appreciate any pointers. Here is the code from frmAddNewCandidate i am using that … |
The End.