Search results for query: *

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

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

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

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

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.

I have a bound listbox in Access2000 that only scrolls after another control gets the focus. I tried passing the focus to another control by code but it doesn't work. I have to click another control by mouse to enable the listbox to scroll. How do I fix this? Also, I would like the listbox to...

I have a database(db1.mdb) with a table(TblRec) In a form I want to connect to TblRec by using an ADO connection but am confussed on the parameters. I want to open the table for reading,editing,del, and adding records thru the form.

I have two table with fields: ID,Date ,Payment 1 , 1/5 , 100 3 , 1/5 , 150 1 , 2/5 , 100 2 , 2/5 , 300 3 , 2/5 , 150 1 , 3/5 , 100 etc... ID , Name ,Due ,Tele1 , Tele2 , Address , .... 1 ,John Do ,100 ,(310)-.. 2 ,Mary J ,110 3 ,Bill W ,100 etc... I want to place values in listview...

I have a table that needs to be displayed in a special way that doesn't fit well with a cross tab query or pivate table. It would be nice if I can use the DBgrid control in unbound mode. Is there a way of placing this control on Access form? A second method would be to use the listbox and set...