Search results

Run into a bit of a snag addressing a Form. My code is in a module and I want to add items to a Listbox. With Form_Form1.Form.List1 .AddItem "1234" With forms("Form1").Form!List1 Most examples use "Me" but that's no good in a module, is it ? Everything I try brings up an error. Can you set...

What is "QBE" ?

Going back to the subform Current event just to populate the Array seems to be working.

Thank you Uncle Gizmo, I do have to create some long abd xomplex queries as part of this current project. So will be studying those then. And maybe Aliases too. I'm sure they've got merit but I've not missed them so far. I only have one table too, so no Joins etc.

The field names are what we want. Some numeric data may become text e.g "-" instead of '0'. I don't know why no table shows in query design, I may have pasted in the sql without using the query builder Window. It isn't the same array for every record, only files for that record. Thats why the...

Ok, This has become quite taxing for me as I know what I want to do but not how best to achieve it. I could do with some advice please The problem in prev message is solved, by following the example db too closely I'd overlooked a control had a different name. However now it's working it may not...

June thanks for letting me know.. I can adjust so it doesn't happen. There is a pause/b key but it doesn't seem to have any effect. I am attempting to apply the "control source" method you described last week. I did get it working but I'm now trying it in the 'bigger picture' and it's doing my...

My query calls a function which isn't working (yet). How can I stop it running? I've found I need Cntl-Alt-Del End Task, but is there any other way ?

I've removed all table names. Aren't using a join (just one table in the query) so should be ok but stuck on something else now! CJ Sorry I don't understand that A B example.

Thank you DBGuy, that's good to know. Changing it now.

With a Select statement, do you really need TableName.FieldName ? It seems to work with just the field name, but maybe there's a downside to this ?

Got it. Shortcut menu = False.

and if I do want to continue without showing the menu, is this possible ?

I'm using https://www.devhut.net/vba-wia-rotate-an-image/ to rotate a Pictures on my Form with this code Private Sub Detail_MouseDown(Button As Integer, Shift As Integer, X As Single, Y As Single) Dim tempPic As String Dim DegreeShift As Long DoCmd.CancelEvent...

Just to let June & Moke know I've successfully applied the control source method and having it get images for any record. (There were more than in the demo). Thanks for the advice.

Solved. I found the anser in another thread. Shortcut menu was off.

Yes

MSDN tells me Hide columns Click the heading for the column that you want to hide. To select adjacent columns, hold down SHIFT and click additional column headers. Note: You cannot select nonadjacent columns. Select any additional columns and...

Looking forward to *trying to get it all working. I will succeed. >Because a form cannot be open in DesignView in two places. Do the reverse and see what happens. I see. Nothing. I'd struck this before and just figured Access was playing up again. It can do the weirdest things... I'm never...

Right, that's very good. And there's no current event. This is a bit of a learning curve... I didn't know what June meant but can certainly see this is the desired result. So qryFrmCDTracksSource has a calculated field "CA" and this becomes the control source for the imgPic with format...