Using VB Rather Than VBA For Access Manipulation?
Jan 20, 2010
I'm familiar with creating tables, updating, deleting, etc. etc. using a seperate VB program and a MS Access database.
However, I would like to know how I can start manipulating reports.
For example:
The user selects items in a combobox to filter certain items in a report.
The user selects a radiobutton to determine how the report is ordered (ascending by what field)
I've tried attacking this problem using VBA, but I haven't got very far. I couldn't even make a OnClick event procedure to execute the code I had written.
View 11 Replies
ADVERTISEMENT
Jul 4, 2011
First thing I should point out, i have looked all over, especially on DIC for examples, have found some, but none that i could get to work for me. I made a program that inserts data into a DB and then on another form it shows a gridview with the data from the DB. My first issue is im not sure how to insert items into the DB when the DB has an auto number field. I have seen on the internet to just not specify that field and let the DB handle it but its not working for me. This is what i have for that part:
Dim cmdInsert As New OleDbCommand
Dim AdoRs As New ADODB.Recordset
[code]....
View 3 Replies
May 20, 2008
I want to open an Access database and I want to multiply 2 fields between each other. I am a newbie and till now I only have found the way to open the access database and create my Recordsets. So, for example, if I have table Mytbl that is a recordset with 4 fields (columns) and I would like to multiply column 3 with column 4 and put the results in a new Recordset, do I have to do it by multiplying each and every record
View 4 Replies
Jun 6, 2010
im working on a small application that lets you input a phone number with "-" hyphens, and then copy that number to a label control minus the hyphens. So for instance 111-234-567 would become 111234567, i have accomplished this using the string.
replace command, however i was wandering if it would be possible to iterate through the string with a for next loop looking for the hyphens and then removing them with the string.
remove command, ive spent nearly 5 hrs trying to get the code to work, but to no avail, no errors are being thrown up, but the hyphens still display along with the number, i am currently teaching myself, and its a sloooooooow process. here is my unsucessful code
[code...]
View 8 Replies
Apr 6, 2010
I have a program that will register you for a certain website using textboxes and stuff but I have an invisible web browser and it just enters the text into the right spots and clicks the button.I was told that I can get rid of the web browser and do the whole thing faster and easier using "HttpWebRequest and HttpWebResponse".
View 2 Replies
Jul 28, 2009
I understand that there are several ways of Inserting, Updating and Deleting records in a database such as DataAdapters, DataSets, TableAdapters, SqlCommandBuilders, Parameterized SqlCommands, StoredProcedures, etc, etc,etc. According to David Sceppa Sprocs are the most preferred. Ok, I go with him on this one (who am I to challenge him anyway?).
My question is, apart from Sprocs, which of these options is the BEST for a large commercial database application and why, taking performance into account? What are the benefits and drawbacks of each option?
View 4 Replies
Jan 19, 2012
I have eight text boxes each can have any numerical value only consisting of the numbers 1-8 up to eight digits each. No 0's or 9's.I am using a timer to loop through the sequences of text boxes at a given rate. This is already configured.Now here's the hard part so bare with me.I need to output the first value of a text box, wait some time then output it's counter letter (below the number on the keyboard), go to the next text box and repeat. Example:
1
34
765
[code].....
View 1 Replies
Aug 7, 2009
This is probably quite a simple question, but I can't remember how to do it off hand.I have an e-mail address of "foo@bar.com".I want to grab the @ and everything after it and then I'll be adding a prefix to the front of the address as I go.
I'm just wonderng how I get hold of the @bar.com from the string?
I know I should know how to do this as this is a really simple operation.
View 3 Replies
Sep 3, 2011
this topic has been touched multiple times on Stack Overflow, but my search still did not give me an answer.
I'm looking for a SIMPLE and easy to use, very basic, image editing library. All I need to do is check the size of jpeg and png files and rotate them by multiples of 90°.I can develop my app in VB.NET or preferably VB5 and I'm not using any other library.
I tried the Advanced Image Library (based on Free Image Library), but I can't get the dll to correctly register and I'm afraid that I will also have problems when distributing the application.Is there something simpler? If it's not free it's fine, as long as the cost is reasonable.
View 1 Replies
Sep 9, 2009
I wanted to know if it's possible to remove a paticular item in my collection and then add it back at a certain location? e.g. say I use RemoveAt and remove the first item in the colleciton; after, I want to add it back at a particular location (index)? Maybe this isn't possible with this type or any other type collection?
View 6 Replies
Jan 27, 2012
The below is the content of my file(which is already sorted). Whichever is there between square brackets, relate to one transaction. The transactions can be groupa, groupb,groupc etc.
Jan 2012 02:10:12 [5678](groupa):Part 1:data1
Jan 2012 02:10:12 [5678](groupa):Part 2:data2
Jan 2012 02:10:12 [5678](groupa):Part 3:data3[code]...
I want to output the below data to another file using vb.net. It should contain the transaction group, followed by the time(the time should be taken from the first row of the contents grouped by transaction, then grouped by the number inside the square bracket, in the contents). Next line should concatenate the data(after Part [1-9]:), corresponding to the particular transaction grouped by the number inside the square bracket. For the above contents,
groupa at Jan 2012 02:10:12
data1data2data3data4
groupa at Jan 2012 02:13:14
data1data2
groupb at Jan 2012 02:13:24
data1data2
View 1 Replies
Mar 8, 2012
I'm developing my first SQL Server database app (for 30+ users) and could REALLY use some advice particularly because the app's design is pretty complex so please bear with the long explanation. My app eventually will display an always (hopefully) up to date list of files (and some related metadata) for a variety of purposes (open file, modify file's metadata, etc). The users deal with (open files, modify metadata, etc) dozens if not hundreds of files everyday so developing an app that making it all super quick and easy would really save company time in our environment over the course of a year.
The list is always enormous so my plan at the moment is to never close the app once it's running.The app will have schemes (TBD) for updating the list (modified data, new files & deleted files).It takes approx 45-60 seconds to load all the data which would make my app unusable if I were to allow the user to close the app.The design gets complicated because the list is a merging of two folder structures that share
some relative folder structures and files. The main list comes from a document management system (DMS) and the secondary list comes from a specific local folder structure (e.g. C drive). As with many DMSs, the user cannot modify documents directly in that system.
[Code]...
View 5 Replies
Jan 5, 2011
I'm expanding upon a tutorial we have in class for a cash register. The basic program is to put the name in, put the price in, then manipulating labels display the item name, price, tax, and price after tax. Three buttons being calculate tax, clear the form, exit the program.
[Code]...
View 2 Replies
Dec 9, 2011
So far I have a button that calls scan.bat which simply runs net view and outputs to file.txt. I then want to strip out all the gumpf so it just leaves the names of the PC's in the list (not the remarks and all that).I'm new to all this, so it might not be the most elegant way of doing this!
Imports System.IO
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
[code].....
View 4 Replies
Feb 19, 2010
I don't actually know where to post this cuz i don't actually need code, i just need help on the logic. But if i could get a code then that's fine either
you see, i'm trying to get specific details on a text file.For example, the contents of the text file is like this:
[Code]...
View 3 Replies
Sep 5, 2009
My.Settings.regLibCardNo = "10-0000"
I want it to increment
CODE:
View 3 Replies
Apr 18, 2009
I am stripping few tags in html file and then assigning that html string to documenttext property of webbrowser. i can successfully do it, but when i use webbroswer1.document.GetElementById(xx) i am getting invalide type cast exception error.. even if i use any of webbrowser document property i am getting invalidtypecast exception.
View 6 Replies
Jun 10, 2010
I have a text file that has about 200 programs that were dumped from a cnc machine. I want to be able to take that text file and extract each program and save it as it's own text file. There is a distinct character at the beginning and the end of each individual program. I an new to vb and the projects that I have done to this date involve database front ends so i have no idea on how to work with text files.
View 32 Replies
Feb 11, 2011
When I try to remove the last few characters of a string, I get an index out of range error. I am using the following to remove the characters from the end of the string:
objJSONStringBuilder.Remove(objJSONStringBuilder.Length - 1, 6)
The string has <hr /> at the end which I want to remove.
View 3 Replies
Jul 7, 2010
Given this Short (signed):
&Hxxxx
I want to:
Extract the most right &HxxFF as SByte (signed)Extract the left &H7Fxx as Byte (unsigned) Identify if the most left &H8xxx is positive or negative (bool result)?
View 5 Replies
Apr 21, 2009
Essentially I have a half text/half graphical tile game that has a level designer. I have several sets of tiles, all of which are bunched together in one file. I'd like to read a certain 32x32 square of said bitmap, and display only that portion on specified area of the screen. I know GDI+ enough to get the display going, so I just need help with reading the specified portion of the image from the bitmap.
View 4 Replies
Jan 21, 2012
I have a vb.net / ado.net application for distributors that queries a sql server db, converts the records to tab delimited text format file. After building the file, the user goes to the website of the manufacturer, logs in to a private area and uploads the txt file.
I would like to add a function to my vb.net code that would launch a browser in a form, load the manufacturer's login screen, load the user id, password and then let the user log in by clicking the login button. Then when the next page loads, I'd like to have the text file I just created pop into the web page text box for file name, choose a couple of radio button options properly and then let the user click the submit button.
View 3 Replies
Oct 10, 2010
The homework assignment goes like this: write a menu-driven program to manage an employee list. the names should appear in the listBox when the form is loaded. When a name in the listBox is highlighted the name and number txtBoxes are loaded with the correct name and employee number. Use the Update menu items--modify,add,delete to edit the listBox items.When the Exit menu item is clicked the new employee list should be written to the text file and the program should terminate.
Well, the first part was completed successfully, but when I tried to delete a name and number I recieved an error box that said "InvalidOperationException was unhandled", "sequence contains no elements" that pointed to line 35. msdn and help were no help, talked about dataset tables? Did I use the incorrect syntax? Once I resolve this issue, the other two--modify,add should be similar, but then how do I reconstruct the text file so that it will properly load the next time the form is loaded?
Public Class Problem_1_p451
Structure Company
Dim name As String
[code].....
View 3 Replies
Aug 15, 2011
I'm suppose to end up with a label box with my name spelled out in it using string manipulation. This is suppose to happen using the concatenated string to output the name into the label box. I don't have any error codes but I also don't have my name in the label either. [code] "Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry's standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout. The point of using Lorem Ipsum is that it has a more-or-less normal distribution of letters, as opposed to using 'Content here, content here', making it look like readable English. Many desktop publishing packages and web page editors now use Lorem Ipsum as their default model text, and a search for 'lorem ipsum' will uncover many web sites still in their infancy. [code]
View 2 Replies
Jun 10, 2011
I'm trying to create a app that will add some reg keys. But I need to change the default value. How can I do it? I don't work :@
[Code]...
View 2 Replies
Oct 6, 2010
So I have a string "New". What is the simplest way to convert that string to "New". Basically right now I'm doing this:
Case "NEW"
makes = connector.GetMakesByYear(_AuthorizationKey, "NewCar", CDate(Now), Year)
Case "USED"
makes = connector.GetMakesByYear(_AuthorizationKey, "UsedCar", CDate(Now), Year)
And I would prefer not to use a case statement because it's only one parameter that needs to change, and both are appended with "Car".
View 3 Replies
Dec 26, 2011
The idea is simple, if I have a string value "ABCD" then with a ButtonClick event it should randomly reveal a char while others are hidden. i.e, "B*" another click would "AB**" and so on. So far, my I have been stuck in a for loop.
[Code]...
View 2 Replies
Dec 19, 2008
I am trying to do string manipulation of an OpenID in my codebehind. For example, if the user enters " url...I want to do the following:
1. Remove the http:// or https:// if it exists
2. Remove the "/" at the end of the OpenID if it exists
So that all would be returned is url...I have used the Right, Mid and Left functions before with a string that contained spaces but I'm not sure how to accomplish what I'm trying to do here.
View 5 Replies
Apr 15, 2009
I am trying an encrypting exercise which takes the txtmessage and encrypts it in characterarray.IStartAt is the starting point and by taking one character at a time from txtmessage I need to insert it in characterarry allowing a gap in between which is IUseGap. KeyGap and Keyfirst will be the next two characters after txtmessage and when insert have no gap in between.I think the logic I done is good however, I get syntax errors on the red lines.[code]
View 11 Replies
Jun 25, 2010
I need some help writing a program that navigates to a certain URL, and then when I click a button, it gets the string after the word(in the HTML source code)MD5:and then there is a 32 bit string. How could I list the 32 bit string in a textbox?It can contain MD5: aswell too.. I don't mind
View 2 Replies
