Search results

I have a report which is needs to be sent off to management once a month it needs to contain all [Status] = "open" records regardless of age and then the Recrods from the previous month with status's [Status] = "Pending" & "Closed" Is there a simple way of doing this? Also is it possible to...

I love you!

I really really appreciate everybody's advice. How do I implement this into my report?

Thank you, but how do I input that function into the textbox? Sorry I'm having a really bad access block day today

If It helps I have uploaded a section of the form to demonstrate what I have. The history side is essential for the form view and some reports but the need to output the last text entered into it's own field within a table is just as essential. I'm sorry to go on I just need to complete the...

Hi All, I'd like to have a text box (locked) in form view that can give me a live status on how many forms contain "open" within there field is this possible?

How would I do this? Thank you

Dear All, I'm aware that this is bad practice but I need to have the follow code Private Sub butSubmit_Click() If Me.cboCommentby.ListIndex = -1 Then Call MsgBox("You need to select a Staff member", vbInformation) Exit Sub End If If...

Thank you I have implemented this now and also added some code Private Sub cboStatus_AfterUpdate() If ((Me.cboStatus = "Opened/ReOpened") And (Me.DateRaised <= Date - 3)) Then Me.boxStatus2.BackColor = vbYellow ElseIf ((Me.cboStatus = "Opened/ReOpened") And (Me.DateRaised <= Date -...

Hmmm seems a bit confusing for me lol, how about this!.... Could I create another field that isn't displayed on the form but stored in the table that will only hold the information from the last time the "submit" button was pressed? (I would want to keep all the rest of the code above though)

Excellent thank you as always :)

Firstly thank you that is brilliant but it's not quite what I'm after. I think I may have confused matters, When I said about the record being open I was refering to a ticket status type of thing, for example. If a record is created and the "Status" cbo is set to "Open" then after 3 days I...

I've had a look but I was trying to have the process automated :o Much like Auto Number but where I could specify the number as having letters and year followed by the number.

Hi All, Again I don't know if this is possible and if so how simple it is. I've got the "now" command setup to stamp the date when a record is created but I'm trying to find out two things... Can I display on that record how long it has been "Open" for (I also have a combobox simply...

Hi All I've searched the net for whether this is possible and I'm still a little unsure, I want to create an Auto generated ticket number along the lines of AV13****(obviously the * would be the incrementing number) It's for a Fault Log that I'm creating. Kind Regards

Thank you this method worked perfectly

Just a quick question, Is it possible for the last entry to appear at the top of the comment field? It would be easier for tracking purposes.

Thank you once again :)

Sorry, Currently I type into a unbound text box which i then click submit on which will then add that comment into the comments cell along with a date and time stamp. I can then repeat that process again to create a new time/date and the text will flow into the comment field. What I would...

I'm really sorry if this has already been discussed but I can't find the whole answer. I currently have some code in my db form where I can create time/date stamped comments (I found the code else where) Private Sub IndirectDataInput_Click() If IndirectDataInput.Caption = "Click to Add New...