Recent content by wdrspens

I have now had a look at my colleague's MS Access 2010 program, and it appears that when trying to open the files saved in my MS Access 2013 program he gets an error saying undefined function “date” in expression! That has me completely stumped - it works perfectly well in MS Access 2013 and...

I have a database that I now use in Access 2013 with no substantial problems, but which is shared with a colleague who only has Access 2010. My colleague can no longer open the database and I believe the problem is associated with a visual basic command that checks the screen size of his monitor...

I have tried your suggestion, which is tough as there are some 47 fields involved, but have come across many instances of my ignorance. 1. I have the following data fields: Text Date/Time Number Currency Yes/No Memo What is the corerct data type for each of those data fields? 2. How do I enter...

Gosh, thank you. David

Thanks, I am sure that would do what I want, but I am not yet sufficiently experienced to write that sort of code.

Yes I have, but the other data is not always completely identical, the times in or out might change, the date payment is made might change etc. so rejected that idea, but could certainly reconsider it. I am thinking about redesigning the database in any event, if I cannot find a neat answer to...

I use a form to enter new data into a room booking database for the hire of rooms in a hall for events, and for a large part of my entries I have no problems because the entries are stand alone. The problem arises when a customer wishes to book repeat dates, usually not consecutive, but often...

Thank you vewry much. That seems to be working properly. Much appreciated.

I have a simple database with 4 tables, one of which, called "Calorie", has relatively few entries and fields but does have an autonumbered ID field called "CalID" set as its primary key. An additonal record is added to the Calorie table on about a weekly basis. That CalID field is related to...

Thank you very much, brilliant, it works just the same in 2007. Very much appreciated. David

I feel rather foolish. At the beginning of this year I designed a database form with an option group to which values were assisgned depending on the option selected - i.e. The option group is "Piano" and the options are "Not booked" with a value of 0, "Upright" with a value of 20, "Steinway...

Thanks, I think you have answered my problem, in that if I disable the control I cannot override the calculation, and I cannot bind the control and have it as a calculated control. I will continue to use the manual insertion method. Thank you all very much David

Thank you Banana, That is worth knowing. David

Yes the form is only used for new records, and cannot be used for existing records. I have on the form a text box (not in the underlying table) called "LastNo" into the record source of which I enter the DMax code given above but without the +1. That produces the Last Number entered for that...

Try "and" - I had the same problem, and that was the way I overcame it! Sorry, David