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 :)
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...
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])
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 ;)
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.