Search results

  1. G

    Define how Access opens using VBA

    I have learned in my company that the less you let the user do the better off you are. Lot's of people her like to "see how things work". So needless to say I have created my own security/design features to prevent these users from being able to do so (without using MsAcess Security which is a...
  2. G

    Define how Access opens using VBA

    I use this non-API method of hiding the database window for all my access applications. IMO it looks better and more like a program only taking up a little of your screen. The method I use it when my default form opens (Main Menu) I have the On Open Event Procedure set as: Private Sub...
  3. G

    How do I Seperate the Time() function into hh:mm:ss

    Here is what I am trying to do with no luck. I have 3 text box fields Hour Minute Second I need each field's default value to correlate based on the current time when the forms is opened / refreshed. Time() I have been trying to use =Left(Time(),2) for the Hour box, it works somewhat. It...
  4. G

    You know you need a life when in your spare time...

    This sounds interesting. Would you be willing to post it for others to check out?
  5. G

    Restarting Custom # Each Year Using Dmax function

    Glad it helped. ;)
  6. G

    Restarting Custom # Each Year Using Dmax function

    Rahul: Here is the sample database. This actually has 4 parts that make up the final number. Hopefully this will help you. Here is the code I used to compile the fields into 1 using the Save OnClick event. Private Sub Save_Click() If IsNull(Me![BaseID]) Then Me![BaseID] =...
  7. G

    Default Memo field value based on seperate table data

    KernelK - That did the trick perfectly. I don't know why I didn't think of DLookup. I used a slightly different approach with the same result: If Me![Letter Type] = "Revocation Letter" Then Me![Letter Blurb] = DLookup("RTFField", "RTF", "LetterTypeField ='Revocation Letter'")
  8. G

    Default Memo field value based on seperate table data

    Is it possible to have a Memo field's default value pulled from data found in another table? Example: I have the memo field "Letter Blurb" on a form who's record source is "tblLetter" What I am trying to do is have the memo field updated based on the "Letter Type" that is chosen. (This is...
  9. G

    Bring minimized form back in focus

    I got it figured out ;) I needed to set the focus to the form 1st and then DoCmd.Restore. Thanks for the help everyone.
  10. G

    Bring minimized form back in focus

    I tried that and it restored the window, but the form is still minimized. That part of code did help part of the problem though :)
  11. G

    Bring minimized form back in focus

    Does anyone know what code I can use to bring focus back to a form that has been minimized? Basically I have a form "Provider Letters" that is open. There is a button (preview) that you click to preview the letter in a Report format. When you click the button it minimizes the "Provider...
  12. G

    check if form is open

    That worked perfectly and is MUCH easier. :) Thanks for the help and the quick response.
  13. G

    check if form is open

    I have been trying to get this to work, but I think I am doing something wrong. I have taken the 1st code and placed it into a module so that I can use it by calling the "IsLoaded" function. I placed a button on a form with the 2nd set of coding and i get the error: "Compile Error: Ambiguous...
  14. G

    Restarting Custom # Each Year Using Dmax function

    Sweet! :) That helped.. I made a few modifications to the code and now it works like a charm. Thank for all the help!
  15. G

    Restarting Custom # Each Year Using Dmax function

    Ugghhh :( I have been trying different combos of the code.. still not working. Could someone please take a look at the same database I attached and see if they have any better luck? The increment works great just not when the year changes; I can't get it to reset the BaseID to 00001 for the...
  16. G

    Restarting Custom # Each Year Using Dmax function

    No luck. I am getting "Compile Error: Expected: list seperator or )" it is referring to the ' in the code. Here is the new code I am using with your suggestion: Me![BaseID] = Format(Nz(DMax("[BaseID]", "[tblTest]","[YearID]='& year(date) & "'"), 0) + 1, "00000")
  17. G

    Restarting Custom # Each Year Using Dmax function

    I have been racking my brain trying to get this to work with no success :( I have read through these 2 posts numerous times trying to apply the coding/methodolgy and can't seem to get it fine tuned. http://access-programmers.co.uk/forums/showthread.php?t=31046&p=519211...
  18. G

    Updating and existing Database

    If you are using a make table query as temporary tables for reports to run off of then you wouldn't need them to be sent to the back-end in this scenario. Just set it so that once the report has been created with all required data have a query that will delete the temporary tables.
  19. G

    Send email with High Importance using Access

    Thanks ByteMyzer! That did the trick perfectly :D (adding this one to my code book)
  20. G

    Auto-adjust size of memo field?

    cdoyle: If you had read my reply about 3 or 4 posts up I suggest you using it on the "Doubl-Click" or "Click" event. Try this out. "Another solutions you could use is the acZoomBox command. Set it as an Event Procedure on the "Double Click" command. Then you wouldn't have to worry about...
Back
Top Bottom