Search results

I have a letterhead that I wish to use in Access on a form and have the images for the header and footer as jpg files. When I import them, they always come out double the size the image is saved as, so I am assuming it is down to the dpi of the image. Can anyone advise what the default dpi is...

I have a form with a subform that has a table on it. The subform table is a price list with the fields Description, Details (which is hidden as it's too big for the table) and Price. I want to be able to double-click on a chosen item from the table to display a pop-up showing the same details...

I have tried to find this on the forum but it seems all the answers are to do with manipulating the strings based on what the postcode is whereas I just want to extract the postcode as a separate string as simply as possible. Basically, I have a text field called Add5 which has the last line of...

I wish to use message boxes that pop up when certain options are chosen, that can either be immediately cleared by clicking the 'OK' button or that disappear by themselves after a short period (10 seconds in this case). After searching the net for various options, I found the following code...

Hi, My database has been set with the 'All records' locking option set to prevent two or more people editing files at once. This is working fine but I wondered if there is a way to make a more personal message appear instead of the default Access one, just to maintain a uniform look. Thanks, Rich

I'm hoping this is something simple to fix... I've got a database written in Access 2010 that shows many reports. When the report is selected and data is available, it is shown as a full screen preview with the print dialog box displayed over it. However, I am having a problem in that when...

When I print a report, I would like the print dialog to default to two copies. Can the dialog defaults be altered with vb?

I have used vb to call up the standard windows printer dialog box whenever I need to print something, basically because on the several PCs using the database there are different printers to select and also it's an easy way to chose how many copies are to be printed. The printing part works, but...

I have a table of invoices with a column for the amount and a column for when the invoice was paid (if it has been). I would like to produce two totals, one for the total amount invoiced (that bit is easy) and one for the invoices that haven't been paid. I have a third hidden column to hold the...

I have a form that normally opens to show all clients. I have another form which lists invoices in a subform. I have made the invoices so that they can be selected and at the bottom I have a field that shows the currently selected client reference. I wish to be able to open the clients form with...

Is it possible to disable the mouse scrollwheel from within Access?

I have a report that uses group headers to display the results of a query. I group entries that are the same so that it only show a single occurance, but if I do a count of the entries, it includes every occurance. How do I count the unique entries?

I have a report in my database that prints reminder letters for appointments. The client address details are imported from another database with the fields HOUSE_NAME, HOUSE_NO, ROAD_NAME, LOCAL_NAME, COUNTY_NAM, COUNTRY_NA and POSTCODE. However, I wish to work with these so I can produce a...

In my current project, I have an imported table of Clients that I don't want to alter. Linked in a query, I also have two other tables; One holds addresses for the names, linked by Client Reference and the other holds additional comments, both of which need to be updateable. This was working...

I have a report that is based on a query. The query gives names from one table and many entries for that name from another. I have designed a report so that the name is in the header of the name group and the entries for the name in the detail section. Sometimes, the name has no entries for it...

I have created a database to keep track of the treatment of patients in a GP surgery who are on particular drugs. All the data is initally imported from an existing clinical database. I have created a form that is tabbed and has subforms. The first tab displays the patient information. This...