Search results for query: *

I recently saw Windows 7 screen with a desktop menu using "Access Forms"?. Brightly coloured tastefully iridescent even. Bout 5x 8 cm tucked into the rhs top of the screen. THey have options for entereing Customer Joc details start date of the job etc. Ive got no idea what they were and how...

I am trying to make sense of some code that I downloaded but the comments appear garbled eg: /*--------------------------------------* Ãû ³Æ: patternDetect2 Êä Èë: ¸ÅÂÊA,B,C,D,E Êä ³ö: ÊÖÊÆÀàÐÍpattern ¹¦ ÄÜ: ¸ù¾ÝÊÖÊÆÐòÁÐÔÚÄ£ÐÍÖеĸÅÂÊÀ´ÅжÏÊÖÊÆÀàÐÍ...

I can create an unbound text box in the detail section of my report. This text box refers to another control on the report called "Person" when I place this expression in the unbound text box... =IIf([Person]="ed",1,2) .. sure enough it gives 1 whenever the Person control is "ed" and 2...

I have produced an report/invoice from the table of data. (It contains some subreports as well.) After the report/invoice appears, I might like to modify the data on the report itself- and then maybe save it as an individual modified invoice. Any ideas how to modify the contents of a report??

I want to print my Access VBA code in colour. I usually copy the code - module by module and paste it into Word where I have written a "Pretty Print" routine to automatically print it colour code formatted. This takes ages when I have lot of modules. I got a bit excited when I noticed that...

I want to format lots of text boxes which are already on my form to .423 height and Font Tahoma size 8. The format painter does the height only. Is there a way - maybe from code (but presumably in design view) of applying formatting in one go to text boxes for example that I place on the form...

I make a "Datasheet" form based upon a table in 2007. The field heading of this Datasheet form are a light brown. I want to print the form. When I Print Preview it, the colours change slightly but I still have the light brown headings across the top. Are they some sort of "system" colour? Is...

We can 1. set up relationships between two tables eg a one to many and eg set the join type to 1,2 or 3 and save this layout. We can then 2. make a query for the same two tables and maybe choose a different Join type. I don't understand why we need to perform 1. above. Does this just set...

I have a form and a subform. I wish to update a combo on the subform for each new record. The current event seems to be extravagant since it seems to fire more that once for each new record. Is there a better way of updating the form each time? Or ccan I use something like a static variable to...

Hello I'd like to prevent/allow edits and additions to a form by using a toggle button with the code: Private Sub tglDataEntry_Click() Dim tf As Boolean Select Case tglDataEntry.Value Case True tglDataEntry.Caption = "All Data" tf = True Case False tglDataEntry.Caption = "Edit Data" tf = False...

I'm sorry to be vague but my 2007 d/base was working fine until i placed on another PC (2 others actually). The call to the subform code came back with an error message saying that it now couldn't find the subform - or at least the controls on that subform. I just wondered if there were any...

We can determine the name of a control by using its index: MsgBox Controls(3).Name but how can I determine the index of a control using code? Thanks

Is there a description of the operation of the new Northwind sample d/base - in particular the VBA? I notice that there is not much commenting in the code. To save some time I've tried Googling without success as yet. Thanks

Hello I have an Access 2007 database. Of course i can merge to Word from that. Is it possible to merge to an Outlook email? ie is it possible to place Fields in an email just as we do for Word?

I place a button on a form to make a filter using DoCmd.RunCommand acCmdFilterByForm After choosing the filter by checking the boxes etc I would then like to Apply the filter using DoCmd.RunCommand acCmdApplyFilterSort in another button or checkbox or whatever. The only problem is that it...

Hello: I would like to dynamically place some text boxes on a form at run time.

I made a Userform - from Word as it happens. If I click on the Word app it won't come to the top ie the userform is always on top. If I start Excel , i can click on it to bring it to the top but not the Word. I saw a Windows API caled SetWindowPos but also read that the userform is not a child...

I wish make Excel to repond as soon as i enter a character into the sheet ie a Key Press event of some sort. I see a Worksheet_Change event but that only fires after leaving the cell. I can't even see an API i might use. Any ideas please?

If I write this code in an Excel Module and run it: Option Explicit Dim xl As Word.Application Sub Import() Set xl = New Word.Application End Sub I get: "Run-time error '430' Class does not support Automation or does not support expected interface." The strange thing is that it runs OK on...

I have a document dated 20th August 1999. The 20th is dispayed with the th as superscript. This feature of course can be turned on and off in Office 2000 & 2003 but can anyone tell me please if this feature was available with Ofice '97 which was presumably supposedly used to write this...