Search results for query: *

This is a little complicated and involves quite a lot of code, so I’ll try to explain in plain language. On each of my Forms I have a DBGrid The relevant query selects filtered data from a Table and this is posted to another Table whose Datasource links to the DBGrid. The ‘filtering’ is...

One of my Users suddenly had an error message "This record is not Updatable", accessing a database which I had sent to him. Because his firewall throws out everything that breathes, I had to remove the .mdb suffix before sending and he had to put it back on receipt. We have done this numerous...

There are certain objects which, once created, remain constant and need to be called in more than one procedure. The messy way of accessing these is to make a query and join the required tables; but this was making some of my procedures unnecessarily complicated and it was very easy to get the...

I have a number of objects in my database which I need to see recalculated on screen as soon as they have been (new record) entered or changed (amended existing record). I have the following code in the "On Exit" event:- If Me.Dirty Then On Error GoTo err: Dim BM As Variant BM = Me.Bookmark...

I am using Access 2002 in Office XP on Windows98. In one project I have several forms which require a Recalc when certain data is input or changed, and the focus must go back to the right object in the right record. To do this, thanks to "tek-tips" I have the following code:- Dim BM...

I have a Form with two alternative Command Buttons, depending on data in a table which Changes as certain functions are completed. One says "Print Draft Data" and, when this is actioned the completion date is entered on the table. Next time the form is opened,the date under...

I am using the usual front-end/back-end structure in an application and do not wish my users to access the front end database by opening it in Windows Explorer. So, I have disabled the menu bar, Database Manger and Shift Key, created an .mde etc and made this open with a Form carrying a warning...

I am trying to create Global Menu Bar to replace the default Menu Bar (AccessXP/2002). So I ..... Right-Click in Menu Bar and select “Customize” Untick “Menu Bar” in list of options and hit “New” Give Name to new Menu Bar. This name appears, ticked, in the opions list. Open Database. New...

I am trying to create a Global Menu to replace the built-in menu,, (AccessXP/2002). Right-Click in Menu Bar an select “Customize” Untick “Menu Bar” inlist of options and hit “New” Give Name to new Menu Bar. Open Database. New Menu Bar appears as box on forma and can be moved, resized...

I have Forms which allow Users to amend data in certain controls in subforms; which is then totalled using: 'If me.Dirty Then M.Recalc Me.Dirty = False End If' This works fine except that the Recalc Method then sends the focus back to the First Control in the First Record. If there are a lot of...

I could use some code that would allow me to control the Font weight, Fore and Back Colors in forms and reports. Logically one would expct this to be straightforward :- 'If Me.Mood = "Frustrated" then Me.Face.Fore_Color = (color code for White) Me.Face.Back_Color = (color code...

I have included this line in an application which I am publishing on a website:- [DoCmd.SendObject acSendReport, "Mail Permissions", acFormatXLS, "instantprofile@comptonit.com", , , "Free Client"] The objective is to enable users to send me a completed report by...

I am distributing an Accesss Application which requires that, at a certain point, users e-mail back to me certain details in a file "Mail Permissions.xls". The code is:- [DoCmd.SendObject acSendReport, "Mail Permissions", acFormatXLS...

I have just completed an application in AccessXP producing reports based on queries which, in turn, access modules which I have written. The application itself was originally started in Access97 and converted to Access2000, using XP, for completion. All the Forms, Queries and Modules work...