Search results for query: *

How can I create a report with labels containing addresses that sometimes have and 2nd line address and sometimes not... so that the label will not have a blank line for addressline2 if there is no data?.. thanks j

If I add an object to a form, it automatically names it...for instance image8 or text1... how can i rename? thanks,j

Do you know if there is a way to insert a thumbnail in a database, with the capability of linking to the jpg file itself.. we have a database which will eventually have many jpgs..and would like to see the thumbnail.. Possible? thks j

How can I get VB6 to recognize the MS Access 2000 .mdb file format?

I have a form that uses a checkbox to populate a field when checked. It makes the field in already opened form match the same field in newly opened form. I am now having a problem in that when the second form opens the next time, the check marks are still there. I have a statment in code that...

I am using two queries for a report...Horse Adoptions... i have one query which lists all categories/quanities of animals shipped and one query which lists all categories/quanities of animals adopted...then using formula can report on percentage of each category adopted.. for instance.. Male...

What I'm trying to ask...and maybe not doing it so well...is how can you accommodate for the spaces in the street address?

I am importing data (names and addresses) into an Access database....the data is all caps and I want it to be converted to capitalize the first letter, then lower case for all of the data. I can use the input mask... >C<CCCCCCCC to do this for the first name and last name and city...however...

Rick: Thanks .... I have the form2 opened when another form1 is open and have a field that needs to be set to a matching field in opened form1...so i use the checkbox in the record (listed in tabular form)..scroll down and check the checkbox to get the fields that i choose to set my field in...

I have a form that shows records in a tabular format.. I have a Checkbox at the beginning of each record.. I want the checkbox to be false on opening the form. If I set the checkbox to false on click of the commandbutton which opens the form, the first record is false but other records show the...

Sean, yes you do have the right idea....and maybe I'm using the wrong tool.... i have a form called adopter...then open another form adopthorse which shows only the animals that are not adopted...i'm using the checkbox to have that form automatically populate the adopternumber field in the...

I am now having a problem that don't know how to fix... i want the checkbox to always be clear when form opens...how can i get that to happen.. i wondered if there is a way to put a statment in the open form procedure section and i tried that and it doesn't work... i tried the before...

Oh WONDERFUL!!!! it works thanks so very much!!!!! forever grateful j

Is there a way to refer to a field of current record being displayed..from another open form.. does this make sense?

What if the form that I called subform isn't really a subform but in fact another form that opens within the input form..there is an 'adopt' button that opens the form that is listing of animals that are still available...adopter number = 0.... is that why it doesn't recognize the...

I've read the help on error 424... still cannot figure out what's missing.. i created a field for the checkbox on the table and added it to the query used for the form..thought that might be the problem but still isn't working..

I am getting an error runtime 424, object required. what do you think i'm doing wrong..j

I need to know how to get the field in a subform populated with data from form when checkbox is checked... inputform has a field adoptnum subform is list of possible animals to adopt when checking the box in record of specific animal, have the adoptnum field automatically populate...

Hi jfischer, Thanks for your response. I had tried using the 3 blank lines at the top of the report header but it threw off the bottom of my report..(report is one page only) trying to print on a preprinted contract form. I have a section that contains data about each horse that is...

Is there a way to cause a report to advance 3 times before starting to print? I am having trouble getting my report to fit a preprinted form... and have made progress except that we have to hit the advance button three times (this is a dot matrix printer due to 3pt form)... any help would be...