I am using VS 2010 and Access 2010 and in a table I have a Primary Key called Counter which is an Autonumber.When I save a record I need to be able to access the value of the counter field for the new record. When I try and access the field I get a value of zero.I can see the value in Access but I cannot set it in Vb.Net. I have set the fields and then
[Code]...
I'm having a problem setting the maximum number of records that can be saved into Access. The maximum allowance is to be 10. Records are being pulled from a listbox. The whole problem is that if the listbox has 7 items and my table already has 5 records, it still records them, making a total of 12. What I'm looking for is a way to trap that to a max of 10.[code]...
View 2 RepliesI have problems to print the records which is saved in text file. It prints whatever in between the textfile but does not print whatever contents in the textfile.
Public Class Form1
Private Sub pd_PrintPage(ByVal sender As Object, ByVal ev As Printing.PrintPageEventArgs)
[Code].....
I'm trying to build a new customer data entry page for a db project. One of the features I would like to add is a way to check and see if there have been any new records that have been added that haven't been explicitly saved to the db. If so, when the form_closing events fires I want to evaluate whether or not new entries have been made that weren't saved, and then count the number of rows that haven't been saved.
[Code]...
i have a sql table which has 2 fields number & name
1 abc
2 xyz
Situation is that the app finds out max of number and increments it by 1 to get new number.The problem is when two users enter some record sometimes two records get saved on same number.
[Code]...
I have a textbox, a sql database, a binding source bound to the sql database. I can use auto-complete mode of the textbox with custom strings and it suggests in in a drop down form as the user types in a textbox. How can I use autocomplete mode with datasaved in different records of a field using the bindingsource?
View 5 Repliesit's just for a program registration. i would store all of the registration codes in the access database, then export it to XML, then upload it to my web host. I would then somehow connect it to my Visual Basics login form (Which I have already made). If this can't be done, having them register through the form and having all the allowed codes on the internet (So i can easily edit them)!
View 5 Replies[code]...
I am currently using this last part to save a bitmap I created.This works, however, by saving it in the .exe directory.How would I specify an address for my .bmp to be saved..or better yet, how could I use a SavefileDialog or BrowseFileDialog to specify an address?
Are My.Settings values saved in the program itself or do they get stored in the registry? o, for example, if I set a My.Settings value with a program, then I copy the program itself to another PC - is the My.Settings value still set?
View 3 RepliesI am creating a simple button based rpg and was wondering if someone could help me with 3 things how to hold information within the game until the player save's the game, Saving the game, and Loading the game.I want the saved games to be saved onto a encryted file like .db or .dat file..
View 3 Repliesfrom yesterday night i have done a part of my practical and i saved to my pendrive... the folder name as <Chapter 3>and today i went to college computer lab continue to finish another part and i also saved to my pendrive, since i open the .sln file from pendrive.and i go rename those folder names and .sln name and others possible to rename as <Practical 3>when i back home want continue to do, the folder is still exist but inside folder's files are lost.
View 3 RepliesI'm using this code to update my access database.
[Code]...
If i run the program in debugmode and then do a update it will be saved to the database.(must stop and run again to see the update. How to se the update directly?)
My main problem is that if a build the program and run it outside VS then update never being saved. How can i solve this. I tried using "commit"(maybe totaly wrong) but that didnt work.
I cannot find a Backup Files folder and auto recover was turned on? I spent ages working on a project when the power went
View 6 RepliesI am trying to use the combobox to update/edit/view the saved data (in contact form) from sql server.
My Load_Combobox (in contact form):
Private Sub Load_Combobox()
'Type
cboType.Items.Add("Director")
cboType.Items.Add("Principal")
cboType.Items.Add("Project Manager")
cboType.Items.Add("Technical Manager")
[Code] .....
The problem now is when I saved a record into sql server (EG Technical Manager) and try to view back the saved data, it always show the first item (Director) in combobox. But, my sql server has saved is "Technical Manager" for that saved record.
We stream the BBC news channel through a laptop hooked to a PC in reception for our clients. Annoyingly the stream is interrupted randomly (the line isn't dropping, it's the BBC's problem). Therefore when it's interrupted we get an error screen appearing which we have to go and manually refresh to get the stream back playing.
My intentions are to build an app which will be run alongside (silently) the stream monitoring intermittently a range of pixels. If the range matches the error screen that I mentioned previously then I'd call "Esc" to exit the full screen and then "F5" to refresh the browser and finally a double click on a specified coordinate to bring it back to full screen.
Problem: I've been doing some googling and so far have only seen related posts where the comparison is between two saved images. Due to this I expect the answer to be "Take a screenshot every now and then, compare, return result".
I am making an application where a user can store their logons/passwords and other details for websites on the internet.My question is this: Am I able to have a list of all sites that the user has saved a password for on the internet?I don't think I will be able to get the password (because of Windows security), but am I able to see what sites the user has saved their password on, and maybe even the username they used?
View 4 RepliesI have a database with 3 tables: Student, Unavailability and Duty.The fields for Student are entered in a form I have. One of the fields in Unavailability is filled by a form, the other fields are an autonumber and a foreign key to the Student table.ow I want records in the Duty table to be created and automatically filled in depending on what the values of the fields are in the Student table.For example, If the Boarder field in the Student table is 'yes' then I want the Duty Number field in the Duty table to be '1', '3' and '4'. If it is 'no' then I want the value to be '2' and '5'. I recognize it will have to create several different records to incorporate the different duty numbers for each StudentID. Obviously this will require an if statement, however this is my first time implementing a database with my limited experience with programming and Visual Basic, so I don't know how to refer to the specific fields in a table and set the value of other fields depending on the data in other fields.
View 6 RepliesI want to be able to use a loop and reference controls using a string. The following code works for textboxes.
dim myControl as Control
dim ControlName as string
dim LoopCount as Integer
For LoopCount = 1 to 3
[code].....
I have a datagridview on a form and this shows up my list of suppliers. I have a textbox which when i click shows up the supplier list and from there when i double click on a row, the supplier's name is shown in the textbox. The thing is i have to do same on the same page for search purposes which got its own textbox. But the cell double-click event already contains code that will display it in some other textbox like i mentioned previously. What i thought is to make another form with a datagridview. So this datagridview will be used to display the supplier's name in search textbox. But what if i have to access this form several times. Do i have to create several forms everytime?
View 7 RepliesI've a problem with accessing to values of added TextBoxes. I'm adding TextBoxes in my application using NumericUpDown control (event of NumericUpDown1_ValueChanged). It' s value is 1 to 10 and by each step it adds 2 new TextBoxes (named TBC11i and TBC12i, i=1-10). I've created a second event (ButtonClick) where I want to use their values in a For Loop named like this:
[Code]...
Im quite new to VB.Net so, this is what i have. A simple "console" form. Its just a form with a ListBox in it. To add stuff to the ListBox, i have to open the console, to let other forms know what the ListBox there is.
[Code]...
I have a script where I make separate routines with identical code
Example:
sub AddToA {
ATotal += 1
}
sub AddToB {
BTotal += 1
[Code]...
My problem is that I have a program which needs to access images for multiple choice questions, hundreds of them. Now when I publish the program it is not taking the images with it. I have read some information by 'kleinma' regarding publishing and he says to right click on the Bin and click include in project, but when I do this there is no command in the menu for this.
I have included all of my image files in the Bin and have also added them using the resource editor, but to no avail As I have indicated it is the Express edition, could this make a difference
I am trying to follow this userguide url... to basically build an application that will allow users to connect to my database, from an exe file. I'll try to explain as best i can. The plan is, users will launch an exe file that i have built in Visual Basic(VB) 2010 Express. When they launch the application they will see a 'login screen'.I am following the example guide (see link above), and will customise it once i can connect to the database. For some reason whenever i connect to the database it gives me two errors, the first is if i use the 'debug' mode in VB to test the script (note it doesn't produce any build errors), the second is if i build the application and run it as my users would.
1)Error Connecting to Database:Access denied for user 'mike'@'92.**.**.***' (using password:YES)
2)Error Connecting to Database:Unable to access any of the specified MySQL hosts..The ip address starred out (*) is my local machine ip address.The server is the server in which my Database runs on. 'mike' is a listed user on my 'user' table, the password i use is the password assigned to this user on my table.
3)I've rebuilt the whole VB project, but still no joy, wern't expecting it to as there were no errors generated.
4) I've read, but don't really understand that it could be something to do with my database not being able to be controlled remotely, only locally. I started digging into 'Access Your MySQL Server Remotely Over SSH', didn't really know if i was going completely off the mark, it didn't mention needing to do any of this in the guide i've been following, but just a thought. It might be the case as i've tried to access my database through a programme called MySQL Administrator. I punch in the host,username etc and connect to my database, for some reason it won't allow me to add new users, could this be because i can't control my database remotely? Would this stop what i'm trying to do working?
5) When trying to install the MySQL.Data.dll file i had great difficulty in choosing one and finding it, adding it to my project using the 'Add reference' in VB. Finnally got it how it should be (i think), installed MySQL.Data.dll Ver 6.1.2.0 into my project.
Is there any way to access your variable names at runtime? Is there any kind of collection you can loop through?
View 2 RepliesI have some code that gets the documenttext of the current page in the browser, the trouble is that im trying to use it in a backgroundworker so the ui remains responsive. Everything works fine as is If I run from a button click event, but in the background worker I get errors when trying to use the webbrowser.
'if urltocheck is blank use hidden webbrowser to get page text
If urltocheck = vbNullString Then
'make sure browser isnt already loading
[Code]...
Thats the code how do I make these calls the the browser from the backgroundworker? Or how I can I run an enormous for loop from the ui thread, and still keep the ui responsive?
I'm having a strange difficulty. Here is the order of events:User presses button on form1 New Form object is created for from 2 New form object '.show' command is fired Form 2 opens correctly In the Load Event of Form 2, the form attempts to do various things in a try, catch, finally clause On catch, I close form2 down '.close' as it cannot be used as something has gone wrong with the execution However, my problem is this. It is acceptable for things to go wrong on the from 2 load event which is why I have implemented the try - catch functionality. However, when I close the form2 down as a result of the problem, a real error ocurrs 'Cannot access a disposed object' and the VB IDE refers me to Form1's '.show' event for Form2.
It is almost as if the form hasn't fully 'shown' before I am closing it down. Does anyone have any idea what the problem is here? Do I need to close down Form2 ourside of it's Load event handler so that Form1 thinks it has loaded correctly?
Im am trying to get two separate applications to communicate with one another via a txt file. The first application writes to a txt file every even second and the second application reads the text file every odd second. The problem is Im getting an exception saying The process cannot access the file FILE_PATH.txt' because it is being used by another process. Not sure if my code is correct or not? Or if there is a better way to do this?
[Code]...
How can I prevent debuggers from accessing my program?
View 2 RepliesI have written lots of code with the ADO Library in VB Excel and previous versions of Visual Basic. With the dissappearance of the recordset object, how do we perform data manipulation with an attached Access Database? It seems things could be a lot easier, and less complicated by now, however, the best methods appear to currently remain ellusive.
[Code]...