Search results

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

YEah!!! Thanks Gambit!!! This searchdB has been downloaded like 300 times!!! Its a blockbuster!!! What's the deal with your signature? Is it pepe le pew????? ze famous french skonk? ;) cheers nico

yeaaaaaaaaaaaaaaaaaaaaah Thanks got your zip file!! for anyone interested the problem is solved here cheers! nico

No one can stop you ancient one! thanks for the help I truly appreciate it. Since I am really new to all this I hadn't seen I had an invalid type for my third combo using numbers.... Thanks again cheers

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

Yeah!!!! I'd like to do those cascading comboboxes!!! But I am not good enough so I'll stick to my first goal which is much easier!! Again, I got this example code from microsoft support and that's the way they were solving a similar problem!! how about changing what I want???? Don't mind if...

THX! Okay I understand verbally what you are saying but when it comes down to editing the code I don't know what to do can you give me a hint please? which code line should I change to get my "fiabilité" recognised as a numbered value? thx nico

Hey ancient! If you downloaded my file, there were stupid mistakes in the properties of my filters.... I changed them It seems like I can now filter for a client which has two opportunities (filter1 on client 1 gives two results) and reduce this to one opportunity on the report by choosing one...

Hey ancient! well I pasted the code that shows the sql statement and when I run my filters the message box gives me the values entered in my three filters.... here's the dbs

Hey thanks for your answer ancient! Here's the full code. I thought it would be too long but if it can help solve the problem... Here you go: Option Compare Database Option Explicit Private Sub Command28_Click() Dim strSQL As String, intCounter As Integer 'Build SQL String For...

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

THx HAYLEY!!!! This is perfect!! I'll change the design but the form is exactly wot I was looking for!!! My app is gonna win an award!!! ;-) I'll check back later and hit the forum with other questions! cheers mates:D :D :D

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

All right jeremie!!! thanks a lot for the tip, it will be useful to me!! c ya around! nico

HEy jeremie, thx for your answer! To your question, yes I want to reset the tables first, I'd like to see the code you are talking about! Attach it to your reply! nico PS: Sorry for the multiple posts but I thought the two topics were related to my question

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! thanks to you all! it was easier than I thought!!! c ya! nico