Choose required IDs to put on a report

[Only1Abhi]

Hi.

In a form, Is it possible to select certain records that I want, somewhere on the form where I could specify what records I want... from a table with many many records) and put that on a report?

Anyway, many thanks in advance!!!

Regards,
Abhi

 

[scriverb]

Check out the code in this thread:

thread703-501270

Scroll down to CosmoKramer's post where he lists the code. It is quite a unique way of allowing the user in a free format to select multiple records for a report/query. Bob Scriver

 

[Only1Abhi]

Thanks again for the help Bob.

I have checked that thread and it doesn't have CosmoKramer's post. Can u plz help me?

Many thanks!
Regards,
Abhi

 

[scriverb]

Here is the appropriate thread for your problem.

thread703-500227 Bob Scriver

 

[Only1Abhi]

many thanks bob.

really appreciate it.

I'll let u know how I got on.

Regards,
Abhi

 

[Only1Abhi]

Hi Bob.
Tried the solution of Cosmo's.

Eventually, I ended up with many many problems in my database and decided to scrap this idea.

Do u know any other solutions in VB?

Many thanks,
Best Regards,

Abhi

 

[scriverb]

There are a number of other solutions. Before we continue what were the problems that you experienced with the code that I recommended?

How many records are being selected at a time? Are we talking about a large number and are they identified by a certain code or record type. You see we could use a ListBox of all of the records in the table and have you select the records that you want.

Provide me with some of the specifics of your needs. Bob Scriver

 

[Only1Abhi]

Hi Bob,
The problem is that the modules code didn't work at all. Maybe because I didn't know how to set it up but someone else in another forum who had a look at my DB recommended not to use modules for my project because of something called runtime error (what is that? I have no idea).

Anyway, here's what I want to do.

Tables: tblTransaction.
Form: frmFax.
Report: rptFax.

I want to select certain records from tblTransaction and be able to view that in a report.

I want to specify WHICH record (to put on the report) somewhere on the form frmFax.

Each record has a unique TransactionID.

RECAP: In frmFax, I should be able to enter a list of all the transactions I want (by entering the transaction IDs) and then be able to view this in a report called rptFax.

Can u plz help me solve this problem??

Many thanks Bob!!!
Best Regards,
Abhi

 

[scriverb]

Just a quick one. What would be the max. or upper limit of the number of transaction ID's that you would request for the report? Just give me a feel for the volume here. Bob Scriver

 

[Only1Abhi]

there wouldn't be a max/upper limit for the transaction ID.

What would happen is that I would write down a list of transaction IDs. I then want to enter this into the frmFax and then the report should show ONLY these IDs.

The IDs are ordered (i.e. start from 1 and go up serially).

I may want to enter stuff like 1-15,17,19,20-22,24
That kind of thing.

The transaction IDs can go on forever (serially).

Many thanks
Abhi

 

[scriverb]

Okay, do you want me to help you get that code to work tonight or wait until tomorrow morning? Bob Scriver

 

[Only1Abhi]

sorry, i guess im a bit late in reading the last post.

how about now?

many thanks,
regards
Abhi

 

[Only1Abhi]

Hi Bob.

Can u plz get me the codes in VB mode or normal mode?

Your help is very very much appreciated.

Many thanks in advance.
Best Regards,
Abhi

 

[Only1Abhi]

thanks Bob

I think I've come up with my own solution.
I seem to understand that the most.

I was wondering whether you could shed a bit of light on that matter.

Here is what I intend to do...

1 Create a new table with just 1 field called "ReferenceNo" which will be linked to the field "ReferenceNo" from orginal table "tblTransaction" via a query which shows only records that match in BOTH tables.

2. I will create a form of this new table. Here I will be able to enter which records I want and then the query should return only these records from the original table that match ReferenceNo s entered in the form.

Now my question is:

1. Assuming I haven't entered any ReferenceNo s in the new table, is it possible to have ONLY 1 text box in the form? And when I enter the 1st ReferenceNo here, another textbox automatically appears? And then another appears when I enter the 2nd ReferenceNo.... and so on...

Many many thanks...
If I get the answer to this question... I think my system will work...

Many thanks
Best Regards,
Abhi