Search results

  1. M

    scanning documents

    Are you asking for a sample database using a path to a file on disk?
  2. M

    Re-design a wellworking data base

    You CAN, but it doesn't always come out working well on a phone. Buttons and entry fields are especially difficult to manage when the phone's keypad can take up half the screen.
  3. M

    Expedia

    Having talked to the folks at hotels / motels, I always contact the place I'm going to stay at instead of a third party. You'd be amazed at how helpful the staff at the hotel can be when you talk to them nicely!
  4. M

    Late Stage Capitalism?

    Not sure if this would be just "Capitalism" as the CCP backs car manufacturers who already do this in China.
  5. M

    Update of stock quantity

    I'll second Arnel's comment on how this is normally done. Avoids any issue of "people playing games" when trying to calculate remaining inventory.
  6. M

    Re-design a wellworking data base

    Along with what other's have posted, you will want to identify what is ESSENTIAL for business at each site. Work out "What happens when our ISP goes down for a day" as part of your planning. Often, having one site down because of internet issues is not an option. This may require redundant...
  7. M

    Crosstab or transpose query with multiple fields

    More important, do you have a change request (and payment) in hand? Access tends to be nice when you scroll vertically, but switching things to scroll horizontally isn't as straight forward.
  8. M

    Report Dilemma

    Any chance the errant printer is set to a different type of paper than you develop for? Say something like "One printer is set for A4, but you developed for 8.5 x 11 inch"? This kind of issue normally appears when no one tells you "Hey, we got new printers!"
  9. M

    Undo Changes on a Main form and associated Sub Forms

    @NauticalGent, Are you asking this because you are looking for a way for a user to roll back during their instance of your database OR are you looking at being able to roll back changes made by any user even when their copy of access (or their computer) is unavailable? If you need to be able...
  10. M

    Import Excel file in Database using VBA (learning purpose)

    2nd to Pat's response. Queries allow you to also do some clean up on data in the query def to better facilitate import / export of data. Really handy to be able to proper case names and such when you keep getting users who DON'T KNOW WHAT THE CAPS LOCK KEY IS OR WHAT IT DOES.
  11. M

    Solved Error 6 Overflow

    Do you have the latest ASPEmail?
  12. M

    Sorry folks, Access World will not accept my posts

    You will DEFINITELY want to reduce the thousands of reports and forms you have then. 2 pages EACH? For a printed manual you'll be contributing to the deforestation of the planet! 😁
  13. M

    Solved Error 6 Overflow

    Something I've noted is at the top your code shows 'Date Last Modified: 07/18/07 The following sample code should give you an idea how easy this is currently. It creates the PDFs creates the EMails, and gets them ready to send out. Private Sub Btn_PrintAndEmail_Click() Dim MyRs As...
  14. M

    Sorry folks, Access World will not accept my posts

    Best way to "Wrap your head around it" is to think of programs like Notepad. Notepad lets you open another file, edit it, save it. Notepad can create a new text document. Notepad DOES NOT save the data in itself, so if you put in a new copy of Notepad you don't loose everything you've written...
  15. M

    Another Loss of Some Note (or Notes)

    @ Doc, wasn't calling Tom's beliefs in question, more the point he'd be singing about "Putin drops the bomb". Seems to have the cadence he'd sing to.
  16. M

    Sorry folks, Access World will not accept my posts

    Isn't there also a soft limit on the number of posts a new user can make per day? That way a spammer can't just make a couple hundred posts to the same thread to get past the limit.
  17. M

    Clear out data

    @MajP, but that intersection works just perfectly when you realize that each line is intended for a different type of traffic! One for blue traffic, one for yellow, one for red, one for green, and an extra to cover non-standard traffic that doesn't adhere to the standards! Also has a bypass for...
  18. M

    Field to enter ONLY time.

    @Ken, thank you for showing that that OP will need to convert to a different data type (string) for display!
  19. M

    2 queries in one form

    Before giving any theory advice, how quickly does your stock change? Do you normally have plenty to sell during the day and still keep stock for the next day? Do you sell out by the end of the day? Do you sell out during the day and have to stop selling that item? Depending on how quickly your...
  20. M

    Another Loss of Some Note (or Notes)

    I've a feeling Tom would approve though...
Back
Top Bottom