Visual Basic Discussion Boards

Dave Kreskowiak26-Sep-05 1:26

26-Sep-05 1:26

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

AutoNumber Field of Access Database

shoaibnawaz24-Sep-05 2:44

shoaibnawaz

24-Sep-05 2:44

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

Re: AutoNumber Field of Access Database

Dave Kreskowiak24-Sep-05 3:18

Dave Kreskowiak

24-Sep-05 3:18

Because once a autonumber field uses a number, it's never used again.

RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

Re: AutoNumber Field of Access Database

Alsvha24-Sep-05 8:54

Alsvha

24-Sep-05 8:54

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

Re: AutoNumber Field of Access Database

Dave Kreskowiak24-Sep-05 15:54

Dave Kreskowiak

24-Sep-05 15:54

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

Re: AutoNumber Field of Access Database

Alsvha24-Sep-05 19:11

Alsvha

24-Sep-05 19:11

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

Re: AutoNumber Field of Access Database

Dave Kreskowiak25-Sep-05 1:41

Dave Kreskowiak

25-Sep-05 1:41

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

trap mouse events

Member 229518124-Sep-05 2:43

Member 2295181

24-Sep-05 2:43

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!

Re: trap mouse events

Dave Kreskowiak24-Sep-05 3:16

Dave Kreskowiak

24-Sep-05 3:16

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

Re: trap mouse events

Daniel Grunwald24-Sep-05 10:23

Daniel Grunwald

24-Sep-05 10:23

image.SetPixel Smile | :)

Re: trap mouse events

Dave Kreskowiak24-Sep-05 15:53

Dave Kreskowiak

24-Sep-05 15:53

Paper and crayon would be quicker! Big Grin | :-D

RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

Tab function

Zealot34524-Sep-05 2:19

Zealot345

24-Sep-05 2:19

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 =)

Re: Tab function

Asim N.26-Sep-05 19:13

Asim N.

26-Sep-05 19:13

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

auto updater

ecentinela23-Sep-05 23:30

ecentinela

23-Sep-05 23:30

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.

Re: auto updater

Colin Angus Mackay24-Sep-05 2:25

Colin Angus Mackay

24-Sep-05 2:25

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

data conversion type thing

l a u r e n23-Sep-05 16:17

l a u r e n

23-Sep-05 16:17

ok so this might get a bit long but i hope someone can read thru and tell me where im being an idiot Smile | :)

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
Smile | :)

"there is no spoon"
biz stuff about me

form.hide

militiaware23-Sep-05 13:53

militiaware

23-Sep-05 13:53

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

Combo Box Improvement

Asim N.23-Sep-05 9:32

Asim N.

23-Sep-05 9:32

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

Re: Combo Box Improvement

shoaibnawaz24-Sep-05 10:29

shoaibnawaz

24-Sep-05 10:29

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

Re: Combo Box Improvement

Asim N.26-Sep-05 19:09

Asim N.

26-Sep-05 19:09

Thank you Shoaib.
THis helped me a lot in resolving the problem.

Regards,
Asim

VB.net and barcode

Member 219430723-Sep-05 8:53

Member 2194307

23-Sep-05 8:53

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

Re: VB.net and barcode

Dave Kreskowiak23-Sep-05 9:21

Dave Kreskowiak

23-Sep-05 9:21

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

search files or folders between 2 computers in network

misz_723-Sep-05 8:47

misz_7

23-Sep-05 8:47

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

Re: search files or folders between 2 computers in network

Dave Kreskowiak23-Sep-05 9:19

Dave Kreskowiak

23-Sep-05 9:19

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

Re: search files or folders between 2 computers in network

misz_724-Sep-05 10:18

misz_7

24-Sep-05 10:18

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

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.