Search results

Help Please - (Access 2007) I have a query which includes a currency calculation resulting (usually) in a decimal portion, and that calculation in the query is correct. However when I use that calculated field in a report the decimal places are ignored and the total rounded down to the...

Many thanks. No I have not done what your link suggests, because I basically like the 2007 format with the occasional floating window, as long as that window is not too big. At the moment I am resizing it every time I open it - which is a bore, but not impossible - and I was hoping for some way...

Thank you, but unfortunately that did not work.

I have a main form on which there is a button to open a Pop Up Form, which is, in fact, a split form. The Pop Up form should be quite small, but when I click on the button the Pop Up Form is huge showing vast amounts of white space. I can drag the borders inwards to the size I want, but when I...

Thanks, Curtis. It is similar to an inventory and your idea also gives me food for thought. David

Thank you. It gives me food for thought and further investigation. Regards David

I have a table of 12 item quantities. Every so often I either take away a quantity of some items or add a quantity of some items (seldom all items). Is it possible to automatically create a new row of the quantity of items by either adding to the previous row, or subtracting from the previous...

Thank you all very much for your kind help. It is way over my head, but nevertheless does give me food for thought. Thank you all very much indeed. David

Thank you, Pat, you kindly answered my question, although I do not understand the answer. I am so ignorant that I am perplexed. "So, your ASP pages or whatever front end you use, ...". I was hoping simply to upload my .accdb file to the "host" server so that a visitor to my site could use it...

I hope you're right, but I thought I would first have to instal Access 2007 on the server - is that not necessary? David

Hi, I have a question which most people would probably describe as inordinately stupid, but it does not stop me asking it and hoping for a helpful answer. I have an Access 2007 database that I would like to put online on a "hosted" site (not my own servers) for other people to view and interact...

I am not making myself clear. I am asking about the form. - My mention of the table was only in the context of the fact that the field [match] is defined as numerical, double integer in the table. It is with the form that I would like to restrict one field only, [match], so that if is only...

Thank you for your post, but I am afraid it has not helped. I am not too worried about insisting on a numerical entry. That is probably taken care of by the fact that the field is defined as double integer in the original table. However it is not the entry that I need to check, it is the fact...

I have a data entry table in which there is one field which is only used if there are certain values in another field. Specifically, if [category] = 1 Or [category] = 5 I want to insist on a numerical entry in field [match] with its value less than 500. If [category]=18 Or [category]=58 I want...

Problem solved (use of Microsoft Help Files :)) In the Navigation pane, double-click your table. That opens it in Datasheet view automatically. On the Home tab, in the Records group, click Totals. That shows the Totals row at the bottom of your datasheet.

I have downloaded a very useful template from the Microsoft Template site to handle my accounts, and on the main Form, which is a split form, there is a most useful and helpful addition to the spreadsheet part of the form, that I do not seem to be able to replicate on the spreadsheet form of any...

Thank you David. It has not worked, but my work-around has resolved the problem, untidily, but since only I use the database, I can put up with that. Thank you so much for your time and effort. It really is appreciated. David

Oh Dear, I feel a right ninny. Despite reading my (out of date) Complete Reference for Access 2002 book, I cannot find the form name anywhere. The name in the side bar is [Accounts Transaction List], and I assume it should have the word "Form" appended to it after a period (dot), but that does...

Thank you so very much. It really is exceptionally kind of you and goes far beyond the call of duty. I will give it a try during the day, today. Again, thank you so very much. David

I entered Iif(lock = true, no, yes) in the Allow Edit property and got the response "The text you entered isn't an item in the list. Select an item from the list, or enter text that matches one of the listed items." The only choices I have are "yes" or "no" So thank you very much for your...