Row Source Help! (1 Viewer)

[melvis]

Hi all,

I've got a form in my database that enables you to print or view reports, which I inherited. There is a list box that is automatically populated with all of the reports listed in the Reports tab of the database window. The list box row source says the following:

SELECT msysobjects.Name FROM msysobjects WHERE (((msysobjects.Type)= 32764));

However, I have been asked to create an identical report list that only shows some reports from the database window.

Does anybody know how I could modify the above code to only get reports beginning frm_id for example?

Many thanks

 

[ansentry]

Have a look at the attached sample, this might give you some ideas.

From your post:

SELECT msysobjects.Name FROM msysobjects WHERE (((msysobjects.Type)= 32764));

I may be wrong but I don't think that could be working, I think to should read:

SELECT msysobjects.Name FROM msysobjects WHERE (((msysobjects.Type)= -32764));

 

[melvis]

Hi John,

It won't let me open the database, its saying unrecognised database format. Do you know where I can find this for Access97? Sorry, I should have said what version I was using.

melvis

 

[Oldsoftboss]

Here is a sample of what I did recently for a client. Hope you can understand it.

Basically I created a table that holds the report name as well as a "User Friendly" name. Then print the report they select. This way you can have as many of few as you like.

Dave

 

[melvis]

Thanks oldsoftboss, but I can't seem to open any other databases for some reason. I keep getting unrecognised database format.

 

[Oldsoftboss]

What version of access are you using?

 

[Oldsoftboss]

An access 97 version

 

[ansentry]

here is a verision in 97 - converted from 2003 so you will have to fix any missing references.

 

[melvis]

Hi guys,

Thanks for the examples, I'll have a go and see what happens.

Cheers