Search results

Firstly, why not do the calculation in the Form? The ControlSource would be something like you have already: =IIf([company]=-1,"50") If you don't want the text box to show anything just set the FalsePart to a space or something: =IIf([company]=-1,"50", " ") Bobadopolis

Cascade updating/deleting is part of JETs Referential Integrity (RI). Cascade delete will delete all child records of any parent you delete. You can turn it on in 'Relationships' view. However, I'm not sure that this will be much use to you in this case... I could be wrong(?). Plus, before...

You shoudn't need to store todays date! You shoud delete that column/field. Place your criteria in the END_DATE field: e.g. <Date() Will return dates before today's date. Or you could perform a calculation on that date e.g. >DateAdd('m', -6, Date()) Will return records from within the last 6...

Anyone? Any ideas?

Try just changing the fields selected to an asterix something like: DELETE Playlists_OnAir.*, blah blah FROM Playlists_OnAir blah blah This selects ALL the fields. You could try changing DELETE to SELECT to see what records the query is returning...

I believe DELETE queries are for deleting entire records from a table. Use another query (append or update) to do what you want to do or else change your approach, for example I just created this DELETE query: DELETE tblResults.* FROM tblResults WHERE...

Hi KeithG, I don't mean to be argumentative at all (I appreciate your help!) but tblListeners is definitely on the Left (see attached)! The main trouble with this is that I want to show data that 'isn't there' for two possibilities in tblReference. A listener can either do a 'Type A' or 'Type...

Any thoughts, anyone?

I am doing something similar at the moment - although it's still work-in-progress. Could you not Right Join 'memberdata' and 'bankdata', or in design view > join properties choose option 3: "Include ALL records from 'bankdata' and only those records form 'memberdata' where the joined fields...

Hi, Thanks for the reply. Yes that is what I want but I thought the Left Join already achieved that - it says in the query design view "Include ALL records from 'tblListeners' and only those records form 'tblReference' where the joined fields are equal". What about the grouping though - any...

Hi, I have two tables: tblListeners ----------- ID (PK) FirstName LastName etc tblReference ------------ ID (PK) ListenerID ReferenceTypeID (FK) ReferenceDate etc (Btw I am aware of the unconventional naming of the PKs but I'm running the B/E on SharePoint so I have no choice!) So listeners...

Got it! Firstly, the Access Chart Wizard is rubbish!! My mistake was that I was using a line chart instead of an XY scatter. For some reason though instead of changing the chart from line to XY scatter I tried to insert a new one! The wizard was completely rubbish for this until someone...

Hi, I have a series of bound charts in a report. My X-Axis data is numeric and sometimes different for each record but always falling in a specific range. Is there a way to make the X-Axis numeric (not categorical) so that when I plot the data the values fall in appropriate places? A...

Hello! It appears you cannot surpress the subject error, I've tried extensively with no success! Bit of a pain! :mad: Well, users will just have to deal with it i guess! Unless I find a way around it... Many thanks for you help with this llkhoutx :) Regards, Bobadopolis

1 table i think. I expect someone to shout at me now about normalization but... So long as you make none of the fields in the table "required" (and give them some appropriate defaults) then you could have 7 forms all feeding off of the same table but in each case showing different fields from...

Well I didn't know that!! Worked like a charm, though I think the functionality I described would be my preferred choice so I'll stew on that a little longer. In the meantime this will be great! One more thing... is there a way to trap the error that causes Access to bring up the msgbox...

Put the code in the OnFormat Event of the Detail section... Bobadopolis

Yes it will - tried and tested! It has to be an IIf though - regular Ifs do not work(!?) You can abbreviate this even further: Me.MyTextBox.Visible = Not (MyTextBox = "0" Or IsNull(MyTextBox)) Bobadopolis

Me.MyTextBox.Visible = IIf(Me.MyTextBox = "0", False, True) Bobadopolis

But there will be duplicates in the table as a whole as the recodsource is in a table on the many side of a relationship. I don't want duplicates in this field for a particualr foreign key. This may be satisfactory but I'd rather remove the option to duplicate altogether if possible. Not...