Recent content by atrodden

Still not working :( If I use a macro then the label changes colour when the toggle is pressed but it reverts back when you leave the form and re-enter it.

Yeah its definitely the back colour I don't what you mean by this though? :confused: The toggle button has a value of either 1 or 0 though, with a Yes/No column in a table as its control source.

Hello all, Is it possible to use a toggle button to change the colour of a label? I assume the code should be something like this: If Me.ToggleButton = 1 Then Label.BackColor = RGB(0, 255, 0) ElseIf Me.ToggleButton = 0 Then Label.BackColor = RGB(255, 255, 255) End If But I've tried it in...

That is the row source of the combo box

Sorry for not being very clear let me try and explain how the database is set up. We have a table with companies in it, and a table with training courses in it. We have another table which list which companies have booked on which course. And the form mentioned above is used to select a...

Hello, I have a database with a from for tracking training course sales and on that form there is a drop down box with all the training dates & Locations in which it gets from a table. However as that list is getting longer and longer I have added ">Date()-31" to the criteria so everything...

My Column count was set to 1, changing it to 4 appears to have fixed the problem! Thank you so much! :D

This one is really bugging me, I have a table filled with company contacts and form with a combo box containing the contacts names. When a contact is selected I want it to show their Telephone, Mobile and email address in text boxes below. But it only shows the telephone number and the other...

I appreciate your help but I am very confused, all the data does exist, when I run the query (Manually typing in a Company ID) it brings up all the data I'm looking for.

also the ComboBox works perfectly for some companies and not at all for others... :banghead:

Ok so how can I make this work... I have three tables... tbl_Company - Primary Key ID_Company tbl_CompanyBookings - Primary Key ID_Booking Tbl_Contacts - Primary Key ID_Contact They are all linked via ID_Company

I tried to enforce the referential integrity but it says "No Unique Index found for the reference field of the primary table" The are linked on ID_Company but this isnt the primary key for the table

Hello, In a form used to record a sale for a company we have a dropdown box with the contact names for that company and when one is selected it populates other boxes like phone number etc however the combobox brings up all possible contacts but when some of them are selected all the boxes...

Thanks for the reply, sorry I wasn't clear first time round. I have added a combo box to the form and I want that code to find the values in the list box and the combo box. and as you can see at the minute it is only finding the values in the list box, so i'm guessing I need some sort of...

Hello, I'm fairly new to access, very new to Forums and even less experienced with VB so any help would be greatly appreciated. I currently have a database of customer information and form set up with a MultiList box based on the regions those companies are based. You select the region(s)...