All categories - 17 November 2006

I am using a user-defined data type to define a record (e.g. Customer name, Customer ID). When I put both fields of the record as strings I get no problem writing the record to a direct access file. But when I put the ID as an integer, the file becomes unreadable and data can't be retrieved again.

e.g.

Private Type CustomerType
CustomerID As Integer
CustomerName As String * 10
End Type

Dim Customer As CustomerType

Open App.Path & "\Customers.dat" for Random As #1 Len = Len(Customer)
NumberOfRecords = LOF(1) / Len(Customer)
Put #1, NumberOfRecords + 1, Customer
Close #1


I was advised to convert the text box that contained the customer ID to an integer before assigning a variable to it.....

Customer.CustomerID = CInt(txtCustomerID.Text)

but it didn't help. MsgBox (VarType(Customer.CustomerID)) showed 2, which is an integer. So what is the problem? Why does it write the ID to my direct access file as a square block instead of a visible number?

2006-11-17 21:14:15 · 3 answers · asked by Older&Wiser 5 in Programming & Design

I am trying to delete myself.

2006-11-17 21:14:03 · 15 answers · asked by no one 6 in Polls & Surveys

if you we're in charge......and a group of radical's slammed a plane full of jp8 into a tower what would you have done?.....and then, a hurricane devistate's louisiana....what would you do????given the power by a house of 50 people....what could you do? just curious.....and you blame who? think before you vote

2006-11-17 21:14:01 · 10 answers · asked by oifgijane 3 in Government

In society nwho has more understanding capacity and more tlerable limit in male or female?percentage wise.

2006-11-17 21:14:00 · 18 answers · asked by Anonymous in Other - Society & Culture

I was chosen as the school's representative to the Rotary Club of Borongan's Extemporaneous Speaking Contest on Nov. 24 at our Provincial Captiol's lobby. How can I maximize the 5 min. time limit? The said contest will base the questions on each of the following topics: Environment, Peace and Order, Employment, Migration, Education, Economy, Health and Government and Governance. Please help me with the topics especially on environment, health, migration and peace and order. Please give tips to help me give a big impact on the contest, Thank you very much and good day!

2006-11-17 21:13:58 · 4 answers · asked by deutsch_rj 2 in Other - Education

2006-11-17 21:13:55 · 4 answers · asked by ÐÅÔÑÏÓ Â 1 in Netherlands

I clear up my dog's mess - its the law. Should the same law apply to horse owners?

2006-11-17 21:13:44 · 26 answers · asked by G 3 in Etiquette

2006-11-17 21:13:39 · 4 answers · asked by Anonymous in Fashion & Accessories

I am an average 17 year old guy. for a little over a year now I have been talking with a very attractive girl. I love her so much that it hurts sometimes when I realize that she doesnt care about me in the same way. what should I do?

2006-11-17 21:13:38 · 9 answers · asked by mrfusion_89 1 in Singles & Dating

2006-11-17 21:13:37 · 7 answers · asked by Cara T 1 in Decorating & Remodeling

Can anyone give me advice on what I should do now?

2006-11-17 21:13:07 · 11 answers · asked by geno g 1 in Mental Health

2006-11-17 21:13:03 · 2 answers · asked by persianooo 1 in Singles & Dating

2006-11-17 21:12:56 · 11 answers · asked by stickyricky 3 in Engineering

I need a book in which I can get information of current designing in advertising media, like: creepers and photoshop fx.

2006-11-17 21:12:56 · 4 answers · asked by abhishek t 1 in Drawing & Illustration

Does anyone ever feel that they have a destiny to fulfil in life, a purpose that you were mean to be here for? And if you weren;t here would that purpose be changed due to you not being here? Or a destiny that you have to fulfil before you die?

2006-11-17 21:12:54 · 10 answers · asked by Michael M 2 in Philosophy

2006-11-17 21:12:30 · 11 answers · asked by Anonymous in Other - Family & Relationships

Well i think so,because mind travels faster than light.And through dreams it foresee the future which most of all becomes a true.

2006-11-17 21:12:12 · 12 answers · asked by rayden 2 in Astronomy & Space

2006-11-17 21:12:00 · 3 answers · asked by ronil 1 in Mathematics

ok . well my boyfriend who i live with has been asked to go out for his friends birthday on a night out in a different city and stay over. my problem is i dont really want him to go. His 2 friedns who he goes out with her both single and iam scared what he will get up to - his 2 friends are always really nice to me but really are a pair of dogs and i just dont no what there like when i am not around - am i being really stupid - its starting to play on my mind thinking things and i dont want to tellmy boyfriend this coz he will just say i am being stupid.....any advice

2006-11-17 21:11:43 · 21 answers · asked by Pebbles 2 in Singles & Dating

2006-11-17 21:11:36 · 10 answers · asked by Vijay B 1 in Biology

If you say 11 you're wrong.

2006-11-17 21:11:31 · 4 answers · asked by 5150 4 in Mathematics

the advert is for chicken stir fry.someone thought it was called chain reaction but it is the wrong song.does anyone else know what it is called

2006-11-17 21:11:16 · 3 answers · asked by ssnhrwd 1 in Music

JUST KIDDING i am totally taking the piss here....goood grief..lighten up...it's a bad move in tastebud judgement though.....

2006-11-17 21:11:11 · 4 answers · asked by Anonymous in Polls & Surveys

i'm 15yrs. i'm so slim . all asks me why i'm so thin. i feel so guilty.but my mother says that slim body is much better than fat body.she says this to me in order to make me happy. but i know that i'm so thin . all calls me as stick covered with some clothes. what should i do to become fat?

2006-11-17 21:10:57 · 13 answers · asked by laveena 1 in Diet & Fitness

my best friend happends to be an ex bf, but i seriously think he might be gay. he is very feminine, my bfs boyfriends friend is gay and he said he think he is (can gay guys tell if another is gay? )....it really isnt a big deal but i thought id ask, what are some sure signs that someone is gay?

2006-11-17 21:10:31 · 18 answers · asked by Anonymous in Friends

Things are looking better by the day for england. They can't and won't lose to a team full of over the hill players. Doesn't even matter if the aussies have home advantage

2006-11-17 21:10:11 · 11 answers · asked by dennis 2 in Cricket

i am having the degree of masters in art with english literature.i am a trained teacher.

2006-11-17 21:09:45 · 4 answers · asked by vishal p 1 in Primary & Secondary Education

2006-11-17 21:09:43 · 16 answers · asked by aruna 1 in Other - Sports

2006-11-17 21:09:06 · 27 answers · asked by mared 5 in Religion & Spirituality

I have an english translation of the holy Quran that translates this verse like this:
ARABIC: Wa eza aradna an nohlika kariatan amarna motrifiha fafasako feha fahaqa Alliah alkowl fadamarnaha (Surat Al-Isra 17:16)
ENGLISH TRANSLATION:And when We desire to destroy a city, WE COMMAND its men who live at ease, AND THEY COMMIT UNGODLINESS therein, then the Word is realized against it, and We destroy it utterly. S. 17:16

i dont know arabic and relay on the english translation. according to the above verse ALLAH comands people to do evil.please read the arabic text and tell me if that is the case.

2006-11-17 21:09:05 · 9 answers · asked by Omar 1 in Religion & Spirituality