Search results

Many thanks to all 3 of you and apologies for not getting back sooner - work is taking over my life. Have yet to sort queries but it's a lot clearer now that the foundations are in place. I tend to rely too much on VBA to mask any deficiencies in my database designs but this has made the...

Thanks for both your responses. I had already set up the attached tables /relationships (should have posted originally) and I think that it captures what you guys have advocated. I had also set up the autolookup query (my initial post) so that if a course detail changed , it would be easy to...

I’m attempting to set up a database to record employee training. I’ve set up the autolookup query (pic attached) to help form a set of default training courses/procedures that are mandatory for each department – if Department A requires eg CPR, Fire Safety and Working at Height training, the...

Probably too late for you now - I use some freeware called FreeByte as an alternative to Windows Scheduler. May be permissible by your network administrators (ours frowned upon Win Sched but accepted this alternative??) and is much more reliable/user friendly than Windows Scheduler. Some...

Are you familair with VBA - you could use on your command button to check that all controls are completed and call following function: Private Function CheckForCompletion() As Boolean 'will check only controls with 'CheckPage1' in Tag property (Form Properties under 'Other' tab) 'IMPORTANT for...

Cheers, got confused with all the quotation mark business so decided to simply reference a query that filtered out the information instead.

When I attempt to include following 'Where' clause, results in syntax error 3075: Set rst = dbc.OpenRecordset("select * from TBL_SurveyDetail where (((TBL_SurveyDetail.txtimagename)<>"")) ORDER BY TBL_SurveyDetail.SurveyDetailMainFormLinkNumber, TBL_SurveyDetail.DistanceM...

Hi Attempting to adapt some VBA in order to sequentially number a field (named Code) based upon whether another field (txtimagename) is either blank or Is Null. Code I have to date for a button on my form: Dim dbc As Database Dim rst As Recordset Dim i As Long i = 1 Set...

Will go down the VBA route instead. Thanks for your help John

Think I've over simplified my initial query in the first post. Due to the user having the ability to input records anywhere within a subform and in any order, I'm unable to sort on the autonumber (RecordID) or any other field for that matter in order for the likes of your domain function or...

Thanks John. In the event that a record doesn't contain an image, the ranking result gives a 1. If there are no images, I'd like this value to be blank and for the next record with an image to obtain the next sequential number. Is there any way of adjusting the function to accommodate this...

Hi Is it possible to include a Dcount function in a query (qrySurveyDetail) to sequentially number records where a text field (ImageName) is not null? RecordID 67 68 57 71 ImageName Image Image No Image Image Dcount Number 1 2 Blank 3 The RecordID for each record, although...

Solved it by basing my subreport on a query that showed records where the text field containing the location of the image was not equal to null.

Apologies for delay in responding. On a form, I've used an image frame linked to a text field containing the location of the image (.bmp) on my PC. I set the text field using VBA behind button on the form. I'm using Access 2010. The images are not stored within the database to help avoid...

Thought I had everything sussed and now I've realised that the page break business may be causing havoc with my page numbers (eg Page 11 of 9). Only established this by searching this forum and concidentally you (vbaInet) had responded to a similar post previously. Any idea if this issue can...

Thanks for taking time to get back to me - have opted to populate the main (parent) report fields using the form values. This means that the images can remain linked to what was SubReport1 (effectively now the parent report) and a page break can now be used to put the images/image locations...

Attempted to look at the DIR() function as a way to overcome issue but couldn't fathom out how this can put the images on a separate page straight after a sub section of a subreport. I can get the information to act as it should on Subreport 1 but when the Main Report is opened, it will...

Hi, I've been working on a report for several weeks and have yet to come up with a solution for the following setup. On the main (parent) report I have Contact Name and address fields with a subform (SubReport1) which have been successfully linked. SubReport1 has a child subreport...

Looks like I'll have to accept defeat on both this one and the football..... Thanks Michael

Apologies Pat - little engrossed in the Ireland v Italy soccer match and didn't see your response. It is the user that is changing the record not code. However as they can click on the subform, this will trigger the main form afterupdate event at some stage even if I disabled the subform up...