Search results

Ok, I am copying the name I gave the combo box from the combo box properties and pasting it into the Control Source of the text box properties. I am adding the = and then the . and the column(2) or whatever. I have five columns and am just concentrating on column(2). So whatever the information...

It shouldn't make a difference. Whether I use column 2 or 3 or 4, it still won't work (have tried them all).

Hi there I hope someone can help before I tear my hair out. I have a combo box that contains a number of fields, but displays only the first in the form (when you select they all show but only the first is shown in the field). Then I have a text box where I want to display the information in...

Thank you so much! Does this go in the Control Source bit?

Ok, I used that, but it is still giving me a date that is two days before the due date, as opposed to two working days. The list of functions in the help doesn't include an expression with weekdays in it.

Hi there This is what I need to do: Date Field - 2 days and Date Field - 1 day Easy enough, but I need the 2 days and 1 day to be working days only (Monday to Friday). In other words, if something is due on 9 June, then two days prior would be 5 June, not 7 June. Hope this is not too...

Thanks for that. What I can't work out is how to put it onto a form if I have it in a different table. I can't for the life of me get sub forms to work! Just about banging my head on the desk at this stage.

Hi there, hope you can help! I have to design a database in which one of the activities required is to ensure that the information was sent to a number of people. If it was not sent, it should be done. From the user's point of view, they need to be reminded to do this but the completion of...

Thanks again!

Double post

Thank you so much for the info! Is there a way to set up the form so that the user doesn't have to do the right click and edit thing? Perhaps with a button or something? But then the hyperlink would need to show so that they can access it when they next open the record. Hope that made sense.

I have a field in my table that needs to contain a hyperlink. What I would like to do is to allow the user to Browse and Select the folder related to the record when the record is created (or create a new folder). Then when the record is browsed, the hyperlink can be clicked to open the folder...

Thank you! At least now I know what to look for, didn't know it was called that. When I click on the 'Not in list' I get [Event Procedure], do I need to put code in here? I have never used VBA, so not sure where to start.

Hi there I have a lookup table that will be used in a combo box on a form. Is it possible to add a function to the dropdown list that says 'Edit'. Basically, when the user gets to that point in the form they discover that the item they need from the dropdown list is not there and they want to...