Recent content by sunshine19

I would like to allow the user to push a command button and import a table from one Access database to another access database. I am using an API call for the user to be able to select the access database in which the table exists but I am at a loss for how to allow them to select the specific...

What if you have a form that has many tabs? Is there an easy way to print what is on those tabs at the same time the main part of the form is printing and the tab that is selected?

I think your SQL statement is your problem (I could be wrong). Normally, the Select part is in the WHERE clause.

Do you have an IIF statement or sql statement in your form? If so, check these types of things to see if you have quotes around numeric data types or no quotes around text, etc.

When are you going to check which control has focus? More info needed to help you.

I don't have that version. I have 97. Try it with .Find and not .save and see what results you get. The code I give you works for 97 but obviously does't for 2002. Maybe it is a conversion thing to ADO from DAO and the syntax has changed. Sorry that I am not much help. Maybe someone else...

Should have asked this earlier. What version of Access are you working with?

change .Find to .FindFirst and remove .Save If you fix that it should work. .Save is not necessary.

try this for strcriteria strCriteria = "[recall_date] = #" & lstYourListBox.Column(1) & "# AND [pat_num] = '" & lstYourListBox.Column(0) & "' AND [recall_type] = '" & lstYourListBox.column(2) & "'" I am assuming that your list box columns are pat_num...

If you are not already bringing the pat_num into your list box, bring it as a column to your list box. You can hide the column for your pat_num so it doesn't show in the list box. In my code below I am assuming that your list box has 3 columns and the first column is the pat_num. On the click...

Do you keep your first form open? If so, then when the third one is open refer back to the specific controls on the first form. For example: a control on form1 is txtName and I want to bring it to form3 txtname. I would put this "=[Forms]![Form1]![txtName]" in the control sources...

I have a list box that has numerous rows and I want to apply a conditional format on the row results. For example I want to change format of the font for those rows that have a date of birth prior to 1/1/1980. Is there a way to apply a conditionally format to specific rows in a list box?

I assume that you have text boxes on your form. Have you tried to set the default property to your text boxes and have that store your information that you want to modify? If you want to delete a specific record that is viewing on your form then try having a command button and a delete query...

Have you tried to write your own global module in the Excel workbook that reformats the cells that have the calculation in them to "general" cell format. Or maybe you could create your calculated field in the global module and insert it in the fields needed because sometimes when you...