Search results

Hmm...this is potentially my ignorance coming to surface but surely if you haven't put anything in a required field then no fields in that record will be saved as it renders the whole record invalid? Obviously you would need one of these SaveOK fields for each table, including any other tables...

Hi guys, Having looked at a number of solutions to removing automatic saving of records from entry forms I suddenly invented my own, super easy solution to the problem! Excuse me if this is considered messy or a bit of a bodge but it is working very well for me so I felt the need to share it...

For the sake of anyone coming accross this thread in future: as it turn out, I did not have a primary key defined in the Staff Data table therefore makining any relationship "indeterminate". Once I managed a one to many relationship it worked fine!

Hi, thanks for your response - what exactly do you need as a sample? The output?

Hi guise :3 I have a database set up to record and report staff absence accross a call centre. I am just putting the finishing touches on it at the moment but I am totally stumped with this bit despite scouring the forums and following tutorials. I am trying to make a simple query that sums...

good show!

Ahh well, when you put it like that! :D So simple. Thanks for your help!

Hi guys, I'm by no means trying to hurry anyone up, however I thought it may be worth mentioning that I literally just need to know what the name of this technique is (don't feel you need to explain the method if it's long winded). If anyone can advise me of that, I will happily do my own...

I have a database designed to allow users to log staff absence and then query based on various criteria including large date ranges. At the moment, users select a staff name from a combo box and then enter the corresponding details. An issue I have realised is in the case where a member of...

Thanks for your help...I think I might take your advice in regards to slapping this guy - it looks like the security is there only to protect his code. I will persevere in trying to get around the greyed out module imported (unless that would be a complete waste of time) as if I don't have the...

Hi, I have just attempted that however the one and only module is greyed out and can't be selected. The rediculous thing is that with all these security measures in place I can still import the actual data it is supposed to be protecting! Any ideas?

Hi Scooterbug, thank you for your suggestion. How can I import a module in to another db? At the moment I am (as far as I am aware) unable to even view the code from this db as the designer has disabled all that he possibly can.

I have inherited a database from a contractor which uses username and password functionality. I now need to add further users, which I am fairly comfortable in doing. However, the shift bypass key has been disabled and the form from which it can be reactivated is password protected. The problem...