Search results

Hi there, I am trying to get a report to display the number of records with a text value of "No" in a certain field. I have not used a "yes/no" field, just a text field with a choice of "yes" or "no". I tried using the formula: "=Count([Component ready?]=No)" but it returns the total number...

Hi there, Is there anyway to create a table that hs the same features as a Word table in an Access form? I am looking for some way of allowing the user to insert and delete rows dynamically. I need to store the data with the record if at all possible. I have tried messing with some of the...

Hi there, Can anyone advise me how the Microsoft Office Spreadsheet 10.0 works? Can it be tied to an individual database record allowing you to store entered information with the record for later retrieval? At the moment all I seem to get with it is a working spreadsheet that loses all values...

Hi there, Does any one have any information about using Access databases on handhelds? Is this possible? I am thinking primarily of Windows CE. Many thanks, Alan

Hi there, Can anyone advise me on the scope or limitations of the Calendar 9.0 control? I am hoping to use it to allow records to be date stamped, (i.e. click on the date on the calendar and have that date recorded with that record). Many thanks, Alan

Hi there, I am attempting to put together a query to allow me to export records from an access database. The records are held in three related tables. When I put the query together in the query window, requesting all fields from all tables, I get a message telling me there are too many fields...

Hi there, I have an Access form that has four fields relating to date and time: 1. Date In 2. Time In 3. Date Out 4. Time Out I want to set up another control that displays the difference in hours between the Date In and Time In versus the Date Out and Time Out. I am struggling on working...

Hi there, Something appears to have happened to my Access application resulting in an error message when I attempt to create and use command buttons. On a new form I can use the “command button” button from the toolbox to create a new button. I go through the wizard choosing the options for...

Hi there, I have just defined a large table of 207 fields. Access let me save this okay and I was adding data when I realised I needed to change some of the number field formats. I went back into the table and changed a fields attributes and click "save". I then got a message telling me...