Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. mikey69

    COUNT in Report phase

    Right click the form in design mode and choose sorting and grouping. Choose Location as a sorting field, check group footer. Then put a text box in the footer that will appear, choose client name, or some field that is always there. In the data source for the text box type...
  2. mikey69

    How to generated Payment Due Dates and Amounts on Report

    Hi kvest - Now that I've stopped wandering, I've had a chance to read your previous posts a bit more carefully. I think the most important thing you said is that you don't want to invest a lot of time. With that as a given, the Excel link route is still the route I'd suggest. To get the...
  3. mikey69

    How to generated Payment Due Dates and Amounts on Report

    Will be back home around 6 Jan, will try to respond shortly thereafter. Access makes all things possible. It even makes them intelligible
  4. mikey69

    How to generated Payment Due Dates and Amounts on Report

    I could give you some help, but not for a couple of weeks, because I'm far from home and don't have easy access to the internet. Pse post again if you can wait till early January. Access makes all things possible. It even makes them intelligible
  5. mikey69

    Ambiguous joins in an unmatched query?

    I don't think that SQL can evaluate an inner join within a left join. I think you may need to redesign your tables to allow two left joins. Access makes all things possible. It even makes them intelligible
  6. mikey69

    invalid use of null

    belovedcej - see that Reuel got there before me. Are you fixed up? You can also use movefirst, movenext, movelast, etc commands instead of GoToRecord. And don't overlook .BOF - another useful attribute. Access makes all things possible. It even makes them intelligible
  7. mikey69

    invalid use of null

    You could also test the EOF property. Use a Do while not .eof loop perhaps. Access makes all things possible. It even makes them intelligible
  8. mikey69

    Add Default Value in Table via Code

    DefaultValue property in the help file will sort you out, I think. Here's the example they give: This example uses the DefaultValue property to alert the user of a field's normal value while prompting for input. In addition, it demonstrates how new records will be filled using DefaultValue in...
  9. mikey69

    Corel Draw 12 slow when doing File, New

    How much RAM do you have? This has an effect on Corel. Another factor is how many processes you hasve running. Access makes all things possible. It even makes them intelligible
  10. mikey69

    Holy Grail of Coreldraw/Photoshop

    I had a quick look at ini files. I don't think you would be able to do what you want by dll/ini manipulation. You'd have to be able to decompile the native code, I suspect, and I don't think it would be worth the effort, assuming you could get it to work reliably. if you think about it, Corel...
  11. mikey69

    Looping and Updating

    You guys are quite right aboout normalizing. If Knicks decides to take that pain, then I'd suggest that he migrates to a table with nothing but long integers in the fields: RegionID QuestionID ResponseValue Use RegionID/QuestionID as Primary key and put RegionName and QuestionText in related...
  12. mikey69

    Holy Grail of Coreldraw/Photoshop

    It's an Avis/Hertz situation. you can achieve most everything in both, but you get used to one or the other - each have quirks. In kingpin's situation, personally I'd put up with the Photopaint limitations. Nothing would ever persuade me to try to open Photoshop from within CorelDraw. It's a...
  13. mikey69

    Looping and Updating

    This is a job for a Visual Basic module. You need to create a temporary table with 6 fields, RegionId, Severity1 thru Severity5. Then you use code to create a 5 element array, read your base table, sorted by region. Loop through the fields 1 thru 43 in each record, add 1 to the array element...
  14. mikey69

    How to generated Payment Due Dates and Amounts on Report

    The quick fix is to link to the Excel file and print it. The more robust method is to use Visual Basic coding to do the necessary calculation to create a temporary table based on whatever data has been input by the users and then run a report based on that temporary table. if you are...
  15. mikey69

    Holy Grail of Coreldraw/Photoshop

    To achieve this, you'd almost certainly need access to the CorelDraw source code - not a task to be lightly undertaken. I guess you'll just have to carry on exporting tif files. Access makes all things possible. It even makes them intelligible
  16. mikey69

    Holy Grail of Coreldraw/Photoshop

    Why on earth would you want to do this? Access makes all things possible. It even makes them intelligible
  17. mikey69

    Change Field Name(s) in Table Definition

    You're up against one of the limitations of Access. The brief answer is that you have to find each occurrence and change it for yourself. You could search the Internet for an add-in which automates the job to some extent. they do exist, but will probably have a cost. There's really no...
  18. mikey69

    Make table with no data (i.e. dummy value)

    ...table first, because it's quicker to do this than to delete all records in an existing table: Sub CreateLocalTable() Set DB = CurrentDb '*** Delete local table DB.TableDefs.Delete "tblOrderedReceived" '*** Create local table Set TD1 = DB.CreateTableDef("tblOrderedReceived")...
  19. mikey69

    Printing vertically aligned textboxes in Access 97

    I had a look at his website and can think of ways around the limitation, but they are complicated and therefore prone to run time errors. I'm probably going to abandon this quest and get my client to buy one copy of Access 2003 to do just this job. Fortunately they operate a front end/back end...
  20. mikey69

    Printing vertically aligned textboxes in Access 97

    Hi dhookom - I had a look at Steven Leban's web page. His code works fine for a label, but I can't see how to apply it to a text box, unless I write code to turn the contents of a text box into a label caption, which I think might be slow and prone to error in terms of positioning. Any other...

Part and Inventory Search

Back
Top