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

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

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

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

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

When trying to load a sample app, i get the following message...how can i fix this? thanks,j Line 146: Class MSDBGrid.DBGrid of control DBGrid1 was not a loaded control class.

I am very knew at VB..but work with access... I have created an access db program that will be helpful to other people within my organization, however there is one step that needs to be made simpler for the users...that is... i have a 'blank.mdb' file that needs to be copied and renamed. Can I...

I am having a problem trying to concatenate data on a report that is run from a query. I want to have the city, state concatenate.... =([city] & &quot;, &quot; & [state]) when i change the field on the report from city to =city when running the report, it asks for city as a...

I have a table that has one record which denotes the location, date and name of event, site code, etc... (wild horse and burro adoption) i have several reports that i want to have this data show up in the header... how can i do this...thanks,j

Please need help on how to get a report to space correctly. Footer has important preprinted fill in information. my detail section always has space for 4 lines...and detail will never be more than 4 but often is less than 4.. how can i get the footer to start always in the correct place if less...

I have a problem and it is perplexing more so because I have solved it before and have now spent so much time trying to figure out what I did before.. I have a command button on a form that opens another form, which has a field that is linked to a field on the original form. I want the form to...

Is it possible to have a lookup for just the last four numbers of an 8 digit number..so that when entering data ...by just entering the last four, all of the possibilites of numbers with the same last four will be in drop down to choose?.. I know that I can make the 8 digit number two separate...

I would like to create a script that would move documents from a folder in a database to a folder of the same name in another database(if no folder exists by that name then create it)... (deleting the original documents) does anyone have a script to do this?