Search results

Is there a way to space out the text characters in a report text box so that I am able to print each letter onto a given template document designed with a box for each letter. This weblink below seems to be the answer but I cannot make it work...

Since 1997, I have been building my business (part-time basis) and sales in the last 3 years have been steady at £10,000 per annum from existing and new clients. I have a mixed customer base from Publishers, to Opticians to local business who run my Access applications for Quotations, Invoicing...

Since 1997, I have been building my business (part-time basis) and sales in the last 3 years have been steady at £10,000 per annum from existing and new clients. I have a mixed customer base from Publishers, to Opticians to local business who run my Access applications for Quotations, Invoicing...

Hello; before I go any further, I am wondering whether it is possible to introduce my Access Developer Business For Sale on this site? I am based in the UK North West, Manchester area. Perhaps a Moderator could respond? Many thanks Ted

In the past 4 weeks or so, a number of my clients have all been reporting the above. We are all running Office 365 and fortunately the problem has been easy to fix by opening and closing (compact and repair) the Back-End tables. I am aware that in recent weeks, Microsoft have been issuing a...

I am using the Image Control to show a thumbnail of an jpg file. This works fine. Is there any way to show the file tiles or thumbnail for (say) a Word document, .pdf or Excel file? I cannot find anything on the web. Many thanks :)

I have a form that I use both as a continuous Form and a continuous SubForm. There is a Close button on this form except that I hide this button when the form is being loaded as a Sub-Form. The way I do this is to use the cmdClose.Visible code is put in the Load event of the form a check to...

I have a continuous form of Quotations (as a summary) where d/c one of the controls opens a particular Quotation as a main form. The Quotation mainform has a sub form for all the quotation components including Totals in the footer section of the subform. The total is brought back to the main...

I believe there is a problem with a recent Windows Update. On or around last weekend (19-Aug-17), I noticed that my Continuous Forms no longer scrolled using the Mouse Wheel or by Sliding the Vertical Scroll Bar. Since then this same problem has been noticed by 2 of my Clients using my...

I have an application where I need to Minimize the Ribbon to load a rather large form using as much of the screen as possible; but I do not want to hide it. As such I use the fooloiwng code in the switchboard load event. CommandBars.ExecuteMso "MinimizeRibbon" The problem is when this...

I have a form with about 30 combo boxes and I am wondering whether putting them into a Collection will allow me to address each individual Combo's event property through the Collection rather having to code up each individual control? For example Private Sub Ctl1_1_KeyPress(KeyAscii As...

I need to check after data entry that the text format of a Rich Text box (for html display purposes) is of the correct text format. I am not concerned about the content only that it is Calibri Size 12 and the correct colour has not been changed by the user. This code does not do it. Private...

I have a main form called F-Clients On this form there is a tab control tabClients On this tab control (tabClients), on tab 2 Shoot, there is a subform SF-Shoot On this subform SF-Shoot, is another tab control TabShoot. On this tab control (TabShoot) , tab 3 is Invoicing I need to open the...

I have found this code that works fine in Outlook 2010 but in Outlook 2016 it gives me an error 91 (variable not found) on the .Execute line Am I missing something? - Thanks . Dim nmsName As Outlook.Namespace Set nmsName = Outlook.Session If nmsName.Offline = False Then If MsgBox("Do you...

I have a line of VBA code as follows with works fine: Cells(2, iCol + 1).Value = "=VLOOKUP(B2,'[SFE macro Remittance.xlsm]SITS'!$A$2:$C$" & iDataRow & ",2,FALSE)" In the Excel spreadsheet the cell formula reads =VLOOKUP(B4,'[SFE macro Remittance.xlsm]SITS'!$A$2:$C$25727,2,FALSE) This...

I have been trying to get this to work but without success. My original source was http://www.slipstick.com/developer/merge-email-without-using-word/ The code looks good apart from the fact that the Inpector was not Dimensioned. Anyway, here is my code which fails as the error message is...

I have a Main form with a Tab Control with a number of bound Sub Forms, each on several tabs. I create a New Record on the Main Form and then move to another tab and then add data to a subform on a tab on what will of course be a New Record. Despite using the Docmd.RunCommand accmdsaverecord...

I think the answer is going to be 'No' but it always worth asking. I have two (or more) text boxes, set side by side (aka columns) and I would like the contents to flow from the first text box into the second. In WORD you do this by linking the two text boxes and as the content fills the...

In Access Options, Current database, Ribbon and Toolbar Options, Menu Bar and Allow Built-in Toolbars are not showing. I want to customize the Ribbon Toolbar etc but it seems I need these two options and they are now shown. Any thoughts how to get them would be appreciated. Thanks

I have an application where there are several month-end data updates and although the code works fine, I am generally apprehensive that if anything ever went wrong, then the data in the BE tables could partially update and it would be a major problem to unscramble the data. I have written this...