Search results

bump......

It is set to true but so is every other form, so they pop up in front or that one.

Thanks Gemma, but the question is how to lock an access userform to the front.

Anyone else got a suggestion on how to keep an access userform locked to the front while still being able to work on other pop up forms.

Thanks Namliam

Thanks for your help Spikepl and Smig, that works well Spikepl and will come in very useful in the future..

I am trying to run a query based on a value in a textbox, the field in the query is a number, if there is no value then return all records, if there is a value then return that value. There are actually around 10 other query parameters but this is the only one that fails with or without the...

I have a query criteria where the data in the query field are numbers. the following works as long as I have a value in the textbox otherwise I get an error message stating, this expression is typed incorrectly blah blah. Like [FORMS]![FONMain]![txtTest15] Or [FORMS]![FONMain]![txtTest15] Is...

Yes, that's great, thanks for your help.

Thanks, that does work, but I think that due to the amount of information and control source info that it then shows slowly, although you now do not see the controls updating.

Thanks Mihail, I can work with that.

Fully loaded meaning that all of the controls have loaded, recordsources for all controls, yes calculations processed, so that when it becomes visible you see a flicker free updated screen, not a screen where you see all of the controls loading one by one..

I have tried using a timer event to not show a form until it is fully loaded, to no avail. If CurrentProject.AllForms("FONNewEdit").IsLoaded = True Then Me.Visible = True Me.TimerInterval = 0 End If I have tried using the onload, onopen but the form still displays before being fully loaded.

Thanks Galaxiom, I do need it to run though, so that's not going to work.

That's awesome. I can add that to my custom rightclick menu so that I can process updates whenever I am in any form or report on the fly.

Thanks Mark and thanks everyone else for your suggestions. I was going to use the following. Public Sub ModifyAllReportsPropertiesTest() Dim obj As AccessObject, dbs As Object Set dbs = Application.CurrentProject Dim ReportName As String For Each obj In...

Thanks everyone, The reason that I wanted an array is that it is something that will be done just once and then it will not be used for those reports again, then I have just 5 reports or 7 etc... and I can then just paste the names into the string and run it, I would prefer not to have another...

I have the following script which I use to modify all report settings, can someone please help with an array so that I can easily list reports that I want to change the settings for, there could be 50+ reports. I can use a string but I have to put str1 as string, str2 as string etc... whereas...

Hi Namliam, Glad you replied as the thread link is one where you replied to. I have currently use vba, however the script that I am using I have 10 different variations and then my boss wants to add tables and so forth in and then I have to start from scratch again, whereas if the query was...

OK, I can deal with that, so what I need is a script that lists the forms and subforms recordsource and control sources in a textbox1.