Search results for query: *

Good afternoon, I have a simple formula to run on a number of cells. The formula references the cells next to it and, according to their values, adjusts the value of each cell in turn. What I'm having trouble with is working out a For Next loop that identifies each cell in turn in order for the...

Good Morning. I need to set the backcolour of a control on a subform in 'Continuous Forms' depending on whether the value of the subform control matches the value of a control in its master form. E.g. Main Form Control Value = 226 Subform control values = 0 23 327 0 226 <---- I need the...

Morning all, I have a Word document that requires different headers at various points throughout. My problem is I can set the second header (using the 'this point forward' option) fine but when I repeat the process for the third header it changes all the previous headers back to the page where...

Firstly, my apologies for the misleading thread name on my previous post, I've resubmitted in the hope that a more accurate thread name will elicit a response. Thanks for your understanding. I have a F-E form that is based on a query that looks at my B-E tables. Occasionally if I change...

I have a F-E form that is based on a query that looks at my B-E tables. Occasionally if I change information in the record on this form (directly or by code from a linked form) Access doesn't change the information in this record but does in an apparently unrelated record several hundred ID's...

I have the following piece of code: Dim Mpty As Boolean Dim earliest As Date Mpty = (IsNull(DMin(&quot;[NextCallDate]&quot;, &quot;CallDate&quot;))) If Mpty = False Then If Me.NextCallDate.Value < DMin_(&quot;[NextCallDate]&quot;, &quot;CallDate&quot;) And...

I have several leftover references to deleted replicas on the synchronisation screen. The Knowledge Base Article Q198950 recommends that I restore the paths to where these objects were and re-synchronise, the trouble is the paths were to machines that have been removed or renamed (as part of an...

Good morning. I have to print off several forms at regular intervals and I've noticed that the text in one of the command buttons is higher than it is on screen. So high in fact that it comes outside of the button itself. Any ideas why this might happen. It's not a trauma or anything but it...

Good Afternoon All. I have a Front End - Back End database and all access to the back end is supposed to be through queries on the FE. Unfortunatly, whilst solving a problem a couple of weeks ago I inadvertantly created a module that directly refers to link to my BE table. The result of this is...

Quick question for information and future refernce purposes more than anything. Is there a limit to the number of users who can use 1 networked system.mdw file at the same time? Thanks in advance for your help. aexley P.S. While I'm here. I've noticed it's possible for one user to be logged...

This is a copy of a post in the 'Forms' forum (not sure which one it should be in) so my apologies to anyone who has already seen it. I am opening a form, if this form opens onto a new record I need Access to open a message box that requests whether data is transferred to this form or not or...

Not sure if this should be in the VB forum but here goes. I am opening a form, if this form opens onto a new record I need Access to open a message box that requests whether data is transferred to this form or not or the action is cancelled. If the action is cancelled the user is put back to...

I'm sure this has been answered before so you'll have to forgive me if I'm repeating a question but here it is anyway. I have a text box that needs to be populated with the contents of two text fields in a query. Using help I came up with the following solution: =[All Sites].[Prefix] & &quot...

I have a table that has data in the following format: ID No. Date Entered Comment 1 12/02/02 &quot;sdfls dskljf aslkj...&quot; 1 15/03/02 &quot;wioyeri uik kasj ash..&quot; 1 16/05/02 &quot;,mzxcn z,mxc zxdczc...&quot; 2...

This probably isn't the right forum but as I'm a bit stuck I hope someone can help. I work in the lightning protection industry and one of the systems that can be used to determine how much or little lightning protection a building needs is the 'rolling sphere method' in which an imaginary...

Hello, I have noticed an @ symbol appearing in the bottom-left corner of the Microsoft Outlook 'Outlook Today' window. I can select it but not delete it. Anybody know why it's there? Pure curiosity really. Conspiracy theories welcome :-) Thanks aexley

Hello, I have deleted the installed letters e.g. elegant letter, elegant fax etc. but I also want to remove several tabs from the 'New' document window and all the wizards. Basically, when the user clicks 'New' document I want them to see only what they need to see and nothing else. Is there...

I have a pleasant 3d screensaver that was compiled using a system known as PETER (not by me I might add). Thing is whenever the screensaver goes off the VB coding screen is visible with all my neat and tidy (yeah right!) code showing. None of the access toolbars are there and I haven't seen if...

I have a bit of code (received gratefully from a tektips forum) that I want to sequentially increment an ID field. If Me.NewRecord Then ... ... If DMax(&quot;Contact ID&quot;, &quot;Contact Information&quot;) = 0 Then Me.[Contact ID] = 1 Else Me.[Contact ID] =...

I have a combo box which I want to use to display a 3-column list, however, I only want the first of these columns to display when the list is closed as I don't have enough room to have a text box the width of all three columns just sitting there taking up space when it's not in use. Is there...