Search results

When the 'All Access Objects' pane on the left of the Access 365 window is collapsed, it is replaced by an arrow that allows you to reopen the pane. Below that arrow there is a rather odd looking button (see image) that also reopens the pane. Having two buttons for the same purpose seems rather...

I have hidden most of the contents of the File menu in Access 365 using the code below, but I would also like to hide the New button. Can anyone provide the idMso for this button? <backstage> <button idMso="FileSave" visible="false"/> <button idMso="FileCloseDatabase" visible="false"/>...

I have created a simple accdb database in Access 365. Its only purpose is to print labels for selected names and addresses. My objective is to create a very simple interface that hides everything that is irrelevant. With the help of...

I have a subform with a multiselect listbox that contains more items than can be shown at one time. Selections are stored in a table, with a different set of selections for each record on the main form. As I step through the records on the main form, is there any way to force the listbox on the...

I maintain an Access 2007 database that stores all the information relating to an annual international photographic competition. I have designed various reports to format the results listings in an acceptable manner, making use of group headings and a variety of font sizes and font weights. I...

I have written some module code in one of my Access 2003 apps that creates a text string of XML data. This string contains vbCrLf characters for each line end. I now want to save this string as an XML text file on the hard disk of my PC but don't know how to do this. Any assistance would be...

I have designed an Access 2003 report in which I have some VBA coding in a Detail_Format subroutine to selectively display certain instances of a text box with both FontBold and FontItalic set to True. This works fine within Access but when I export this report as an RTF file these bold and...

I'm looking for a VBA function for use in Access 2003 that will let me select a specified number of words from a string (counting from the left), where one or more blank spaces are used to separate each word from one another. The result should only have single blank space separators. For...

I have a form with a small navigation subform that provides Previous and Next arrow buttons for stepping through a recordset. I would like to program a KeyDown event for my main form that will trap presses of both the Z and C keys, using Z to trigger a simulated click of the Previous arrow...

I have an Access 2003 application that contains a table for recording payments received by post. The Primary Key of this Payments table is an autonumber field called PaymentID. I also run an ASP.NET website that has an SQL Server Payments table, in this case for recording PayPal payments. It...

I am returning to Access 2003 VBA programming (with DAO rather than ADO) after a gap of a year and my rusty brain needs some assistance. I am trying to write some code for a form that will add a new record to a table. For complicated reasons I won't bore you with, the Primary Key of this table...

I am currently learning how to write web apps using ASP.Net 3.5 in association with a SQL Server 2005 Express database (everything is installed on the same PC). This database was upsized from Access 2003 and then copied into my ASP.Net project folder. I have no prior experience of using SQL...

I am using Microsoft's Sequel Server Migration Assistant for Access (SSMA) to migrate a back end Access 2003 database to an MDF file (in SQL Server Express 2005). All but one of my tables convert to SQL Server format, complete with all data. The report for the problem table only lists a bunch of...

I need some help on how to charge for an Access application written for free for Customer #1 if I sell it to Customer #2. Up to now, I have only ever written in-house Access apps while working as an IT Manager (recently retired), apps for my own use and my most recent project, a database for an...

I have just hit a very strange problem with a form in an Access 2003 application. The 14 point text in some of my labels significantly degrades in quality as soon as you spin the mousewheel to scroll through several records. The text seems to partially bleed into the background and loses all...

I am developing an Access 2003 application associated with a photographic competition. My ScoringForm permits the selection of image classes and a subform displays all the image records in the selected class. This subform is bound to a query and contains an option group of 14 buttons - each...

I have designed an Access 2003 application that has several forms with different coloured backgrounds. I also have warning text messages in red. Most users can run my application without any problem. However, one user gets what is an almost monochrome version of my interface. The red text...

It wastes a lot of screen space and looks a little unbalanced to have a very short custom toolbar immediately below a very short custom menu, as I do in an Access 2003 application of mine. Is there any way to make a menu and a toolbar sit on the same level? David

I have a need to enter a range of non-English names into a combo box on a form in an Access 2003 application. Sometimes this requires the use of accented characters that do not appear on a UK keyboard. If I refer to the Windows XP Character Map facility (charmap.exe) then I can see that many...