Search:

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

Page 1 of 5 1 2 3 4

Search: Search took 0.01 seconds.

  1. John, all, Thank you once again for the help. ...

    John, all,
    Thank you once again for the help. Your demo did work. I started over and was able to get the code to work with the microsoft example. In my first attempt I deleted and recreated the...
  2. Good afternoon (EST) I found an article and code...

    Good afternoon (EST)
    I found an article and code sample I am trying to run: How to retrieve the selected items in a multiple selection list box as a comma delimited string in microsot Access . I am...
  3. Replies
    8
    Views
    1,887

    I would like to base the current ("new") record...

    I would like to base the current ("new") record on the previous record's date+7 days. Not change the previous record but base the new upon it. Thanks again for looking at this.
  4. Replies
    8
    Views
    1,887

    Thank you both for looking at this. I appreciate...

    Thank you both for looking at this. I appreciate your help.. Going to play with it some more.
  5. Replies
    8
    Views
    1,887

    Good Friday. I have a simple continuous form...

    Good Friday.
    I have a simple continuous form "frmOnCall". Three fields: oncallstartdate, PrimaryResource, SecondaryResource
    Oncallstartdate is a date field with general formatting. I am trying to...
  6. Replies
    1
    Views
    703

    I am trying to send information from the current...

    I am trying to send information from the current form to an MS Word template using the following I found in the book Mastering MS Access 2003.

    I get an error on createwordobj "sub or function...
  7. I initially thought stopping the user from making...

    I initially thought stopping the user from making the error (trapping) would be preferable. However I like the idea of using the native functionality to simplify things. Thank you for the...
  8. Replies
    2
    Views
    1,391

    Thanks Mark. That fixed it. I appreciate the...

    Thanks Mark. That fixed it. I appreciate the help.


    A couple of things. You should try to put all your variable declarations at the top of the sub. Don't wrap you Exit and Error Handling code...
  9. I would like to add the allow backspace in...

    I would like to add the allow backspace in addition to 0-9 integers below. I believe the Ascii code is 13 but i can't get it to work with the following.

    Private Sub txtSSN_KeyPress(KeyAscii As...
  10. Replies
    2
    Views
    1,391

    I have a text box on a form (txtLast) that is...

    I have a text box on a form (txtLast) that is used to obtain characters of a person's last name to pass to a form/query. I have a command button/on click event with which I am trying to:
    1) test...
  11. Replies
    4
    Views
    605

    I'm not sure if this posted already. (if so...

    I'm not sure if this posted already. (if so sorry) I am trying to pass start (saddr) and destination (daddr) from txtAddress and txtDestination using the following:

    Private Sub cmdMap_Click()
    ...
  12. Replies
    2
    Views
    475

    Thank you Hans! By using the Format...

    Thank you Hans!


    By using the Format function in the expression:

    ="Activity Statistics for Date Range:" & Format(Forms!frmDateRangeForActivity!Text12, "mm/dd/yy") & " - " &...
  13. Replies
    2
    Views
    475

    I have a text box on a form that uses the...

    I have a text box on a form that uses the following epxression to pull dates from text box controls on another form:
    ="Activity Statistics for Date Range:" & Forms!frmDateRangeForActivity!Text12 & "...
  14. Replies
    1
    Views
    302

    Pass list box selections to field (2003)

    We use Access to create meetings recaps. Information is stored in tblMeetingRecap, presented on frmMeetingRecap. InAttendence is a field used to capture who attended the meeting. There is a lot...
  15. Replies
    5
    Views
    384

    Re: List addresses in sent to folder (2000)

    The financial reporting application (FRx) is installed and published on a Citrix server. Outlook is also installed on the same server (but not published). Users access FRx to create/print reports. ...
  16. Replies
    5
    Views
    384

    Re: List addresses in sent to folder (2000)

    John,
    I would like it in some sort of structure (txt, csv, etc.) in an output file if possible. The trick is that outlook is installed on the server to facilitate emailing, but is not available to...
  17. Replies
    5
    Views
    384

    List addresses in sent to folder (2000)

    We have a financial reporting application that uses Outlook to distribute monthly reports to numerous (40-80) users. After the reports are sent, we would like a way to generate a file (text, csv,...
  18. Replies
    5
    Views
    288

    Re: Data not displaying consistently (2003)

    Hans, Andrew:
    Sorry for the delay in response. Primary keys are setup on the tables mentioned. The codes do appear in the drop down. I can see all the codes if I view the data source for the drop...
  19. Replies
    5
    Views
    288

    Data not displaying consistently (2003)

    We started with a single MDB containing two tables (Existing_Vendors, New_Vendors), one form (frmNew_Vendors) and one query (qryExisting_Vendor_Names). The form is based upon the New_Vendors table. ...
  20. Re: Create tasks in Project from MS Access (2003)

    Carla,
    That worked! Thank you. Do you know of any sites/resources that have documentation about using VBA to manipulate additional information within project (start, end, resources, etc.) ?
    Thank...
  21. Create tasks in Project from MS Access (2003)

    I posted this originally in the Access forum and was informed it is more of an MS Project question. I use the following to create/update an MS Project plan with a list of tasks:

    Function...
  22. Use Accessfield contents to create task in Project (2003)

    I use the following to create/update an MS Project plan with a list of tasks (found on MS KBID 210014)

    Function fncProjectOLE()
    Dim prjApp As MSProject.Application
    Dim prjProject As...
  23. Replies
    6
    Views
    322

    Re: Duplicate specific fields (2003)

    That works perfectly. Thank you Hans.
  24. Replies
    6
    Views
    322

    Re: Duplicate specific fields (2003)

    The replication works but from the last record. Is there a way for this work with the current record? Thanks.
  25. Replies
    6
    Views
    322

    Re: Duplicate specific fields (2003)

    (Edited by HansV to make URL clickable - see <!help=19>Help 19<!/help>)

    Hans, Thank you for the KB reference. The solution calls a procedure from the OnCurrent event on the form. Is there a way...
Results 1 to 25 of 107
Page 1 of 5 1 2 3 4