Search results

sorry. I just wanted to do a generci search of the table for null values. I am aware of the is null but I have 75 fields with data containing around 1,300,000 records. Just wanted to search the whole table for null values. Thanks

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

Doesnt work doing this. has 0 rows to update

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

Bizarre I know. I could not understand it as I used the same SQL as was in the initial query???? Hey, but at least it worked!!

I created a macro and pasted my SQL into the macro. The data has now been updated. Thanks for the advice.

I have increased the size of the VMS to the maximum allowed but this does still not resolve the problem. I have also inserted an extra 512 mb of RAM so my machine now has 768 mb of RAM installed but I am still unable to update the records in the table??? Any other ideas? Thanks

how do you increase the virtual memory??? on a pc

I have tried the reboot, shut-down, etc... but nothing seems to work!!! Thanks

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

Its ok thanks, sorted the problem. Downloaded the valupack and that contained the data access compoenents I needed. Thanks anyway

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

Thanks very much!

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

I have created a simple piece of VB that imports a .txt file into a table within my MS Access DB. This import specification has worked fine for months but all of a sudden this weekend the import failed to work and returned an error that reads Run Time error 3027 database or object is read only...

I am developing a table that contains a series of values both text and numerical based. In one of the fields CLASS_RANGE I want to specify a range that an item can be associated with. Is the following syntax the correct syntax to use: CLASS_DESC RANGE ========= ======== local...