Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.01 seconds.

  1. Replies
    6
    Views
    1,461

    If you use the following command: ...

    If you use the following command:

    DoCmd.OutputTo acOutputReport, "Report Hourly", acFormatXLS, "C:\Dropbox\Report Hourly.xls"

    And leave off the location it will automatically prompt you for a...
  2. Replies
    6
    Views
    1,461

    I tried that and the code from Listing C where it...

    I tried that and the code from Listing C where it makes declarations does not compile.
  3. Replies
    6
    Views
    1,461

    This is what I have to save the report to the...

    This is what I have to save the report to the hard code location. I want to prompt for the location though.

    Private Sub btnExport_Click()
    DoCmd.OutputTo acOutputReport, "Report Hourly",...
  4. Replies
    6
    Views
    1,461

    SaveAs Dialog Box Access 2000

    I am trying to export an access report to excel. I can currently export the data and save it by hard coding the file location. I want to prompt the user for the location where they want to store...
  5. Replies
    4
    Views
    2,954

    The ActiveX Calendar Control 12.0 is not...

    The ActiveX Calendar Control 12.0 is not supported in Access 2010. See the link to the msdn:

    http://msdn.microsoft.com/en-us/library/gg251104.aspx
  6. Replies
    4
    Views
    2,954

    I am using Access 2010. This is why I can't just...

    I am using Access 2010. This is why I can't just use the built in Calendar Control. The application is a timesheet card. The user picks the week they want from a calendar. The database has worked...
  7. Replies
    4
    Views
    2,954

    Access Calendar Control in SubForm

    I am trying to implement a calendar via a subform. I found this demo on the msdn. However I don't want the text box to be updated when the Month and Year increment and decrement buttons are...
  8. Replies
    1
    Views
    804

    Modify SQL from VBA

    I have a make table query that adds a table to a back end database. I need to modify the location of this table from VBA. Here is my query in design view:

    SELECT tblJobNumbers.ID,...
  9. Replies
    1
    Views
    591

    Browse to computer from text box?

    I want to select a file location and have the path stored to the text box. What is the best way to do this? I don't need to upload the file or anything, just remember the path.

    Thanks,
    BZ
  10. Replies
    4
    Views
    1,823

    Thanks RG I got this to work. BZ

    Thanks RG I got this to work.
    BZ
  11. Replies
    4
    Views
    1,823

    Is there a way to look for the linked table in...

    Is there a way to look for the linked table in the folder where the front end is located?
  12. Replies
    4
    Views
    1,823

    How to locate linked tables automatically.

    I have an MS Access database that has a linked table. For various reasons the location where the database and linked table is stored changes. Is there a way to store the linked table so that I don't...
  13. Replies
    3
    Views
    3,099

    I want to display two fields together in a text...

    I want to display two fields together in a text box from my table. I can get it to show one of them but not two fields.
  14. Replies
    3
    Views
    17,635

    I have a Visual Studio project that I am trying...

    I have a Visual Studio project that I am trying to open a form in the click event of a button. When I try DoCmd.OpenForm "frmName" the compiler says docmd is an error. How do I make DoCmd work?...
  15. Replies
    2
    Views
    728

    I am trying to run a sql query from an on click...

    I am trying to run a sql query from an on click event from a button. Here is my event:

    Private Sub Command44_Click()

    Dim dbs As Database, qdf As QueryDef, rst As Recordset

    ' Return...
  16. Replies
    8
    Views
    548

    Re: Object Lists (2003)

    Ohh my mistake I looked right over that.
    thanks,
  17. Replies
    8
    Views
    548

    Re: Object Lists (2003)

    When I select type 5, the list has all my queires in addition to several queries that start with "~_sq....." They do don't apper in my normal list of queries. Do you know what they are?
  18. Replies
    9
    Views
    700

    Re: Sub Form Entry from List Box (2007)

    That is what I needed. That works.

    Is [Forms]![frmweek]![Child808]![Field1] the same as Me!Child808!Field1?
  19. Replies
    9
    Views
    700

    Re: Sub Form Entry from List Box (2007)

    But that is what I want to do, I want it to create a new record. The Subform contains entries for different vendors. I am setting it up so if the user doesn't know the vendor name, Field1, they...
  20. Replies
    9
    Views
    700

    Re: Sub Form Entry from List Box (2007)

    I am sorry. Let me try to better explain.

    My table has fields Field1, Field2, Field3, and Field4. The table currently is populated with records 1, 2, 3, 4, 5, etc. When the parent form loads the...
  21. Replies
    9
    Views
    700

    Re: Sub Form Entry from List Box (2007)

    The hidden value in the textbox is set from a different form when the form loads. The value will change each time the form loads. The subform loads and fills with several records. The last record...
  22. Replies
    9
    Views
    700

    Sub Form Entry from List Box (2007)

    I have a form which contains a subform. There is a hidden value on the parent form call txtName. When the form loads the sub form, which is set to continuous, loads and has multiple records. The...
  23. Replies
    6
    Views
    598

    Re: Search Form (2007)

    thanks hans.. thats what i need.
  24. Replies
    6
    Views
    598

    Re: Search Form (2007)

    Here is my code:

    Private Function DoSearch()
    Dim rs As Object
    Dim strFilter As String
    Set dbs = CurrentDb

    ' Assemble filter string

    ' Field1 is string
  25. Replies
    6
    Views
    598

    Re: Search Form (2007)

    Thanks Hans. I want the user to be able to search by keyword also. For example if they type in "Station" in the customer name, I want to display all customer names that have the word station in it....
Results 1 to 25 of 132
Page 1 of 6 1 2 3 4