Search results for query: *

Hi! When a user access my database, the first thing that is done is the execution of a macro. In the macro, a table is first opened and the user is asked to enter his userid and password to access the database. Even if the user enter a wrong password, he gets a couple of error messages but...

All i want to do is calculate the difference between the date field in the current record and the date field with previous record. I have tried to modify the code from the thread "query to compare data with previous record" but i do not understand it and finaly do not get any result(but many...

I, Using Acces97 i'm trying to reset the page number to 1 on a group break. Here is my code: Private Sub PageFooter_Format(Cancel As Integer, FormatCount As Integer) Dim i As Integer ReDim Preserve GrpArrayPage(Me.Page + 1) ReDim Preserve GrpArrayPages(Me.Page + 1) If Me.Pages = 0 Then...

Hi! I have just converted an Access97 database to Access2002. The conversion seems to work just fine except that now, some dates do not appear in the reports. The way it works is: - i open a form where i fill in the dates (min and max) i want to use for an extraction - i...

I, Using Acces97 i'm trying to reset the page number to 1 on a group break. Here is my code: Option Compare Database Option Explicit Dim GrpArrayPage(), GrpArrayPages() Dim GrpNameCurrent As Variant, GrpNamePrevious As Variant Dim GrpPage As Integer, GrpPages As Integer Private Sub...

Hi! I have an Access97 database that begin to be very big and that refers to different applications. That database is used by many users at the same time. Is there a way that i could split that database into 2 or 3 smaller databases and access these new databases from a main one thru a...

Hi, I generate a report with groups(salesman). The name of each salesman appear in the group header... and the last salesman name appears also in the report final page header(footer). How can i reset the salesman's name so it won't appear on the last page of the report? Thanks Aietoe

Hi, Using Access97, i have a database that is used by many users. In a query, a table is updated with a field "Currentuser". I always receive the identification «ADMIN» from whatever user is updating the table!!!!!! Any hint would be appreciated. Thanks Aietoe

Hi! I have a graph showing amounts over 3 years A table holds the relevant data as follows: Months Amount 1999-07 1000 1999-09 200 2000-01 600 2000-03 800 The x-axis is the amounts from 0 to 1000 The y-axis is holding the months. The graph looks like...

Hi, I created a very basic graph in Access97 reading a table with 2 columns: period and amount. i have 72 entries(bottom axe of 12 months X 6 years) and my vertical axe shows the amounts. Originaly, my page size was "US letter", and my graph looked fine. To make it more...

Hi, i'm trying to run a query using the "in function" in the criteria area. My problem occur because i want the "In function" data to come from a form. Here is my query: SELECT DISTINCTROW PROD_I_SMOD_SR_ACTE_MD_NOMTF.SMOD_NO_DISP, PROD_I_SMOD_SR_ACTE_MD_NOMTF.SMOD_COD_ACTE...

Hi, Using Word and Access 97 in a mail merge processus, i would like to give the opportunity to my users to decide the kind of paper to print on(us letter or us legal), the orientation of the paper(vertical or horizontal) and the number of side to print(duplex or not). I would like to do it in...

Hi! Using Access97, i have a query that creates a table with many fields that are used afterword in a mailmerge with Word. One of the field is a date that i format the following way:jjjj" le "j\ mmm", "aaaa and the date comes out in the table like this:Mercredi le 14 aout...

Hi! Using Access97, i have a query that creates a table with many fields that are used afterword in a mailmerge with Word. One of the field is a date that i format the following way:jjjj" le "j\ mmm", "aaaa and the date comes out in the table like this:Mercredi le 14 aout...

Hi! Using Access97, i have a table that looks like this: Name date1 date2 date3 BOUNxx 00-10-10 00-10-12 00-10-14 COLDxx 00-10-10 CYRPxx 00-10-12 SCIFxx 00-10-14 How can i change it to this...

Hi! Using Access97, i have a table that goes like this: Cust# Prod# _______________ 0001 1234 0001 2345 0001 3456 0002 4321 0002 5432 0002 6543 and i would like to create a table like this: Cust# Prod1 Prod2 Prod3 ________________________________ 0001 1234...

Hi! Doing a merge mailing using Access97 and Word97, is it possible to code a macro so that the user is given the opportunity to choose the name of the Word template he wants to use and pass it to the macro as a parameter(similar to what we can do in an Access query)? Thanks Aietoe[ponder].

Hi, Using Access 97, i call a macro from a form that does the following: 1- Make a control invisible on that form; 2- Call Word for a mail merge. When i run tha macro step by step, the control becomes invisible whitout any problems. When i run it regulaly, the control stays visible. Why is...

Hi! Using Office 97, i do a merge mailing in Word using data that comes from a table in Access. One of the field is a date with the following format in Access: YYYY-MM-DD In Word, i convert the format using the following formula:{CHAMPFUSION DATE \@ " JJJJ, J MMMM, AAAA"}} .It works...

Is there a way in a Word Macro to format a page to, let say, print on both side? Thanks Aietoe[ponder].