[2005] Access and VB.NET -
Hey everyone,
I have a couple of questions about Access and VB.NET.
1. If I create a query inside the database in Access, is there a way to get/store those results in VB.NET?
2. My database is currently in Access 2003, and I recently had Access 2007 installed on my computer, hence I'm not able to do an oledb by using 4.0 jet provider (bis). Is there a workaround for this?
Thanks
date in access [resolved] -
Hi guys,
Two days I am thinking about solvig problem with date in access. I need to work with date, but access dos not know date() function like Excel. I have database where is for every week in first column stated starting date and in the second finishing date. For example 6th week
Return Record for each day if any [HALF - RESOLVED] -
hi, got other problem here
i need to return detail (like OrderQuantity, SaleQuantity) for each Ordered/Saled day for Specific Product
so let say if i had ProductID "a" which got Ordered at '01-06-2005' ,'05-06-2005', '13-06-2005' and Saled at '13-06-2005', '14-06-2005'
Access 2007 DB conversion to SQL using VS 2005 -
I am totally lost. I used a wizard from MS Access 2007 to convert my db tables into SQL and I can see the design view of the tables in VS 2005 but I dont know how to get past that to fill in info into the tables. I also have an interface started in VB 2005 for the Access db and I need
[2005] Using a Access 2007 database in VStudio 2005 -
I,am trying to use a Access 2007 Database in the Visual Studio 2005,
but the Access Engine, Microsoft Jet 4.0, does not support the
( .accdb ) database file from the Access 2007.
Could you help me.
Data Migration from MS Access to MS SQL 2005 -
Good Day,
I'm a newbie in MS SQL 2005, can anyone please give me a hint/procedure on how to migrate data from MS Access database to MS SQL 2005.
Thank you in advance,
How to generate weeknumber and begin of week date in access vba -
Hi guys . I got a table in my db called week. It has the following
feilds on it . Year, weekno and monday. I created a button and a text box in a form.
when i type a year name and press a button i want the the follwing happes:
it check if the year exist in the db. if the year doe
VB6 or .NET for Access 2007 -
I have always used VB6 for our programming needs but now I have a new project that will be a front end for an Access 2007 db. We have VB.NET 2005 but I've been too lazy to migrate and have always managed to get by with VB6. Can I still use VB6 to connect to the Access 2007 db (with DAO
Puzzling question on Matching up dates and accounting for double entries -
Hi there,
I have two worksheets in one excel file. The First Worksheet is a complete worksheet, and the second is to update the first.
First Sheet:
01/01/2005 .....more data.....
02/01/2005
03/01/2005
04/01/2005
05/01/2005
06/01/2005
07/01/2005
08/01/2005
09/01/2005
10/
VS 2005 Express, VS SQL Express, or MS Access -
I have written an APP in VB6 that uses a MS Access database and ADO. I am now rewriting that program in VS 2005 Express. I have some questions.Should I use the built in database part of VS 2005 Express to build a new database and use VS 2005 Express to handle all the database stuff?
Sh
[2005] opening an access database -
heya guys
can anyone tell me how to open and access database with access when a button is clicked.
i no in VB6 there was a thing called shell execute i believe it was however i cant seem to sind anything like that for VS 2005.
Very noob question on SQL (Creating a new DB) -
Hi!
I've Installed Microsoft SQL Server 2005 And VB.Net 2005.
Now i want to make a new SQL Database, tables, insert the values etc. But NOT from VB. Like i do in Access:
I open access then i go to new Empty Databases and i start to work. How do i do this in Sql?
Can i even see
SQL Server 2005 Express vs Access 2007 -
I heard that SQL Server 2005 Express is supposed to replace Access. If that is the case, then why did they include another version of Access in Office 2007?
Personally, I don't really like Access but at the same time, I don't think it will go away any time soon. Can SQL Server 200
SQL 2005 Data Type Question -
Hello,
I am going from Access to SQL Express 2005 and have a question about the data types. I normally used the type Text in Access for strings. Is the Text type the same in SQL 2005?
And I used Currency in Access. What is the same in SQL 2005?
Thanks
Warren
[2005] - Using VB to do Access Reports -
I have used the wizard in access to call out all information from a table in my DB. Is there a way of only pulling out data for a certain month using vb 2005?
VB 2003/2005 and Access 2007 -
Has anyone had any problems with a VB 2003 or VB 2005 program using an Access (*.accdb, not *.mdb) database?
Right now we're using Access 2003 (*.mdb) databases, but our unit is considering using Access 2007 (*.accdb) databases with VB 2003/2005.
Access LDAP Provider on Linux -
Hello,
I know that VB 2005 works well with LDAP providers on windows such as Acti Directory.
My problem is that I need to access LDAP installed on Linux namely OpenLDAP. I am able to access is from Outlook and see user info. I wan to do the same from my VB 2005 application. Any U
Database [VB 2005] -
Hello,
I make a database program. I use Access DB. But when user hasn't MS Access then projekt is functionless.
I use VB 2005 and here is possibility use SQL Database. But can't it using.
Can you me help ? It's right use Access Database ?
[2005] Scan For Wireless Access -
I was wondering if any one could point me to some tutorials or some examples of scanning for wireless access points? i would like to get information about the access point, like, MAC Address, Name of router, ect.
Im using vb.net 2005 Express
[2005] Access and VB.NET -
Hey everyone,
I have a couple of questions about Access and VB.NET.
1. If I create a query inside the database in Access, is there a way to get/store those results in VB.NET?
2. My database is currently in Access 2003, and I recently had Access 2007 installed on my computer, h
How can I access a MMC plugin in VB 6 or 2005 -
Hi,
How can I access / change a MMC (Microsoft managment console) plugin in VB 6 or 2005.
Is there a .NET standard or a Winapi way?
Any info would be great help.
Thanks all
Kim
Upgrade from Access2000,Access2003 to SQL Server 2005 -
Upgrading to SQL Server 2005 from Access 2003, Access 2000-Any pitfalls to be wary of?
Use Visual Studio 2005 or use VBA in Access or Excel -
I am looking for some direction as to how to begin a new project.
I am wondering if it would be better to try and use Access or Excel along with VBA to do this project of if I should use VS.NET 2005.
What I would like to do is make a proggy similar to QuickBooks. When I downloade
how to connect vb.net 2005 with ms access 2003 -
hello
I'm new in using vb.net 2005, I need to connect it with .mdb ms access 2003 database, also I need to know how to add into that database by entering the values in the textboxes at vb.net 2005 .
can you provide me with help please??
Thank you
pulling data from an access DB into SQl -
Hi there,
I have a database project (I am using visual studio 2005) I also have a connection to an access database and then a connection to a SQL server (sql server 2005)
What I want to do I pull data into the new sql server database from the access database. This would be a sim
Access -> VB 2005 -
Hi there. I've developed a database in MS Access which I have distributed to a few people to use for themselves. The database will most likely only have 1 user and will not be needed for multiple/networked use.
I would like to move over to a standalone program for the database thoug
Using ACCESS with SQL 2005 -
I'm trying to help a client of mine with a problem.
They recently migrated a database from SQL 2000 to 2005.
They work this DB with an ACCESS project - called Building2002.adp.
I just went into this project - hit f11 - clicked on DESIGN - and got this error message.
Any ide
[2005] Help plz deploying my App -
Hi Peeps,
I have wrote a small application that uses OLEDB to access an Access 2000 database. I want to not create a package and deploy so I can install it on a client PC but I don't have a clue in VS 2005. The application is using VB.Net.
Cheers for any help,
Jiggy!
VB 6 and Access 2003 / VB 2005 and Access 2003 -
Hi,
I am looking to link an access database preferably with vb 6, can you tell me if access 2003 will link with vb 6, if not, can you tell me if VB 2005 or VB.NET will link with access 2003.
Any help is much appreciated.
Thanks in advance
[2005] Remote Database Advice -
Hello
I need to store a database on my server. I would like to just connect to my access database. But I dont think I can do that because ODBC has to have physical access to the database..right? And my web host will not allow me to access mysql databases unless from a script run on
[2005] Using an Access 2007 DB in VB 2005 -
The Access 2007 DataBase as the extension .acdb
VisualBasic .Net 2005 dont acept that extension.
The System.OleDb. ... dont reconize the Database.
[2005] Quick and Dirty way to access MS Access DB via ADO -
I need to write a little utility program that updates an Access DB. I want to be able to access the DB really quick without using SP's or anything like that. All I want to do is update 1 table in this DB. Any suggestions on how to do this?
Thanks,
.NET db access (Access to sql) -
Hello all,
I have a desktop application that uses an access database, and I need to have access to it on the mobile device. How can I get sqlce to open the access database?
--> using VB.NET 2005 / Windows Mobile 6
Thanks in advance
Access IIF statement -
Hello,
Ok, hopefully you all can help me with this. I have the following SQL SELECT
statement:
SELECT [C_PROD-089 Availability WorkStatus].StatusDateTime, IIf(Format([StatusDateTime],"hh:nn:ss") Not Between "00:00:00" And "03:59:59",Format([StatusD
Access 97 IIF statement -
Hello,
Ok, hopefully you all can help me with this. I have the following SQL SELECT
statement:
SELECT [C_PROD-089 Availability WorkStatus].StatusDateTime, IIf(Format([StatusDateTime],"hh:nn:ss") Not Between "00:00:00" And "03:59:59",Format([StatusDa
[2005] Access and VB -
I am making a program in VS 2005 using access. When I press a button I want to close one form and when it closes I want to automaticly open another. Once the other is open I want all the data from the first one to show up in the dataGridView on the second form. I am puzzled to say t
Writing code to a Access Database in VB 2005 -
Hello everyone! I need to know how to write code to an Access database in VB 2005. Is it the same as writing code in a regular VB project or is it differnet? Let's say I wanted to write code for a table of TransNum how would I code that? How do you write functions to an Access Database
Importing an Access DB into SQL Server 2005 -
Is it possible to import Access DB's into SQL Server 2005?
Access Key forTab Control on windows form(2005) -
I have a tab control on a windows form and I want to set up access keys for each page on the tab control. Usually when you set an access key all you have to do is an ampersand and a letter or number ( &B sets the access key is set to Alt-B. This doesn't work for the individual pa
SQL Server & VB 2005 Express -
well... a friend of mine is telling me (annoying me ) that with vb2005 Express we cant access remote sql server databases... well i made complete applications with vb 2005 express that connects to msde, and its working pretty well... so it must be possible...
i think this is just a
Help select VB6 or VB2005 for win app with access or mysql -
Hi,
I used to do Powerbuilder programming ages ago. Now I need to develop a Windows application which can use a ACcess runtime database or a mysql database on a PC.
I would like to know what is best to use - VB6 or VB.NEt or Visual Basic 2005.
Also, I want to create a Installer