Recent content by chiuchimuN

Typo getbal([ID]) should read getbal([ID],8/15/09, 9/15/09) DOA recordset calls can't be made in a report module? They have to be in a standard module? I want a DOA solution over a subreport since I just need one textbox at the top with the balance. I've done everything else, that's the...

The table(TB) is: index ID Date Oldbalance Transaction Amount NewBalance I just tried creating creating a function in the reports module that opens a Query and gets the last record for each ID but I get an error. 'In Reports Declare dim DB as database dim RS as recordset 'In Reports module...

I have monthly reports that need to be ordered by date in descending order showing each members purchase and payment activities from the first to the last of the month, printing one page per member. I've been able to do this. The boss wants the last record( mainly the balance ) in the top part...

Does details_print trigger only once or for each record in the recordsource?

This is my second question. I have a report that currentley prints Wednesday 5/23/02 1 John Doe A 2 Mary B A 3 Bill Gates E 4 Mark K D 5 James Q A 6 Tony Z D Todays Total 6 Thursday 5/24/02 .... ... I want to organize it like Wednesday 5/23/02 1 John Doe A 2 Mary B...

I want to make format changes in a report. Rather than create query after query, It would be nice if I could deal with the printing myself. Something like: Report_CurrentRecord(Index as integer,Cancel as integer) if Report.Field(3)="Payed" then Text1.Color=vbBlue End If if...

I've been doing this by VBA code filling in an unbound Flexgrid by textarray(i) but its slow and there must be a better way. Every time I find an SQL technique I notice its always faster and simpler than VBA coding. So, I hope someone knows something out there. Original Table data ID Name...

Thanks, you can Email me the Report chiuchimu@yahoo.com I appreciate the help!

Its for work. I think i'll keep two tables;Attendance and Absents. 1. Sort the Schedule by ID 2. Sort the Attendance by ID 2a. Filter Attendance for the weeks desired. 3. Loop reading the Schedule for ID into an Array 4. Find the first row for that ID in Attendance visible cells. 5. If...

I have a database with student id and day they are schedualed to attend: ID day 101 Wed 002 Fri 203 Mon etc... Another table that contains their actual attendance: ID Att 340 5/10/02 096 5/10/02 112 5/03/02 023 5/03/02 etc... How can I find out who was absent in the last 2 weeks?

I'm using Access2000 and making a report for the first time(I know how to program forms make SQL Queries already). The reports the wizard makes can't be used because the data in a field has to be parsed to other fields by weekday. Database1 fields are: ID , Date , Info 1 5/14/02...

I need a grid that keeps the first three columns of data fixed while horizontally scrolling like the flexgrid "fixed column method". But I also need to resize the columns if records don't fit in cell like the listview allows. I can't bind the control to the records because of the way...

JohnYingling, you're right about Keypress() Vs change(). The change event worked in VB but not in VBA.

Did'nt work. I'm actually doing this in VBA (Access2000) so maybe this is why I can't trigger function from Keypress.

I have a search function that finds a listview match from a textbox and scrolls to show this match. The function works fine when placed in a buttons click event but won't start when placed in the textbox keypress event. Command1_Click() SearchShow end sub Text1_KeyPress(keyascii as integer)...