Search results

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

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

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

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

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

Hi, I have a key in my registry for a particular application where the data entered is a long number, certainly not the data which i entered through the application. Is there a way to convert this piece of data to see the actual data which it contains, maybe via some kind of utility? Thanks

I have a field which I enter a short time such as 3:13, 5:45, etc Now i am creating a report which at the end of the report I would like to include an unbound text box, which displays the total amount of time for that field (pls note that the total will never exceeds 24 hours) What is the best...

Is it possible to download the MSDN Library from the Net from offline viewing ? Cheers,

i have a form, and i would like that on one of the fields, as soon as i type something in it when i leave the field, i want it to automatically convert it to title case. can this be done please? Cheers

when using lookup tables do i have to link the the autonumber or the field. ex. tblCountry CountryID Country tblPerson personID firstname lastname country ... when i select lookup as datatype, and i follow the wizard, and i select tblCountry, then do i have to choose CountryID or Country as...

i've seen several threads in this forum, advising to use querydef. Does anyone please have any links to resources which describe exactly what they are and how to use them pls? i have tried searching on google for them but i think i did not place the right keywords. thank you in advance for any...