Search results for query: *

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?

The table with the criteria contains just one row and one field. I need to use the value in that field as the criteria in my query.

I have a query set up that needs to get a criteria value from a field in another table. So far I have tried writing the criteria as: =[table]![Field] The query asks for the parameter so it's not reading the value in the field. I really have no idea how to set that up, is there a way of...

Does VB code actually run sequentially? It appears to process a block of code (inside a loop or with etc) then return values to the begining of the loop, execute them then move to the next block. This means my loop at the END of my with statment is effecting the begining of the block of code!

It is actually the last one that is not being displayed (the last record). I also pasted the wrong loop, the main one is: Do While i < .RecordCount '+ 1 frmMain.lstMainContacts.ListItems.Add i frmMain.lstMainContacts.ListItems(i).SubItems(1) = ![Surname]...

I have a ListView control that is being populated via a loop from a database. The loop is quite straightforward: .MoveFirst i = 1 Do While i < .RecordCount frmMain.lstMainContacts.ListItems(i).SubItems(4) = !_[Phone] .MoveNext i = i + 1 Loop This works okay except the first record...