Recent content by slaman

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.