Search results

  1. B

    Excel Spreadsheet will not import into Table

    Save as Text I've run into the very same problem many times. One solution is to open the file in Excel and save it as comma or tab delimited text - I've never had problems importing such text files. Another issue involves excel files downloaded from the web - some web applications actually...
  2. B

    PHP Editor

    I like the "TextPad" program - you can get a free demo, it is quite simple, it displays line numbers to help with debugging.
  3. B

    Hyperlink to open new window

    If you want ALL links to open in a new page, you could insert the following into your <head>: <base target="_blank">
  4. B

    Web Design Question

    Simply use percentages and relative values for object sizes instead of specifically setting them. For example, you could use "<div width="50%">" instead of "<div width="600">", or "font-size: 1.5em" instead of "font-size: 16pt", etc.
  5. B

    parameters and macros

    I'm not sure what you mean by: If the USER is deciding which section to query, then the user is going to have to either type in the section or select it somehow. The simplest way is to add the parameter to the query design grid, eg: [Enter Section Number] on the criteria line. When the query...
  6. B

    Question Regarding Splitting a Database

    Splitting a database means separating the tables from the queries, forms, reports, macros, etc., and you end up with a front end (with all those objects) and a backend (that holds the tables). Splitting is beneficial when you have multiple users accessing the database - you put the backend on...
  7. B

    On Exit Event - tab/click header vs. detail

    Thank you both for your help on this so far!!! I'll be redesigning the whole thing based on both of your input. Apparently, I was so concerned about the form in this project that I ignored good table design - even if my coding skills are weak, I should know better when it comes to tables. It...
  8. B

    On Exit Event - tab/click header vs. detail

    Not Sure What to Do From Here I'm really at a loss as to where to go with this, and so I've attached the database with the form in question [Order Form]. I would be VERY appreciative if someone could take a look at it. No matter what I try, the ProdQty isn't recognized as having changed...
  9. B

    On Exit Event - tab/click header vs. detail

    I have a continuous form, with data entry fields in both the form header and the detail section. I've attached an "On Exit" event to the ProdQty field in the detail section. The prime function of the event code is to run an update query on the table (which is the data source for the form)...
  10. B

    Small, Probably the Most Basic Question You'll ever Hear

    What he means about Enter Criteria On the Criteria line of the Query Design Grid, if you enter something inside of brackets (eg: [Something]), a message box will pop up to prompt the user at the time the query is run. For example, if you wanted to filter records by Centre Number, you could...
  11. B

    cycle through records and add to array

    In the end, I'd like to create print-ready output to be included in the appendix of a book. However, any output that groups author with however many entries (quote_id's) in the format I mentioned above is fine - a query, a report, unformatted text output, etc.
  12. B

    cycle through records and add to array

    More info I have a table of quotations by various authors, with the following structure: quote_id (integer, primary key) author (text) quote (memo) Some of the authors appear only once, some of the authors appear a number of times. I would like to output an index of quote_id's by author in...
  13. B

    cycle through records and add to array

    I am attempting to create an index of items in a table. The data looks something like this: Bob...2 Jerry...27 Bob...79 Phil...14 Jerry...53 Bob 102 etc. I would like to create output like this: Bob...2, 79, 102 Jerry...27, 53 Phil...14 etc. Is it possible to cycle through the records and...
  14. B

    Loopy from Loops

    First, thank you for your assistance on this! I figured out that my Do counts were slightly wrong, which escaped the loop too early. So, I changed them to Do Until loops and then added an If statement to check to see whether the form had reached the absolute, final rep and, if so, to escape...
  15. B

    Loopy from Loops

    The underlying query for the report is getting the Rep Number from this form: [Reps List].[SO Rep]=[Forms]![Automation]![SO Rep]
  16. B

    Loopy from Loops

    Unexpected Loop Results I am attempting to create a form for the automated printing of a series of reports. The form is tied to a query that captures Territory ID, Sales Rep ID, # of Reps in that Territory, Total # of Territories. Once completed, the code behind the form should: 1) Print...
  17. B

    Decimals Gone Wild!

    It's a string! OK, I finally understand what's happening here. The following formula has transformed my currency field into a text string because of the return Null statement: CurrApr: IIf([Salesrep Sales Analysis - Reps]![CurrApr]=0,"",[Salesrep Sales Analysis - Reps]![CurrApr]) Once that...
  18. B

    Decimals Gone Wild!

    Tried the cstr() function and it errored out the field as well as the other, calculated fields based on it. :( I also tried Round([CurrApr],2), but it's still displaying only a single decimal place (1.5) instead of 2 (1.50).
  19. B

    Decimals Gone Wild!

    Still not working I tried setting the format as you described, first in just the report and then just in the query, but the results are the same. The original field in the underlying table (Invoice Lines) is: FieldName: Sales Data Type: Currency Format:[none-not specified] Decimal Places...
  20. B

    Decimals Gone Wild!

    I have a numeric field on my report that I want displayed with 2 decimal places, regardless of whether the 2nd decimal place is a zero (i.e., if the number is 7.2, I want 7.20 displayed). The format for the field is currently Fixed / Decimal Places: 2. The display seems to be ignoring the...
Top Bottom