Search results for query: *

Given: Multiple Tables converted to Access 2003 file format. Using Access 2003 and Access 2007 all tables are readable. Now using Access 2010 some files do not appear in table or datasheet view. "This program is not responding" is the result. Open the table in design view, then switch to...

Hi REMOU This works and you supplied the information I asked for and you deserve the star --- however I now have a secondary quirk. The form is forced into the right order but only the first record of the form (subform with multiple records) can be selected. WHATCHATHINK about that? LOL...

Hi REMOU Yes I tried Expression Is "In Balance" --- but nothing happened either bad or good. Somehow it seems that there is some sort of timing problem here. When I fast forward through the form, from record to record, the field that I am trying to color does not show its result until I stop...

Given: A subform with totals. A control on the subform with the source: =IIf ([Forms]![Subproject/TransactionHead]![TransactionHead].[Form]!{PlanAmt] = Sum ([PlanAmt]/1000),"In Balance","Out Of Balance" The words show as appropriate. Now I want the field to show a background color of...

Further Clarification I have optioned "Select entire Field" -- when I use the tab key it goes to each field and does what it is supposed to do -- it selects the entire field. However, when I use the mouse and position it to a particular field the the edit bar stands before the first character...

Hi Remou I see the property OrderBy in the property list -- spelled correctly. Me!OrderBy does not properly reference the property -- at least the way I am looking at it. Strange. This is a subform and the code currently looks like this: Private Sub Form_Current() Me!OrderBy =...

Hi Remou I tried that before and now once again -- however I get the message XXXXX cannot find the field "OrderBy" referred to in your expression. I am going to check out the spelling of the parameter -- it might be that there may be a space between the two words -- unlikely but . . . . .

Given: A subform -- supported by a query. I wish the subform to display records based on a field called "Transaction Sequence". The query includes this field an is annoted as "ascending" in the sort order. The forms works normally most of the time. However, the "Order By" property in...

How can one select or highlight the contents of an entire field to avoid doing so manually by passing the cursor over the entire field? When tabbing through fields on a form, each field is fully highlighted or selected -- you can begin keying immediately. When using the cursor to position to a...

Sorry for the confusion the current environment is that there is an ACCESS front directly linked to a SEQUEL backend. The is no middle linkage.

Environment Access database split into front end and back end. The back end then ported to Sequel Server. Problem Occasionally, atttempting to edit (in the Access front end) records (newly added after the port) resulting in a warning that another user is attempting to edit this record (more...

The key word is AUTOMATE. Manual process is not an option.

I have a series of forms (screen displays) that I need to send to a Power Point application. Bascially, I want to automate a screen capture of each form display and paste to a PPT session. Is there anything available in the form of code or 3rd party application to accomplish this in ACCESS 2003?

I just found a recent post that enables pasting an ACCESS chart into PowerPoint. I like the concept and wonder if the person that provided the solution consider how the code would need to be modified to paste the top window into Powerpoint and advance to the next slide to allow another top...

I tried the simplex me.visible = False in numerous events in the form OPEN, LOAD, etc. and none of them would work. I any case I am trying to have the form close itself immediately afer being opened. The only Event I have activated is OnTimer.

There is a sneaky way to "color" command buttons. Lay the transparent command button over a colored box.

This item has been previously covered but the needed link to the answer has disappeared. Hense, a requery of this topic. Situation: Multiple users signed on and operating on a shared netwok. I would like a procedure to warn all users that the systems needs to come down for maintenance, allow...