Search results

Thanks for your good will, I did delete the field time and changed the field date to 'general' which includes the time. I have 5 fields in my table. An autonumber 2 text fields just for information The date which fills automatically when I enter a new record. 1 text field with the name of a...

Hi Galaxiom, Sorry my English is not so good. I would like to put the propriety visible of all (same) names on false behalve the most recent. Checking date() and time() Thanks, Jackske

Hi Galaxiom, Thanks Next the name, I have also date() and time() Thanks in advance, Jackske - Belgium

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

Dear Peter, :) I am afraid that with such a name you have to be a man because I want to kiss you on your lips. You resolved my problem. I would never have find this by myself. Thanks a lot Jackske/Belgium

Dear Peter, Thank a lot for your fast reaction. Here is the code I wrote following your instruction -------------------------------------------------------- DoCmd.SetWarnings False strSQL = "UPDATE tblLeden SET tblLeden.lidgeld_betaald = 'J' WHERE tblLeden.ID=3;" DoCmd.RunSQL strSQL...

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

Thanks Pat but this is not working. I did find the solution on a google forum. You have to define the orderby of the sub-form in the main form. Set the OrderBy (and set OrderByOn to true) for the subform in the OnOpen or OnCurrent event of the main form. Something like: Me![name of subform...

I did find on a google forum the solution of my problem. You have to define all in the main form. Here is the solution Set the OrderBy (and set OrderByOn to true) for the subform in the OnOpen or OnCurrent event of the main form. Something like: Me![name of subform control].form.OrderBy =...

I got the solution I did find on a google forum the solution of my problem. You have to define all in the main form. Here is the solution Set the OrderBy (and set OrderByOn to true) for the subform in the OnOpen or OnCurrent event of the main form. Something like: Me![name of subform...

Strange no? Dear Thread, Thanks for your good will but I did not solve my problem. I did put a filter in the properties of my form (MemberNr=320) and I did put an order in the properties of my sub-form (OrderBy = date_of_payement). The strange thing is that when I open my form, I get the record...

strange result Dear Doc_Man, Thanks for your good will but I did not solve my problem. I did put a filter in the properties of my form (MemberNr=320) and I did put an order in the properties of my sub-form (OrderBy = date_of_payement). The strange thing is that when I open my form, I get the...

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:

Yes, I want to count the number of records!

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

thanks but it did not work. I had to create first a table and after this, to check if the table is empty. Never less, 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

soory if I am abusing Sorry, if I am abusing but what is an Outer Join? Jackske/Belgium