Search results

Thanks on the query info, I just didnt think about that. On the between part how would you write the following for a number field on a form "OrderAmount Between 50 and 75" I have tried the <> but because it is a number field(as double) it shows me all of the records not just the one between 50...

Is it possible to use a Between function in vba as you can in a query? Also how can i reference a field in another table other than the one I am currently in?

I wish to hide a field and only make it seen if they order over 50 of one item then i wish to make the new field requiered. on my table I have Order Amount: Order Comment: plus several other fields, but the order comment field I do not want to see on a form unless the order amount field has...

Thanks, Works great and will save me lots of time doing the same thing over and over every day.

Is it possible to delete a file that is not in a database? What I have is a simple macro that imports data form "readings.txt". This file is automaticly generated by another program. After i import the data, i need to delete the old "readings.txt" file so that I will not have double data next...

Write a macro that runs the event and assign it to each button you need.

Sorry, but no I dont I have done everything I can think of not to take VBA class.

A trick I used was to make a subform (in the plain form view of wizard) the way I needed it first and then insert in other form as a sub form...

Would it help to have a linear line on the chart that changes as the data changes? If so in chart design right click on the data line and add a trendline May not be selecting two points but it will print on the chart...

To Help Clarify I have Two tables and a form Table A "specs" Fields in table A Product Code - Product Name - Product Finish - Length - Width - (ect total of 36 fields) and (110 different records) Table B "Data Entry" Fields in table B Name - Date - Product Name - Product Finish - Length...

I am not sure if this is even possible. I have a table in my database that contains specifications numbers i.e. the length of product "A" is 150 inches (Length Field) and the width is 8" (Width field), There are about 100 different products total. Well my problem I have run into is that I want...