Search results

This, coupled with a save record command on each of the fields on the second form has proved to be perfect :) Thank you :)

I've just had a further play with it - sometimes it updates the checkboxes on the main form (record is saved by the code for the close command on the second form), whereas other times they do not; I have just had a write conflict message twice (that is a new one, not seen before), so I am now...

I have a form that has an on current event where it checks the value of a few check boxes, and depending on the result it sets a label to visible or not - works just fine. However, I have a second form that opens from this main form and when a user changes anything on this second form, it has a...

I must admit that I never even considered it - I had my mind set that I should be looking at Access Totals from the ribbon. Thank you, it works beautifully. :)

I am having a bit of a memory blank here - I have a report to which I have added a couple of text boxes that show numbers (2 decimal places) for each record. I am wanting to add a couple of textboxes in the report footer that total up all the values in the textboxes above, but I can't remember...

Cracked it! I hi-jacked my daughter's PC (much to her disgust!) and ran through various configurations of 2010 and 2013 both 64 and 32 bit, and was able to recreate the problem. In doing so, I have discovered that I was actually wrong - whilst my PC is 64 bit, my Office 2010 is 32 bit (home...

Thank you - checked that too, and no they are not SP1; to quote the IT guy, they are just "plain old straight 2010, with only the basics like Word, Excel and Outlook" Thank you also - I will try this one. I am slightly miffed that they refused my suggestion to uninstall both the runtime...

I have a feeling that this is where the problem lies - IT are telling me that they have installed the Runtime environment on the PC's concerned, but I am less than sure that I trust them. A new front end file has been tried, still the same - yet, the same front end file can be moved across the...

I have a database that is running on numerous PC's across various sites, and for the most part, it runs without any issue at all. It is what I am sure would be considered as 'fairly standard' in terms of its configuration with a front end .accde file that resides on a user's PC, with the...

Thanks for the swift response :) I wouldn't ordinarily do this, however this particular process demands that things happen in a certain sequence, and links in with a physical process that the user is also doing at the same time. Nine out of ten users would follow the sequence through, but I...

I have a pop up form, on which two fields that are compulsory - that bit I can handle with the procedure to close the form, however is there a way to prevent users from navigating away from the pop-up form (for example by clicking on a larger form that is open in the background), to force them...

Thanks both :) - and criticism is generally a good thing, as we would never improve without it. I admit that I was trying to be extremely economical with the design of this particular part - I shall instead add a 'last updated date' field which can be simply updated along with the other code...

Hi all, I have a table etc that has a field [History] which is a memo field. The data that goes into it is solely from pre-defined strings depending on which command/action is carried out on the associated form, and therefore the text being entered into the field is strictly controlled (field...

Worked it out - It is a short report with a few DCounts and a few DAvg fields, none of which are bound; I had set the report to be bound to a query, and the query was returning six records hence the number of pages; I have made the report unbound and it appears to work fine. Thanks for the...

I have a report that should fit on one page (it certainly appears to do so in design view), however when I run said report it produces six identical pages, and I cannot for the life of me work out why?

Thank you :) Works perfectly now. That's what I get for copying a sub-report, bending it a little and expecting it to just work. The ID was left over from the other sub-report. Simply because I didn't know any better at the time the original sub-report was created, and I copied that...

Happy New Year to you all :) I have designed a very small sub report, the intention of which is to give a total number of complaints lodged against each individual employee in a specified timeframe, however I am getting something wrong somewhere and I cannot for the life of me get my head...

Found a workaround - instead of using the word overdue, all I did was create an unbound text box that shows the 'due' date that each session of the course is due to be completed by, and then using conditional formatting it goes red bold when overdue. Simple, but should do the trick. Thanks...

Found it! List Width - right in front of my nose. Thanks :)

OK - having some problems with this; when I try to run the query, I am getting a data mismatch error? Here is the code as it is for one of the fields (I need five, with the criteria varying ever so slightly) Status1: IIf(DateDiff("yyyy","[Current Card Expiry...