Search results

When the wizard ask you for these links, there is two options, «Choose from the list below» or «Create them yourself» (Translated from French; may be different in your version). By choosing «Create them yourself» you can link many fields manualy.

Not sure, but if you used two queries instead of one, the first grouping by «codename» and «part number» without duplicate, and the second using the first one to do the counts...

Use this query: UPDATE tblYourTable SET tblYourTable.YourField = UCase([YourField]);

As you may know, I've been building databases for Hydro-Quebec for years. There I met a guy who's job was to do that. He showed me pictures of it and I was petrified. It was weird to see him up there. I just couldn't believe it.

If you have DeleteOnCascade on, just deleting the record from the main form will delete the records from the subforms. As for the Add button, adding a record in the main form will automaticaly enable you to add a new record in the subform.

I don't have Access with me so, I cannot take a look at your database. But, if your subform is linked to your form with DateWorked(LinkChildFields & LinkMasterFields), it would then filled the Date field with the default date and it can be changed without a problem. If you don't want the user to...

I don't know if that would fix your problem since I didn't understand it, but I noticed that you give the alias «Build» to «Codename» but you grouped by «Codename» instead of «Build».

A squirrel once jumped at my back and made long scars... Well that's what I told my wife when she asked me where they came from. :D

I am not sure if that has an impact on it, but I don't understand the use of the column «:» in your fields.

stLinkCriteria = "[ISIN]=" & "'" & Me![ISIN:] & "' and [ISIN2]=" & "'" & Me![ISIN2:] & "' and [ISIN3]=" & "'" & Me![ISIN3:] & "'...

I am no expert, but wouldn't it be easier to use a link to a doc or txt file instead?

Use two subreports, each with it's own query.

You can do it the other way around. In the critera row of your field in the query, add something like this: [forms]![frmMyForm]![lstMyList]

You could play with the the "Top" property of the visible fields. In your code, every time that a field is true, add 1 to "x". Then, do something like... Top = 1 inch + x times half an inch.

It sounds like there is a problem with these modules of yours. It is normal that it grows a little when playing with the datas, but it is not normal that modules make it top at 1.6Gb. What are those modules doing exactly? Can you send us these modules? If you don't know which modules does make...

MIT researchers demonstrate 'WiTricity' (Wireless electricity) iTWire Wow!!! Imagine the future...

If you got the money (up to 1000$) you can look for a place where they sell chairs made exactly for you. They take your measures and your weight and ask if you have any knees, back or neck problems and they offer you the chair that fits you perfectly. When I have enough money, that's what I'll do.

Rich does not! He does not have photos of himself at all.:D

Many forums have users who will tell you that your question is stupid. These forums tend to be for database administrators only. This forum understand that some people have no Access knowledge. We are glad to answer any question as long as you show that you tried somthing and that you are...

Welcome to both of you. Dave --> You will learn a lot here. At least I did. I suggest this part of the forum for a good start... http://www.access-programmers.co.uk/forums/forumdisplay.php?f=26 And suggest you take a look at these threads if you are new with databases...