Search results

You're doing better than me with the Access 2007 command button wizard - when I tried to use it to open a form at a specific record it produced a list of controls in the form I was opening, but the box for the controls on the form I was adding the button to was empty so there nothing to select...

Thanks everyone for your help - putting the data entry and combo boxes in the header and using a different query for the detail worked. However, I did come across what seems to me to be a bizarre feature of Access (possibly just 2007?). When tidying up the data entry by enabling/disabling...

Thanks, Lagbolt, but I'm not sure that I'm really changing a property of a control - what in effect I am changing are the criteria in an underlying query which, in qualitative terms, I would have thought is no different from displaying different records? It has occurred to me to put the data...

I have a problem with a subform which is a continuous from used to create lines on a delivery note. The first combo box selects the supplier, and then performs a requery on the second (stock) combo box to limit the stock selection to that of the supplier. This works fine on the first line but...

I finally found a solution to this problem on a Microsoft website. Although right-clicking the mouse or using the shortcut menu key on the keyboard won't work, using F2 will!

Does anyone have a problem renaming tables, queries, etc in the Navigation Pane? The Pane is set to view by list. If I right-click on an object then click on Rename, the focus just moves to another object. If I use the shortcut menu key on the keyboard then type "m" for rename, the inside of...

Solution Thanks for all the advice - fyi I have got a working solution using the "Unmatched Records" query wizard although the route is a bit counterintuitive. First I wrote a query for the linking table to select only those records for the manufacturer whose unlinked stock I wanted to list...

Sorry - messages are crossing one another in the ether. In reply to jdraw, the tables are exactly as you describe them so the stock table might be:- KEY Description === ========= 1 Chair 2 Table 3 Sofa and the manufacturers:- KEY Description === ======== 1...

Thanks for your advice. In its "raw" state the query produced by the wizard selects a field from the "linking" record with the criterion "Is Null" which means it only shows stock not linked to any manufacturer. I tried adding another column with the manufacturer in the linking record and in...

I have a table for stock with two fields, KEY and DESCRIPTION; a table for manufacturers with two fields, KEY and NAME; and a third table which links to them both with a many-to-one join with three fields, KEY, STOCK-KEY and MFR-KEY. What I am trying to do is write a query that for a given...

Version Sorry - forgot to mention that I am using Access 2007

I have a subform whose recordsource I set by clicking a button on the main form which runs the following code: Me.MfrStockSubForm.Form.RecordSource = "MfrUnlinkedStockQuery" Me.MfrStockSubForm.Requery Me.MfrStockSubForm!LinkButton.Visible = True Me.MfrStockSubForm.Enabled = True...

Printing I was looking for a simpler solution than creating a report, synchronising it with the current record etc etc... As far as I can remember last time it was just a couple of lines of code to send the unformatted text to a printer.

I have a memo field which displays on a form and I want to put a button next to it to print the contents of the memo field for that record to the default printer. I'm sure I've done it before some years ago but no longer have that DB to refer to. I'm using Access 2007. Any help would be...

I am using Access 2003 to create text files which are sent to mailing companies. I use FileDialog and SaveAs to get a pathname as in the code below - Dim dlgSaveAs As FileDialog, PathName As Variant Set dlgSaveAs = Application.FileDialog(msoFileDialogSaveAs) With dlgSaveAs...

I have been reading through all the threads concerning exporting reports from Access 97 to Word and it clearly seems impossible to export graphics such as boxes. However I have reports where boxes are drawn in particular places depending on the underlying data and I would like to e-mail them...

In Access 97 Tools/Options/Keyboard/Behaviour Entering Field I have selected "Select entire field". However, for some text boxes I would like to change this so the cursor is positioned at the end of the text. I assume there must be some code that can be triggered at the Enter or Got Focus...

Does anyone know of some simple code (access 97) to check/refresh a link to an Excel spreadsheet - I have adapted the Nwind example to link the program to an external Access DB but am not sure how the Dim statement etc should work for a spreadsheet and if you have to justspecify the workbook or...

Thanks for your help.

I am sure this is pretty simple but I cannot figure out how to check if the data source for a form (query) is returning any data at the form's On Load event. I have tried using HasData but it seems only to apply to reports. Can anyone help? Thanks