Search results

I have a database with 200.000 records, how I Add Primary Key Field. I'm getting error "File sharing count exceeded..", tried to increase "MaxLocksPerFile" registry , but without success.

Because of error I cannot enter my query to fix it. Please help.

When I'm runnig the query, I'm getting an error "syntax error in from clause". I can't enter to "design" mode to find the error.

I'm importing MS Outlook Contacts to Access by "Access Link Table". I have a data in "Contacts Note Field", but this field is not importing to Access. Only following fields are inporting to Access. How to fix it?

I have some table , for example: name | mail ------------------------------------ John Smith | John@gmail.com Jack White | Jack67@yahoo.com Mike Baker | mb1578@surfree.com I'm trying to write some macro, when I press it opens new mail...

It solved It solved! SELECT s.Items, s.Manufacturers FROM Table1 AS s INNER JOIN ( SELECT Items FROM Table1 WHERE Manufacturers LIKE [Manufacturer?] GROUP BY Items ) AS r ON r.Items = s.Items Thanks to everybody!

I'm traying to build a query that doing following: I have a table with two columns: items | manufacturers ------------------------------ ABC1 | golf ABC1 | toyota ABC1 | citroen ABC2 | skoda ABC2 | subaru ABC3 | peugeot ABC3 | renault ABC3 | dodge The access ask me for "Manufacturer", when I...

Each item has one or more manufacturers: Is any way to get all the items with all manufacturers where one of manufacturers fit required expression. I will try to explain in example: items | manufacturers ------------------------------ ABC1 | golf ABC1 | toyota ABC1 | citroen ABC2 |...

Thank you ;)

I need to update column 'customer' in table 'db' with a name of a customer. Currently this column is empty from data. I do following , but it doesn't work. UPDATE db SET Customer = 'Microsoft' WHERE Customer=''; Where is the problem.

ajetrumpet, This only one step, according to your code I will get only records that match my criteria. And I want to get "all item" (with all manufacturers) , where one of them match the criteria. Is it possible?

I don't want to do it thru form. I want to do 'Like [Mfr Part Number]' as *<something>* and to get list of all manufacturer part numbers of an item that matches the criteria. Any idea?

I have some database with columns 'Number', 'Mfr Name' and 'Mfr Part Number'. Number - internal catalogue item of a company. Mfr Name - name of a manufacturer where from we purchase the item Mfr Part Number - part number of a manufacturer where from we purchase the item Each item may have one or...

I have some database, I need to replace empty cells one column with some data. But Access does not do it. Any suggestions?

When I write: Select * From a, UNION ALL Select * From b; It works nice, but when I add Select * From a UNION ALL Select * From b UNION ALL Select * From c; I'm getting "Syntax Error In FROM Clause" Sorry for my question, all this really new for me.

I've added following SQL statement: Select * From a UNION ALL Select * From b; How I add to this statement third table (table c)?

I don't want to display all the record by query. I try to create one database table that contains both tables. for example: table1: 123 456 table2: 234 567 New Table: 123 456 234 456

I have two tables of 100.000 rows. Is any way to join them into one table?

I have three tables with a same structure (fields and e.t.c). I wanna append them into one table. How I do it?

Which event to allow to select the item from the Combo Box? I try "click" and "change" events, but it do nothing? Please help.