Search results

Here you go...... Regards

Hello In your query, add a new column and use the MID function to extract and return everything from the dollar sign. Regards Mark

Here you go.... =LEFT(A1,4) If your data Accounting1234 was in cell A1 Regards

Here you go....... Regards

10-4 and good luck with this.

The "Default Value" property of a combo box allows you to initially set the value you want displayed in the combo box window when the form is opened. If this happens to be the name of a query that you want displayed, then place that in the default value property. Regards Mark

Yes. You set this "Default Value" in the properties of the combo box. Regards

In the table design mode, refer to the format section for the field. Set it to "General Number" Regards

http://support.microsoft.com/kb/210307/en-us

Hello Glad you got it working, and good luck on future projects. Regards Mark

Hello Your welcome and good luck with this. Post a sample if your having trouble. There is a lot of good folks here. Regards Mark

Hello: It sounds like you want a cascading combo box effect. Please see the below link to Candace Tripp's site. She has a downloadable example of how to do this. Regards Mark http://www.candace-tripp.com/pages/access_downloads.aspx

Hello: Your on the right track. What you need to do is nest your control check routine within your form check routine. Then after the first form is loaded and check for the control name, You need to issue a command to close that current form. Your code would then procedure to the next form to...

Hello: How about the below solution. It works better! http://support.microsoft.com/kb/210307/en-us Regards Mark

Post what you have so far

One more http://www.mvps.org/access/general/gen0008.htm Just change import to export Regards Mark

Hello again: http://www.bluemoosetech.com/microsoft-access-tutorial.php?jid=3&title=Microsoft%20Access%20Transferspreadsheet%20Macro Regards Mark

Hello: Might this help? http://msdn2.microsoft.com/en-us/library/aa193071(office.10).aspx Regards Mark

Hello: The statement would be...... SELECT Table1.Code FROM Table1 WHERE ((Not (Table1.Code)="0001AC" And Not (Table1.Code)="0016AC")); Use your table and field names though Regards Mark

Hello: What you seek can be accomplished using a crosstab query. Regards Mark