Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.42 seconds.

  1. Re: Query to display missing records in a time period

    Try:


    SELECT tblReadingDate.ReadingDate, tblDailyReadings.entityKey, tblDailyReadings.myValue
    FROM tblReadingDate LEFT JOIN tblDailyReadings ON tblReadingDate.ReadingDate =...
  2. Replies
    2
    Views
    253

    Re: Open Args and export question

    If the record source for your report is a named query (which you can rewrite as the criteria for the report are selected), you can export the query to Excel.

    Denis
  3. Re: Query to display missing records in a time period

    If you include the data field from the main date table in the output, you will see which dates are missing. Just having the null fields from the data table will only show blanks, because that is what...
  4. Replies
    6
    Views
    476

    Re: Count and Group by Date Range

    I've come to this late but you could try leaving DATA.DUEDATE out of the display fields. That way you don't need to group by it.

    So, change...


    SELECT DATA.ACCOUNT, DATA.VENDOR, DATA.AMOUNT,...
  5. Replies
    5
    Views
    1,519

    Re: Merge Cells Repeat

    Hi

    Here is one way to extend the macro:

    Sub MultiCol()
    Dim i As Long
    Const RwStart = 3

    For i = 1 To 7
    Cells(RwStart, i).Select
  6. Re: Tutorial -- An Access menu / permissions system

    You're welcome, and I'm glad that I could point you in the right direction.

    As you can see from the first post this thread has been up for several years, so I don't always remember what answers I...
  7. Re: Tutorial -- An Access menu / permissions system

    Hi, and welcome to the Board.

    That sort of error often happens if something is missing. I'd suggest that you put a break-point on the first line of that sub, then launch the for and go into Debug....
  8. Re: Tutorial -- An Access menu / permissions system

    Hmmm should have read the topic first. I have 2 tutorials, and thought you were referring to the other one (Access and Excel)
    it doesn't change the fact that you can use this for tables, but...
  9. Re: Tutorial -- An Access menu / permissions system

    Yes it does. In the segments where you add a region and populate it, you're directly using a table. Where you retrieve data by region, you are creating a filter to effectively run a query on a table....
  10. Replies
    6
    Views
    262

    Re: Display Count of Records in a Textbox

    Happy to help.
    Out of interest, which option did you go for?

    Denis
  11. Replies
    6
    Views
    262

    Re: Display Count of Records in a Textbox

    Textboxes can't hold query results, which is the problem you are having at the moment.
    Actually, rephrase that. Textboxes *can* hold query results but you can't have a query as the Control Source of...
  12. Replies
    6
    Views
    262

    Re: Display Count of Records in a Textbox

    Do you just want to see how many there are, or actually view the details?

    Denis
  13. Re: VBA to copy formula from one cell to variable range

    I'm guessing that the LR bit isn't working correctly, and this snippet could be the reason.
    Change

    LR = Range("A" & Rows.Count).End(xlDown).Row
    to

    LR = Range("A" & Rows.Count).End(xlUp).Row...
  14. Re: VBA to copy formula from one cell to variable range

    Try:


    Range(ActiveCell,Cells(LR,ActiveCell.Column)).FillDown

    Denis
  15. Re: Is there a 3rd party freeware can modfiy MDB file with similar graphic solution as Acess ?

    You can also use Excel to modify an MDB file but that requires coding to retrieve and update records.
    Note that if you use the Access runtime it's fine for viewing / manipulating data, but you...
  16. Replies
    14
    Views
    115,524

    Re: Database keeps opening as READ-ONLY??

    That will do it. I avoid linking to Excel because either application can lock the other up, and you can't edit the Excel data from Access. In addition, the performance is much slower than for a...
  17. Replies
    18
    Views
    12,664

    Re: VBA Code to Rename a Defined Range

    Hi, this code belongs in a standard module like you did the second time. Places like Sheet1 or ThisWorkbook are generally a bad place to put general VBA code.

    When you put the code into Module1...
  18. Replies
    1
    Views
    279

    Re: Modify multiple MDB file's modules

    It is possible to edit modules using VBA. The best tutorial I know is Excel - based: Programming In The VBA Editor
    However, you will most likely need to go into each database first and change the...
  19. Replies
    30
    Views
    1,703

    Re: Addressing Access Forms

    Not that I am aware of, unfortunately.
    it appears that you have to have the focus in a control to show the scrollbars. That would be a point of difference for, say, a web-based control.

    Denis
  20. Replies
    30
    Views
    1,703

    Re: Addressing Access Forms

    If you are only working with one record, a subform isn't going to help much because they are usually intended to display many records related to the one one the form.
    Examples would be students in a...
  21. Replies
    30
    Views
    1,703

    Re: Addressing Access Forms

    No, not to pick the values at run time. The form will populate with the contents of the table.
    But because you will have many records in the table (and hence in the form), it often helps to be able...
  22. Replies
    30
    Views
    1,703

    Re: Addressing Access Forms

    Yes, but the trick to it is what the combo box does with the value.
    If you follow it through, this is the sequence:
    1. You type the name you want to search
    2. The combo takes the associated ID,...
  23. Replies
    30
    Views
    1,703

    Re: Addressing Access Forms

    When the form is bound to the table, you can browse through the records -- see navigation controls on bottom left of form.
    If you make changes to a control value, they affect the current record....
  24. Replies
    30
    Views
    1,703

    Re: Addressing Access Forms

    Is the form's record source set to the table, or a query based on the table? I think it isn't, and that is your problem

    Denis
  25. Replies
    30
    Views
    1,703

    Re: Addressing Access Forms

    The reason that you couldn't do any data entry is because you had a calculated value in the control source.

    If the form is set to use tblMisc as a record source, then connecting the checkboxes is...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4