Search results

Hi again guys.... I use VBA to execute a standard Report, and am controlling various pop-up forms which the User uses to initiate the reports. The Reports are always initially opened in "Print Preview" mode. When the User closes the Print Preview, I make the Form which initiated the report...

Hi guys (again!) I have a pop-up Form which has a command button to print a Report. When the Report is activated (in Preview mode) I need to hide the Form so the User can see the preview. My problem is getting the Form visible again when the User “dismisses” the Report, either by printing it...

There's probably a frustratingly simple answer to this one, but I'm trying (and failing) to use a Query to locate one or more records in a Table where a field in that Table has the value "X:\GKD\Photos\Awaiting Image.jpg". Because I know that the text has a blank in it, in the Query Builder's...

I have the following code which I hoped would read an entire (short) document, but it doesn't- the problem is commented in the code. Can ayone help? Sub ReadWordDoc() Dim wdApp As Word.Application Dim wdDoc As Word.Document Dim strWordFile...

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, _...

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, _...

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...

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...

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...

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...

Hi... The Background I have a Form, on which there is an Image. The Image is either a photo of an object, or a "default" photo saying "Awaiting Image". The photos are NOT embedded - they are paths to images in sub-folders. The Requirement I want to allow the User to double-click the photo to...

Hi guys.... I have a form on which there is an Image. When the User doubleclicks the Image, I want a "pop-up" Form to appear, with various radio-button options etc. This all works (ish), but I'm struggling to size the "pop-up" Form vertically. On the Form I have removed all scroll bars...

Back in 2004 the User anb001 had a problem with forcing a text box to show a vertical scroll bar. The argument in 2004 seemed to focus on "Why" rather than "How". I have the same problem, and as it happens the same reasons as anb001. I want the User to be aware at a glance that there is more...

Hi Guys, it's the amateur seeking help again! I want to delete a record from a Table, but that record might be referenced by an entry in another Table. For example i have a Table of Locations, and a Table of Boards. Boards exist in Locations. If my user chooses to delete a Location, I'd like to...

I have a Form which is a main menu form, on which there are buttons which, when clicked, invoke other Forms. These other Forms have a Query as their ControlSource, and this Query is unfiltered, so it gets all of the records in a particular Table. The "master" form is called (unsurprisingly)...

I'm in the Access 2010 VBA editor, developing VBA code (fairly experienced in VBA, but not in Access VBA), and to test my code I'd like to execute a test harness to display a particular form. When I single step the code I can switch windows to see what's happening to the form, but at times I'd...

One of my mantras is "The only really stupid question is the one you don't ask", so I'm asking it! If I've been working on an accdb file, when I come to "Save Database As" the database name has at least one "1" (and often a series of them) appended to it. Where is the setting which controls...

I am trying to show a value on a form, but can’t work out how to do it. I have been using Excel (cell formulae and VBA) for years, but this is my first venture into Access. I’m not looking for a VBA solution, just trying to work out how to do what I’m sure should be a simple routine task. I...