Recent content by dcarr

I'll give this a go now, thanks

Hi, if I did have -1 for (Non-Smoker) and 0 - (Smoker) or vice-versa, how would I in the form get it to display yes or no? Also in the reports section of the DB I have created Membership cards that relate to the data in the table? How would I get these to display smoker/non smoker if the data in...

Thankyou this appears to have worked. Thanks for the contribution.

Hi. I have a table that I want to use the Yes/No option on a column. Instead of having Yes or No I want the table to display Smoker/Non-Smoker, what is the easiest way to go about this and configure the formatting so when viewed it displays "Smoker" or "Non-Smoker"? Thanks

How do I go about linking a tet box to records in a table. I have several text boxes linking to records in a table named membership. I have set the record source on the form to be the 'Membership' table. And have linked the text boxes like shown below: =[Membership]![Membership No] When I...

Thanks guys that worked.

I have created a blank form and have copied the coade, as well as creating a text box and naming it TextBox, but it still does not seem to work? I am using Access 97? Thanks

I have created several queries of the format Like "*" & [Enter first initial of Surname] & "*". This query prompts the user for some input which they have to respond to. If the data is found great, but if it is not is there any way of reporting this via the query? With an error message 'Data not...

I have a form that I would like to apply scrolling text to? The form is part of a piece of work I am assisting with my brother with? I would like the scrolling text to read 'Welcome to the main menu of Michaels gym, etc......', is there any easy way of integrating this into a form? Thanks

Thanks that worked a treat!!

I would like to create a query that is based on a field surname. I would like the query to prompt the user for the first letter of the surname and for the query to return all those results based on the character entered by the user? I cannot seem to do this any ideas? Thanks

Does anybody know the syntax for executing a DOS command from a MS Access module? Thanks

Thanks for the advice guys

I have a database that is business critical. Over the past couple of months the database has regularly been reaching is maximum capacity of just over 1gb in size. I know really I should be looking at moving the database to SQL server but cost and budgetry restrictions mean I have limited...

This was given out yesterday. He is quite enthusiastic and wants to impress. His current skill set in terms of MS Access is quite limited and he wants to achieve maximum marks, whilst learning as he goes through. I thought if he had one as a sample to reference it may help him. Thanks