Search results

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

Hi guys. Does anyone have a copy of a video database they have created??? My younger brother is trying to do this for his school work and I would like to help but have a lot on at the moment. If I have a sample I can give him some pointers, etc on what to follow, etc. Thanks guys.

I have a series of records approx 120,000 that contain personal information on individuals. I am trying to export this list to a new table that has a series of pre-defined constraints on the fields. Some of the data I am trying to export contains invalid values i.e. not the correct data type...

I have created a table that contains in excess of 1,100,000 rows. However I do not have a unique record (key) for each row due to the way the system was set up prior to my extract. Is there any way I can created a formatted field that looks something like this INTELL0000000 - where the count of...

Thanks very much that worked a treat!!

I have created a query using an IIF statement. In the query I would like to search for a string and replace text based upon the criteria in the IIF statement. The query is shown below: Local_Advert_Type: IIf([JanData02]![Client_Name] Like "++CLASSIFIED","C","D") This like statement does not...