I use an access database and some queries return calculated fields resulting from
functions in the code module of the database These queries are not listed in the "Views" tab of the query designer when adding a tableadapter in the data source designer
I have implemented webbrowser control in my windows application. I have some functions inthe class file. i want to use those functions from the webpage which is displayed in my windows app through webbrowser control..For example say... I have an standalone windows software. Which has a webbrowser control in the some form. Now i would like to create a webpage that can be displayed in the webbrowser control in win app which has some buttons and textboxes. When i click on button in the webpage it should get the version number of that software. I have some other functions that are in the class file aswell.. but dont no how to call those functions from that webpage when a button is clicked or something like that.
View 4 RepliesHow do I run Access queries from within VB? The queries have been written and saved in Access using SQL, and use a search-parameter (Team name) to return a single integer value (games won, points scored etc).
View 1 Repliesis there a way to run a query that already exists in an access database?
View 22 RepliesI have 2 queries to run, one after another.
View 7 RepliesI would like to transpose the data from queries in access database, the current data extracted from the table look like this :
[Code]...
I have a access database setup which i am connecting to via ODBC, the access files already has all the required queries built and i would simple like to call them from within my application.I am using Visual Basic .NET and this is what i have tried so far..
[Code]...
I have an Access database with some table and some queries.Here you see one query which returns 2507 records:I also added this database to a vb.net project.However, if i try to fill the datatable of the query with the specific tableadapter, the datatable stays empty. Also when I click the query in the dataset and choose 'preview data' I get none of the 2507 records:Any idea why he won't load the records into the dataset?
View 2 RepliesI have an access 2003 database file with hundreds of queries. I would like to rename all tables referenced from within my queries based on a condition
If tableNameInQuery = "tableName" Then
tableNameInQuery = "newTableName"
End If
I would like to be able to run a query that could tell me where a given table/query is used within all of my queries. I would like to do this with SQL but VBA is also fine.
View 1 RepliesIs there anyway to import a crosstab query from Access 2007 to VB 2005?If not, can I create a crosstab query within VB 2005 from the raw database tables
View 3 RepliesI have queries using microsft access 2007 and vb.net. If I tried to execute it in microsoft access manually then the result was fine. But using code in vb.net I the result I've got was all the same
[Code]...
I am writing a message system on my server, the xml is something like this
<xml>
<entry>
<sender>[code]....
my problem now i guess is 2 fold, i wish to combine the first 3 queries into a single query and place in a list or a collection or is there a way to do this with a single query that will give me my desired result?
Is this possible programmatically? Getting the names of stored queries or checking if a query with a specific name exists?
View 3 RepliesWhile I have no problem to to program the output of two queries into 2 separate Excel workbooks and worksheets via
DoCmd.OutputTo acOutputQuery, "QueryA", acFormatXLS, "filenameQueryA", True
DoCmd.OutputTo acOutputQuery, "QueryB", acFormatXLS, "filenameQueryB", True
I have tried without success to find the right VBA commands within MS Access to create and save only one file with two worksheets, one for each query.
I have developed a small ms-access based software with vb.net.
I've added auto-update capabilities to the software (mostly by using clickonce) to simplify the release of new features.
Every version of the software executes the update routine which may update also the existing database.Lately i've made few changes on the database structure adding few stored queries, so i want the autoupdate code to programmatically add these new queries to the existing database and make it perfectly up to date.
I haven't already found a solution to add stored queries to an ms-access database using odbc...I also tried to use the "CREATE PROC" sql statement but it does not seem to work with access databases, even if i create the query form the Microsoft Office Access front-end.I've found some examples that uses ADODB, but i'm using odbc to remain both x86 and x64 compliant.
What I am trying to do is have a class where the functions of the same name are both instance functions and shared functions.
Public Shared Function Get...(byval xx as xx)
and
Public Function Get...
The Public Function uses a Property xx created in the constructor, whereas the Shared Function has the parameters (byval xx as xx).
I've written an application and I'm trying to utilise a database behind it. I've created a mysql database, and table which all appears to work correctly. I appear to have connected to the db correctly too. And hit a bit of a brick wall. As a side-note, within Visual studio connected to the database using the add data source wizard, I then dragged and dropped my db table's column onto my form that intends to display them all (6 textboxes, including primary key) and that now displays the first record of the table. It confused me, because i did this as soon as I had setup the database with no visual basic code assisting, so there wasn't even a connection string?!
One functionality i want to have is to press a button and cycle through the table's records using the form by the unique id, how would I do this? I'm essentially asking how can I enter a number in a textbox which would then return me the relevant primary key and data attached to that record.
My project contains a DataGridView with a SQL Database Table called Shows. This is a list of TV Shows and I want to apply several filters to it. So I have several different columns to apply the filter to.
1. Completed (bit)
2. Hide (bit)
3. Seen (bit)
4. Genre (nvarchar)
Currently I am using RadioButtons to switch between the queries, but I want to be able to have several filters applied at the same time with CheckBoxes.
[Code]...
I'd like to display the same data in 6 different listboxes but with different queries.The data is formatted as so:
ExptStage
expt1Expt List
expt2Ready to Print
[code].....
I've got everything working except this one problem which I can't seem to get my head around.I've made a function that returns a random number between 1 and 11 (how many invaders there are on a row).I've managed to get this to work, however the invaders will keep firing even if they are visible, so I made a do until loop which says to keep running the random number until it finds an invader which is visible... The problem is that if the whole row of invaders aren't visible, it will get stuck in the loop.
View 13 RepliesI'm a PHP coder normally, but I've been asked to make a small vb app. I've created my sql db (MSSQL) and have got all the data in it. However, I have no idea about how to connect or perform queries.
Here's my
Private Sub Form_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
[CODE]..........
1) Am I connecting properly? I created a new database using the dataset option and it has no username or password.
2) I'm trying to list the results, which will be clickable to open a new form with the full details. How would I do that?
Eg: In PHP, I'd loop through the resources using fetch_assoc, and create a link with the id and it's name as the firstname and surname.
Still experimenting with datagrids and ran into another problem...I'd like to sort a column displayed in a datagrid bound to an Access table programmatically. The field is a date ime type and is sorted in descending order in Access. I can manually sort it at run time but i'd like to know how to sort it with code.
View 1 RepliesThis is what i have for my set of columns:
[Code]...
2nd question. How can i bind other queries from different table to these columns. like Column[2]and Column[3] should come from a different query.
I am new to .NET 4 and VS 2010. I am using VB 2010 and have made a class and need to know how i can access those functions in the class within another form. So there is a function say of XYZ in the class named classes.vb and need to get to it from form1.vb
View 9 RepliesI have recently started learning VB.NET. I created a simple 3 tier windows application. The DAL project contains a class with a number of functions. In the BLL project, I've added a reference to the DAL project, but I still can't access the functions in the DAL class from the BLL. However, if I change the DAL class to a module, I can access them then. Both the DAL class and its functions are public.
View 1 Repliesi am having a query in access 07 which uses 2 functions (PUBLIC function)how can i run it from the front end (vb.net)
View 2 RepliesI am using the WebBrowser control with VB.Net (2010 Express) to get exchange rates from ft.com. (Note: I realise that there are simpler ways of getting exchange rates, but it is a learning exercise as much as anything else). I am navigating to a webpage, setting the values of a textbox and two listboxes, and then trying to get the resulting exchange rate which will be displayed as text. Trouble is, the result is not being displayed. I probably need to trigger an event to force the page to update, but I have tried this and it hasn't worked. [code] The 'onchange' event is intended to trigger an update, but it doesn't. I have tried a few variations without success (including "invokeMember"). So at the moment the amount and the to/from currencies are correctly set on the page, but the resulting rate is not shown.
View 2 RepliesAccessing Dlls functions/objects using VBScript
View 2 RepliesWhen a user clicks the + button on the binding navigator, I want to set the displayed item of acombobox to the value displayed in a label. The combobox is bound to a field in the table. Theproblemis that when the user clicks to add a new record the combobox is cleared and they forget to select a value before they click save.
View 7 Replies