Search results

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

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

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

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

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

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

I am sure there is a very simple solution to this but I cannot see how to set the size of the window that opens in preview or design. I thought you could open a report in preview, resize the window and save it but for some reason one particular report reverts every time to an irritatingly tiny...

I am not sure whether this is a table or a form query so I am posting it under both. I have a form which is used to amend, delete and create new records. However, when a new record is created, information which is not editable by the user is added from a number of different tables, system date...

Can anyone show me how to reference the AbsolutePosition property of the record being formatted at the On Format event in the detail section of a report? Iwould be very grateful for any help or suggestions anyone can offer.

I want to print a report (no headers or footers) with two records per A4 page, so that, when I cut the page exactly in half, horizontally, each record will start exactly the same distance from the top of the new A5 page. The top and bottom margin are the same (minimum) but the second record...

I would like to group records in a report by a predetermined number so after every say 5 or 10 lines the group header (and footer) would be printed but I cannot find a way of doing this without put a number column in the underlying table and printing the report in this number sequence. Can...