Recent content by Ali29J

Hi All I have table showing previous years sales based, against month, format as below: PartnerID Type Jan Feb Mar 01113 YT-1 23 55 34 01113 YTD 33 45 33 01123 YT-1 44 55 43 01123 YTD 42 51 48 partner id is customer identification type YT-1 = last...

hmmm very strange when i set date to filter for a day works great when i set to filter for a week from beginning 19/02/07 works great when set to week beginning 26/02/07, finds first date but continues past second date same sort of thing with dates througout march?!? very strange, can anyone...

pampers nice little tool thankyou much cleaner than MS version

Hi Remou The filter works to certain extent, it finds the first date filters from that date, but it does nt seem to be considering the second date??? Ali

I m using the microsoft date and time picker control 6.0. found in toolbox after update it enters the date chosen and enters it into a text box, at present its enterring date and time but i only need the date THanks Ali

great thanks for the help remou

Hi All does anyone know how to output only the date (not time) on the afterupdate of a microsoft date control? THanks Ali

Hi all I am trying to use the following code in the onclick of a command button located on the master form to filter a subform to show records between the dates Me!frmVisitReport.Form.Filter = "AppointmentDate BETWEEN #'" & Text48 & "'# AND #'" & Text50 & "'#" Me!frmVisitReport.Form.FilterOn...

hmmm i must have done something wrong first time round, thanks for your help, worked great Ali

Hi "Report" is a table record in the, not sure how the second solution would work seen as changes would be saved on close??? PJM can you elaborate a little, i ve not used this coding before so i m not sure of the structure, table Record - Report (format Yes/No) table name - Customer Require...

Hi All have a continuous form listing all customers, against each customer is a check box "Report", i m looking to use a command button to set every customers "Report" check box to false, can anyone help with the code to do every line not just one at a time... Thanks Ali

Hi All I have a table with below field names ID Type Jan Feb Mar Apr ..... Dec 001 YTD 12 15 13 20 001 Y-1 15 18 25 17 002 YTD 11 18 13 14 002 Y-1 15 65 11 17 003 YTD 17 18 33 11 003 Y-1 20 44 43 11...

Hi All I have a master form which i would like to total up all items entered in a continuous subform, could anyone help how i could total all values in the filtered continuous form and show it the master form?? THanks Ali

Ok So it seems i ve over complicated this, i just used simple command button, with the following code Forms!frmContactReport!Attendees.Value = Forms!FrmContactAdd!frmContactAddSub!Name.Value So, just minor alteration needed, how do ensure it adds the name to the box rather than completely...

Hi All I have a main form "frmContactReport" with a text box called "Attendees". On click another form opens and it displays all contacts relevent to the current customer (master form with a continuous subform). what i would like to do is check next to the relevent customer contacts which in...