Search results

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 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...

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...

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...

Hi, I have an ID field in my form in which, at present, I manually enter the "ID" number (duplicates allowed). I have another field which shows me the last entered ID number and I add 1 to give the new number to be entered manually. I would like to automate the process, with the ability to...

Can anyone see the error I am getting in this expression in a query: LastNo: DMax("[BookingFormNo]","DetailNewQuery","[Organisation] = " & [Organisation]) I have a [BookingFormNo] field in the "DetailNewQuery" Query which also has an [Organisation] field. There are about 40 Organisations...

Hi, I have an unbound text box into which I insert some text and a date, specifically: ="We will keep the date pencilled in until " & [DateEntered]+15 & ". If you would like a firm booking please, before that date, either pay the Discounted Amount or the Booking Deposit." However the...

Hi, I have a database with a limited number of Organisations in a field called [Organisation] and I usually need to see what only one of the Organisations in the field has entered against it, so I use the expression [Enter Organisation's Name] in the criteria line of the Design View of the...

Hi, I am no good at programming access code, but reasonable at designing an access database to produce what I require using its inherent design criteria in the Design View of a query. However I have hit a stumbling block which I would like to overcome, if at all possible. I have a date field...

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...

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...

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...

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 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...

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...

I have an Access 2007 database that has Fluid records (meaning various fields within them can be changed) and later they become Static records (meaning that thereafter no fields within that record should change). Is there any way I can lock a record within a table so that the data in the various...