Search results

No, this doesn't work as the form is not bound. Mabey if you could show me how to make this form bound? Is there another way you can add these up (mabey VBA or a report???). Also I was thinking mabey smething like =Sum(AllClientDetails![And]) in the control source? Thanks alot, Dan.

I have a table with a column called "And" whitch shows the currency values like "£45" ect. I'd like to know how to add up all of the values in the column "And", and then put the currency value into a text box on a form onload. So mabey something like Private Sub Form_Load () Textbox2.Value...

Its a a large database that I'm not allowed to send over the web. But, any help will be appreciated? Thanks, Dan.

I've tried that but how does it know what query to take the value from ect. Also Id ont want it in a msgBox.. Heres the code I've used: If Forms!PaymentsDue!List14.ListCount >= 1 Then Forms!Form1!No5.Value = "There are " & Forms!PaymentsDue!List14.ListCount & " clients with payments due at the...

I'd now like it to say Something like: If Forms!PaymentsDue!YourListBox.ListCount > 1 Then Forms!info!Label1.Value = "There are ""There are " & Forms!PaymentsDue!List14.ListCount & " clients with payments Due including" & 'by here the names of a few in the list box. Else...

New to VBA. I have an if statement and its something like If this = true then text1 = "...payments due including " & (by here i want it to say the value of record1(the first cell thing) in the query "qryPaymentsDue" So the text box would say something like There are 7 payments due including...

Thanks mate, that worked great.

I need the VBA to take a date from the textbox "NewDate", add 3 months onto the month and then place the new date into the textbox "DueDate". Ive done this before but have forgotten it, Something like: Date Day("NewDate"), Month("NewDate")+3, Year("NewDate") But have forgotten something, any...

Well, I need an example of the cascading combobox but also the details coming up as The first file you sent me doesnt seem to be working. Also, I do want to know how to do the things myself but I manage these sort of things better if I can have an example and look at how the codes and work is...

If you could send me another form with the combobox that would work with client and staff names and send it back to me as it has gone quite wrong? I would be very thankfull if this is possible? Name the Combobox "Combo3" and add it to Form1. The tables are "staffdetails" and "clientdetails."...

I want to know how to write: If a list box on form "PaymentsDue" has more than 1 piece of data in it then make label1 on form "info" Visible = True. I know how to do the visible bit but not the on the other form bit. Can anyone help ?

Thanks alot mate, you got me on the right track and now I have it sorted! Thanks again, Dan.

I have a list box with peoples names in from a table, and I'd like it if when I click on a name that persons details came up in different text boxes on the form. So I'd have text boxes showing first name last name ect.. Thanks in Advance, Dan

Now, is it possible to have a list of names from not just one table but also another table (2 tables). EG: ClientDetails and StaffDetails names. I think this can be done using a query? Can someone use the file above but change it so its 2 tables. Thanks alot in advance, this is all part of a...

Yeah, thats great. All I'd like now is that when you type the list will automatically appear without having to click on the arrow. This is because I would like to be able to see every client as they have same names. Is there a way when you enter a value or even when you click on the box, the...

I'm just wondering if you could make a simple access program, with a drop down list and make up a few names and publish it on here. I would publish mine but I'm on another computer. You are a great help thanks, Dan.

Yeah, I get that. But when I use a combo-box the drop down doesnt appear with the list of selections, it just auto-completes your text for you. Also you cannot select a name and it take you to a new form with there details. Thanks, Dan.

Hi, I have a database with one table full of client names, another with staff names ect.. I have made a text box, and would like to be able to type in a client or cleaner name and have a drop down list appear with the names available. Then I would like to be able to click on one of the names...