Search results

I know this is an old thread, I was just wondering if there is any other solution to this problem apart from making a sub-form, I'm to far down the line on a complex form to go for that. To recap, on a continuous form with a set of unbound combos in the header to filter the data, all the combos...

It is possible if your front end is a secured mdb file. It's more work as you have to set sqlserver and access permissions.

Hi oldaf294, Unfortunately I'm still getting 1000's being returning when I use your solution. Thanks for the reply, Melt

Hi all, How do I search for a particular occurance of numbers within a larger number. Example: ProductCode 23331000786 43244100999 88810008886 7771009999 5646461000 7771000888 6464100922 In the above product codes I want to be able to pull out any product code that has 100 in it, omitting...

I just wanted to update this post with my solution to opening a secured access database through a shorcut using Bob's updater. This is what you need to do: 1. Copy your shortcut string into notepad, then save it as a .bat or .cmd file, I've called mine 'open.bat'. 2. Save open.bat into...

SammyLou, Did you ever figure out how to restart the database using the workgroup file? I'm now in the same position, the updating works great (thanks Bob!), but as it's a secured database I need to restart it through a shortcut Melt

Thanks for the reply, I know how to make and create right-click menus, I'm specfically interested in getting an Access shortcut menu to appear on a left-click. Regards Melt

Hi all, Is there any way to bring up a shortcut menu in Access on a left-click? I want to be able to just click a text box and bring up a shortcut menu., or does it require a work-around. I know it's not the usual design practise for shortcut menus, but I need to find out, thanks. Regards Melt

This is what's great about the internet - ghudson, it's more than a year later, but your little bit of code saved me a lot of time today, thanks a lot for sharing. Regards Meltdown

Hi jkl0, Sorry, I don't see any Dual Font Support on the View tab, what version of Access are you using? I'm on Access 2003. Regards Melt

Thanks for the reply statsman, I have a fix, sort of, I had to rebuild the form making sure to use a common font, i.e. Arial If anyone has a solution that does not involve rebuilding the form, I'd like to hear it please, in case this crops up again. Thanks Regards Melt

Hi all, I have a couple of subforms on one particular PC where the data is showing in some strange font, WingDings or something like that. On my PC the data shows correctly. Please see screenshot here: http://www.confetti.ie/screenshot1.jpg I tried changing the Font Name for all the controls...

You need to insert the results from query 1 into a temp table in your sproc, then you run a SELECT against the temp table to get the query 2 result you want. At the end of the sproc you drop the temp table.

Hi all, I keep getting a Compile Error when I try to run some code, it a "Error Loading dll" error. Below is a snippet of code, it stops at Set conn = CurrentProject.Connection Dim conn As New ADODB.Connection Dim rs As New ADODB.Recordset Set conn =...

this should help... http://www.access-programmers.co.uk/forums/showthread.php?t=72630&highlight=Typeof

There are a few ways to do it, I used the OpenArgs method in my demo.

Go to Tools > Options, just uncheck the Hidden Objects checkbox to show all your hidden tables in one go, recheck to make then all hidden again. If you want to use code, look up the SetHiddenAttribute and GetHiddenAttribute methods in the visual basic help section of Access. No harm to hide...

Can they not use the keyboard?...highlight the text...Ctrl+C for Copy, Ctrl+V for Paste, Ctrl+X for Cut.. ...or make your own right-click shortcut menu

This thread should help: http://www.access-programmers.co.uk/forums/showthread.php?t=101027

When setting focus to a control in a sub form you must first set the focus to the subform and then to the control... Me!frmNavSNewCat.SetFocus Me!frmNavSNewCat.Form!txtCatParID = Me.txtCurrent