|
The DateTimePicker is a very custom Combobox. Everything about the DTP control overrides the original code of the ComboBox. This is a topic that is much too large for a forum discussion. I would suggest going to Google and searching for articles on "Custom Controls", or "Custom ComboBox" for more information and examples on how you can ownerdraw your own ComboBox.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
I stored 5 records in a tables whose first field (ID) is assigned a primary key and autonumber properties. During the test phase I deleted 2 records.
The query "SELECT Max(ID)From TableName" returns 3. But Whenever I store a new record by a query "INSERT TableName (_2ndFiled,_3rdField) VALUES('the value for 2nd field','The value for 3rd field')" the new record is stored having ID as 6 Why??
Whenever I record a child record into a child table with reference provided by this query "SELECT Max(ID)From TableName" . The error occures! How to deal with this problem.
Shoaib Nawaz
-- modified at 8:45 Saturday 24th September, 2005
|
|
|
|
|
Because once a autonumber field uses a number, it's never used again.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Doesn't, what in Access is called, Compact and repair databases - reasign the autonumber field, so it can reuse previously used but deleted numbers?
---------------------------
127.0.0.1 - Sweet 127.0.0.1
|
|
|
|
|
Nope. Autonumber fields are not reset to the lowest unused number. Identity fields are also not renumbered to compact unused numbers.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Well....
It resets incrementing AutoNumber fields so that the next value allocated will be one more than the highest value in the remaining records. For example, if all the records in the database have been deleted, after you compact the database, the value in the AutoNumber field will be 1 when the next record is added. If the highest remaining AutoNumber value in the database is 50, after you compact the database, the value in the AutoNumber field will be 51 when the next record is added. Note that this is true even if records containing values higher than 50 were added previously but were deleted prior to compacting.
Some MS support article for access 2002 (and the same is said in the 2000 and 97 articles)
So while it doens't automatically reassign all existing autonumber fields, it does infact seem to reassign the next number in the list after a repair, and that you can reuse previously used autonumber fields.
---------------------------
127.0.0.1 - Sweet 127.0.0.1
-- modified at 1:12 Sunday 25th September, 2005
|
|
|
|
|
So it does. :-> But it still won't result in what the OP was talking about.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Hi all,
I am new to .NET.
I am working on an assignment as given below.
Assignment - Class and events concepts.
Create a class clsPaint
This should draw circle,rectangle,ellipse on the form.
Take a menu with 3 options - circle,rectangle,ellipse
Trap mouse events and do the drawing.
I want to know, how to draw the objects without using graphics.
Can anyone help me out here?
Thanks in advance!
|
|
|
|
|
How on earth do you expect to draw anything with using a Graphics object?
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
image.SetPixel
|
|
|
|
|
Paper and crayon would be quicker!
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
I will try and makes this question simple, so if anyone could lend a hand that would be great...
Basically, I want certain tabs on my tab form disabled but not removed completely when a certain condition has not been met (such as a user not logging in)
and clickable and functional when they have logged in.
please help asap =)
|
|
|
|
|
In the tab control use the tabs collection like tabl(0) to enable or disable any tab on appropriate time/action you want to perform.
you can even set the visibility as well and any other action.
Regards,
Asim
|
|
|
|
|
I have seen in this site a few ways to create an auto update feature in aplications (and are good), but seems to be a "home" solutions.
Which is the "profesional" way to make this?
Thanks.
|
|
|
|
|
What is the difference between a "home" solution and a "professional" solution?
My: Blog | Photos
"Man who stand on hill with mouth open will wait long time for roast duck to drop in." -- Confucious
|
|
|
|
|
ok so this might get a bit long but i hope someone can read thru and tell me where im being an idiot
so i have to get data from a source database and write it to an xml file defined by a destination database schema file (xsd) ... what im doing is this:
1. create a dataset and load a schema file into it to define the structure & relationships
2. create a custom mapping file (in plain text) that defines the query i'll use to pull the data from tables in the old database to fit with the new tables in the new database
3. for each line in the mapping file i run the query and read the result set row by row adding each row to the output dataset in the correct table
4. write the xml from the output dataset
is there a better way to do this?
thnx very much in advance
"there is no spoon" biz stuff about me
|
|
|
|
|
i use a module containing the sub main.
in this module there's notifyIcon and an object (objX) of Form (X).
doing one of these:
objX.Visible=true
or
objX.Hide=true
causing all of the application to treminiate
is there and way to hide the form without minimizing it and closing the appliction.
with considering the notifyIcon.ContextMenu has a show menuItem and Hide MenuItem?
militiaware - VB.NET
|
|
|
|
|
Hello,
I have a little problem, i am expecting a solution.
I have a combobox loaded with data. I have to do some operations once the New item is selected. But i don't want to use selectedindex/value changed event, as this will change on any selection. Instead i want to perform the operation once the item is selected i.e. once the change is committed. The event is SelectionChangeCommitted.
The problem with SelectionChangeCommitted is that this never fires in different cases like COmboBox is in drop mode and we are using keyboard arrow keys to select different items. Now when we click anywhere on the form the value is changed but this event is not fired!
There are other cases like you are going through values in drop mode and then you press escape button. New Value is selected but again SelectionChangeCommitted is not fired.
So Can anyone tell me the work around ?
Waiting anxiously for some solution.
Regards,
Asim
|
|
|
|
|
Each firing event execute a subrutine in Visual Basic. In some cases when one event is firring and not the other which you want, You can fire it manualy by calling the subrutine that executes against that event which is to fired.
If user selects with arrow keys.
KeyUp event can be used to fire Click Event
Sub MyCombo1_KeyUp(KeyCode as Integer, Shift as Integer)<br />
If KeyCode = 38 or KeyCode = 40 then<br />
Call MyCombo1_Click<br />
End If<br />
End Sub
When user will press Up or Down keys, Click Event Functionality will also work.
This is only the demonstration, you can manage it your self.
Shoaib Nawaz
|
|
|
|
|
Thank you Shoaib.
THis helped me a lot in resolving the problem.
Regards,
Asim
|
|
|
|
|
i m making an application for a medical shop i wan't to intigate with barcode reader.can any one help me out.
get back 2 me
|
|
|
|
|
Normally, barcode readers are just like a second keyboard. You put the focus in the TextBox, or whatever, scan the code, and whatever the barcode reader sees is "typed" into the TextBox. It's a little more complicated than that, but that the basic idea.
It sounds liek you really don't have any experience with this. I would suggest getting into the documentation for the barcode reader and putting togther a test app or two to "play" with the reader to see how it works.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
hi friends..
Im facing a problem in doing my project for Search files or folders between 2 computers in workstation using Visual Basic language...
Searching files are based on their filename, word or phrase of the files.The searhing result will be display the filename, filepath ,filesize,create on and last updated in a List View toolbox.
Please help me !!!
Best regards
Thanks
misz_7@yahoo.com
|
|
|
|
|
Help with what? You've just laid out the general specifications for your program, but you didn't ask a question specific enough to answer. What part of this are you having problems with? Have you started to write the code yet?
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Sorry..actually i didn't have any code as my refrences in doing my project (still searching in internet).I dont know how to start coz this is my first time with VB.
Do you have any samples of program or source code that related with my project for my references???
I need ur help,plzz!!
Thanks
|
|
|
|