Search results

Thanks for replying, the excel part was just giving an example of what I am currently doing, what I actually want to do is to keep an access form locked to the front but still be able to use other access forms.

so I have a commandbutton on a form, when I click on the button I would like an inputbox that lists the subforms and subforms recordsource/ controlsource.

I am after a script to lock a userform to the front but still be able to work on other forms. I have an excel userform in access which does this and better still it is like a sticky note as it stays on the screen even when going to another program, but as I am working in vba all day long...

Oh, on google people stated that you can modify the sql string to stop it from changing it, I just am not sure how to change my sql. This thread states that you can modify the sql to stop it happening. http://www.access-programmers.co.uk/forums/showthread.php?t=161585

I have various scripts in one criteria row in my query and access does it's jobs and puts the data on numerous rows which makes it really difficult to modify my script easily. I read that you can change your sql so that access won't change it but I am not sure where to change the script and...

Thanks Mark,

does anyone know the xml code to hide a form, I want to add it to my xml that creates the ribbon.

Thanks Mark, it works great, much appreciated.

I have the following xml script in my table and I want to make the 3rd button be a image that is saved in my c drive. <customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui" onLoad="onRibbonLoad1"> <ribbon startFromScratch="true" > <tabs> <tab id="FirstTab"...

I have the following script which tells me what window is in the top of the order, does someone have a script that list the position for all windows. Private Declare Function GetTopWindow Lib "user32.dll" (ByVal hWnd As Long) As Long Private Declare Function GetNextWindow Lib "user32.dll" Alias...

OK, so I got it to work for a sub, where there is a will there usually is a way. Thanks for your help. Private Sub Command5_Click() Dim str1 As String str1 = [Forms]![form1]![Text3] str1 = Mid(str1, 1, 50) 'MsgBox str1 Application.Run str1 End Subthe sub is in a module Sub test1() MsgBox...

if I can click on a field and it automatically goes to the script it is a lot faster than having to hit ctrl+ f11 to get to the editor and then having to click ctrl+F for the find box, type in the value and then change from current module to within the project, one click event instead of...

sorry, I haven't used eval, how would that work with my string. Sub formscript() Dim str1 As String str1 = [Forms]![fscripts2]![t3] 'MsgBox str1 call str1 ' this is where it calls the script based on value in textbox End Sub

it's vba code.

I have a large list of scripts to do various tasks and I want to be able to go directly to that script in my vba editor, I edit the scripts frequently and therefore I do not want to have to copy the edited scripts constantly back into my table if I can just call them and go directly to them, the...

I have the names of the scripts in a field of a database, so in my form it shows the code name for the specific script so when that name of the script is in the textbox it will be the string. ie. a macro named sub macro1() the name macro1 is the value in the textbox, so it would then call that...

Hi, even with just one option it does not call the script, I thought that it was because my str was text so it was acting like call "mycode" ' my str1 valueinstead of like call mycode with just one option it is not working Sub formscript() Dim str1 As String str1 =...

I am trying to use a textbox value to call vba code and can not get it to work. I keep getting an error on the call str1 line. Sub formscript() Dim str1 As String str1 = [Forms]![fscripts2]![t3] 'MsgBox str1 If str1 = "" Then str1 = "err1" Exit Sub Else Call str1 ' this is where it call the...

I have found the scripts to do the job. Option Compare Database Sub ReferenceProperties() Dim ref As Reference ' Enumerate through References collection. For Each ref In References ' Check IsBroken property. If ref.IsBroken = False Then Debug.Print...

Thanks for your help