User Profile

Collapse

Profile Sidebar

Collapse
scubasteve
scubasteve
Last Activity: Jan 27 '09, 11:24 PM
Joined: Jan 21 '08
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • scubasteve
    replied to VBA Solution for Simulating Excel VLookup in Access
    in Access
    I've found a flaw in the function which meant that, if there are several records with the same LookupValue, it might not return the right one.

    Fixed function:

    Code:
    Public Function AccessVLookup(strTable As String, strLookupField As String, _
    varLookupValue As Variant, strReturnField As String, _
    Optional strCriteriaField As String, Optional varCriteriaValue As Variant) As Variant

'Aaron
    ...
    See more | Go to post

      Leave a comment:

    • scubasteve
      replied to AC2007 - Report 'Close Print Preview' button not working
      in Access
      Problem solved by copying everything to a new report. The usual answer to Access' flakiness!
      See more | Go to post

        Leave a comment:

      • scubasteve
        started a topic AC2007 - Report 'Close Print Preview' button not working
        in Access

        AC2007 - Report 'Close Print Preview' button not working

        I've developed a product pricing application for a client in AC2007.

        They enter all the data on the one main form, then click a button to open a printable report in Print Preview.

        My problem is, once in Print Preview, the Close Print Preview button on the ribbon doesn't work. It's there, it just does nothing when I click it. To close the report you have to press Ctrl+F4.

        This is bad, but worse is I can't...
        See more | Go to post
        • scubasteve
          replied to AC2007 - Show Built-In Ribbon For Report Only
          in Access
          Thanks Megalog, that looks like exactly what I'm after with the Print Preview issue.

          And for pointing out what should have been blatantly obvious about the Open command!

          I'll give it a go later today, and let everyone know how it went.
          See more | Go to post

            Leave a comment:

          • scubasteve
            replied to AC2007 - Show Built-In Ribbon For Report Only
            in Access
            Apologies, the answer to 1) was on these forums at

            http://bytes.com/forum/thread772071-ribbon.html

            And I had 3 issues, not 2.

            So, anyone know the easiest way to show a ribbon with the Print Preview functions available?

            And why my Open menu item is still available?

            Thanks again...
            See more | Go to post

              Leave a comment:

            • scubasteve
              started a topic AC2007 - Show Built-In Ribbon For Report Only
              in Access

              AC2007 - Show Built-In Ribbon For Report Only

              Hi,

              I'm having issues with AC2007 custom ribbons.

              I'm building an AC2007 runtime app which has a custom ribbon (called CommandsDisable dHideRibbon) set as the default db ribbon name (see XML at end of post). The aim is to hide as much of the Access interface as possible.

              CommandsDisable dHideRibbon ribbon XML (verified as well-formed by the Office 2007 Custom UI Editor):

              Code:
              <customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui">
              ...
              See more | Go to post
              • scubasteve
                started a topic VBA Solution for Simulating Excel VLookup in Access
                in Access

                VBA Solution for Simulating Excel VLookup in Access

                Looking up values from an Access table is simple. Simulating the 'Range Lookup' functionality from Excel's VLookup formula is a bit trickier.

                For those that aren't familiar with this, it allows you to look up the next smallest value to what you provided, and return any corresponding field from the table. Very useful for looking up things like currency exchange rates, tax rates, etc., where there might not be an entry for every day/income...
                See more | Go to post
                • scubasteve
                  replied to Concatenate multiple records question
                  in Access
                  Hi,

                  Apologies if this isn't exactly relevant, but someone may find it useful.

                  This is a function I've got off somewhere on the net and altered to suit (apologies if it was written by anyone reading this, I got a bit overzealous cleaning up my code library and I've lost the credits).

                  I've used it in a query for printing nutritional labels for a bakery - it concatenates all the ingredients in the recipe...
                  See more | Go to post

                    Leave a comment:

                  • scubasteve
                    replied to Exporting AC2007 Report with Images to HTML
                    in Access
                    After even more research, if you:

                    - Export an Access report to XML
                    - Make sure you export the XSL as well
                    - Add a line in the XML file telling it how to use the XSL (insert at second row of file: <?xml-stylesheet type="text/xsl" href="MyFile.xs l"?>)

                    then you can end up with an XML file which, when opened, looks like HTML, with working hyperlinks. It doesn't have the problem of...
                    See more | Go to post

                      Leave a comment:

                    • scubasteve
                      started a topic Access HTML Templates
                      in Access

                      Access HTML Templates

                      Hi,

                      I'm exporting Access reports to HTML. I'd like to have more control over the end result, so I assume I should use an HTML template. I particularly don't like the way Access splits wrapped text into different rows in the HTML table.

                      The only problem is, I can't find any useful information about HTML templates for Access. Anywhere. Can anyone point me to some? Or a sample file I can have a look at?

                      ...
                      See more | Go to post
                      • scubasteve
                        replied to Exporting AC2007 Report with Images to HTML
                        in Access
                        Thanks for all the suggestions so far.

                        I've made some progress, but still haven't come up with an ideal solution. Here's my thought processes so far, hopefully they might help someone in the future!

                        My client currently has a product catalogue (of sorts) in Excel. It's used to maintain product information, and produce product catalogues. It requires a lot of maintanance, and is hard to update prices automatically....
                        See more | Go to post

                          Leave a comment:

                        • scubasteve
                          replied to Exporting AC2007 Report with Images to HTML
                          in Access
                          Thanks Megalog, I'll investigate exporting as pdf then converting to HTML.

                          The only other option I can think of is to write some VBA to edit the HTML after it's been produced, to insert the img tags. A little messy, but at this stage whatever works is the right option.

                          Unless anybody else has a better idea?
                          See more | Go to post

                            Leave a comment:

                          • scubasteve
                            started a topic Exporting AC2007 Report with Images to HTML
                            in Access

                            Exporting AC2007 Report with Images to HTML

                            I'm a fairly experienced Access/VBA developer, but I haven't been able to find a solution for this issue yet.

                            I'm using AC2007 to build a product management system. The main purpose of this system is to publish a product catalogue in a format which can be put on a CD and opened by virtually any PC. It needs to have good internal navigation, to make it as user-friendly as possible.

                            Building the system is no issue. Creating...
                            See more | Go to post
                            No activity results to display
                            Show More
                            Working...