Search results

I'm using access 2003 - I'll be looking for some ideas for being able to save file attachments like word documents within access form - each page should show any files currently attached, different links for each form. Links can then be clicked on and open ups the file via hyper-link to the...

Ha! I have to laugh :) Never realised access had conditional formating. Its all working fine - Thanks for the feedback - Its just about knowing where to look. Nice website you have BTW - Hope you don't mind but I've saved your link as a favorite. Some nice top tips and templates. You don't...

Hi - Need some help - I have a subform called [Attendees Subform] which loads in a main form called [Attendees] When the subform loads I have it set with a default view datasheet. One of the fields within the subform is called [Indate] and would either contain the words "Live" or "Expired"...

HHmmm.... Its a good point - The dates I'm looking at never expire I've now changed the form for two unbound / un-Raw sourced text'd boxes - user now needs to enter two dates and it works great - even the exired works too and to be honest, probably works best this way - most of the time we'll...

Thanks vbaInet Remember to remove what is in the FILTER property of the report. Not sure how to turn off the filter in the report - This get assigned from the [frmPrintOptions]somewhere or somehow? Each time I delete the line it come back on the next time the report opens? Just noticed...

VBAInet - Please take a look and see where its all going wrong. Database attached - Once opened top right "Print options" - this is where the problem lies... Think you know what I'm trying to do :-) Again Thanks Mike

Still not working - I need to re-think this one. I'm not sure I'm looking in the right places for the data??? I have what I'd called a master query that stores all the data for the report data when asked for "qryReportData". inside this query I have a field called [Indate] which depending on...

Thanks for your help Did as you said - Now get this error say MS can't find the field but I don't know which field it means? This is the full line of code i have to run the report - Can you see where its falling over? The line in bold is your bit added. DoCmd.OpenReport "rptOrders"...

Hi - I'm stuck again!! I'm trying to setup a print preview option for a report based on two dates. User is asked to select a Date from: and Date to: from two combo boxes. This bit works fine and gives a report based on the two dates. In addition to this - I'd like to also be able to select...

Hey guys! Its working...and it flippin looks great! Have a top New Year and thanks for you help regards Mike

WOW! OK Sorry didn't quite understand first time. Now I see it working although I don't quite understand my mistake and how it works off the RegistrationDate - can you explain how it works? Looks pretty neat though! Thanks...full day on this and I knew it would be simple once we knew how Mike

OK see attached. Please note the problem lies within the Attendees Subform. Its all left abit messy at the minute but I know you get the gist.. Thanks Mike

RuralGuy - I did as you suggest and still it doesn't work. Infact, this way changes all the fields to expired. Its been a full day stuck on this problem - Do you think I should look at doing away with this idea? Mike

RuralGuy - Thanks for your comment. However, still gives me the same problem. I've attached a small .jpeg for you to look at. I've now moved the calcs into the form recordsource query. Although looks a lot neater it still gives incorrect results. Do you think it sees the whole data as being...

Hi - I have a subform which stores 2 bound fields and 2 that are populated via an iif statement based on the 2 results from the bound fields. What I'm trying to do logically sound quite easy - Getting access to do it is another thing. Bound field 1 = [date1] Bound field 2 = [course length]...