Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.01 seconds.

  1. Replies
    3
    Views
    611

    I like that, very simple. What if there is a...

    I like that, very simple. What if there is a requirment for a password?
  2. Replies
    3
    Views
    611

    I have to simple access 97 database that I would...

    I have to simple access 97 database that I would like to make read-only. What is the easiest way to make this happen?
  3. Replies
    2
    Views
    1,225

    I'm just looking for an easy way to filter a...

    I'm just looking for an easy way to filter a subform (subform based on query) using a toggle. Something that is also easy to expand on since I can foresee multiple toggle buttons. Thanks.
  4. Replies
    1
    Views
    415

    The following code works when I type 4.1 but not...

    The following code works when I type 4.1 but not with 4.10. Any ideas why?

    Dim strSQL As String
    Dim smp As DAO.Recordset

    strSQL = "Insert into tblDatabase ( EmployeeNumber,...
  5. Replies
    1
    Views
    367

    I can't remember the code to format the color of...

    I can't remember the code to format the color of each textbox in the detail section of a report. Could some please help, it was something like.

    For each ctrl in details
    if me.ctrl.value = 0 then...
  6. Replies
    5
    Views
    710

    Still nothing, could it be because the column...

    Still nothing, could it be because the column headings are the same in each crosstab query?
  7. Replies
    5
    Views
    710

    The subreport is blank for all records. I just...

    The subreport is blank for all records. I just want the subreport to show records where they are available.
  8. Replies
    5
    Views
    710

    Is it possible to create a subreport that has...

    Is it possible to create a subreport that has less records than the main record. I have tried and the subreport is blank. The subreport and main report are linked by two fields. Both reports are from...
  9. Replies
    1
    Views
    428

    I have a crosstab query that has 6 row headings...

    I have a crosstab query that has 6 row headings and about 25 column headings. I would like to create a report that fits on one page and hopefully can wrap onto one page. I would like to have the row...
  10. Thread: Date Checker

    by sarnelli
    Replies
    3
    Views
    406

    How do I code the date from the form (currently...

    How do I code the date from the form (currently being entered) vs. the date from the table (stored date to be overwritten)?
  11. Thread: Date Checker

    by sarnelli
    Replies
    3
    Views
    406

    What is the simpliest way to check that the date...

    What is the simpliest way to check that the date entered is greater than the already stored. For example

    Private Sub Last_Reviewed_BeforeUpdate(Cancel As Integer)

    If Me.LastReviewedDate <...
  12. Replies
    2
    Views
    413

    I'm trying to do some totals per person with a...

    I'm trying to do some totals per person with a query and not having luck (summary report). I have Grouped By Person in the first column. In the second column OriginalDate and count below. This works...
  13. Replies
    6
    Views
    518

    Oops, the Name the of the textbox was Original...

    Oops, the Name the of the textbox was Original Date (with a space). Works now, thanks.
  14. Replies
    6
    Views
    518

    I'm getting a Compile Error: Method or Member not...

    I'm getting a Compile Error: Method or Member not found and .Locked is highlighted. Any reason? Thanks.
  15. Replies
    6
    Views
    518

    Is this possible with a datasheet style form?

    Is this possible with a datasheet style form?
  16. Replies
    6
    Views
    518

    I have a dataform that stores two dates. One is...

    I have a dataform that stores two dates. One is called originaldate and one is nextdate. If the originaldate is null I want to be able to enter a date but I don't want to be able to change an...
  17. I have a form with single select listbox...

    I have a form with single select listbox (LAreas). The listbox filters the records that show in my subform (LTests). So each LArea has many LTests. I want the user to select a LAreas and be able to...
  18. I have a table called people, a table called...

    I have a table called people, a table called tests and a table called data. To make the database work a little like excel I added all the records in tests for all the records in people into the data...
  19. Replies
    1
    Views
    271

    Crosstab Query (Access 2000)

    I have a table that has data in the attached format. I need to create a crosstab query where the samples are across the top or column headings, the result is the value and where lab is the row...
  20. Replies
    9
    Views
    730

    Re: Parent.Column (Excel 2003)

    Hans, you rock. So close to finishing. Just need to dump the array on to a sheet called Calendar, one row for each 1 to 3. Not sure how to do this.

    Thanks again to help.
  21. Replies
    9
    Views
    730

    Re: Parent.Column (Excel 2003)

    So would I have three arrays to collect data like that.
  22. Replies
    9
    Views
    730

    Re: Parent.Column (Excel 2003)

    Thanks again. Another question, how do I determine the size of my array or do I have to. I want to collect data the following way. I'm not sure who many points it will collect.

    Option Explicit
    ...
  23. Replies
    9
    Views
    730

    Re: Parent.Column (Excel 2003)

    Thank you, another question.

    When I'm giving through my range of values I want to ignore cells that have the text "Contact" or "Supplier" or "Etc.1" or "Etc.2". What is the best way to do this? I...
  24. Replies
    9
    Views
    730

    Parent.Column (Excel 2003)

    I'm having problems with the following code. I get an object error on the Response line where I get to determine the header for that column.

    Public Sub Outlook_Calendar()

    Dim oCell As Range...
  25. Replies
    5
    Views
    420

    Re: Linking Tables (Access 2000)

    When I remove the Link Child Fields and Link Master Fields the subreport shows on print preview and print. It does work or show on layout preview.
Results 1 to 25 of 132
Page 1 of 6 1 2 3 4