Search results

Hi, I have a datasheet form with a datasheet subform. I would like to make it that when a user expands a subdatasheet, any other existing expanded subdatasheets are collapsed, so that the user only sees one expanded subdatasheet at a time. Can anyone tell me if this is possible? I am using...

The only problem with that is that it would keep flagging up every time the user moved from any one record to another, unless I add some sort of new flag field to the table, which isn't ideal. Did some digging and it looks like MS originally planned to have a RecordExit event, as it was...

Thanks for the suggestion - that might work. The only complication is I have just thought of a scenario where the user needs to be notified the payment method has not been filled it, but has the option to override it. Then this method won't work. As you say, unbelievable that a 'leaving record'...

Thanks for the suggestion, but this doesn't help me. I need the user to be able to move the focus to the subform and input data there, without the required field from the main form causing a validation issue.

Using Access 2016, I have a main form frmInvoice which has a subform frmInvoiceDetail. My main form is bound to a table with a Required field "PaymentMethod". However, the field is usually not populated until after the items on the invoice have been entered into the continuous subform. I want...

Thanks CJ. Feel a bit silly now. I know this didn't work using the bang! operator, but for some reason thought it didn't using .dot either. Must be the heat....!

Hi, I often have bound forms or subforms where I need in vba to update the value of one of the fields in the form recordset, although that field does not need to be displayed on the form. I have always just added a bound control to the form, set it invisible, and then updated the value of the...

Hi, I have a client who is running a Front End/Back End Access 2007 database where the back end has a non-standard filename extension (i.e. not mdb, mde, accdb, accde etc.) The extension is not associated with MS Access on his system. (Long story as to why, and its not important here, but he...

Thanks CJ. Good to know that it won't cause performance or reliability issues. I'd never thought about the logo idea :-) I just set the logo in the Database properties.

That's useful to know, thanks Galaxiom.

Thanks for everyone's input. Ok, we are looking at doing this another slightly different way. Some trusted users in the office need access to the confidential data and will know of it's existance, other's do not need it and (hopefully) should not become aware of it's existance. One option...

I agree, all legitimate questions. At the end of the day this is about the wishes of my client, not for my own system. Unfortunately it is not possible to host the database on a server - it is on a laptop. The access vba code will be compiled into accde format. Am I right in saying that it is...

Hi, I am developing an Access database with a Front End and two Back End files where is it absolutely essential that users of the computer cannot access one of the Back End data files in any way or even make copies of the file itself. The other Back End file isn't a problem. I have done all...

This may be the option I have to go for. But I was trying to avoid doing this - what is the point in having a Required property if the limitations of Access prevent you from using it? Why oh why does Access check the requirement is met every time the bound control is updated, and not when it...

Hi, I have a form which contains 2combo boxes (cboMag and cboIssue) bound to two fields (Magazine and Issue), both of which have the Required property = YES. The range of values which can be entered in the 2nd combo box depend on the selection in the 1st combo box. The problem I have is that...

Think I might have fixed it, for anyone else with the same issue. Have a look at the Michael Kaplan link I posted above for more info. Basically, your startup code should contain a simple procedure to check if the file exists and if so, calls whatever other code you want to run, stored in...

Thanks for the suggestions guys. I am not sure either of these will help me though. How would this work? Would this not be just transferring the problem? (i.e. if the launcher file was deleted, how could I stop users opening the main mdb.) Thanks CJ. A lot of useful information here, it also...

Hi, I have a number of different mdb databases which all use a couple of common functions. Instead of inserting the function into each database, I have each one referencing an mde file containing the functions in the same directory. My problem is that if an mdb opens and the mde does not exist...

Exactly what I have just done Dave. This is for a licencing product I already developed, where each machine an access application is installed on requires its own licence key. Licence keys are generated by a companion tool which uses the machine ID of the installation pc and a date formula to...

Ok, think I might have solved this by myself. But if it helps anyone else - I needed to use CodeDb instead of CurrentDb.