Search results for query: *

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

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.

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

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

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] =...

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

I am trying to create a subform with the following fields AutoNumberID CorporationID PersonID Position DateHeld Now I have this form related to the "Corporations" database using a One-to-Many relationship and same with the "Persons" database. Now, I can get the...

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

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.

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?

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

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

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.

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

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.

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

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

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.

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

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.