Recent content by camelman

Ahhhh. ok ... 2 ways to skin a cat. That works the same as binding to the 2nd column like I was doing. I tried it your way and the problem remains the same. The values still dissapear. I have put an "on enter" event on CmboCompanyMember to requery it. Otherwise you can select a company in 1 row...

Your ADP file has forms and reports just like a normal access file does. Go to forms and try to create one. The query's section works quite differently though.

Hey guys. Thanks for all your speedy responses. I think you are all missing the point of why this is a problem. This is not as simple as it looks. CmboCompany: select company.companyName, company.companyID from company CmboCompanyMember: select member.surname, member.memberID from member where...

I have a bound continous form with 2 comboboxes on it. A [company] combobox and a [company_member] combobox. If you select a company it should update the rowsource of the [company_member] box to only show the members in that company. Both combo boxes have BOUND COLUMN = 2 (So that I can...

This is actually quite easy. In access click file/new and then specify "new project" (not blank database). This will create a .ADP file (not an .mdb file), Select your server from the list and you now have a blank access project. Any tables you create will be created on your SQL server. A few...

Thanks guys. Works like a charm.

Then you and I have the same problem. I have posted a question called "more problems with max querys" it is driving me nuts. I have a solution for you but it is really slow if you have alot of records. I am using it until I find a decent solution. Create VIEW1: Select...

Hi people I have a table called receipts in a SQL Server Database. I want a list of clients, their last receipts (according to date) and the details of these receipts. ie: If there are 100 different clients in the table (each with 10 receipts) then I should only get 100 records returned. The...

Did that work ? I am trying to do the same thing and I got the highest pagenumber and the highest page ID even though they were from different records. What I am trying to get is the highest pagenumber and then the corresponding pageid for that record. Camelman

I just upgraded my machine recently to a thunderbird 1400, 512MB Ram and a 19" monitor. This was a bankrupting experience but one I found well worth it. I am going to install the release version soon so I can start playing around with it. My worry was not so much that it would crash but...

Thanks I look forward to hearing about whether the release version has many bugs. I will probably use VB and not C# because I am more familiar with VB. I haven't worked on C since I used visual C when I was studying and found it painfully difficult to get my projects to compile.

Have you used .net to create applications yet ? Did you find that it behaved and did what it was supposed to? Any major bugs to report? I really appreciate the advice you are giving me, I am finding this a hard decision to make but it looks like .net is the way. Camelman

This should spark off quite a discussion. I have been talking to developers about what they think I should be using for developing client server apps. The ones who have worked with VB6 and Java all say that things just work better in java. They have to fight with their VB code to get things...

Hey guys I can't seem to find code that sets the homepage of netscape 4 and IE 4 upwards. I want to put a "make this site your homepage" button on my site. Thanks

A last comment to add on to Dawns excellent advice. Check that you are only sorting in the last query. If you have any sorts in the queries that make up your final query they will only slow things down.