Process: I have the below code which gets the base SQL statement and defines the working query. Based on this it then generates & exports Excel spreadsheet into a defined folder (wkfolder).
Objective: The exported workbook name is fine but the sheet-name comes up as "RunReport". I wish to change the sheetname to "UpdateData".[code]...
I agreed to trade some code with my wife (her SQL for my .NET), but I am running to an issue on my side. I have taken some old vb that she is needing converted to .NET and made it work, but there are two lines of code:
DoCmd.SetWarnings(False)
'and
DoCmd.SetWarnings(True)
I have found out that these are objects related to using Access, but i can't figure out how to use them in .NET. It seems that, in the original code, they are used without instantiation, but I get the "Reference to a non-shared member requires an object reference" on those two lines of code. I have never worked with Access before, but it seems like it would be a simple fix if I just knew exactly what was having its warnings enabled/disabled.
I use the followoing code to import an xlsx file into an Access 2007 table. It works fine when I enter the exact file name.However, part of the file name is a date which will change every week.The file location does not change,just the date in the file name.[code]I've tried using a wildcard but I get a Run-time error 3011.Db engine could not find the object. Make sure the object exists.
View 1 RepliesI am using ms-access 2002. I have to export the data of a ms-access table in Fixed Width format.To accomplish this I am using DoCmd.TransferText method. DoCmd.TransferText acExportFixed, "schema.ini", "table_ABC", "C: estingTestData.txt"But I am getting error message: "Run time error-3625 The text file specification 'schema.ini' does not exist.You cannot import, export, or link using the specification."Here schema.ini is at same location as of text file. i.e. "C: esting" I tried with DoCmd.TransferText acExportFixed, "C: estingschema.ini", "table_ABC", C: estingTestData.txt"
View 16 RepliesI'm trying to connect vb to sql server using this code:
Public Class _Default
Inherits System.Web.UI.Page
Dim insertQuery As String
[Code]....
I'm new to VB, trying to connect vb to sql server using this code:
Code:
Imports System.Data.OleDb
Public Class _Default
Inherits System.Web.UI.Page
Dim insertQuery As String
Dim updateQuery As String
Dim deleteQuery As String
[Code]...
this code:
If Not DataSet1.Tables.Contains("Table0") Then
DataSet1.Tables.Add(New DataTable("Table0"))
End If
[code].....
Am a bit confused on a basic select statement.Select Fieldname from Tablename Where FieldLink ='1007'
Nothing special.Now I pass into a sub that populates a combobox for me, but I get an error message - Index was outside the bounds of the array. This happens on the line when trying to add the data to the combobox But, if I change it to
Select * from Tablename where FieldLink = '1007' it will work fine, but returning the wrong field data.
Am I missing something. Procedure below that I using to populate the combobox
[Code]...
I am using the following command "DoCmd.Outputto acOutputReport, Report Name, acFormatPDF, FileName".The report I am using legal as the page size. When the PDF is created in is created using letter size pages and the buttom of each page is cut off. I would like to find out why this is happening.Bob Gouveia
View 4 Repliesgetting a DoCmd.RunMacro method for running macros inside EXCEL and Word?
View 1 RepliesBasically i have a list(of TransRecord)
vb Public Class TransRecord
Public TableName As String
Public PKs As String
[CODE]...
And want to create a linq filter to select only unique records for TableName + PKs (group by) ... but want it to select only the record with the highest ID for this group by.
My first project is a grading system for a certain school. In my login form, there's a Forgot Password button. In the Forgot Password form, the user is asked to answer a secret question that he filled up upon registration, and if the answer is correct it will lead him to a Change Password form. My problem is, I don't know how to get then delete and then replace the password of a certain user.
View 3 RepliesI thought i am doing fine with my project..The access level is fine.. when i login as "ADMIN". I can change the password.. But for other users, if i click save nothing happens but if i click it again it will save(In my savebutton event the txtbox is cleared if saved)
Here is the code for my login(this is the access level part)
If reader.Read Then
Dim access As String = reader.Item("Position").ToString
Select Case access
Case "ADMINISTRATOR"
Me.Hide()
[CODE]...
AND THIS THE change PASSWORD PART
Private Sub UserPasswordUpdate()
Try
Using _connce = New SqlCeConnection("Data Source=" & _dbAlumniTracking)
_connce.Open()
[CODE]...
In my login form, there's a Forgot Password button. In the Forgot Password form, the user is asked to answer a secret question that he filled up upon registration, and if the answer is correct it will lead him to a Change Password form. My problem is, I don't know how to get then delete and then replace the password of a certain user. I attached some screen shots of my work.
View 1 Replies(using VB.Net 2008) I'm inheriting from a class, and overriding one of the properties. However, the original property has public get & set, whereas I want to make it read-only in my derived class, because the property in my derived class is already determined by other factors. But it appears I can't change the access level of any overridden method. Is this possible?
The closest analogy I came up with is suppose you have a Person class, with a get/set Address property. Now suppose you inherit Child from Person, and Child will have a new Parent property. Say you want the Child's Address property to be readonly, because it will simply return the address of Parent. Even if you can override the Address property, you can't make the Set non-public. The best I can do is make it throw an exception but that's obviously misleading during design time.
I'm a newbie in vb. My first project is a grading system for a certain school. In my login form, there's a Forgot Password button. In the Forgot Password form, the user is asked to answer a secret question that he filled up upon registration, and if the answer is correct it will lead him to a Change Password form. My problem is, I don't know how to get then delete and then replace the password of a certain user
View 1 RepliesI have a website that currently uses a MS Access database, but I have been asked to change it to an SQL Server DB. I used the upsizing wizard and have changed the association in the web site from c3.mdb to c3.adp but I get the error "unrecognized database format. I tried using the .mdf file
Code:
Sub Application_Start(ByVal sender As Object, ByVal e As EventArgs)
' Fires when the application is started
[code].....
im currently working in a project and i already made a code for the login, the only thing is that i dont know how to update the records(Username/Password) in access using VB 2010. well i can update by manually changing the content of my table but i like to have it change using an interface in my vb named Manage account
View 9 RepliesI am looking for some code that will allow me to set field properties of fields in a table I have just created in code using vb.net (2005). I have seen a number of articles to do this in vb6 but not vb.net.
View 2 RepliesAutomatic update Dataset after change in Access
View 8 RepliesI create an Access database in runtime, but when want to change the column properties I can't,the IDE tooltip say: "Property 'Item'is'ReadOnly'".I have a VB6 application with an Access 2003 database and not have any problem to manipulate to many properties like OrdinalPosition, ValidationText and others.
View 2 Repliesi want to now how to change the access modifier of a form so that it is publiv ind=stead of friend.
View 2 RepliesHow can i change the currency in ms access 2007. I want to change the dollar into peso. How can i do it?
View 5 RepliesI would like to use VBA to change the caption of a report when it opens based on parameters set in the code. For example[code]...
View 1 Repliesthe msg box was prompted with code :
StrInput = InputBox(Prompt:=strMsg, Title:="Location of Files", XPos:=2000, YPos:=2000)
im not sure how to change the size of the box. i want to because my strMsg is quite logn and doesnt look nice in a small box.
I have made several changes to the columns in an Access db, such as additional columns, column type changes, etc. how do I now incorporate those changes into my datasource? Do I need to delete the datasource and create it from scratch?
View 1 Repliesim currently writing a program calculates commute costs. How can i have the class that calculates the costs of the commute, to be able to change the .text value of a label?
View 1 RepliesFirst, I would like to add a text box search field to this form (because navigating through several thousand users with arrows isn't going to work). When the search button is pressed, I want the username to be looked for. If found, the form (and each textbox, option button, etc.) is updated with that user. I can then modify the user's information and press save.
Second, how do I access and change information in a database with only code? For example, if I periodically want to check every user in the database to see if they have over "100 points" and if they do, I subtract 10 points from that user.
I have a drop downList and I have it listing colors. When a color is selected I want to change the background color of the page itself.
I am using Visual Studio 2008 and using VB.Net.
i have an application with access .accdb as backend.How can i convert the backend to OracleBL (Visual Studio 2010 Ultimate)
View 3 Replies