Search results

I downloaded Severin's copy onto our main server BEFORE working on making the changes he suggested. I had to do a Save As, then a Save in otherwise it would have just saved on my own laptop - I'm accessing our server via a remote. Everything was working on Friday after making those changes.

OK, latest issue!!! Getting the subforms to accept unique data worked on Friday but not today, whilst refreshing the forms to blank when moving to next record does work now. When I enter a figure into the first subform, it enters ok. When I enter a different figure into the 2nd SF, the first...

Thanks for that, will have to wait until Monday to sort it all out, our server is down again and will be all weekend so I can't access it on the remote until then.

Glad to see the lockout is over and the proper Zebras can get to work. I have to think the debacle that was the end of the Seahawks v Packers game was the straw that broke the camel's back. Something HAD to be done to avoid further farces.

Just when I thought it was all completed, I've just discovered the following fault. When I move from record to record on my main form, I've noticed the subforms recording the Stats are remaining as they are. Also, if I try overwriting them as a new record, they alter on all previous forms...

Right, I'll have to make a note of that and make a few bods aware of the score. The server is back up and I've now completed the form. I can now train a few inputters in the intricacies of my masterpiece :D. Just got to wait for the first ones to get back from London this weekend. Thanks...

Quick question. The YearInCity field is currently set to 2012, Would I be right in saying it needs to be changed to 2014 when we start our data entry for our next Focus City? We currently work in one city every other year.

Thanks for your help, Severin, much appreciated. I have spent most of the morning working bit by bit on the forms, but we're having Server issues at the moment (again!!:eek:) so I have no access to the DB until it's sorted and back up running. This does mean I may have to come in on Monday to...

Now I'm really confused (but then that's not too difficult to achieve:p). Does my query have just the specific week or does it include the other fields in the relevant form?

QUOTE=Severin;1193916]You need a year field and a week field in your activities table. Then you need to change the record source on your week subforms from activities to a query that filters the specific week. ...and then you need to remember that you need to add the fields to the week...

I have a series of subforms to record the number of occurrences of specific actions over a set number of weeks, one subform equals one week. My issue is that when I put a number into any of the fields in the first subform, that number is automatically repeated in all 11 subforms for that...

Thanks for that, check boxes all working now. Haven't automated the date stamp as much our our data entry is done retrospectively, ie the users will be spending much of the time clearing a backlog of info to enter for the first City on this DB. The info for our next Focus City (wherever that...

Thanks for your suggestion Severin, but I tried putting the code in and it's not working. The form is still searching for a false object. I'm attaching a copy for anyone to have a perusal at and see if they can offer any solutions. Any help much appreciated, this is the last task to solve...

Sounds possible, but I'm struggling to see where when I search the various property sheets. I'm guessing that a True/False type statement needs to be included somewhere as the process involves changing a status from " Have they applied? - 'No' " to "Have they applied - 'Yes' " and so on for...

Someone's definately dealing with some dodgy stuff if your mate thinks the A-League is lower Prem equivalent. Lower League 1 would be closer to the mark for the better teams, with the rest being League 2 or Conference level at best. There are a handful of individual players who wouldn't look...

I have a form with a series of 6 checkboxes which show various stages of an application for teams to join outreaches in our focus cities. These stages are Enquiry, Application, Acceptance, In City, Left City & Thankyou Letter. Ideally, the user wants to simply tick each stage as it is...

My form has been set up to enter and display info. However, the table it goes into is not populating until the user has finished his/her session and closes the form down. We need this info to update earlier, preferably on entry, as we require certain elements to be able to populate other...

Not critical but.... The Main Form is now sorting all the records according to the Nation a team is from. The American bases are together, the Ozzie bases are together and the Norwegian Base is on it's todd at the bottom of the list. Just wondering if this is normal practice. Ideally, we...

SOLVED !!!!! Or at least I hope so. checking my relationships, I saw I had no NationID in the School or Ministry Table, so I added it in and created the relationship with the Nations table 1-many. It's working now !!! Spent so many days going :banghead:

Oh well, back to Blighty in little under 2 weeks time. There I can watch some decent live footy on the telly at sensible o'clock instead of silly o'clock. For attending games, almost anything from the Conference (Blue Square Prem) upwards will be an improvement on the A-League that I have...