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

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

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

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?

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

Ok, I am starting a new thread because I guess my question was too confusing. I am trying to create a printable form that fits on one page. This form is a summary of all the information in the database. Now, not all fields in the database are required, meaning they can be null. This is where...

Ok, I am starting a new thread because I guess my question was too confusing. I am trying to create a printable form that fits on one page. This form is a summary of all the information in the database. Now, not all fields in the database are required, meaning they can be null. This is where...

Hello, I have a field that can be any length. I specified a size for the text box, but is there a way to make this box "grow (vertically)" appropriately according to the size of the field? Plus after it "grows", how can I shift everything else below down? I'm hoping that...

Ok, I think I have gotten the structure of my database down perfectly. I just need to work on some cosmetic changes... The first has got me confused. When a person uses the Mouse Wheel, I want the form to SCROLL through the page (just like in design view or in a subform) Instead, it scrolls...

I have a secondary index entitled "Corporation Name". The database has an AutoNumber primary key, but the Corporation Name field has to also be unique. I have created a form for data entry for all the needed information; however, I am encountering a small obstacle. I want the FOCUS...

Ok, the first field in a form I have is called "Name". Now I want to make sure that this Name field is: -unique -non-Empty and I want to verify this BEFORE I move on to the next field. Below is my pathetic attempt at doing this: Private Sub Corporation_Name_Exit(Cancel As Integer)...

Thank you very much for your help in my previous questions... I have the structure of the database all set... but now I am having an extremely difficult time trying to create a form to INPUT the data. Is it me or is the Paradox HELP lacking in a bad bad way? Anyways, this is what I am trying...

Hello, I am a learner of database programming, but I cannot seem to figure out a way to create a database using Corel Paradox that does what I want. For example, I want to have a field entitled "Members" with the number of members being unspecified. Each Entry in the Table will have...