Search results

Hello, I am controling a windows based application with a macro. This application sends multiples spyders to retrieve data from the web. I have about ten different spyders. My problem is that when I create the macro which is gonna run them automatically, they all run together which causes a...

Pease HELP!!! export to Word problem Hello, the code below allows me to open on a separate form one entry of a table with the use of cascading filters. Private Sub Commande31_Click() DoCmd.OpenReport "rptCordisDetails", A_PREVIEW Dim strSQL2 As String Dim intCounter As Integer 'Build...

Hello, I use MS Access 2k2 on Windows Xp. I have created an application thanks to the great concentration of grey matter on this forum. I now get down to publishing my results to my clients in a clean way. Indeed, I want to export my results, and not all the results but only the filtered...

Hello, I want to have a button dedicated to importing text files into tables on a click. Here's the code I was given but I can"t manage to have it work. Both of my field are memo type is there a special declaration for this type of fields? Is the String type OK for this type of fields? Is it...

Hello, I use Access 2k2 on windows XP, when I run a module which parses the fields from table A and extracts the words contained between identified characters (",",";"," ","/","&") to table B, it does the job correctly, but it gives me an error 3021 at the end... here's the code: Option...

Hello, I use mS ACCESS 2002 on windows XP, I want to automate the importation of multiple text files but an error occurs when I run my Import text macro based on the text transfer action. Indeed, Access asks me to choose the format (I use french version sorry, it's the second row from top in...

hello, I am using Access 2k2- I'd like to create a form where the users enter words in a combo box. Then on a click event I'd like to have Access look for each of the words in a specific table and return the hits in a report. I know this question is rather not precise, but I am only starting...

easy SQL statement problem hello, I need to filter data which gives a reliability grade for an entry ([Customers].[Fiabilité%]). I wanna do this by using a combobox which, if selected, will interact on the data shown as all the entries with a reliability grade under 50 will disappear. Here's...

Filter using VB Hello! I use Access 2002 I found this code on the microsoft support site. I tried to use it with my own tables. So I changed the names of the reports and the tables they were refering to in a clean manner. This code is the code of an action button which takes the values from...

Hello, I want to create a dropdown list to filter my results shown on a form. Sort of like a selection filter but for the dates (select offers earlier than... or from the past week,from the past 2 weeks...), or type of activity (identified with an acronym) ... Anyways the problem is the same...

Hello all! I made an application based on an acces form for my final year of study. Since I have to present to my teachers for a final examination, I want to impress them!!! That's why I want to give to my application a professional look, and have, sort of like any regular program, a loading...

Hello, I have created a set of queries and macros which "transform" a mother database into different tables. My problem is that I want to know how I can change a query into a module which will be commanded by a macro. I need to do this because my database treatment will be automatical, and when...

Hello, I have created a set of queries and macros which "transform" a mother database into different tables. My problem is that I want to know how I can change a query into a module which will be commanded by a macro. I need to do this because my database treatment will be automatical, and when...

Hey y'all, I have a table with three fields |KEY|KEY_Tbl1|KEY_Tbl2| The fields KEY_Tbl1 and KEY_Tbl2 each have numbers in them (1,2,3 for field KEY_Tbl1 and 10,11,12 for field KEY_Tbl2). I can count how many 1,2,3,10,11,12 there are in each tables but my real problem is: How can I count, using...

hello, I have a table of results which is like that: ID/ KEYWORD1/ ID-tbl1/ ID-tbl2 This table is the result of a data treatment which takes a KEYWORD from tbl1 and searches this same KEYWORD through tbl2. If a same KEYWORD is found in the two tables, this table of results is incremented with...

hello, I have a table of results which is like that: ID/ KEYWORD1/ ID-tbl1/ ID-tbl2 This table is the result of a data treatment which takes a KEYWORD from tbl1 and searches this same KEYWORD through tbl2. If a same KEYWORD is found in the two tables, this table of results is incremented with...

Hello, I have two distinct tables, from these tables I want to compare two fields containing text values (keywords) whose data type is memo. they look like this: RecID Value 1 tree 1 mountains 2 orange ... 1003 pluto 1003 saturn 1003 mercury 1003 earth but, being a noobie to access programming...

hey! Up to now this function helps me to find within a field the words situated after the word "Keywords:". This is, to talk in a visual manner, the left limit of my parsing area. function: Public Function TheKeyWords(longText As String) As String Dim varPos As Variant varPos = InStr(1...

hello, I have a query based on a module which parses a memo field and which searches through this field for the word "Keywords:". The module code goes like this: Public Function TheKeyWords(longText As String) As String TheKeyWords = Mid$(longText, InStr(1, longText, "Keywords:") + 9) End...

Hello, I have a database with a field containing mutliple words separated by comas . ID Keywords 1 steack, meat, tomato 2 car, porsche, ford 3 food, egg, cow I want to parse this keywords field and to transform this database into another database with a single entry for each keyword...