Search results

  1. 5

    PHP Link mouseover Title Colours

    As plog says, CSS is the way to do it, you don't necessarily need to use JavaScript. Browser tooltips can not be customized. You could add a custom data-* attribute to the <a> tag like <a data-custom="something" ... > and target that with css like this: [data-custom]:hover:after { content...
  2. 5

    PHP Link mouseover Title Colours

    Let me start by saying I've never used dreamweaver, however, this line: $lst .= '<a title="' . $link_title . '" href="' . $scripturl . '?action=links;sa=visit&id=' . $row['ID_LINK'] . '" rel="noopener" target="_blank">' . $row['title'] . '</a>, '; Appears to be php, perhaps you could add a...
  3. 5

    Protection against copying

    Look up isladogs, he has examples of that. I would recommend switching platforms, Access was not built with top security in mind.
  4. 5

    Solved Refresh/Requery Subreport from pop-up

    Uh, the me.dirty = false before the requery method is the solution to this. Is it not working?
  5. 5

    Creating a constraint in a table in the backend

    Here's some VBA code to add constraints from VBA https://www.access-programmers.co.uk/forums/threads/tables-multiple-instance-why-do-this.327115/post-1870637 EDIT However, it's for creating tables with constraints already. I tested this Sub x() DoCmd.RunSQL "ALTER TABLE diarios_det_2022 ADD...
  6. 5

    Solved Refresh/Requery Subreport from pop-up

    Just commit the record before trying to requery. Private Sub cboStatusCodeUpdate_AfterUpdate() Me.txtExtStatus = Me.cboStatusCodeUpdate.Column(2) Me.Dirty = False ' Forms![f_OTD_Assignments]![srep_OTD_AssigmentDetail].Report.Requery Forms![f_OTD_Assignments].Requery End Sub Edit...
  7. 5

    Solved syntax error in DLookup

    "OR EAN=" Is missing a space: " OR EAN=" Use this before the Dlookup Debug.Print "Article number=" & Article & "OR EAN=" & Standard Check if you're getting numbers there, if you're getting strings, you need to add apostrophes. I just read those are strings, then try this: DLookup("Unit"...
  8. 5

    Report PDF

    Troubleshoot by creating a report that just says "Hi". With just that little word, do you still get two pages? If not, then gradually add more stuff and see where the limit is. I've also had the issue where the printer pulls two sheets, so figure that out too.
  9. 5

    How can I send message in watsaap through ms access

    The easiest is universal links. From: https://faq.whatsapp.com/ --Accounts and Account Bans ----Accounts ------How to link to Whatsapp from a different app There is also a REST API, which requires you to use a HTTP library for the requests to their servers. And there are some third party...
  10. 5

    VBA SQL vs "GUI"

    I use the query builder for SELECT queries. If I need to review the SQL string and it's too long or complex, I use this site https://codebeautify.org/sqlformatter Then I remove parentheses to copy the output of the site and then I paste it back into the sql editor of the access query builder...
  11. 5

    How to reference a control on Tab Control from the Main Form

    @MajP Dude, I presented a lot of different ways to reference a control and then I invited the reader to find other references because the point was that there are a lot of ways. Not only that, I also provided proof, samples and, most importantly, the resources and methodology to find even more...
  12. 5

    How to reference a control on Tab Control from the Main Form

    Well, consider the amount of wasted time for a new developer. Googling answers, trying and failing with possible syntax combinations, all looking different and for very different form setups and not even a single post read by this new developer even mentioned inspecting the Form. I've been...
  13. 5

    How to reference a control on Tab Control from the Main Form

    Inspecting the Form object will help you clear any doubts about Parent references. Several members of the Form class inherit Parent. In the example I provided, I'm using Parent to reference the same textbox from the BorderStyle property, an exercise to demonstrate that even a property can be...
  14. 5

    How to reference a control on Tab Control from the Main Form

    Nah. Sure-fire all the way, MajP. I use that syntax. It never misses. Shortcuts are taught wrong. I know it. You know it. Everyone with enough time in this knows it. Shortcuts are the reason these threads exist.
  15. 5

    How to reference a control on Tab Control from the Main Form

    Inspecting the Form variable will help you learn how to reference anything from anywhere. 1. You seem to have a parent form with a tab control and a subform control on page 2 of that tab. 2. The requirement is to reference a textbox in the subform from the parent form. If I add a little Stop in...
  16. 5

    Opinions on form design

    I think isladogs had a form tool that basically opened connections until error 3048 was triggered, I think he assumed 255 was the limit so he simply checked 255 - connection count before error = your open connections. It wasn't precise but it gives you a north. OP, If you worry too much about...
  17. 5

    Opinions on form design

    Subforms and pop up forms are both useful form formats. But there are places where they should be avoided. Best example I can think of is to never allow a workflow where you can add children before you add the parent. Always add the parent first. Also, subforms in tab controls are handy but you...
  18. 5

    DTPicker on Form

    You have to account for too many things with date data types, string validation is simpler, more predictable and if you tell the user to use a certain format, the user will definitely understand the format expected more than having that same user learn how many ways dates can be handled and...
  19. 5

    DTPicker on Form

    Don't let it fire until conditions are met. Example: Private Sub MyDateTextbox_Change() If Len(Me.MyDateTextbox.Text) > 9 Then MsgBox "fire" End Sub
  20. 5

    How to Refer to Navigation Subforms and Their Associated Controls

    OP, I understand the frustration of having scarce documentation. Hey, that rhymes. Anyway, I'll start with some facts about what you want to do: 1. You can only reference a form and its stuff when it's loaded. 2. Navigation controls are a NavigationControl and a NavigationSubform control grouped...
Back
Top Bottom