Search results

  1. speakers_86

    VBA form that relinks tables

    Just use the JStreetRelinker. I've used it for years. Also, why would the path of the backend change?
  2. speakers_86

    Properties

    This is a form that will give you quick access to database properties, and you can use it to create custom properties. The hotkey is Ctrl+Shift+P. For the ribbon option to work, you have to have the USysRibbons table.
  3. speakers_86

    Datasheet column sizes sorts and filters

    Hello all. I wrote a module to manage datasheets more easily. It allows developers to set the columns simply by using the tag of the form and the controls. When the end users apply filters, sorts, or change the column widths, these settings are saved and loaded the next time the form is...
  4. speakers_86

    scrolling through report using the mouse key?

    Here is how I make a report move to the next page using a button in a custom ribbon. DoCmd.OpenForm "frmDummy" DoCmd.Close acForm, "frmDummy" RunCommand acCmdFitToWindow SendKeys "{PGDN}" The opening and closing of the dummy form fixes an odd...
  5. speakers_86

    Third Party Controls (Yay or Nay)???

    Also what about iTextSharp, the PDF library? Will this technique work for that too?
  6. speakers_86

    Third Party Controls (Yay or Nay)???

    My only experience with this was in trying to use the ActiveX treeview control. Deployment was impossible due to the common controls reference being installed at different paths. Can this technique be a solution?
  7. speakers_86

    Third Party Controls (Yay or Nay)???

    Does this work with mde?
  8. speakers_86

    Hyperlinks in a table, each click opens NEW browser window - me no likeee

    It is my understanding that modern browsers do not honor parameters to open in new windows. Instead, they use their own internal settings. So basically check the settings in your browser.
  9. speakers_86

    Why not store date/time seprately

    It's funny you say that, because that is exactly how I'm doing it now.
  10. speakers_86

    Why not store date/time seprately

    These are just notes that have date and time logged. I have a dynamic search form that allows users to search for entries between given dates and times.
  11. speakers_86

    Why not store date/time seprately

    I have read that it should be stored in one field as a date/time, but in the front end, I have a date picker for the date, and a separate time field. Why would I not store it separately?
  12. speakers_86

    How to Set Column Width in Datasheet View?

    Sorry, forgot about this. It seems to work great, but I haven't completely tested it. Option Compare Database Option Explicit Private booDebug As Boolean Private Sub SetDebug() booDebug = False End Sub Public Sub SetDefaultColumnInfo(frm As Form) On Error GoTo err SetDebug...
  13. speakers_86

    How to Set Column Width in Datasheet View?

    This thread keeps getting resurected! I recently wrote a module to set column width, order, and hidden properties based solely on the control's tag. It can also save column width and order adjustments made by the end user in the front end. I'll post it once I get back home.
  14. speakers_86

    Unrecognized Database Format

    Firstly, you should not be using the lookup wizard. How about the other wizards, do you get the same error? Do you have any kind of addins installed?
  15. speakers_86

    Fuzzy Matching in Access - How to Use

    I didn't quite read all of this, but there is another post in the sample databases called 'simil' somthing or other.
  16. speakers_86

    Requering forms automatically

    I appreciate that Lightwave, but all I have is Access. How about this, is there any way for message passing between front ends? How about blasting the local subnet over tcp/ip? I did a quick search and didn't see anything. I know VB.NET can us tcp or udp, but I'm not sure about Access. If...
  17. speakers_86

    Requering forms automatically

    There are two computers, one account per computer. The backend is on one, while the frontend is on each. There are many forms that can cause changes to the overview, see below. The overview screen has six subforms. Three show current missions, ended missions, and upcoming missions. The...
  18. speakers_86

    Requering forms automatically

    So basically I am stuck using the timer?
  19. speakers_86

    Requering forms automatically

    On one machine there is an overview form that gives a snap shot of a few different things. This is mostly read only, and is popup and displayed on a second monitor all the time. If the user changes data using another form or at another terminal, the overview screen is no longer correct.
Back
Top Bottom