Search results

I'm really sorry vbaInet but with this one you'll really need to treat me as a complete novice. I totally understand if it's too much trouble because with code you're dealing with a rank amateur. I'd love to understand but really don't know where to begin. So I start with the form...

Still at a loss. Sorry Would that look like this? Private Sub Form_Current() Dim ctl As Control For Each ctl In Me.Controls Next End Sub

Sorry but you lost me at 'Cycle through the forms controls' I have adapted a number of pieces of code in the past replacing field names etc but have no idea how to tell vba to find similar fields or how to specify the same code for all fields. I'm quite willing to go away and do some...

Thanks vbaInet I'm not great with code but am learning. I did consider moving between excel and access, I even considered trying to do something with project. All the calculations will be done using queries. However there must also be a timeline that can be quickly viewed. This...

Yep, there's a text box for every working day of the year. There's also another form that displays >Date ()-30 and <Date () +320, and then there will be one for 2015, 2016 and 2017. I can very quickly create a similar sort of Gantt chart in excel but I want to be able to apply all sorts of...

Thanks for sticking with this. Screen attached

See picture attached. Using format painter I can copy the formatting from one field to the other however the expression referring to the Date doesn't change. What I am looking for is some way to say [Current Field] Like "*Delivery*" rather than [10/01/2014] Like "*Delivery*". That's...

Thanks vbaInet The sql for the query: TRANSFORM First(Resourcing.Activity) AS FirstOfActivity SELECT Resourcing.Trainer_Name, Resourcing.Team, Resourcing.Duration FROM Activities, Resourcing INNER JOIN Dates ON Resourcing.Start_Date = Dates.[Work_Dates] WHERE...

It would involve replicating the same code in every text field but changing the field name. I have dates in my table from now till December 2017. I could use format painter however I would then need to go and change the field name for every single date. If I could reference the current...

The text boxes are created from a table of Working_Days. In order to ensure that each day is displayed whether it contains an entry or not I have created a record encompassing all those dates. What I need to be able to do is copy the formatting from textbox 02/07/2014 to textbox 03/07/2014 if...

Haha! My fault. It is because the query was a crosstab. I'm calling the field Activity as that was where the source information came from. However the Activity is a value in the crosstab field Work_Date. See screen capture: Now I have a new issue. The form see's each field as an...

Thanks vbaInet Perhaps it's because the source query was a crosstab but I still can't get this to work. As you suggested I might try and delete all the conditional formatting and start again. Thanks for your help

Please note I did change the word to Delivery in this instance despite what you see on the screenshot

Sorry vbainet but I'm still stuck. I tried both your suggestions but with no luck. See screenshot attached relating to 01/07/2014 Thanks again for looking

Thanks guys The form in question is the result a crosstab query with a date field as the column and an activity (i.e Design) as the value. Based on your feedback I tried the following but still no joy Private Sub Backcolor() If ([Forms]![Query2]![Activity] Like "*Design") Then...

Hi Guys What I am trying to do is create conditional formatting to colour fields within a form. The conditional formatting option built in allows me to colour based on set values i.e. Value=Design turns green. I need to somehow say if Value contains the word Design turn green. This...

That looks fantastic thanks Gerry I'll need to adapt it slightly to ignore any combination of the first four fields being empty as not all fields will be filled in for things like holiday. This will also help me with another enquiry I had on here as when 'all day' is selected I want to...

Hi Gerry Sample of the database attached. Entries are made using the Resourcing form Query 1 calculates the amount of working days between start and end date Query 2 is the crosstab that I want to populate. Any questions just give me a shout Thanks again Guinness

Thanks Gerry I'd really appreciate it. I did think of an append query but was advised VBA would be required. It will take me half an hour or so to get you a sample of the database. Hope that's ok

Hi JDRAW Litteraly create an exact duplicate of the record that I have created so that I now have two records. One starting AM and one PM. The duration says whether a person is on an activity for a full day, a morning or an afternoon which I need to know in order to schedule free time...