Search results for query: *

Hi, I have a form with 2 comboboxes and one datagrid. I want to use these 2 comboboxes to filter the information from datagrid. I have in the first combo all countries from table country in the second one: all cities from the country that is selected in the first combo (table city) I want in...

Hi, I have an application with a SQL server database and using VBA, also some temporary tables in Access. I need to make it working for being used by more than one user in the same time.My boss wants to have the entire database on a network server and everyone shares the data and uses the same...

Hi! My problem looks something like this: I have some sequences, every sequence has some steps.Every step is a function.Of course, every step, function can have one or more arguments. for every sequence I have to call every function with its own arguments. these things I have in a DB. I have the...

I have a listbox with columncount = 2, boundcolumn = 1 and Multiselect = extended. I need to use the values selected in this list from the second column. For ex, if the user select World Markets;http://stocks.onvista.co.uk/overview_quotes.html?ID_OSI=85374; AND...

Hi! I want to compare the text from 2 different files, to see if there are some differences. Do you have any idea how can I first open these files to have the text from them? (in VBA) I have the path and also the file name in 2 variables. Thanks!

Hi! I have a list box with Row Source Type: value list. I want to delete all duplicates from this list(every value to be found just one time). Do you have any ideea?

Hi! I wanted to use a common dialog control in Access 2003 but I dont have this in Components. So, I use a code from http://www.mvps.org/access/api/api0001.htm. The problem is that I can browse but not open (when I press open its not doing anything). Can you tell me where is the problem?! thanks!

Hi! How can I verify if a string contains numbers or only letters?! and, if its possible, to verify if the numbers contained in this string are in a specified interval, like 0 < x < 100.000 Thanks!

Can you tell me, please, how can I add values in a list with 2 columns?! (ColumnCount=2) First column: lstLinks.AddItem MyBrowser.Document.links(i).innerText second one: MyBrowser.Document.links(i).href thanks!

Hi! I have a form with a web browser control.I want to print the information from this web browser (navigate through one web page).Until now I can preview and print this, but if I want to save in a word document it doesnt work. I can save this as a html file or txt file, but thats all...

I need to have in a report some information from Web pages. I have this information stored in a table in text format (.innertext) and also html format (.outerHTML). I can open this in a form in a web browser to see it. But, if I put in a report the information in text format, of course it doesnt...

I have 2 tables like this: dbo_link and tmp_link. I want to delete all records from dbo_link that are in tmp_link also. the problem is that the field url from both tables is a memo field, and I cant use a memo field in a subquery. strsql2 = "delete * from dbo_link where dbo_link.url in (select...

I have a problem. I have 2 recordsets rs1 and rs2. I want to delete all records from rs1 that are in rs2 also, so just the records that I find in both recordsets. and then to delete from a table all records that are in rs1. rs1 = CurrentDb.OpenRecordset("SELECT DISTINCT dbo_link.url as url...

Hi! I have 2 lists with urls. I want to delete all records from a table (link) if link.url like list1.column(0)and not like list2.column(0). so, to delete all that are in the first list but not in the second list. I have this: strsql = "delete * from dbo_link where dbo_link.url like '*" &...

I have a table with a structure like this : {id, url, content}. This content is all the text from a web page(memo). The problem is that I need to look in this content and to find some words and extract them. the table is called Link. I have this code , but it doesnt work. Do you have any...

Hi! I want to save all the content, the text, from a web site into a text file.now I can see this text in a msgbox like this: strtext = MyIE.Document.body.innerText MsgBox strtext But, sometimes, if the text its too big I cant see all of it. And I need to save this in a database...

Hi! I have a problem in finding the best way to store all information that I can find on Internet about every company into a database. I mean, I need to find an Entity Relationship Model. But,I am confused, because first I thought to have something like this: Branch{id_b, branch} Company {id_c...

I need to know the size for every web site resulted after a google search. I have these pages from Web into a table and a combo box, too. I want to find a solution to be able to find their size, to know if they are 'small', 'medium', or 'large' sites. if u have any sugestions,..

I have a list box with all web sites resulted from a google search. I want that when I double click on one link from the list to be able to open that page. I can do this in VB using list property, but in Access? I send u a piece of my code for DblClick event in VB: MyBrowser.navigate...