Recent content by rickyoswald

Basically the code does what I want it to do provided there is only the one table involved in the query. If a second or third table is introduced, I get no error, it simply stops executing the code. I am totally stumped by this. I will tell my DB guy to check his naming criteria :)

Typical MS.

I have three tables; tblQryID, tblClients and tblCases. tblClients holds client info and tblCases holds case information while tblQryID holds a string from a VB app. There is a report called rptClientCases which holds information from the tables tblClients and tblCases, these are connected as...

I am not sure what units it is measured in but in Access 2003 I can only stretch it out to '56', which is about two and a half pages in landscape. Is there a way to stretch it further?

I have three tables; tblQryID, tblClients and tblCases. tblClients holds client info and tblCases holds case information while tblQryID holds a string from a VB app. There is a report called rptClientCases which holds information from the tables tblClients and tblCases, these are connected as...

The criteria works if the query only contains data from one table. If there is more than one table it ceases to work. Why is this?

I moved all the relevant fields from the different tables into one large table, then sorted this by date. Thanks anyway.

I am using the same criteria on several queries; (SELECT[Field]FROM[Table]) Where the Field is ID and the Table is tblQryID. A Visual Basic application sends data into the field then any records in the query whos field with the criteria does not match that of the on the criteria points to...

I have several actions and the times they were carried out stored on several tables. I need to list all actions in a report ordered by date, my problem being there are several date fields relating to only their own table. What I need is to have one list of dates which for each day can call up...

It does work. Here it is again: To set the criteria of a query to that of the data in a field on a table simply enter the criteria as; (SELECT[Field]FROM[Table])

Possibly (SELECT [FIELD] FROM [TABLE]) I'll get my DB man to try it and tell you if it works!

How do I set the Criteria of a Query to that of text in a field on a table? The MSDN has suggested; In("Canada", "UK") For a ShipCountry field, orders shipped to Canada or the UK In(France, Germany, Japan) For a CountryName field, employees living in France or Germany or Japan Which to me...

Thanks again Mark. My friend used my account to make this post, he has fixed the problem but (unfortunately) says he dosen't know what your talking about! Don't worry, I think it's just him ;)

Coincidently I already have a first column which is blank and hidden away. This is beacuase the first column cannot have text aligned in the center!

Did you miss out i = i + 1 on purpose?