count, vbLf, string

Hello Experts,
I have to count the number of occurrences of Line feed (vbLf) in a long string.
The code I am using is:

Code:

---





       

Code:


       

---

MAX = TLine.Split(vbLf).Length - 1

---

---

It does not work. Help please.

count, vbLf, string

running a query based upon a listbox selection

this is likely very easy but being somewhat new to access listboxes I am having trouble. I have a list box that is correctly listing resources from a table (tblResource). I would like to select one of the list box entry and run a query against the tblResource to show the information for that resource in a form. I have tried to use the lstindex with the control (lstResource) in the where clause of a query to accomplish this with no success. Any ideas for me?

running a query based upon a listbox selection

Delete records from a table

good day !

need assistance on below.

have two tables as follows;

Master file:Vessel_master
Vessel_code
Vessel_name

main data table:Main
Vessel_code
container_no
size
Voyage
weight

by using above two table have made a query as follows;
Vessel_name:Vessel_master
Vessel_code:Main
container_no:Main
size:Main
Voyage:Main
weight:Main

Have joined "vessel_code" fields of the both tables by join type 2.

by using the query as data source made a form to edit/update/delete data. the problem is, when delete a record by using the form, it will delete the related data in the master file as well, which i do not want.

Appreciate any expert's advise.

brgds
Htadis

Delete records from a table

Hunting

Saw a article in the news about Ricky Gervais publicly humiliating a hunter. (For sport and pleasure, not for eating.)

Just would like to know where you guys stand on hunting?

I would very much like to hear from the guys over on the Gun control thread.

My Opinion on Hunting (For Sport):

An Absolutely disgusting thing to do. I mean why on earth would you set out to kill a giraffe or a wildebeest for sport? Just why? I would understand tribes killing animals and hunting for food and nutritional needs. But killing for sport just isn't right in my books.

I cannot bear to imagine how many animals have become seriously endangered due to hunters. There is (apparently) only 1 male white rhino left in the world. I would put this down to hunters.

I would really like to hear a hunter justify why hunting for sport is OK?

And I hope all you hunters run into this woman out there!

http://ift.tt/1c2fjTw

Hunting

Show last page

I have a form with records in chronological order, as this has hundreds of records I would like to open the form and go to the bottom of the form to display the most recent records by date in the window, I know I could invert the order of the records displayed but I rather have them sorted by chronological order 1->999
Any help?

Show last page

Exporting Currency Field Without Decimal Place

Hi All,

I need to export a currency field to include the pence but without the decimal place, is this possible?

It also needs to be 11 characters wide.

I have tried a number of formats and can get the decimal point removed but I am not getting the pence displayed. :banghead:

Thanks in advance.

Exporting Currency Field Without Decimal Place

Question about database normalization

Howdy.

I have an IT class in which we're studying SQL.

We have a midterm coming up and we've been given a sample exam for studying. I've got everything locked down, just one thing left - Database normalization.

The question is:

1. When is the process of normalization used?

2. Describe BCNF

3. For the given relation, find all functional dependencies and possible anomalies implied from the functional dependencies. Put the relation into the appropriate BCNF.

EmployeeID | Name | Dept. | Title

100 Jones HR Executive director

200 Chau HR PR

205 Parker Marketing Clerk

300 Garret Accounting Accountant

400 Miller Marketing Clerk

I've been googling and reading for a while and still can't seem to really understand BCNF and normalization with all that XY dependency stuff. Can someone perheps help me with this question from the exam? I'm sure an actual answer for an example would explain it much better than any theoretical one would.

Thanks!

Question about database normalization