Search results

Hi, I have a form based on a table ordered by 'name'. If the same name appears several times, I would like to change the propriety of all same names (except the last one) to visible=false. Thus I will only see in my form the most recent record with this name. Thanks in advance, Jackske - Belgium

I am French speaking, so sorry for the faults. I made a new module In this module I did a "Sub" I this Sub I search for a value in a table "A" Now, I want to change the value of a field inside an other table "B" How can I do this without leaving my Sub ? Thanks in advance, Jackske/Belgium

Every time when I write a letter, I add a ref. number. I would like to write a macro that remembers the last ref. number and add 1 to this number every time I call it. for example: I have a letter with ref:001/2006; next time I call the macro he has to fill in ref:002/2006. Thanks, Jackske-Belgium

I have a form (Members of the club), linked to a sub form (payments of membership). When I open the record of Mr John, I want to see all his payments order by date of payment. How do I do? Thanks in advance, Jackske - Belgium :confused:

I have a form (Members of the club), linked to a sub form (payments of membership). When I open the record of Mr John, I want to see all his payments order by date of payment. How do I do? Thanks in advance, Jackske - Belgium :confused:

I did a query which shows all record with 'Y' in a field. I would like to have also a field with the total of all the records in this query. The problem is that the field with 'Y' or 'N' is a text field. Thanks, Jackske/Belgium

I have a form based on a query. I want – before the form appears on the screen – to check if the query is empty or not. Via which Event can I do this and what is the code. Thanks, Jackske/Belgium

I have a main table and 2 sub tables which are linked to the main table. I put all of them in 1 query. The query shows me only those record where some data are also inserted in the sub tables. That is NOT my wish. I want this query to show me all records even if there are no data's for this...

at one go How can I convert at one go all the records in a table to vbpropercase? Thanks, Jackske, Belgium

I want to change all names to vbpropercase via an update query. I did put the field "Names" in my query and wrote in update names:strconv(names,3). It does not work. Thanks in adavance, Jackse Belgium :o

I have a table call Members In the table, one of the records is called 'rank' I want to write some code to replace the rank with a value. For example, in the first record, rank has to be replaced with number 67 In the second record, rank has to be replaced with number 68 etc… I made a new module...

I have a table call Members In the table, one of the records is called 'rank' I want to write some code to replace the rank with a value. For example, in the first record, rank has to be replaced with number 67 In the second record, rank has to be replaced with number 68 etc… I made a new module...

I have a group of 2 tables (members & gifts), which are linked. I have an other group of 2 other tables (members2 & gifts2) with identical structure as the tables of the first group. I one to add some records from the 2 tables of group 1 to the 2 others tables in group 2. An 'append query'...

About the DCount function. Dcount (“[Field]”, “Table”, “criteria”) I am calling this function from a form while I am adding a record. I use the criteria argument to compare if the ‘Name’ in my table is = ‘Name’ in my form. The syntax of the criteria is...

About the DCount function. Dcount (“[Field]”, “Table”, “criteria”) I am calling this function from a form while I am adding a record. I use the criteria argument to compare if the ‘Name’ in my table is = ‘Name’ in my form. The syntax of the criteria is...

About the DCount function. Dcount (“[Field]”, “Table”, “criteria”) I am calling this function from a form while I am adding a record. I use the criteria argument to compare if the ‘Name’ in my table is = ‘Name’ in my form. The syntax of the criteria is...

Hi, I want to permit the user to go back to the main menu by pushing a function key (for example F2) Does anybody know the VBA code for it? Thanks, Jackske/Belgium

What is the visual basic command to open a form on the size that you obtain when you push on the square “restore down” in the upper (right) corner of the form. Thanks, Jackske Antwerp/Belgium

I want a specific event to happen "on exit" of a field except if a specific "command button" is pressed. How can I have my "event on exit" to control which button was pushed to exit the record? Thanks, Jackske-Belgium

I made first a Table with 1 field 'Name' I made a form with 1 field and I try to start this function 'on exit' I was excpecting to seen the value of the fiel in the variable 'Seen' ------------------------------------ Public Function Show_Me(Seen As String) MsgBox "The result of this function is...