Public Declare Auto Function SQLConfigDataSource Lib "ODBCCP32.DLL" _(ByVal hwndParent As Integer, ByVal fRequest As Integer, ByVal lpszDriver As String, ByVal lpszAttributes As String) As Integer[code]...
View 2 Replies
i am pulling together a cash register that will allow both bar code product entry and manual key entry.imagine if you have a tin of beans in front of you, in a small corner shop they would probably type "47" and then hit "Produce". Fairly straight forward as I have the button Produce to act upon my code and update my salestrans.mdb but,if you scan the bar code I want the same form to handle both 'real' actions, (i assume that keyboard emulation barcode scanner includes "ENTER" after providing 13 digits)....
Q. in perhaps a long winded way i want to know how to kick off an event based on the "ENTER" key being activiated by the barcode scanner)?i do not want to have to hit any buttons if i am scanning bar codes.
What is the code for ignoring the case of an entry while checking to see if the entry is correct or not... (i.e. in a flashcard program... given definition, asks for the name) I don't want the case of a character to affect whether the answer is correct or not.
View 2 RepliesI am trying to make a program with a bar code reader for the first time. I am programming with VB 2005. I want to differentiate a bar code entry to keyboard entry. My questions:
1. Does bar code reader generate a keydown (or keypress) event for each of the digits of the entry? For example, if the barcode read: 1234567890, does that mean that there will be 10 keydown (or keypress) events for that single barcode that was read?
2. I have read from the posts that the best way to differentiating keyboard vs bar code input is to analyse the time between keystroke (for less than certain number of milliseconds).
I am trying to make a program with a bar code reader for the first time. I want to differentiate a bar code entry to keyboard entry. My questions: 1. Does bar code reader generate a keydown (or keypress) event for each of the digits of the entry? For example, if the barcode read: 1234567890, does that mean that there will be 10 keydown (or keypress) events for that single barcode that was read?
2. I have read from the posts that the best way to differentiating keyboard vs bar code input is to analyse the time between keystroke (for less than certain number of milliseconds).
I am using sql for this, I would like to know How I can allow only one entry (in the database) per day for each user ID
View 18 RepliesI'm doing a project where I need to have people register by entering a username and password. When they click register I want them to be added to the database, but I'm having trouble doing this. Can anyone help? This is my first time using VB.[code]...
View 2 RepliesI have an XML below like this and I want to add in another entry to it:
<?xml version="1.0" encoding="utf-8"?>
<CampaignRewardsVoucher>
<VoucherCode>Vouch001</VoucherCode>
<Quantity>3</Quantity>
</CampaignRewardsVoucher>
I have the above xml but I want to add Vouch002 after Vouch001:
<VoucherCode>Vouch002</VoucherCode>
<Quantity>3</Quantity>
</CampaignRewardsVoucher>
I have the code below which checks if an input is a duplicate and update accordingly, if not I want to create a new Vouch002 entry
'Create XmlWriterSettings
Dim settings As XmlWriterSettings = New XmlWriterSettings()
settings.Indent = True
[Code].....
I Use visual Basic 8.0 and Mysql 5.0 I have two exactly the same Tables:
Table1:
RecordID , Integer = primary key auto_increment NOT NULL
Articlenr , Integer
Articlename, Char(20)
[code]....
I want to add all the records from table1 to table2. I want to do this 10 times if I execute the following statement: INSERT into Table2 SELECT * FROM Table1 ; Everything works perfectly. The two records are added to table2 But if I execute the stament a second time get the following message: Duplicate entry '1' for key 1 I now i must do something with "duplicate key update" in the Insert statement.
I've produced an IP Entry box with similarities to the one Windows uses when setting addresses.It seems to work (I say seems),th the setting of text.I have code that checks the entry of text so this seems fine, but when text is being set through code, it allows anything and i'm unsure on how to make it only allow numbers and numbers between 0 and 255.
View 5 Repliesi know it might be impossible to achieve (as i've been reading from another articles) but does anyone know how to set a dll entry point in VB.net project? I have created a VB.net dll and trying to call that dll from cobol (unmanaged code). in Cobol, i can only use the entry point statement to call VB.net dll (cannot add reference to it). as consequence, i'm getting "called program not found" (or in VB error is equal to "can't find dll entry point")
View 2 RepliesIn my program I need to test whether an entry is available I ue the following code:
If Not (westTF(Me.K) < 0) Then
If westTF(Me.K) Then
Exit Sub
End If
End If
This does not function, but when I remove the outer IF it is OK. ( I need to test otherwise an error is generated when West is exhausted).
This is my Vb.net Project for company i want to generate code for each individual slip so that i get one field as unique field for that i want to use date & slip no to generate unique key. i have attached screen shot my project in this date 21/12/2011 & slip no is 12 now i want to generate unique number as 21121112 (i.e 21/12/2011 as 211211 & slip no is 12 appended at the end)if u have code then attach with your solution
View 3 RepliesI am trying to update a few entries in a access database through VB.NET. With the code I used below could anyone help me out and show me where I made a mistake because it is creating new database entries instead of updating them.
[Code]...
I have a form with textboxes for entering data. One of the textboxes is for entering a value that is always one character. How can I make the cursor automatically jump to the next control when a character has been entered? I'm thinking the key press and release event and then set focus but is there a better way?
View 3 Repliesim currently working on a project for a warranty company. I need to be able to attach pdf files using a browse button that will save them to the file, so that later if the contract is reviewed we can pull of the scan of the contract without say having
View 3 Repliesthis is the event table that records all the status(IN/OUT):
[Code]...
So am making a sign in-out program using vb.net and mysql. i was wondering if theres a code i can put in somewhere that will be like if a user opens the application he/she must signin before they can signout and if they open the application and they've already signed in, they cant signin again they must signout before they can sign out again.
[Code]...
I am trying to create a data entry wpf form and I am getting the following error when trying to create a window1 loaded event: "table name table adapter is not a member of file name.new data connection set table adapter.table adapter manager" I understand the error message and checked all my names but to no avail. Below is my class statement and window 1 loaded event:Private data connection as new data connection setprivate tatable as new data connection set table adapter.table name table adapterprivate tamanager as new data connection set table adapter.table adapter managerprivate view as collectionvie
View 1 RepliesHow can you add a system DSN with its security credentials programmatically at runtime from VB.NET? Keeping key in ODBC.INI is done, but when creating ODBC, it asks for Authentication Type (SQL or Network Login).How can we set that option at runtime?
View 2 RepliesI have a program to make for a class i am in and i am stuck on this one part, its a form application where you have to enter the first and last name of five students along with their final grade then you click a submit button after each one and i need it so that after all five buttons are clicked it activates the summarize button and i can't figure out how to do that and another thing when you hit the summarize button it has to compare the grade against the value of a text box containing the pass threshold to amount how many passed or failed.
View 1 RepliesI have an application which has a label, set to multiline. This area of the app is for notes and comments. One of the database tables behind the app is specifically for thenotes/comments table.I want to set it so that when someone puts in a new entry, the date is auto-inserted so we can see when they did it.
View 3 RepliesI am using Visual Basic 2008, and I am making a simple meeting planner program. The data stored for each day is stored into an array with three fields:
calendars.Days
calendars.ToD
calendars.Appointment
[code].....
I'm trying to delete an entry from my database, i have the code written to display the details in a listbox but now i need to write the code do the user can select the item they want to delete and then click the delete button to delete it? I just want to flag it as deleted not get rid of it completely from the database?
View 5 RepliesI am trying to find the last position of a name in a list.I have tried the following:Dim instructorp As String = lstInstructor.SelectedItem.ToString Dim endpos As Integer =instructorp.Length "Length" does not retieve a value. I think it is because there is a tab character in the string.
View 1 RepliesJust lately I've been 'playing' with entering data into a ListView and I have come up with the following code which seems to be OK. Can anyone see if there is any fault with it?
Code:
I was playing with VB.Net yesterday using Visual Studio Express (VSE). I am trying to get a feel for the language. One thing that struck me was the fact that VB's entry point, Sub Main(), is written inside a Module, as opposed to inside a Class like in C#. At least that's how it appears in the books I'm reading. That got me thinking. Is it possible to change the entry point location from a Module to a Class, or for that matter to have Sub Main() completely outside these two constructs?
I search the internet and found out that VSE indeed allows one to changed the entry point through the project properties. So I set the entry point to Sub Main() and tried compiling the "Hello World!" project locating Sub Main() inside a Class construct. Well, that didn't work. I tried changing the name of the class to match the project name, but that didn't help. I didn't bother try putting Sub Main() completely outside a module or class figuring that would be impossible. However, while looking through various post in this forum, I got the feeling I gave up to soon. So here are my questions:
1. Can the entry point be within a Class/Form construct or completely outside any construct for that matter?
2. Can the entry point be some other Sub (e.g., Sub MyMain)
If the answer is yes to anyone of these questions, where do I set the option to make this work?
I have a database containing usernames and "points". I need to increment the "points" at will. I have the table connected to a sqldatasource.
Here is my current code:
With Users
.UpdateCommand = "UPDATE Users SET points = points + 1"
.Update()
End With
This works great, except, instead of just changing the entry with the username specified by a QueryString, it changes all of the entries and adds one.The sqldatasource has the following select command:
SelectCommand="SELECT * FROM [Users] WHERE ([username] = @username)"
This command makes it so that only entries with the querystring specified username are displayed. This is really my first attempt at SQL.
[code]....
Suppose I have a parameter query called FillByStatus in my "Customer" DataTable and I want to fill the CustomerTableAdapter On Form_Load using this query. So I can do that by using the following code:
Private Sub Form2_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Me.OrdersTableAdapter.Fill(Me.CustomerOrdersDataSet.Orders)
Me.CustomerTableAdapter.FillByStatus(Me.CustomerOrdersDataSet.Customer, "Active")
End Sub
I have a reporting utility for my users to view, send (via email), export SSRS reports. I have set up date parameter boxes with calendar drop down and they are able to send via email a URL link that would either display the report via ReportViewer or send a link via email (listbox of email addresses) that would let them view the report in Excel or PDF. This is working just fine. Now I just added a button for adding new email addresses and a new windows form with a textbox for entering the email address and a command button for Save Email Address. I am able to save the email address just fine from the small pop-up window for entering the email addresses but after closing the window, the listbox of email addresses on the main form does not get refreshed with the new entry from the textox even though the SQL table EmailAdresses got updated.[code]...
View 5 RepliesI have got an array being populated which works fine What i want it to do is to return one of the items in the array (within a text box for example) which corrects certain criteria.
[Code]...
