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...
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...
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...
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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.