Search results

  1. T

    "Autofit to screensize" note - sidebar re Acc2k

    My basic Q is: is this problem discussed on a separate thread relevent to Acc2k? I ask because the app I am working on is with a company going thru a mega-downsize iniative, and hence both of my alpha/beta users not only have a 15" screen or smaller (vs. my office pc with 17" and my home office...
  2. T

    Cbox Wizard (Acc2k) code - error 3077

    As many of you are probably aware, I have been much challenged to come up with a "simple" combo box to move to a selected record on the same form, so I tried again with the combobox wizard today, which works ok for a while, then eventually (after 3-7 correct selections) crashes. Anyway, the...
  3. T

    Subform Not Recognized as Open-Acc2k

    Following the suggestion in MS article Q209537,I created an unbound form to hold a combobox and a two page/tab control form/subform. The good news is that the combobox works very well to move to a desired record, but I am getting the following error when a repaintobject action is run from an...
  4. T

    Order of Events for Multipage Form w/TabControls

    I have a form with three tab controls as follows: Tab 1 - main form for proposal specific information Tab 2 - continous subform to select models to include to include in the current proposal Tab 3 - a two-part form; the top is single form, and the subform shows the models entered in Tab 2 for...
  5. T

    ActiveX Controls Descriptions for Acc2K???

    I have just recently begun to explore the number of ActiveX controls that are available for use, but there doesn't seem to be any description of them in any of the documention or any reference guides I have purchased. For example, I have had trouble with the standard combo box control for a...
  6. T

    Protecting Database Win View Acc2k

    Hi Folks... Moving into the final devlopment stage for my application ... user training scheduled by the client for their users for the first week in Feb. Problem: 97.939494% functionability and experienced user beta test going well ... but: I haven't been able to 'bullet-proof' the app for...
  7. T

    Validating logon data from Another Table...

    Hi again folks ... I am trying to figure out how to check from a popup form if the user has entered a valid combination of their department's code (RC# aka responsibility center #), and the Dealer#, the two of which combined are used to grab the right pricing data for the department submitting...
  8. T

    Tab Order Problem in A2k

    I have a number of forms with 15 plus controls each, that I had previously the tab order set to my satisfaction. However while making changes to the DB today, unrelated to the forms, I found the tab order to have changed, and in some cases when viewing the tab order, I found only one item...
  9. T

    Exporting reports to Excel ... Setwarnings problem

    I have a simple macro actuated by a command button on a form that exports via output action on click a set of 5 reports to the client's server in Excel format. Everything works fine, but even with starting the macro with Setwarning to no, the A2K warning screen still appears before every...
  10. T

    Emailing Reports in A2K... 'on demand'

    My current client app is primarily focused on improving productivity for their sales force... regional sales VPs down to field reps. To that end, I would like to be able to add a menu/form option (based on macros) for the admin asst-enduser (not all the reps have access to the server) to...
  11. T

    Multiple Filters and Combo Boxes Problems

    As usual probably a simple answer awaits, but what I want to do is allow the user (when the 'edit proposal' form is called up), I want to give them the option of either: 1): Entering the proposal ID (a primary key) 2): Seclecting from the entire list of proposals to edit (approx. 500...
  12. T

    A2K bug? Occassional details data dissappears...

    For the second time in the past month or so I made a simple change to a form that was working great before (e.g., I added a new field to the form today), and when I viewed it, all the data in the details section was not visible. I double checked the settings for the details section and nothing...
  13. T

    Tab works but Form view doesn't change for subform?

    I have parent form for users to enter basic information regarding a new spending proposal (client name, beginning/ending date etc.), and a subform for them to select a model# and the related quantity they project for sales over the next 12-15 months. Everything works fine but when they reach...
  14. T

    Take2... CopyObject or Openquery/MTQ action?

    I will try this again in a shorter version (see my note below for background info on what I am trying to accomplish), so the basic Q is .... am I better off trying to use copyobject action mastertable/rename it via sendkeys the name of the unique table name previously established via form...
  15. T

    Repost re Using Macro (vs VBA) to Copy Master Table for User Data Submission

    Hi all ... I posted a detailed description last night under the General topic (thinking more folks would see it there, but no luck). Anyway... for reasons explained in the General Topics note, I want to use a macro to copy a MasterNewEntry table for each user on a server that can be passed on...
  16. T

    Using DLookup function in forms

    I am not sure if using DLookup is the right way to go, but basically spent most of the afternoon trying to figure out to have the foreign table (MasterIDsNames) feed the Dealername, when the user adds a new record and enters the DealerID# on the form for the ProgramTracking table. Everything...
  17. T

    Format/Align Bug?? in A2000

    Hi again folks .... I spent most of the day today manually aligning (adjusting/moving fields, preview report, adjusting, previewing etc etc) page headers and detail records for a financial forecast report with monthly revenues in the 8 figure range, e.g., $33,000,000, and ranging down to zero$...
  18. T

    Getting Values for Selecting Reports ....

    Its probably a lousy subject title for my problem but the overview is this: The objective is to let field sales reps run a basic access applicaton (only a switchboard and report request option/form and of course an exit Access button) so they can take the report to a specific dealer, showing...
  19. T

    NZ functions in underlying queries for reports

    I have tried to use the NZ funtion to clear up the null problem in query totals for reports (it works fine for the first field defined then doesn't work for the other fields). Have also tried basing the NZ function on the direct-table querie and another on which the report is based on an...
Back
Top Bottom