Search results for query: *

Hi all!! Sorry for asking such an esay question ... but what do i have to do to use windows api functions into an VBA access module ? I think I have to include a library, but which one ?? thx in advance

I'm currently developping a database with access 2002 on windows XP. It works well on my PC, and on any other windows XP PC. Now I need to install the base on a windows 98 PC(196 Mo of RAM), using access 2002. When I run Access, I use an autoexec macro to run VBA code. In windows 98, I get an...

In my database, I use replicatoin to allow some users to have the data on their laptop, without being connected to the serveur. After a whole week to setup replication and synchronisation in the base, i thougt all was fine ... Today, I modified the structure of a table, adding a field named P...

I have a table named folder, with a number a description, and what I need is to sort folders by the number and description. The problem is that there are some records with no number, and these records must be at the end of the list, but with SQL, NULL is before other numbers. I can't use UNION...

Hi !!!! I've a table called client. The primarykey of this table is an autonumber. I need to duplicate some clients in the table.So I made an add request which add a record onto the client table using datas from other record in the table. My query works very well. It creates a new record in...

Hi !!!! Is it possible to change the report window size when the user zoom in or out ? At the moment, the report is open with fit, and I can't change the size of the window after zooming, whereas I put resizeable property to the report. So if I could automatically change the size of the window...

I have a replicated database, and a starting function which synchronizate the two replica. Synchronization is a bit long, so I would like to display a message, like "Loading ...", and close it when the synchronization is finished. So I made a form with a caption, and I call it before...

Hi !!!! My database is nearly finished, but I have a last problem to resolve : One of the user is "on the road" 4 days a week, so I think I have to duplicate the base on his laptop for these days. But on the monday, he works on his office, with acces to the server and the master DB...

Hi !!! I have a continuous form with a combobox.Data in the combobox are based on a table : ID | Name ******|********* 1 | name 1 2 | name 2 ... What I want to do is to change the data into the combobox depending on the value of this combobox. e.g : If the value selected...

Hi !!!! In the database i'm developping, I have a report which is saved as a snapshot file every week(with a different name depending on the numeber of the week). I exported it with outputto and it works very well. Now, I want to open these files from access : * show the openfile...

Hi !!!! I'm designing a report based on a query. The report looks like this Header __________________ line 1 __________________ line 2 __________________ ... __________________ line 24 __________________ line 25 __________________ footer Each lines represents a record in the query, but thera...

Hi !!! I have a little problem with reports in my database : I set resizable to True, but when I open it, I can't resize it. I open the report from VBA : docmd.openreport "reportname",acViewPreview, , , acDialog Any idea ?

Hi !!! I have a table names Devis, with many fields(but to resolve my problem, I only need to understand with 3 fields): ______________ Devis Numero | Indice | Montant ______________ _______________________________ Numero 3000 | |...

Hi !!! It should be quite easy, but I am working on it since more than an hour and I feel very ... I have a table with two columns (let's say c1 and c2) Datas are sorted by the first column (c1) Does anyone no a way to set the sort by c2 using VBA ?

Hi !!! It should be quite easy, but I am working on it since more than an hour and I fell very ... I have a table with two columns (let's say c1 and c2) Datas are sorted by the first column (c1) Does anyone no a way to set the sort by c2 using VBA ?

Hi guys !!! I have so many forms in my application that I decided to write a function to kwnow what form to show for each case (I don't know the english for this : maybe form handler) To perform it, I open all my forms as acDialog, so that VBA code is freezed until the form is closed. This is...

Hi !!! I'm working on a report to show data from 3 queries : Firm, employee and notes. In a firm, there are none, one or more employees, and the same for notes. So I put data from the firm in the main report, and others in two sub reports. My problems are : - how can I filter data in...

Hi ! My problem can appear easy, but I'm working on it for two hours and I didn't find any solution... I want to create a column in a table. This is a code, composed with exactly 5 numbers. At the beggining, I used a numeric column, but if I do it, zeros are erased at beginning of code.And...

Hi everybody ! I'm working on an Access application where I have to manage dates and actions (for each date, I have an action) in a table called ACTION At the moment, I display the table ACTIONS in a listbox. So, the date and the linked action are displayed line by line...