Search results

Try the following trick round(yournumber + 0.5) Using the above, 18.5 will be rounded to 19.

I have a form for displaying the Club Members info (like Name, Address etc). I'd like on the top right of the total debit of each Member to be displayed. For that reason I construct a Total query. Problem is that when I'm trying to relate the MemberInfo form with this query, all my records are...

Here it is. It includes a test form to see it in action :cool: The calendar button adds the date you choose in the most near field. If you want to add the calendar functionallity to your database you have to copy paste every module along with the frmMothCalendar included in the database i...

noprob, Anytime

The error is here: seq = SELECT tblWood.txtWoodIDcode FROM tblWood WHERE (((tblWood.txtWoodIDcode) Like "Maple07:*"))ORDER BY tblWood.txtWoodIDcode; You can't get the result of a query just that. You need a recordset. Here's the VB code that would do the job assuming that you have already a...

Tha'ts not a problem. I'll describe you the process for the case your table is as in previous post and then you can easily adjust it to your table as it is now. First you will need a Select query to filter every species. E.g. the query for Maple will be as follows: SELECT tblWood.ID FROM...

Well, let's say that your table is exactly the above (in previous post). Next Ash is Ash07:005? And similarly next Elm is Elm06:003, next Maple is Maple05:004?

It's not a problem for me to create one, but it probably won't be what you wish. So, I'll wait to build your DB as you wish and then attach it to add you the calendar

You need the calendar to add "somewhere" a date. I'm looking for this "somewhere"

Where's your Date field?

Maybe try Form.Refresh after Requery?

I'm a bit confused. The combobox reads from table txtWoodIDcode Ash07:001 Ash07:002 Ash07:003 Ash07:004 Elm06:001 Elm06:002 Maple05:001 Maple05:002 Maple05:003 or it writes to? And if I understand well, you want each time to search which species is the last one in order to construct the next...

You can use anything for primary key as long as it is unique. Now concerning the second part of your question, you can have a VBA code generating the key providing that VBA "knows" how to do this. From your description however I can't figure out how VBA can decide whether the next piece is the...

I am using a nice and clean calendar, which fills the nearest textbox. Upload your DB and I will added to your form. Just write down at which textboxes you want the calendar to be added to.

Data comes from a single table, so I suppose I'll go the first way. Thanks for the immediate reply

I am not keen on designing graphics with VBA nor am I an expert in but look what would I try if I were you. I would place the point to the willing starting location and then get its x,y position. The simplest way is by depecting those values to a msgbox. Having that location its easy to find...

Base your form on a query of the join table. Then change the textbox field "equipment ID" of your form to a combobox, and set its rowsource type propety to query which should contain the relative fields of your equipment table. The SQL syntax should look something like Select...

I need to display filtered data in a subform using a Tab control. Something like every day of week being a different Tab. My question is what's most appropriate? To place the subform inside a Tab control or exactly the opposite? What would be the pros and cons in each case?

The wizard simply tells you that you can open the subform (that is Contacts in your case) either by listing all available records in Contacts table or only those relating to your master form that is frmMain. From your description I assume you need the first way, so follow the wizard steps and...

Please don't feel like I'm judging you. I'm only try to make clear as much as possible how the DB should look like and to figure out which should be the optimal design of it, before starti adding queries. Thanks again for your time