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

Thanks Jack, I'll give it a go and see how I get on. Cheers, 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, Thanks again for the advice. Unfortunatley when I select a query to use as a source in my second query I am still getting the "too many fields defined" message. Any idea how I can get around this? Many thanks, Alan

Thanks very much for the info. Unfortunately I am not sure how you use another query as a source for a second query - can you explain that to me? 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 Ricky, Thanks very much for the help - works a treat. Cheers, Alan

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 Curt, Yup, you are probably right. Unfortunately I am travelling at the moment and won't get my hands on the CD for a couple of weeks. I have managed a work around of sorts. It appears that the error is somehow linked to generating code to perform the button actions. If I use a macro...

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 Pat, Many thanks for the tip - worked a treat. I guess I should look at breaking my table down into more sensible chunks, but I really apprecaite you helping getting me going. Cheers, Alan

Hi Rich, Thanks very much for getting back to me. Yes, you are right, I have been pretty stupid with my table design and I apprecaite that searching etc on a table of that size is going to be slow. I may break the table into smaller chunks further down the road, however for the moment I would...

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