Search results

see if this post helps. If not, search for 'Twain' in this forum as there are plenty of posts on this topic

Hi folks. I'm a bit rusty with not using Access for a bit so I need your guidance. A friend of mine has caught wind that 'I've done a bit' and asked me to produce a Db to simplify his sales and manufacturing part of the business. Unfortunately, working in the NHS leaves me with no experience in...

You Did! You Did! Now a rare sightings in yhese parts (unfortunately) :mad:

The default value will need to be a little more longwinded ie =Forms!nameofForm!initialreviewDate that should work

In the subform, create a control in the form footer and set the controlsource to =Sum(FieldToSum)

Hmmm, good point! Nae Bother BW.

Rather than setting the control source of the form control to reference another control, set the control source to the field you want to save the data in and set the default value to the other form control.

What for, a packet of crisps and a 20p mix-up?

Hey Blackwidow, we all started in the same boat, some (such as Mile-O the genius) learned a little quicker than the rest of us (and he still types quicker than me - younger fingers, more time!) No offence meant about the structure - just had a feeling that is all.

Mile-O, you are supposed to answer the question, not ask more tsk:rolleyes: What are you trying to do with the combobox text? - if you are trying to add it to another table, make sure that the length of that field is set to accept the text. However, you should not need to duplicate this...

You are looking at a Running Sum with the last field. This is easy to do in a report as there is an option to make a control a running sum but it takes a bit of code trickery to do it in a query. See here http://support.microsoft.com/?kbid=205183 Personally, I would use the report to present...

Use the DateAdd function within the criteria of the query Eg Field: DrivingDate (Do not use 'Date' as a field name) Total: Where (You will need to enable totals by depressing the Sigma button on the toolbar) Criteria: Between DateAdd("d",-7,Date()) And Date() (for last 7 days) hth

You will need 3 queries 1 calc total in last 7 days 2 calc total in last 6 days 3. Create new query from these 2 and perform the calculation you need. any help?

I always thought BukHix was a bloke.:confused:

The screenshot nearly helps. The info that would be most valuable is the bit just behind the error popup, which obscures the Data Source information, hmphh. It is important to ascertain how the client is accessing the mailmerge helper, - is it via code within the Db but I suspect is is via the...

1. is easiest but less flexible. If you ever want to change the name, it means dabbling with the code. 2. A little more tricky but more flexible as changing a field in a table will change the name for you (or even more flash - change the name according to who is logged into the Db) 3. A bit...

Wouldn't pounding salt sting a little? ;) Here are a few ways you could skin this one. 1. Hard code the report name as you already have here stDocName = "2004 Quote Corian" 2. Store a value in a field in a separate table and use a Dlookup to extract that Data 3. Base the name on a field...

Hi arthur, welome to AWF. Can you highlight the process that the user executes to perform the mailmerge and if possible, the code behind the mailmerge function? The screenshot may be helpful so go ahead and post it. Also is the Db split into FE/BE and does the mailmerge use a particular template?

I would split this into a FE / BE regardless of the number of users as this will a) give you a performance boost b) allow you to trap for a broken connection. I have posted somewhere here a check links module. (If I find it before you I'll point you in the right direction) As you seem to...

Have you tried using the followhyperlink method instead?