Search results

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

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

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

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

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

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

Hi, is there anyway you can create a query to search a whole table for null values in any column? I

Hello guys. I have just bought a copy of office xp. I have installed the latest service packs, etc, to bring it up to date. However, when attempting to import a foxpro tables into my new database I do not have the option files of type -> foxpro. I do not have half the files of type I had on a...

I am attempting to join two tables by two common columns. The columns are named AD_TYPE and GRP_FDC. The tables are named tbl_FDC tbl_CLASSIFIED. In the tbl_FDC there are a series of AD_TYPEs with the advert type zz. With a corresponding GRP_FDC, typically OTH, BMD, ETC. I have a problem in that...

I want to create a query that deletes duplicate rows from a tables. I have created a find duplicate query that finds the duplicates based on a value but I want to turn this into a delete query. I tried to write a delete query that deletes the field where the count is greater than one, but this...

I am trying to create a query that updates a series of values in a table from one value to another. In the criteria field I have specified the value -1 and in the update to field I have specified "A". When I run the query however, the values do not get updated to the update value? I get an error...

When attempting to create a link to a foxpro table within access, before I bought a new machine, in the list of file of type there were a series of options available to me i.e foxpro, dbase, etc,. Now after installing MS Access on my machine none of these options are available except MS Access...

When attempting to use the Link Table manager to re-establish several links I have within my database I receive an error message that reads unable to find installable ISAM??? I have attempted to re-run the installation of Access including all possible elements that come available on the disk...

I am trying to install Access 97 from the Office 97 Pro CD on my Win XP machine. However, after the installation has been completed when launching Access I receive an error message that reads 'CANNOT OPEN APPLICATION. LICNSE NOT FOUND ON MACHINE'. I appreciate this is not really an Access query...

Hello guys. If I want to create a field in my query that is not available in any of my tables but is needed for an extract, how do I create the field in the query so the field value is NULL. Can this be placed in the query or should I create the query as a make_table query then add the field to...