Search:

Type: Posts; User: gheyman; Keyword(s):

Page 1 of 6 1 2 3 4

Search: Search took 0.10 seconds.

  1. Replies
    1
    Views
    178

    Yes/No Message Box

    I would like to add a pop-up Message box that happens in this code after the DoCmd.RunCommand acCmdSaveRecord.

    "Do you want to return to the TSL?"

    If Yes then then DoCmd.OpenForm "frm_NIS_TSL",...
  2. Thread: Len() function

    by gheyman
    Replies
    10
    Views
    365

    Re: Len() function

    Thanks. I agree with Micron on using the title (Textbox label) vs the control name in the msgbox. So would this need four If Statements inside this code to identify the Label? (four based on...
  3. Thread: Len() function

    by gheyman
    Replies
    10
    Views
    365

    Re: Len() function

    Curious, how would you loop?
  4. Re: Slightly Modify VBA Code that deletes Dups

    That worked! Muchas gracias amigo.
  5. Slightly Modify VBA Code that deletes Dups

    i need to modify this code because the data has changed with respect to column location.
    previously the pertinent data was in B & C

    It is now in C & E

    I think changing it is straight forward...
  6. Replies
    8
    Views
    117

    Re: Copy down to next row where there is data

    Perfect!

    Again, my apologies for not trying first.

    I appreciate the help very much.
  7. Replies
    8
    Views
    117

    Re: Copy down to next row where there is data

    No, I tried to read the code. I guess I didn't understand it.

    My apologies, I will try it now.
  8. Replies
    8
    Views
    117

    Re: Copy down to next row where there is data

    wont that just copy A2 all the way down? I need to copy A2 down to where the next Part number is listed in column A (in the example above it would copy down to A44, then I would the code to copy A45...
  9. Replies
    8
    Views
    117

    Copy down to next row where there is data

    I have data running down column A (Part Numbers)
    Example: I have a Part number in A2 but don't have another Part number until A45 and then another lets say in A55

    How can I copy A2 down to A44...
  10. Replies
    4
    Views
    426

    Re: Make a unbound field = 1

    Got it!

    It was missing an "l"

    Forms!frm_NIS_TSL.TextSq = 1

    Forms!frm_NIS_TSL.TextSql = 1

    Thank You!
  11. Replies
    4
    Views
    426

    Re: Make a unbound field = 1

    I get a message "Application-defined or Object-defined error



    Private Sub Command11_Click()
    'Go to TSL Button
    On Error GoTo Command11_Click_Err

    updateQuery1
    DoCmd.OpenForm...
  12. Replies
    4
    Views
    426

    Make a unbound field = 1

    Private Sub Command11_Click()
    On Error GoTo Command11_Click_Err

    updateQuery1
    DoCmd.OpenForm "frm_NIS_TSL", acNormal, "", "", , acNormal
    [TextSql].Value = 1
    ...
  13. VBA code paste as text not formula problem

    I have code that was running great for more than a year. Now its adding in the formula as text so its not doing the calculation any longer
    ...
  14. Replies
    16
    Views
    788

    Re: Updating Linked Tables to Back End Problem

    Joe; If we all had our own FE doesn't that mean that every time something is changed on a FE (ie new form, report....) we have to go to each individual and copy over their FE? We will have almost...
  15. Replies
    16
    Views
    788

    Re: Updating Linked Tables to Back End Problem

    I will check to see if we are Mapped the Same. But would that screw up my Links if someone else was mapped differently? I assume the answer is yes, but want to confirm
  16. Replies
    16
    Views
    788

    Re: Updating Linked Tables to Back End Problem

    Joe;

    your correct, we ended up working the same issue. Same problem, same database

    We all use the same FE. No one has their own copy of the FE
  17. Replies
    16
    Views
    788

    Updating Linked Tables to Back End Problem

    I have a Back End (BE) with all my Tables. When I am solely in the Front End (FE) Database everything runs fine. As soon as another user opens and uses the Front End database the database somehow...
  18. Re: Access: Design view problem - only showing SQL

    Yes, I created all the queries.

    Some were designed/created in SQL using VBA but others were not. As stated above, once I refreshed the Table Links (to a Back End database) the problem went away. ...
  19. Replies
    3
    Views
    523

    Access: VBA to identify User and rights

    I have code that checks a table to see if the Current User should be able to open a form



    Private Sub Form_Open(Cancel As Integer)
    On Error GoTo Error_Handler

    If...
  20. Re: Access: Design view problem - only showing SQL

    After I updated the Linked Tables (Tables are in a Back end) the queries let me view them in Design view.
  21. Re: Access: Design view problem - only showing SQL

    All of my queries are like this. They all will only show in SQL View.
  22. Access: Design view problem - only showing SQL

    I am trying to see my query in Design View, but its only coming up in SQL (I am clicking Design View not SQL View).

    I'm not that good at SQL so I need to see it in Design view. Anyone know how to...
  23. Replies
    1
    Views
    45

    Covert a Table to range

    I have code that takes a table and converts it to a range

    ActiveSheet.ListObjects(1).Unlist

    But now I need it to check and see if there is actually a table to convert before it runs the...
  24. Re: Access: Modify VBA code from an On Open to On Click

    Got it to work



    Private Sub Command270_Click()
    'Check to see if user has permission, if so unlock the fields
    On Error GoTo Command270_Click_Err


    If Nz(DLookup("UserName",...
  25. Access: Modify VBA code from an On Open to On Click

    I have code that I successfully run for one of my forms "On Open". I am trying to modify this for another form where the code is run when I click a button on the form



    Private Sub...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4