Search results

Oops, thought I had this nailed (could swear it did work but not anymore) Forms!frmTest!Single = "ddd" Forms("frmTest")!Single = "Q213" Run—time error '2450': Microsoft Access cannot find the referenced form 'frmTest'. The Form and the field named "Single' do exist.

THE ACDIALOG wasn't needed (at this stage anyway) as I was just looking at ways to set the recordset where it needed to be calculated. I've abandoned the idea of using Property Let and gone back to writing a query before opening the Form. Which is hard wired in Properties. This works fine but...

DoCmd.OpenForm "frmFiller", acFormDS, , , , acDialog Forms!frmFiller.Target = "ddd" Form code is Option Compare Database Option Explicit Private iSource As String Private Sub Form_Current() MsgBox iSource End Sub Public Property Let Target(a As String) iSource = a End Property By stepping...

Thanks.. I'll not attempt to set it before opening anymore. I was using OpenArgs but quite often it would report invalid use of Null. Particularly when writing code and testing different things. So I was looking looking for an alternative method. Nz() fixed the null problem but if I can use Let...

Can I send a in Forms record source via Property Let ? I think the Form must be opened first but by then its too late. That is, the events where you'd apply Recordsouce are done. Or am I wrong ?

Gasman, I have bound the Form to a table that holds the image filenames and show them in the Current Event with me.Picture = filename Sounds like that overrides the header/Footers (that I've never used). I did not want as Image control as it works great as is and might have been more complex...

That must be part of it. I don't have an image control. Me.Picture is assigned in the Current event and Form is bound to a table holding the image filenames. Are header/footer/detail only used for controls placed on the Form.?

OK, hopefully this will show it

I'll go one step further if I may and assume the Header is superimposed on the detail when the Form is opened. I wanted to use an independent part per of the Form to resize it. Cycling through 3 or 3 views. I can't use the click event as that is used to rotate the picture. And the dblclick event...

In design mode the header section appears above the line saying "Detail". But when you open the Form is it all combined together. Is this normal or possible to have 2 independent sections ?

I haven't tried to use a Form header until now, and not getting quite what was expected. Although in looks fine in design view, when opened in Form view the Header section is on top of the detail section. The Form shows embedded pictures with record source a table with image filenames. Wanting...

Yes, I'd finished it before seeing the other replies. And all of them work. I like the look of KitaYama best. Wonder if it's position on screen can be altered/centered?

Sheeks, here I had given up on finding a solution here and then heaps of examples and help. Much appreciated and I will try them all. In the meantime I got something working and prepared an answer so will show it anyway. It's intriguing how some code can be dozens of lines and other just a few...

Many thanks arnelgp but that's the one I had and doesn't offer to create a new folder. And Gasman if that info is there couldn't find it. This is getting nowhere after 4 days so please delete/ignore and I'll see if I can find what I want somewhere else. If successful and this thread remains I'll...

Gasman those links must be good to some, but I find them a bit frustrating they sort of allude to what you want but tell you nothing. Is it actually for Access? Those curly brackets are not. I did try fnShellBrowseForFolderVB but got an error on Dim objShell as shell. The flags/numbers - I...

I'm a little further ahead but don't get quite the same visual appearance. From msg1 I looked further down the code and found this which is almost spot on: Sub t2() Dim objShell As Object Dim f As Object Set objShell = CreateObject("Shell.Application") Set f = objShell.BrowseForFolder(0...

Sorry, thought I had it already in six other 'Object Libraries' References but didn't have Microsoft Office 16.0 Object Library. It now works but isn't quite what was hoped for. 1) No obvious way to add a New Folder 2) Shows files as well as Folders. Don't want this Is anything around that will...

I found https://bytes.com/topic/access/insights/916710-select-file-folder-using-filedialog-object but it doesn;t work (as supplied) lngType:=msoFileDialogFolderPicker msomsoFileDialogFolderPicker is a undefined variable. Is there anything else ?> Thanks.

I tried https://social.msdn.microsoft.com/forums/office/en-US/b45fb1d2-5d4a-436d-91f8-372145eb6733/access-2013-vba-shbrowseforfolder?forum=accessdev But when clicking Cancel, Access just quit. Is there something better and one that lets you add a folder if desired? Many thanks

Can't seem to find anything on this.. and various combinations go to error e.g. Dim df as String, Cd as Date df = "Saturday, 19 Mar 1983" cd = DateValue(df) Whether Sat or Saturday is used, same error. CDate is no better. What would be the correct way to cast a string date including Day to a...