Recent content by Qamar

thank you very much both for your replies, it is making more sense now.

I have a small database with three tables as follows: tblPerson PersonID LastName FirstName tblOffence OffenceID Offence tblPersonsOffences PersonsOffencesID PersonID Offence DateofOffence ReportedBy Remarks Now in the form frmPersonsOffences, I have created two unbound textboxes, so that...

Does anyone knows what these two mean exactly please? No data manipulation language Loss of information content Thank you

thank you for your feedback. actually i have been doing some research on the net and the most common disadvantages that i found are: Limited constraint representation Limited relationship representation No data manipulation language Loss of information content However, from the above points...

while there are several advantages of using an ERD, can someone tell me if there are any disadvantages apart from the diagram being cluttered if a complex database is required ? Thank you

thank you i understand it now.

khawar, many thanks for your sample ... it does exactly what i was looking for, but please could you tell me how the continent and rate changes automatically as soon as the country is changed, because i noticed that you did not use any events?

thanks for the answer. Yes the country field is a combo box. The others i haven't created the control yet on this form, but i am assuming that they should be two unbound textboxes. My main concern is how can i populate these controls based on the value from country combo box? TU

I have the following setup tblContinents, with ContinentID, Continent Fields tblCountries with CountryID, Country, Continent, PostageRate tblCustomer with CustomerID, Country, AddFields Now on my main form where i enter the customers details i would like that as soon as i would enter the...

Hello, I have a form which i use mainly for adding new records to a table (although form is based on a query and not directly based on the query). Now as i am inputting records i have already about 8000 records on this form. So my question is, since i basically use this form (almost only) to...

thx for your reply, i will give that a try.

Hello, I have often read on these forums that the code which normally creates command button wizards are often obsolete and rather than using the domenuitem, it is recommended to use the docmd.runcommand alternative. Now i am about to create a button which duplicates a records, and the code...

Thank you very much for all your posts, you certainly set me on the right track :)

Hi, Thanks for your reply. I think the best solution would be your suggestion of using a 1 record table. My very final last question because i think i really made you bored. for example if i have something like: Me.ControlName.Picture = "C:\Documents And Settings\User1\My...

If i put something on the OnOpen event such as VarName = "path", what do you mean exactly by having to populate each time, as i thought that i would only have to do it once. Moreover, if you think that your other suggestion is more efficient you mean i can create something as follows in a...