Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations MikeeOK on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by newbilko
-
Changing between form View types.
Hi Thanks for the reply! I now have the original form incorperated into a new one as a subform. How do I create buttons that control the subform rather than opening up the form again in a new window? Also using the toggle buttons it should be possible to switch between modes i,e when the...- newbilko
- Post #3
- Forum: Microsoft: Access Forms
-
Changing between form View types.
Hi, This may seem like an odd request but I am trying to make an "idiot Proof" database. I want users to be able to switch between "tabular" and "Form" views by pressing a command button on that particular form. I have found that users do not want to, or do not understand how to use the...- newbilko
- Thread
- Replies: 3
- Forum: Microsoft: Access Forms
-
Returning highest number in a row
In case anyone is interested a friend provided me with this solution for returning the highest value (plus 1) in a list of numbers in 2 different tables. (Collumn with numbers (numlist) has the same name in both tables) Solution: SELECT 1+Max(numlist) AS HighestValue FROM [SELECT numlist FROM...- newbilko
- Post #5
- Forum: Microsoft: Access Queries and JET SQL
-
Returning highest number in a row
Following on from this how can the above solution be applied to 2 tables. I.e. Find the highest value accross two tables? Thanks- newbilko
- Post #4
- Forum: Microsoft: Access Queries and JET SQL
-
Returning highest number in a row
Thanks!! Thats got it.- newbilko
- Post #3
- Forum: Microsoft: Access Queries and JET SQL
-
Returning highest number in a row
Hi, This may be a common question. I am creating a library database for a large number of data CD's. The catalogue uses a simple disk numbering system, i.e 1,2,3......n. I want to be able to run a query that tells the user what the next disk number should be (as the disks are often not...- newbilko
- Thread
- Replies: 4
- Forum: Microsoft: Access Queries and JET SQL
