Search results

Can anybody help with this? I've got until tomorrow to sort it out! Help!

Hi, My database has a seperate table for comments. The Excel s/s I want to import has a single column for comments eg '28/10 Phoned Patient, 29/10 Patient confirmed appointment, 30/10 Saw Patient'. I want to convert this column into my table as seperate records eg PK: 1016 Ref: 11293 Date...

JBB, That works a treat - many thanks. The code I ended up using was Private Sub F194_AfterUpdate() Dim SrchVar As String If IsNull(Me.F194) Then Exit Sub End If SrchVar = Me.AcqStage1 Forms![Fin Finance]!cfoAcqFixedCosts.SetFocus Forms![Fin...

Many thanks JBB, nice Avatar! That works a treat, but problem is it updates the wrong record in the subform. It defaults to the first record. I have three amounts on my main form, each of them relating to a corresponding record on my subform eg. Submit Planning Amount relates to a record...

Hi All, I have a form with a value field on it. I also have a subform on the main sheet. When I update the field on the main form, I want a field on the subform to equal 50% of the value. I'm sure this is simple, but I've tried everything and can't for the life of me get this to work. Can...

You never know Bob. The Grand National comes up every year, and we have the closest house to the course. Seriously, many thanks. Can we talk offline, as there are many other issues we have which need resolving. A lot of them I can sort myself, but we need some advice, and don't expect it for...

Bob, Tried and tested. You're a gentleman Sir. Many thanks for your help. Don't know where you are, but if you're ever in town, it's on me (town top right). Know anywhere I can get some hair grow cream?

Hi Bob, Here's the db with the offending table / field. Please let me know if you can't access anything, as it's been chopped to death.

Thanks Bob, Will take a little while to strip it out, but will have it over to you asap.

Another thought is could I use columns for this?

Hi Guys, Can I post a cut down version of the database, it must be difficult trying to visualise this.

This is in the Control Source in the Properties. I have seen a number of examples of this on various sites, and couldn't understand why the square brackets were put in even though the field name had no spaces in the name.

Number of hairs on head left = 35.

Wow, When I put the Me. in without the square brackets, the field goes crazy, like it is refreshing itself over and over. When I include the square brackets, it returns #Error

Hi Access9001, this makes the field go blank.

Hi Bob, I've tried this with spaces and without, and it gives the following message: - The expression you entered has an invaild string A string can be up to 2048 characters long, including opening and closing quotation marks. Apologies if I'm being thick here.

Thanks Bob, AgreedCostType is text and set as text in the table. AcqCosts is a Currency.

Hang on a minute, I've just noticed a space in AgreedCost Type, which doesn't show when I paste this into the Control Source!! Weird - is this a bug?

Hi All, I'm new here, and found the site when looking for some help on a DLookup problem. I'm just about to pull the rest of my hair out. I've tried just about everything - even copying and pasting the code directly from the Microsoft site. My form has a Combo box, which links to a table...