Search:

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

Page 1 of 2 1 2

Search: Search took 0.00 seconds.

  1. Replies
    95
    Views
    15,779

    When you go up to Microsoft's gadget gallery, it...

    When you go up to Microsoft's gadget gallery, it does indeed say that " the Windows website no longer hosts the gadget gallery. " It also states: "Gadgets installed from untrusted sources can harm...
  2. Replies
    6
    Views
    6,184

    You might want to Consider this as an...

    You might want to Consider this as an alternative:
    1) Using Code, create a linked table to the SQL Server database (see: http://support.microsoft.com/kb/892490)
    2) Once you have that linked table...
  3. Replies
    10
    Views
    3,679

    In addition to what has been discussed...

    In addition to what has been discussed previously, you might want to review this paper the addresses Query Exectuion Plans and how they can impact performance:...
  4. Replies
    3
    Views
    6,852

    I watch your column with great interest but have...

    I watch your column with great interest but have never really needed to avoid any updates until recently when my PC wouldn't install the automatic updates. Thankfully there is some "Rollback"...
  5. Replies
    8
    Views
    2,287

    Fred, I normally agree with your columns. ...

    Fred,

    I normally agree with your columns. You give great advice. So I am puzzled. Did I miss something? Your advice to change my internet settings to protect against Evercookies has caused my...
  6. Corey, Perhaps you have come to a conclusion...

    Corey,

    Perhaps you have come to a conclusion with this. If not, here are a couple of things to think about.

    First of all, I took your spreadsheet and turned it into a Table in Access 2010...
  7. Just a few observations You can certainly can...

    Just a few observations

    You can certainly can do an emailing using Word 2003 and Access 2003 and use Outlook 2003 as the email client.

    First, create and run a MakeTable query in Access that...
  8. Replies
    9
    Views
    1,230

    Very interesting. I stopped creating/modifying...

    Very interesting. I stopped creating/modifying Querydefs through code a while back because it caused major MDB file bloat. Each time you modified a Querydef, MDB file expanded. haven't tested it...
  9. Replies
    9
    Views
    1,230

    PMJI I see you have a couple of solutions. I...

    PMJI

    I see you have a couple of solutions. I would have to agree wth John that in most cases the best way is to use the WhereCondition of the OpenReport method when running the report rather than...
  10. Sure... One way is to set up a Tab Control...

    Sure...

    One way is to set up a Tab Control with a different page for each situation. Put the controls in places that you want them and then just choose the desired page of the tab depending on...
  11. I think a better way for you to approach this...

    I think a better way for you to approach this would be to examine your reasoning for not creating a persistant form and showing, hiding and populating controls etc as needed. Creating a form "On the...
  12. Thread: Input Mask

    by BobOxford
    Replies
    2
    Views
    528

    I think what you will want to do is manipulate 2...

    I think what you will want to do is manipulate 2 of the Properties for the Control displaying the Long Time:

    Input Mask: 99:00:00;;_
    Format: hh:nn:ss

    Input Mask - will control how you input...
  13. Replies
    9
    Views
    912

    Oh yes...I certainly agree about your source of...

    Oh yes...I certainly agree about your source of business. Quite a number of my clients start with Excel, think they can use Access but never learn how to use it, bringing their Excel paradigm to...
  14. Here is an article from MSDN which might be of...

    Here is an article from MSDN which might be of some help

    http://msdn.microsoft.com/en-us/library/aa217449(office.11).aspx
  15. Replies
    3
    Views
    516

    Assuming the following table structures ...

    Assuming the following table structures

    Complete_Report
    ID (Long Integer)
    WriterName (Text)

    For_Processing
    ID (Long Integer)

    The Query Should read:
  16. Replies
    4
    Views
    567

    You will be able to do it with a UNION query but...

    You will be able to do it with a UNION query but each Query will need to have the same number of columns. In your current situation, query_future has one more column than query_actuals. The Query...
  17. Replies
    9
    Views
    912

    I have done some research on this issue. From...

    I have done some research on this issue. From what I have experienced and read, I have drawn the following conclusions about this issue:

    1) There is no way to have Access 2007/2010 using an accdb...
  18. Replies
    2
    Views
    487

    Suggestion...place a label Control (lblFooter) in...

    Suggestion...place a label Control (lblFooter) in the Footer on Report1 with the message: "There is no data in this time frame" with it's Visible property set to False. Instead of cancelling the...
  19. Replies
    6
    Views
    670

    Glad to help.

    Glad to help.
  20. Replies
    6
    Views
    670

    Step by Step Example: A 2 column report ...

    Step by Step Example: A 2 column report

    1. Open up your report in design view
    2. For the Detail/Group header/Group Footers, do not place any controls past the 3” mark in the ruler
    3. Choose:...
  21. Replies
    6
    Views
    670

    Yes, you certianly can have a Multi-column...

    Yes, you certianly can have a Multi-column reports in Access.

    It is accessed somewhat differently depending on the version of Access you are using but basically it is a Page Setup issue. You make...
  22. Replies
    2
    Views
    535

    Instead of...

    Instead of =Int([txtrunsum])*24+DatePart("h",[txtrunsum]) & ":" & DatePart("n",[txtrunsum])

    Try: =Int([txtrunsum])*24+DatePart("h",[txtrunsum]) & ":" & Format(DatePart("n",[txtrunsum]), "00"))
  23. Replies
    4
    Views
    3,746

    Not sure if this will help or not. If your issue...

    Not sure if this will help or not. If your issue really stems from cabling then I would guess not but I recall...way back, an issue that was had that sounded something like this. We solved it by...
  24. Thank you. I appreciate your input. Yes, your...

    Thank you. I appreciate your input. Yes, your approach certainly has merit except for that one little glitch of needing to add tables for each different relationship type. My overall goal here is to...
  25. This issue has always proven to be a challenge to...

    This issue has always proven to be a challenge to me when designing a relational databases: Types

    For example: You are entering in data for a person: Name Address, etc. Each Person is of a...
Results 1 to 25 of 34
Page 1 of 2 1 2