Search results

Hi Arnel, I did warn him it would always be red in my earlier post if he didn't specify some condityion for it. See below: This code won't work, because you are not referencing the forms and controls properly.: Code: Rem If Forms![Bill_Due_Date.Value] <> Form![Bill_Due_Date].OldValue Then...

Try adding the line in red below to your code. It works on your sample database. Private Sub AddRecord_Click() Dim Account As String Dim LastPaid As Date Dim NewPaymentDate As Date Dim Last_Bill_Due_Date As Date Dim Bill_Due_Date As Date If IsNull(txtBillName) Then MsgBox "You have not...

This code won't work, because you are not referencing the forms and controls properly.: Rem If Forms![Bill_Due_Date.Value] <> Form![Bill_Due_Date].OldValue Then MsgBox "Here" Me.Bill_Due_Date.Value or [Forms]![Form_Bills]![Bill_Due_Date].Value are the proper ways. Also, the new value will be...

In the AfterUpdate Event of that field, try this code: Private Sub YourFieldName_AfterUpdate() Me.YourFieldName.ForeColor = 255 End Sub That will change the font color to red, but it will remain that way. If you want it conditional to a value, try: Private Sub...

If you are referring to the tab controls page captions, you would use: Me.Page1.Caption = "Whatever" Me.Page2.Caption = "Something Else" You can use a field's value for the cation name as well. Me.Page1.Caption = Me.YourFieldName Not sure if this is what you're looking for, but hope it...

Break up your string into parts. Dim strWhatever As String strWhatever = "Blah, blah, blah..." strWhatever = strWhatever & "More blah, blah, blah..." strWhatever = strWhatever & "Still more blah, blah, blah..." In this way, there is virtually no limit to the length of the string. Wayne

I was just wondering if anyone has tried (and found a way to make it work) storing the BE tables on a cloud drive. I tried it with one of my databases, however, my OneDrive seems to have a permanent "read-only" attribute. When you open the database (the FE is on my hard drive), it opens as...

Thanks Arnel and Mark. For the short term, I used Cronk's idea for the Index with no duplicates allowed, and it solved that problem. But I do like Mark's idea for the list box, as it would always be current with what's in the picture directory. I can use code to view the pictures on an unbound...

Thanks for the ideas. So Mark, you are saying to just populate a drop-down list with whatever is in the directory for that order number, and not to save the name in a table. If I do that, could I do it as a hyperlink that will open the picture that is selected from the drop-down list or listbox...

I posted this earlier but got no response. Can anyone help point me in the right direction please? I used to save pictures related to a job as an attachment in an attachment field. My database grew in size dramatically, so I set up a bound subform on my main Orders form to save each picture as...

I used to save pictures related to a job as an attachment in an attachment field. My database grew in size dramatically, so I set up a bound subform on my main Orders form to save each picture as a hyperlink. The form and subform are linked by the field "OrderNumber". The pictures for each order...

Maybe if I attach the link to the thread.... https://access-programmers.co.uk/forums/showthread.php?t=243577 Sorry about that. Wayne

Here is a thread that may help you. Wayne

Hi Colin, I just checked out your videos. I really like where it shows a preview of the reports when you hover over the report buttons. I think I am going to try that on my db. Thanks for the inspiration. Wayne

With respect to Control Tip Text, I found that sometimes it wouldn't work, but I discovered a fix. In the form design view, select the field you want the Tip Text to show for, if you right click on that field, select "Position", and then select "Bring to Front", and then save the form. The...

Always nice to see a fellow Canadian in the forum. Welcome aboard. Wayne

Hi Pete. Welcome to AWF. Wayne

Here's the code I use, and it is on the main form that has 4 subforms, and it works without having to click twice. Private Sub btnCloseForm_Click() On Error GoTo Err_btnCloseForm_Click DoCmd.Close acForm, "YourFormNameHere", acSaveYes Exit_btnCloseForm_Click: Exit Sub...

I looked at your database. I tried a few scenarios, but didn't get any #ERROR messages. Where does it occur?

Welcome to AWF! Wayne