Search results for query: *

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...

...dim DB as database dim RS as recordset 'In Reports module private function GetBal( ID, DateStart, DateEnd ) dim Str as string str="select * from TB where ID=" & ID & " and date >=#" str=str & DateStart & "# and date <=#" & DateEnd & "# " str=str & "order by Date dsec, index desc;" set...

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)=&quot;Payed&quot; 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 &quot;fixed column method&quot;. 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)...

Found it. EnsureVisible method.

There is a control called file listbox thats part of the built in controls of VB. Set the path to the directory of the files File1.path=&quot;C:\MyFolder\&quot;

My second listview question. Iv'e seen many programs that let users drag a listiem up or down the list by dragging. Examples are Internet Explorer favorites list,Winamp playlist,Reget downloaders list etc.. Currently I use to buttons to accomplish this but would like to learn how to...

Iv'e seen the code in this forum but could find it in the search. Basically I want to move the visible listitems up or down in code(scroll). The MSDN help file index does this,WinAmp playlist does this, and so does Access tables.

Thanks for the info guys. I'll make my next project ADO. This time I'm sticking to DAO and use ADO after a little experimentation.