Search results for query: *

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.

Compact and repair is a tool for compacting and repairing your data. It doesn't in any way optimize your queries. Access has an optimization tool which tells you how to change the way you have set up your tables to optimize performance but it doesn't make any changes itself. When stringing...

I suppose if there is no other way then that is what I have to do. I always worry that it will be tempramental and that one day I will find out that my date swapping will cause it to make the correct date incorrect. Maybe that is just stupid but I hate pulling stunts to get things to work...

In SQL make the field that was your autonumber an INT (integer) In the fields properties make Identity = yes, Identity seed = 1, Identity Increment = 1. This will give you a field that works exactly like an autonumber. The other bonus here is that you don't have to get rid of your existing data...

I am using VBA in MICROSOFT ACCESS to write a record to a table. My regional settings are "English South Africa",my short date is "dd/mm/yyyy" and my long date is "dd MMMM yyyy" I have an auto date in the table (ie: default value = now() ) in a field called...

What I meant to say was Can you use the name of a frame in a different scene or does "ourlabel" have to be in the same scene as you are in ? I think you have already answered this question and unless I am completely clueless the answer was yes. I have a habit of making flash more...