Search results

I have Multiple Table all in the same Format... I Can create a query to select all the data which has "Name" in Collum1.. But i Dont want to have to recreate this query for all 700 Tables.. So can i create a query that ask for Table Name or Source Table before running???

Ok the latest task, i have to create a query, that works in a similar way to the find duplicates query... however is has to look through "query1" and count common phrases for example.. if the word "sand" appears in query1 "row 7 colum 4" and "row 8 colum 9", it would produce a table which...

I have a "mainForm" which contains a "subForm" (container) Can i create a button on the "mainForm" which will search for a record and find next record for which ever form i currently have in the "subForm (container)" thank you

I have a data base with multiple tables, example t1, t2, and t3 i want to create a query that will search all data in "t1, t2 and t3" and find a word i specifie... for example i run query and get a popup box i type sam...and it produces a result that says i have 6 sams all together... any...

I have a form say "form1" which contains a subform "form_sub" containing "form2" can i put a text box with a button on "form1" that will change the contense of "form_sub" to what ever is in the textbox, e.g. "form2" or 3 or 4 etc...

I have an html file with hundreds of tables in and i want to import them into access when i try this is says there is more than one table please select which one u want, but i want them all is there a easy way to do this????

Hi im not sure if its a macro i need BUT.. I basically need to take a table that i have and split it into seperate tables at every 30 lines intervals...e.g. line 1-30 become table one... 31-60 become table two... also while doing this i need it to remove all rows with null values any...

is there anyway of sending an inturnal message to those logged into my shared data base, i no who they are there machine name and thats it- i have heard of this net send command but its not working in command promt, i was wondering is there a way through access 2003 to do it ???

i have asked b4 how to see who is logged onto my database? i found this out using this code :::: Sub Show() Dim cn As New ADODB.Connection Dim cn2 As New ADODB.Connection Dim rs As New ADODB.Recordset Dim i, j As Long cn.Provider = "Microsoft.Jet.OLEDB.4.0" cn.Open...

I used the big name to attract attention lol... my problem: i look after a large data base on a shared drive we are talking massive that hundreds of people with different user names and user rites use... no when it comes to editing the data base this is very hard because it means everyone...

I have created a database on a shared drive...and using the normal access user and privliages tools ive made a admin and a user account however it only works for the one pc i created it on, WHY i need major help with this as there are about 2000 computers that all use the data base and i...

Why is it when i move my whole database the user name and password features no longer work ?????

is there any way of creating relationships between two tables where i go from table1 primarykey to table 2 notprimary key however hav it show on the table2 the one without the primary key like the little plus thing because at the moment it will only show on the table where i have selected...

I dont no if this is even possible ive never heard of it being done but it would be kool... i have created different users for my data base now if a normal user clicks on the button for admin area it tells them they dnt have privlages etc ( u no the default popup ) however i was wondering...

Situations - i ahve a large LAST names database i want to changed all the "CURRENTS" to "NEW" casue they got married lol... is there something i can add to the critia box so that, it gives me two pops up firstly "enter current name" so i type "CURRENTS" and it shows me them all then a...

My problem - i have a huge data base with 1000's of items and i have created a query with the [enter name] as critier but of course i have to enter the name perfectly which is hard to remeber all those names... is there any way i can create a query still with an enter name box however when i...