Search results

Can some one please tell me the code to close a form that as command button is set in that opens another form?? In other words I click on the command button on a form, that for opens and another form opens. I have everything except how to close the old form that the command button is on...

The easiest way to explain this is to have a look at the Northwind DB form "Customer phone list" You'll see at the bottom theres the alphabet, click on a letter and it filters the Customer list and displays only the customers with that letter in their first name. I've a contact list that this...

Sorry for the confusion. In my last post I put in those tables so that if I knew how to add up a field so the total would appearing another field, then I'd be on my way to trying the more difficult things I first mentioned. So, I guess the easiest was to ask it is. How do I add the numbers in...

thanks again. Unfortuately I'm suffering from the problem "problem between keyboard and chair"!!!! I'm starting again. one table on it is ID(autonum) - Affiliate(text) - Football(tick box) - Hockey(tick box)-totalfootbal(number) - totalHockey(number) What is the easiest way to add up the...

Thanks Travis, I get what your saying. But a little lost in how to actually implement it. What is ABS? .... Naw, actually on second thought I'm totally lost. Right, Lets presume I have a new table. ID - Affiliates(there are 44) - Football - Hockey are the only fields. I'd like to count...

I'd like to do something similar to what the Northwind has for displaying labels. Can someone tell me if this is a long way to going about things?? Personally I was thinking of just have a a sub form with a button for each label catagory! The form looks nicer, user friendly etc, but looking...

I've a massive table (I've only just learnt how to break tables up and relate them, but for know I have to stick with this old table) To sum it up: 44 Affiliates 12 sports Each sport costs 75 I've a tick box next to each sport in the affiliate table/form to indicate that they do that sport...

That worked perfectly thank you

I have a form built on a Query which is built on a relationship between two tables. On the Form is data from both tables. What I'd like to do is prevent users from changing data in certain fields from 1 table, yet still be able to make changes in other fields?? Keeping in mind both tables are...

I've finally managed to get a some tabels together in a relationship!!!! Took me long enough though. It's not quite what I expected though. the "+" Symbol drills down to show you the address on the related table. So in table 1 I have filled in contacts and address in table 2 I have the sports...

Thanks a lot Doc, First thing tomorrow morning(it's Ireland here) I'll give that a go, and I'll let you know how I got on as soon as I know myself Thanks again for the time

I'm building a new database for an organisation. It will have many facets. I'm new to making tables, I've always just one or more unrelated tables and used queries to get the results I want. I'm also dyslexic and while the whole Idea of relationships makes sense, I can't put it into practice -...

I had problems with the website too. Download links were down quite often. I just kept checking back and eventually hit the jackpot and got the download i was looking for. It's a valuable site, if you need the animation download send me an email. Cheers Dave

Thanks a million that did the trick!

I've been to the candace-tripp website in order to put a Gif image onto my start up form(splash like form). But the download link is down. Anyone got anyhelp on how to but an animation onto a form??? Be it a Gif(preferably) or even flash?? Thanks

Thanking you, much appreciated

Thanks but I need a password and log in for that site??????? c

I'm partly guessing here. But do you need a plugin or something to but an animation into a form. Mainly this would be for the opening splash screen I have set up. But there is one tutorial for I have that I'd like to but a Gif image into. Any ideas about putting animation onto forms?? Thanks...

Hi Dawn Thanks so much for the time and effort you went to. I'm now printing off your solution and will endeavour to make it work over the coming days. I really do appreciate you help and hope that you got a good nights sleep!!!! dave

Thanks for comming back to me Dawn. Basically I have a list of 2000 companies that I've done research on. My project has been succesful and now there will me more people doing research on those companies. I'd like to have a user open the DB, type a password, and give them access to a...