User Profile

Collapse

Profile Sidebar

Collapse
JustJim
JustJim
Last Activity: Apr 27 '15, 12:17 AM
Joined: May 14 '07
Location: Bacchus Marsh, Victoria, Australia
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • JustJim
    replied to Close Form Pop-up if it lost focus
    in Access
    It's always tricky to get VBA to do 'destructive' things to the item that contains that code. There are two things you could do.

    First would be to make the secondary form Modal so that it has to be dealt with before the user goes back to the original form.

    The second would be to have code on the original form, perhaps in its On Activate event that closes the second form, for example.

    Code:
    Private Sub Form_Activate()
    ...
    See more | Go to post

      Leave a comment:

    • JustJim
      replied to How to know how close I am to fixing "Compile error: Procedure too large".
      in Access
      Thanks folks,

      It seems that I shall have to put some real effort into splitting up this code. It probably can be done, but it's going to be a pain in the sitter-upon.

      What I was really after though, was a way to peek under the bonnet/hood of Access and see exactly how large the code in question was once compiled so that I could get an idea of how far I had left to go.

      I tried the built-in "Database Documenter"...
      See more | Go to post

        Leave a comment:

      • JustJim
        started a topic How to know how close I am to fixing "Compile error: Procedure too large".
        in Access

        How to know how close I am to fixing "Compile error: Procedure too large".

        Well howdy, strangers! Long time no see.

        I have an Access application that's throwing the "Procedure too large" error. The Sub really* does need to be as complex as it is, but I have been trying to save some bits by minimising remarks and variable name lengths etc, while still trying to maintain some readability.

        What I really want to know is how can I tell if I'm getting close to solving the problem? If I...
        See more | Go to post
        • JustJim
          replied to Assistance with Query
          in Access
          G'day,

          A couple of questions before we can get started.
          1. When you say SKU, are you talking about Stock-keeping Unit?
          2. When you say diamond are you taking about the gemstone which is an allotrope of carbon?


          Jim
          See more | Go to post

            Leave a comment:

          • JustJim
            replied to Value returned from look-up
            in Access
            Make a select query that joins your main table and your lookup table and use this as the underlying data for your forms or reports. Then you can put the data from the main table and the corresponding text from the lookup table on the form/report easily.

            Jim...
            See more | Go to post

              Leave a comment:

            • JustJim
              replied to acCmdImportAttachExcel (Access 2007)
              in Access
              Yes, I'm probably going to have to bite the bullet and build a Vista/Office 07 machine, at least one to use at home (my office).

              Then again, Windows 7 is going to fix everything, isn't it? Now where have I heard that before?

              Jim...
              See more | Go to post

                Leave a comment:

              • JustJim
                replied to E-Mail to other than outlook
                in Access
                Nose wet!

                Let us know how you get along.

                Jim
                See more | Go to post

                  Leave a comment:

                • JustJim
                  replied to E-Mail to other than outlook
                  in Access
                  How did you go Tom? I was only kidding about the AOL user, you know? First things first, then we'll sort them out!

                  Jim
                  See more | Go to post

                    Leave a comment:

                  • JustJim
                    replied to Table issue
                    in Access
                    Hi Gregg,

                    Sorry about the delay, I don't think my subscription notifications are working properly.

                    I thought you were talking about only one form, which I suggested should be fed by a query linking your two tables. You should probably also go into "Relationsh ips" and link your two tables there. You probably need to read up on "Cascade update" and (to a lesser degree) "Cascade delete"....
                    See more | Go to post

                      Leave a comment:

                    • JustJim
                      replied to acCmdImportAttachExcel (Access 2007)
                      in Access
                      Reporting back just for completeness; I did the suit and tie thing today (on-site school visit) and used
                      [CODE=vb]DoCmd.RunCmd acCmdImportAtta chExcel[/CODE]
                      and took the users through the dialogs and how to save the import specs. It was so much simpler for them with the old DoCmd.TransferS preadsheet etc etc which Access 2007 seems to get confused about. It doesn't error out, it just doesn't seem to know where to put stuff!
                      ...
                      See more | Go to post

                        Leave a comment:

                      • JustJim
                        replied to acCmdImportAttachExcel (Access 2007)
                        in Access
                        Thanks PDB,

                        Your link was where I found out about the command (great minds etc). Probably not going to be automated enough for my users, but I'll give it a go when I get back on site again tomorrow - another suit and tie day darnit.

                        Thanks again

                        Jim
                        See more | Go to post

                          Leave a comment:

                        • JustJim
                          started a topic acCmdImportAttachExcel (Access 2007)
                          in Access

                          acCmdImportAttachExcel (Access 2007)

                          Hi all,

                          I've got a client that upgraded to Vista and Office 07 thereby breaking one of my applications that they were using.

                          Apologies for vagueness in the following question - I'm off-site and don't have Access 07 here.

                          The problem is most in evidence in a line of code that used the TransferSpreads heet method which now seems to have trouble figgering out what goes where and whether or not I'm using a...
                          See more | Go to post
                          • JustJim
                            replied to Table issue
                            in Access
                            Hi,

                            If you base your form on a query that correctly links tables A and B then your form will show and accept data for each table just fine.

                            Jim...
                            See more | Go to post

                              Leave a comment:

                            • JustJim
                              replied to E-Mail to other than outlook
                              in Access
                              Hi,

                              As you seem to be aware, the SendObject action has arguments for To: and Bcc:, as well as, of course, sending the object. If you need further assistance after reading the help file for SendObject, then come on back.

                              As for the AOL user:- tell them to change if that is causing a problem!

                              Jim...
                              See more | Go to post

                                Leave a comment:

                              • JustJim
                                replied to Forms Slow to Save and go into Design View
                                in Access
                                I'm hearin' ya.

                                Jim...
                                See more | Go to post

                                  Leave a comment:

                                • JustJim
                                  replied to Forms Slow to Save and go into Design View
                                  in Access
                                  Have you tried Compact and Repair?
                                  Also, try not clicking too loudly, you might be scaring the poor little beastie!

                                  Jim...
                                  See more | Go to post

                                    Leave a comment:

                                  • JustJim
                                    replied to Access CheckBox VB Code Help
                                    in Access
                                    Oh and by the way, welcome to Bytes!
                                    See more | Go to post

                                      Leave a comment:

                                    • JustJim
                                      replied to Access CheckBox VB Code Help
                                      in Access
                                      The check box is a control on your form and as such it has a name. If you haven't renamed it, it will be something like Check1. To find out its name, open the form in design view and double click on the check box. This should open up the properties sheet for the check box (if not, click on the Properties button on the toolbar, or click on View > Properties, or type alt-Enter). Now that you know it's name you can refer to it in code.
                                      ...
                                      See more | Go to post

                                        Leave a comment:

                                      • JustJim
                                        replied to Access CheckBox VB Code Help
                                        in Access
                                        Part of the problem is that you have no Dim statements and no Option Explicit statement. Then you have variables such as Perm, chkbox, chkPerm, and in another post, permCheck. With no Option Explicit statement, any typos are simply accepted and Dim'd as type Variant.

                                        Anyway, the sort of method that I think you need is:

                                        [CODE=vb]Dim strMessageText as String

                                        If Me.chkPerm then
                                        strMessageText...
                                        See more | Go to post
                                        Last edited by JustJim; May 7 '09, 10:42 PM. Reason: trying to line code up!

                                          Leave a comment:

                                        • JustJim
                                          replied to keeping records of previously entered data
                                          in Access
                                          Certainly. The important thing to realise here is that an employee can check out many inventory items (perhaps several at the same time), and an inventory item can be checked out by many employees (although not at the same time). This is a particular type of relationship called a many to many relationship between the inventory and employees tables.

                                          To model a many to many relationship in Access requires another table (usually called...
                                          See more | Go to post

                                            Leave a comment:

                                          No activity results to display
                                          Show More
                                          Working...