Search results

To Paul and Colin.... First - I've no idea (as usual) why I have to use acFormPropertySettings - it was code which Paul kindly supplied when I was having problems getting the Form to stay on screen so that I could interact with it. If you need further details, that thread is at...

Thnks to some great advice from forum members I was able to achieve opening a form using the following suggested code strForm = "frmReportFilter" DoCmd.OpenForm FormName:=strForm, _ View:=acNormal, _ DataMode:=acFormPropertySettings, _...

Thanks guys - now I can start solving my other (numerous) problems. Minty - works fine from VBA! Just what was needed!

Hey Paul and Minty - if I've said anything wrong, please accept my apologies. There's no need to stand down. It's fairly obvious I need all the help I can get! Minty - if you're still around, is that setting available on the Property sheet? I'm having difficulty finding it, which could be...

arnelgp The MsgBox is not necessary, it's only there to prove that as soon as the Form is displayed, the VBA continues without giving the User the chance to interact with the Form. pbaldy I've now tried making the form Border=Dialog, but it has no effect. It seems very strange that the other...

I have the following code snippet in a VBA module called "ListRequested". GoSub SetFiltersOnForm DoCmd.OpenForm ("frmReportFilter") ' DoCmd.OpenForm "frmReportFilter", acNormal MsgBox "Back in ListRequested" & vbCrLf & _ gstrWhere DoCmd.OpenReport strAllReport, _...

Just in case anyone is avidly following this post (sad creatures!), and to prove that even Yorkshiremen can make mistakes, I offer the following solution. GET THE SYNTAX RIGHT! When I replaced DoCmd.GoToRecord , , glngOldCurRec with DoCmd.GoToRecord , , acGoTo, glngOldCurRec it...

Thanks Minty - I'll have a rummage round for a bit and see what I can come up with. Thanks for confirming that the Add hadn't added a record - that was really puzzling me. And thanks again for the (completely unnecessary) apology - it's refreshing when an expert can also talk to twits like me...

I'm a bit new to Access, and have never used bookmarks, so I'll look into that area. Also, I don't know what you mean by "the current PK identifier", and how you would"simply go back to that". Sorry, I said I was new! I'll try Mr. Google (unless you can elucidate, he said hopefully!)

Unfortunately, at record 4, during the "Undo" code, and with the "Form_BeforeUpdate" setting Cancel = True when I subsequently execute DoCmd.GotoRecord , , lngRecNo where lngRecno is 4, frm.CurrentRecord (where frm is the received version of "Me") has a value of 1. The GoToRecord didn't...

If I understand what you're saying correctly, until I execute a "Save" (in some way), the record isn't actually committed to the Table. Presumably if I attempt to abort an add by pointing the Form at the record which was being shown before the Add function was selected, I'll end up saving the...

Hi guys.... I have a Form, who'se data source is a Query. There are text and combo boxes on the Form, all of which have a Control Source of a field name in the Query's underlying Table. On the Form are some Command Buttons. There is a Command Button for "Add", and a Command Button for...

Ah, but if the door was hinged at the top, and guarded by an enormous purple ferret armed with a bent skeleton key, on which were written the words "ridders is helpful", would I still be able to play the piano?

I have a table of Locations (tblLocation), a Query which returns all Locations (qryAllLocation) from tblLocation, and a Form (frmLocation) whose datasource is qryAllLocation. On the Form frmlocation I have text boxes whose Control Source properties are set to fields in the Table tblLocation...

Thanks to all for the thoughtful replies. As it happens I already have a User written sort function in VBA, but it seemed a bit extreme to deploy it. I often find I've spent hours coding and testing VBA, only for someone to say "Why didn't you just use the 'Wibble' function?". Looks like for...

I have a "main" folder, in which there are subfolders. I have VBA to get the name of every subfolder present in the main folder, but I wondered if there is a way I can get the names of the subfolders returned in "Date Created" sequence, instead of alphabetical sequence? I know I can write VBA...

Cheers Minty - I am now using the Load event with OpenArgs so I've access to the "Me." properties. Looking good so far!

jdraw In essence, I want a pop-up form with a listbox containing a particular field taken from a specific table,, where the name of the field and the name of the are supplied by VBA..

Thanks pbaldy - "Wino Moderator"? - Is Wino short for Windows, or do you have some sort of "refreshment"l related issues?

I have a simple Dialogue Form (“frmISs”) with a listbox (“lbxSelector”), and two command buttons, the usual “ cmdOK” and “cmdCancel”. Using vba I want to “point” the listbox to a field in a Table. I’ve tried all sorts, the latest being strTable = “tblItem” strField = “ItemName” With...