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 Rhinorhino 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. slaman

    Generating a report I want!

    Ive posted this problem once already and didn't get a good response. Maybe this forum will be able to help a bit better. A little background into the structure Corporations.CorporationID Corporations.CorporationName Directors.PersonID Directors.CorporationID Officers.PersonID...
  2. slaman

    A really complex query/report

    Unfortunately, after trying many many different queries - I havent gotten one to work =/ I tried the one you posted, but it was full of syntax errors, so it didnt work =/ If anyone has anymore suggestions - I'm running out of time and really don't want to restructure things to make it work.
  3. slaman

    A really complex query/report

    so right now I have temp_for_directors - Corporations.CorporationID, Directors.CorporationID, Directors.PersonID and the same fields for Officers and Shareholders... How would I use that to make the report - I'm not understanding what you're saying... That join thing you mentioned is for a...
  4. slaman

    A really complex query/report

    A little background into the structure Corporations.CorporationID Corporations.CorporationName Directors.PersonID Directors.CorporationID Officers.PersonID Officers.CorporationID Shareholders.PersonID Shareholders.CorporationID People.PersonID Ok, that is the above structure/fields I am...
  5. slaman

    Problem with Date Query!

    This is the query, where FromDate and ToDate are fields on a search form. SELECT Businesses.[Expiry Date], Businesses.[Business Name], Corporations.[Corporation Name], Corporations.LawyerID, Corporations.FirmID FROM Corporations INNER JOIN Businesses ON Corporations.[Corporation ID] =...
  6. slaman

    Referential Fields

    Well done... I don't know why I make things so complicated for myself when Access has all these neato pre-defined wizards =P
  7. slaman

    Referential Fields

    ...work. Here is what I've tried: Since I can get the correct CorporationID, I will only explain the PersonID field. I tried SELECT subformName.*, Person.* both with and without the Person database. I've tried binding the pulldown list to the "Field" in Person and unbinding it...
  8. slaman

    Adding a Carriage return to a string

    Chr(13) & chr(10) worked wonders... the second one didnt.. I assume it's Access 2002 syntax again...
  9. slaman

    Adding a Carriage return to a string

    It's for a textbox on a form. [Text Box Name] = stringName1 + Chr(13) + stringName2 is basically what I am trying to do to have the stringName1 and stringName2 display on two separate lines.
  10. slaman

    Adding a Carriage return to a string

    I want to add an carriage return to a string if it exceeds a certain length. I thought this would be easy (simply add a & Chr(13)) but for some reason, it displays a little black box instead of actually doing a carriage return. Any ideas?
  11. slaman

    SLAMAN! An answer to your question

    http://www.mvps.org/access/modules/mdl0004.htm This is the module I need... This is how I call it [Former Name(s)] = Me.fConcatChild("[Dates]", "[Corporation ID]", "[Former Name]", "Long", 1) where the Corporation ID is 1. I get nothing - no errors, no...
  12. slaman

    SLAMAN! An answer to your question

    Thanks, I just found that out from the help files. This is how I am calling the function. I get Runtime errors 0 and 20. [Former Name(s)] = Me.fConcatFld("[Former Names]", "Corporation ID", "[Former Name]", "Number", "String") I am so...
  13. slaman

    SLAMAN! An answer to your question

    I am using Access 2002 which has VB6. Unfortunately, I can't use that code because I can't define a data-type As Database. I don't know what its equivalent type is in VB6... Any help would be appreciated.
  14. slaman

    SLAMAN! An answer to your question

    Heh thanks... that caught my attention... twice ;) I will check it out
  15. slaman

    Stopping record navigation via mouse scroll wheel?

    I am having the same issue with Access 2002. On the form's MouseWheel event, you can do Cancel = True and it will prevent it from scrolling through the records. But I'm still lost as to how to scroll through a single FORM.
  16. slaman

    Auto-scrolling and Wheel

    Thanks th3856. About the tab thing, the tab ORDER is fine... its just that when I'm at the bottom of the screen and press tab to go to the next field, it only moves up just enough to scroll that text field on the screen - I want it to scroll one screen length, so the user starts again from the...
  17. slaman

    Auto-scrolling and Wheel

    Two simple things I'm having a hard time with. How can I have it so that the MouseWheel scrolls the current form as it would in Design Mode? As it stands, it scrolls through the records. I have managed to eliminate that by putting a Cancel = True in the form's MouseWheel event, but that still...
  18. slaman

    If a database field isnull, move everything up!

    The reason I am trying to do this is so that it doesnt show up on the Summary. Why bother having that textBox show up as a blank space and take up room? This is a one-page summary of the record in the database displaying only relevant information in a space-efficient manner.
  19. slaman

    If textField IsNull, move everything below it up

    I have looked everywhere, but I do not see mailing labels or any related wizard. I have looked extensively through reference material and don't see anything. I am using Access 2002 - perhaps they removed that feature? Trim simply removes spaces from a string, it has nothing to with removing...
  20. slaman

    Autoexpand TextBox depending on field value?

    I want the user to be able to view this summary as a Form on the computer to make sure things look properly before printing. A report will not allow me to do all the things I want to do with this summary... I may be wrong though, any suggestions would be appreciated.

Part and Inventory Search

Back
Top