Search results

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...

so you mean i should create a table with just 1 record? So if i create something globally, for example Public varname As String, could i set the string on an onOpen or OnLoad event of a form to set it to my path? TU

Hello and thank you for your reply. My plan of this string of text is to be a path, reason being that when i run database on other pc, i would only have to change a certain path once, and not everywhere i used it. TU

I have a string of text which i shall use often in my code in different places. What is the best solution to adopt to set this text in one place and then reference to it, so that if i need to change it, i would only have to change it once? TU

Hello Thank you for replying. I agree with what you said, but in my circumstance i don't want to put all the range of years which i may use, as i wish to only use the years that i have records for and then populate other years if any new records would require them. For example if i don't have...

Hello I have a combobox on a form where you can select a year. In this circumstance is it overdone to have a lookup table (YearID and YearofIssue) for this field rather than simply have a combobox with a value list? Thanks