1,597 Topics
 | |
| | Hello, I am trying to populate a spreadsheet using Access data, however I am having trouble with the line noted below, which is giving a run-time error. I am not familiar with the Excel Object Model, so not sure how the "selection, range, etc" should be used. Any help and … |
| | Hi guys well I have successfully got my update query to work correctly. Now I have two tables in my database. What I want to do is when I click my play button not only does it update my column's in my first table but all updates my colunms in … |
| | I know this might be a very simple one, but yet I can't figure that one out! How do I get data from one table that are not in another? Let's say Table ServerA has: IP, User, Password, Table ServerB has: IP, CanConnect. If ServerA has 20 rows and ServerB … |
| | is it possible to access an access database without ms office or just using references or .dll  |
 | I have a set of PDF files on our website that the user needs to log in in order to view. The only problem is once they log in and get the URL for them, they can email it to their friends or anyone and they can be viewed by … |
| | When I add a NEW row to the datagridview, it for some reason freezes the datagridview. That is, it adds the rows pulled from the database to the grid. But you can't add rows to the datagrid by some a click button event. Nor can you select a row in … |
| | please i need help on making data report which the database is access 2007 with accdb format. what connection will i use and how and sample codes. thanks a lot in advance. |
| | Hey guys! I have created an Access 2010 database. On one of the tables, there are fields [Start Time], [End Time] and [Total Time]. The user will input the start and end times but and the total time will be the difference between the two. I cannot figure out how … |
| | Hi guys!I'm currently making a database project and I want to update an access database. I connected the database using this sql command 'select*from word' And I tryied to update the database using this code ds.tables('word').rows(0).item(1)=”cat” Dim cb as new oledb.oledbcommandbuilder(da) da.update(ds,”word”) da is a data adapter ds is a …  |
| | I am looking at a source code There is a class called A and it has a parameter in its _init_ function called. Class A self.id = id There is another class called B and has a parameter in its __init__ function called Class B self.ide = ide There's an … |
| | Hi there guys can someone explain to me how I can increment a value within a field in my database each time I execute my query?. As I cannot seem to find a way to do this. Below is my structure for reading + writting to my database if you … |
| | Hi!I'm currently trying to make a language translation tool using vb.net 2008 and access 2007. For that I want to do these... 1.There is a textbox,a command button and two labels in my form and I have a database named 'dbwords.mdb' with one table 'word' and two fields named 'word' … |
| | Hi! I'm having a bad time on learning how to store and retrieve image files on MS Access. This is some sort of uploading profile picture thing in my software. The open file dialog stuff and the storing of image file in the MS Access Database are taken care of … |
| | Hi, I have a database with lots of fields, some of which are still empty and are to be filled in at a later stage. Is there any way of writing an IF statement (or any other method) that will allow these empty records to be 'shown' in my textboxes … |
| | |
| | Hi Guys well what I want to do is instead of within my writeString to set my PLAYCOUNT to '16' what I want to do is every time the statement is executed my PLAYCOUNT is increased by 1. Any help you can give would be appreciated: My code is below: … |
 | So, even thou I have searched throughout the forums, I couldn't get a clear answer, maybe perhaps I'm a noob @ Python. As a beginner, I don't know much about Python, and it's frustrating to search the net and not find the actual answer. So, I'm working on this project, … |
| | I'm trying to design Programmable Logical Array using c language. Due to lack of time I downloaded code for tabulation from internet. Now I have modified it to return f and f' in a character array. It works fine for some functions. But it shows memory allocation problem for some … |
| | Hi guys well what I want to do is that when a button is pressed it increases the value in one of my database cells. So my question is how do I do this? As I cannot get this to work. My code so far: Any help would be appreciated …  |
| | Hi guys well I have created a JComboBox that lists all my values from a String. However I want instead of the values for the JComboBox to be in a String the values to be displayed in the JComboBox from my database so if more values are added to the …  |
| | Hi guys well what I'm trying to do is produce a query that only produces the results which will match my director input. I have looked for the correct syntax and cannot seem to find it. Any help would be appreciated Code of my syntax below: [CODE] ResultSet results = …  |
| | Hi guys well I have a problem on my JFrame which is once I click on my List all Videos button it displays my data from my MS database which all works well. However as you can see from the png the query results are not aligned up correctly together …  |
| | Hello! Is there a way to hide the password of your database inside the source code? [CODE=vb.net]"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" & Application.StartupPath & "\Database.accdb; Jet OLEDB:Database Password = [B]MyPassword[/B]"[/CODE] As you can see the password is exposed, increasing the risk for the database to be compromise. Is there anything you can suggest … |
| | Hello, I wrote the following code to create dynamic controls-textboxes and labels. [CODE] ctlRow += 1 ctlRowLocation += 25 Dim new_ForceLabel As New Label new_ForceLabel.Text = "Force" + Convert.ToString(ctlRow - 1) new_ForceLabel.Location = New Point(txtForceLabel.Location.X + 2, ctlRowLocation) new_ForceLabel.Height = 25 new_ForceLabel.Width = 50 Dim new_ForceInput As New TextBox new_ForceInput.Name … |
| | Hi guys I am able to drop my tables that I want but however when I come to trying to drop rows the rows do not delete. I have tried the following which have all produced the same error duplicate key TABLENAME : Any help you can give for a … |
| | Hi guys I have successfully set up my database which through my GUI I am able to create my tables that i wish and insert data into the table. My problem is through that I can only insert one row of data into a table so what would I need …  |
| | Hi there well title says it all really. Is it possible instead of creating tables within my database to create the tables within a form in java? . If it is possible how would I go about doing this?. Before you ask yes my database is fully connected to my … |
| | I asked this basic question a couple of days ago but I probably didn't include enough information in my question. Sorry for reposting, but I am really lost here. This is a web application in VB.net connecting to an Access database on a 2003 server. The problem: I have a … |
| | Hi and Greetings, I am new to these forums, so if I submitted this to the wrong forum, my apologies. Before I get to my question, a little backstory. I was running an application on my laptop that was using Microsoft Vista, with Microsoft Office 32 bit and JRE 1.5. … |
| | Hello i am developing a web app in JSP as front end and ms-access as back end..i hv login.jsp which contains username & password which will be validated in access database upon success user.jsp will be shown..i hv been done with jsp page design..but don't know abt database connectivity..can any1 … |
The End.