User Profile

Collapse

Profile Sidebar

Collapse
bwesenberg
bwesenberg
Last Activity: Apr 23 '09, 06:52 PM
Joined: Jan 24 '07
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • bwesenberg
    started a topic Produce Consecutive Numbers
    in Access

    Produce Consecutive Numbers

    I am not sure how to explain this so I will try to the best of my ability.

    I need to be able to produce 1000 labels from access that are based on consecutive numbers that Access will produce.

    Here are some of the criteria they are looking for:
    • Need to be able to produce labels on demand – generating at least 1,000 labels at a time.
    • The program will know what the last number used was so when they print the next
    ...
    See more | Go to post
    • bwesenberg
      started a topic Message Box for a Duplicate Entry
      in Access

      Message Box for a Duplicate Entry

      Hello All

      I have a form that my users enter their Audits in. The Primary key is the RECID field.
      They enter a policy number and an effective date in this form as well.
      What they want to happen is after they enter the policy number tab and enter the effective date if the Policy Number and the Effictive date is a duplicate record they want an warning message. However they want to be able to continue to enter this record....
      See more | Go to post
      • bwesenberg
        replied to PasteAppend - Clipboard not responding
        in Access
        So far so good. I talked with the user today and she said that she has not had a problem.
        Thanks so much for your help.
        See more | Go to post

          Leave a comment:

        • bwesenberg
          replied to PasteAppend - Clipboard not responding
          in Access
          The user contacted me already and it did not work.
          I will try the other option.
          See more | Go to post

            Leave a comment:

          • bwesenberg
            replied to PasteAppend - Clipboard not responding
            in Access
            I have changed the code to use:

            DoCmd.RunComman d acCmdSelectReco rd
            DoCmd.RunComman d acCmdCopy
            DoCmd.RunComman d acCmdPasteAppen d

            I am having the user test it for a few days and let me know.

            Thanks for the thought you both put into this. If this does not work I will try the other code.
            See more | Go to post

              Leave a comment:

            • bwesenberg
              replied to PasteAppend - Clipboard not responding
              in Access
              Sorry it took so long to get back to this. I have been so busy.
              Here is my code for the duplicat record button.

              Private Sub Command60_Click ()

              On Error GoTo Err_Command60_C lick


              DoCmd.DoMenuIte m acFormBar, acEditMenu, 8, , acMenuVer70
              DoCmd.DoMenuIte m acFormBar, acEditMenu, 2, , acMenuVer70
              DoCmd.DoMenuIte m acFormBar, acEditMenu, 5, , acMenuVer70 'Paste Append...
              See more | Go to post

                Leave a comment:

              • bwesenberg
                started a topic PasteAppend - Clipboard not responding
                in Access

                PasteAppend - Clipboard not responding

                I have created an Access Front End Database that many people in one of the departments use. Each user has their own copy of the Front End on their Computer. The Back End is on a SQL Server.

                On one of the forms I created a Duplicate Record Button using the Wizard in Access. I have ONE user who has trouble using this button.

                She uses it to copy records over and over and over. Then she changes just a few pieces of...
                See more | Go to post
                • bwesenberg
                  replied to Ntext limitations??
                  in SQL Server
                  Can anyone give me any ideas at all even what to start looking at?
                  See more | Go to post

                    Leave a comment:

                  • bwesenberg
                    started a topic Linked Table Manager Macro
                    in Access

                    Linked Table Manager Macro

                    I would like to create a macro or something that I can assign to a button on my form that will refresh the link on the tables. So the users do not have to do this manually.

                    Can anyone help me with this?
                    --
                    Becky
                    Applications Trainer
                    XP & 2003 Master Instructor
                    See more | Go to post
                    Last edited by bwesenberg; Aug 6 '07, 01:38 PM. Reason: Trying to delete in wrong area
                    • bwesenberg
                      started a topic Ntext limitations??
                      in SQL Server

                      Ntext limitations??

                      Hello,
                      I am having and issue with an ntext field. It seems to have a limitation on it.
                      Here is the history.

                      I am supporting a database that was created by a prior employee and I am now having some issues.
                      I have a MS Access front end connected to SQL back end. Connected through ODBC.

                      The filed is called [Comments] the data type on the SQL table is ntext. The field is located on [Table1]....
                      See more | Go to post
                      • bwesenberg
                        replied to System.mdw Error when opening Access
                        in Access
                        Putting the Front End on the net work is not an option.
                        I have 80 or so users using this database and only 10 have a problem.
                        A copy is kept on the network and then they run a bat file to run a copy from their own computer so we don't run into the too many user issue.

                        Any other ideas?
                        See more | Go to post

                          Leave a comment:

                        • bwesenberg
                          started a topic System.mdw Error when opening Access
                          in Access

                          System.mdw Error when opening Access

                          Access 2002
                          Windows 2000 Or XP

                          I have a Access database front end that is stored localy on a users PC. The back end is SQL on a server.

                          I have about 10 people who get this error occationally when they go into Access:

                          could't find file 'System.mdw'. This file is required for startup.

                          I have found that if they open Access with the shortcut to the file is when it happens. So my fix...
                          See more | Go to post
                          • bwesenberg
                            started a topic Question on form minimizing
                            in Access

                            Question on form minimizing

                            Hello,
                            I am not really sure if this is a form issue or not.

                            I am running Access 2002 with a SQL back end for the database in question.

                            The forms were original run from queries but are now being run from the tables to make them faster.
                            Since I have done that the users are complaining of an issue when they minimize and then maximize the form.

                            Here is a little history to explain the process...
                            See more | Go to post
                            • bwesenberg
                              replied to Report Issues
                              in Access
                              I finally found it. It was a data entry error.

                              Thanks for looking anyway.
                              See more | Go to post

                                Leave a comment:

                              • bwesenberg
                                started a topic Report Issues
                                in Access

                                Report Issues

                                Good Morning,
                                I am using Access XP. I have a report that is based on a query. They enter a date for criteria. It is just a single date. This report is run from a switchboard.
                                We ran the report for 1/29/07 and it works fine. The report comes out perfect.
                                We try to run the report for 1/30/07 and we get an error "There was an error executing the command.
                                I tried to run just the query without the report and it...
                                See more | Go to post
                                • bwesenberg
                                  replied to Removed (Filter For: ) from the default pop up menu
                                  in Access
                                  I just ran the detect and repair and had it set the defaults back.
                                  That worked.
                                  Thanks anyway for looking.
                                  See more | Go to post

                                    Leave a comment:

                                  • bwesenberg
                                    started a topic Removed (Filter For: ) from the default pop up menu
                                    in Access

                                    Removed (Filter For: ) from the default pop up menu

                                    Hello All,
                                    I am new here just found this network.
                                    I need some assistance. I am using Access XP.
                                    I was creating a custom pop up menu for a database and wanted the Filter
                                    For: in the menu and I somehow removed it from the default pop up menu.
                                    How on gods green earth do I get that back in the default pop up menu.
                                    I have tried restoreing defualts but can't seem to get it back. I tried moving the
                                    ...
                                    See more | Go to post
                                    No activity results to display
                                    Show More
                                    Working...