Search results

Thank you for your help.

This is my row source SELECT Contacts.ContactID, Contacts.CompanyName FROM Contacts; Where abouts do i change in order for it to be alphabetical?? Thanks for your help.

This is probably a really easy question (i Hope) i have combo box on my main form which lists all company names so when selected will take you to the relevant record. Is there anyway i can set the combo box to list all the companys alphabetically? Thank you

ok i know nothing about coding but i will give it a read. Thanks for all your help.

I need it to store the info on a form, and as 9/10 the recurring charges will also be the same value as the monthly invoice instead of adding the data twice i wanted to be able to check a box if it was the same value instead of duplicating. I understand the problems with duplicated data but i do...

Sorry it is a tabbed form within a tab.

They are on two different forms that both have their own tables and both fields are called Amount.

oh i see, i do have two text boxes but both are Amount in seperate forms???

Private Sub Check8_Click() If Me.Check8 = -1 Then Me.Amount = Me.Amount Else Me.Amount = 0 End If End Sub

I did yes but still didnt work,

I didn't get an error and it did not move the data.

Well i gave it a go, unfortunately i could not get it to work :-(

ok thank you i will give it a go

Thank you for your help. Basically in my invoices form i have text boxes for One-off Charges, Recurring Charges and monthly invoices, 9 x out of 10 there will only be a Recurring charge so the monthly invoice will have the same value as the Recurring charge so i want the data entered in to...

Hi everyone, I have a tabbed form and for the invoicing part i would like it so that if data is added to my text box it is also duplicated in another box on another tab on my form although this is duplicated data i do need to have it on both forms so instead of having to enter twice would just...

When i open my db i have tabs along the top however if i select a tab it takes me about an inch down the page so when you want to move on to the next tab you have to arrow up, hit the next tab (which will move down an inch) add your data then arrow up hit the next tab (which will move down...

Thank you so much, i will have a look at getting a book and some training.

Thank you for helping

I tried that yesterday but it kept taking me back advising of an error. I placed it underneath the Setup Price code, was i right in doing that as it took me to that page automatically.

I would prefer the code as it worked so successfully beforehand.