Search results

Re: =DLookUp("[Colour]","Colours","[Colour_ID] = " & [Colour_ID]) Thanks for your quick response. Yes, by 'not assigned' I meant that a Null value is returned which results in the error. I created a dummy text box called 'TB1' to try out your code. In the 'on current' property of the form, I...

=DLookUp("[Colour]","Colours","[Colour_ID] = " & [Colour_ID]) =DLookUp("[Colour]","Colours","[Colour_ID] = " & [Colour_ID]) This statement controls a textbox on a form. It looks up a colour ID number on the colours tale, and presents the name of that colour on the form. In many cases a colour...

I have now found out that if the records already exist in tbl2, then the form button will direct me to the correct record, by matching the ID fields in the two tables. Might the solution be to populate the tbl2 ID field with the exact same data in the tbl1 ID field (i.e. 1-600)? If so, how...

Its an embedded macro the criteria of which is: ="[ID]=" & [ID] Would I be right in thinking the point here is that it cannot match the ID number of tbl1 to the ID number of tbl2 simply because tbl2 has no records and therefore no ID numbers to match? If this is the case, I need to find a way...

Oh, and if I create a new form based on the same table, this problem does not occur - I can scroll through all of the records, if that provides any clues...

The records which are viewable in my form seem to end at record 655, after which any new entry is recorded in the underlying table but not appearing in the form, which is very odd. There are no filters in place that I know of. Any ideas of how I can get to the bottom of this? Thanks, Mark

Hello all, So I have two tables each with a respective form. tbl1 frm1 tbl2 frm2 tbl1 stores the bulk of the information, and occasionally further information will be stored about a particular record in tbl2. Tbl2 does not list all records, but only those that have additional information...

I have a table with the following headings Date | Day | Weight | Start Weight| When I enter the first date, I would like subsequent dates to enter themselves below for 32 days in this Date column. Similarly in the second column 'Day' I would like it to autofill the Day from 0 - 32 (zero being...

Thank you sir!

Hello all. Can somebody please tell me the correct way of entering the above statment in the afterupdate coding of combobox35 Many thanks

Adi, that sounds like a much better approach. Many thanks for your help.

tough crowd... For those trying to do this - You can use something called mail merge wizard, in which the word 'recipients' can be assumed to mean rows. However this brings up an SQL warning every time you want to open up the word document from Access, which is a little annoying. I used a...

by that I mean Microsoft Word Document. Any suggestions?

I have various text boxes in a Microsoft Word database, which I would like to be linked to different fields in an Access database. Ultimately, I would like a situation in which clicking on a button in my Access form, brings up this Word document with the details for that specific Access...

I have an options group for colour with options: White, Black, Grey, Brown, Other. They are recorded as numbers 1-5 and on the underlying table. How does one go about recalling this information. Do I need to create a seperate table with two field such as 'number code' and 'colour' and then...

Great tips, worked perfectly. Datasheet view was the key. Many thanks!

Forget Access - now you guys are talking my language! It is indeed, after 5 days or so you can normally see some development/movement (or lack of) in the egg by holding a candle behind it. Nowadays we use modified lamps. Thanks for your suggestions Linq, I am going to have a play around and get...

I am recording weight change in eggs over time during the incubation period. Each egg has a unique Egg_ID, and are listed in an underlying table, with details such as parent IDs, date laid, etc. I would like to incorporate a weight change chart within a form. It would show how the weight has...

Solution found. For those wondering have a look at this: http://www.databasedev.co.uk/common_dialog.html

Rather than write out each pathway for each image for each record, is there any way one can click a button, which opens up a browser so that you can locate the image on your hard drive, and then the pathway to this file is stored in your underlying table so that the newly found image is...