Search Results - VBForums

Search:

Type: Posts; User: swoozie

Page 1 of 9 1 2 3 4

Search: Search took 0.02 seconds.

  1. Replies
    0
    Views
    1,112

    .Net Architecture and the Cloud

    I am looking for reference material on how to design a .NET application which interacts with a database which is housed in the Cloud.

    I am specifically concerned with the interaction with the...
  2. Thread: Footer Issues

    by swoozie
    Replies
    1
    Views
    272

    Footer Issues

    I am using Access 2003 to generate letters. I need to be able to access a footer and update text to a date. I am unable to do this.

    I have tried variations of this

    If...
  3. Replies
    7
    Views
    425

    Re: Accessing a Variable Value

    i dont want to call it directly. let me try to explain it better.

    I have several word templates that are set up slightly differently for the letter type. I want to beable to write one little...
  4. Replies
    7
    Views
    425

    Re: Accessing a Variable Value

    No, that is backwards. I want to dynamically read the value of varname.

    i.e., we dim the variables ToAddress, CCAddress

    we set the variables

    toAddress = Mark
    CCAddress = George
  5. Replies
    7
    Views
    425

    Re: Accessing a Variable Value

    Okay, let me see if I understand the concept.

    I would "store" the values of the variables in a scripting dictionary object?

    then grab the values based on the variable name from the scripting...
  6. Replies
    7
    Views
    425

    Accessing a Variable Value

    This may sound odd, but I want to be able to dynamically access a variable value.

    I have a bunch of variables that correspond to bookmarks in word templates. Not all bookmarks are in all of the...
  7. Replies
    2
    Views
    270

    [RESOLVED] Check for Open

    How do you check if a file is already open and locked for editing before going to open it again via VBA code in Access 2003, opening a word document?
  8. Re: Unselecting a check listview item

    that is what I orignally tried however that throws an error that the property cannot be used for that.

    Any other suggestions?
  9. [RESOLVED] Unselecting a check listview item

    I have a list where users select the items they want to do an action with. To do the action the items selected need to meet certain criteria. If the item does not meet the criteria I want the list...
  10. Re: Access 2000 Email via groupwise

    It sends the email with out the attachment.

    When I debug, it assigned the file name to the variable but nothing happens after that with regards to the attachment
  11. [RESOLVED] Access 2000 Email via groupwise

    I am trying to send an email via Groupwise from Access 2000 adding an attachment of an Access report in rtf format. It is not recognizing or locating the attachment.

    I am using the following...
  12. Replies
    2
    Views
    540

    [RESOLVED] Form Operations in Excel VBA

    I created a user form called it Report.
    It opens on workbook open.
    On the initialize event it poopulates a combobox.
    Then I have a button that hides that form and shows a new form.

    this doesnt...
  13. Replies
    3
    Views
    465

    Re: Cross tab Reports

    I am looking to create a report that looks like this

    2007 2008
    MAY MAY...
  14. Replies
    3
    Views
    951

    Re: ODBC Error Trapping

    For some reason VBA did not capture the err when receiving and ODBC call fail, I had to use dbengine.err to identify the error and set a work around/response for when it happens.
  15. Replies
    3
    Views
    465

    Re: Cross tab Reports

    I wish it did, my problem is that I do not need any vb/.net help pertaining to crystal. in fact I think it would be easier to build this report via a vb app, but then I would have just build an...
  16. Replies
    3
    Views
    465

    Cross tab Reports

    I have not worked in Crystal since 8 came out years ago. I am way behind the ball on a project I was assigned. I took the project because I thought it was an excel report then I was told I had to...
  17. Replies
    3
    Views
    951

    [RESOLVED] ODBC Error Trapping

    Is there anyway to capture an ODBC error and manage it through an error handler?

    I am using Access 2000 VBA
  18. Replies
    1
    Views
    296

    [RESOLVED] Access to Word with VBA

    I have a database that manipulates a word template and then merges data into it. I am trying to speed up the processing and I am not sure what else I can do.

    I have turned screen updating off, I...
  19. Replies
    2
    Views
    2,647

    Access 2003 Runtime Error 3265

    I want to capture the run-time error 3265, item not found in this collection, but I have been un successful.

    I have 2 tables and the items with column names alike I want to update from one tot...
  20. Replies
    6
    Views
    373

    Re: Has this happened to you?

    Public Function FixZipCode(ByVal Zip As String) As String
    Dim Lenth As Integer
    Dim i As Integer
    Dim Temp As String

    Zip = Trim(Zip)

    If Zip Like "*-*" Then
    'nothing
    Else
  21. Replies
    6
    Views
    373

    Has this happened to you?

    I have an access 2003 database and I am receiving a type conversion failure error on a zip code field.

    I have a function that inserts the "-" in the zipcode.

    The field is Text(15) Zero...
  22. Replies
    1
    Views
    2,729

    [RESOLVED] Check for Open File

    I have an Access 2000 database writing to a word document. The issue I am running into is that the database doesn't always open the file but it was coded to always close the file. I need to check...
  23. Call Access 2000 to run a macro from VB Script

    I want to write a vb script to be run on a schedule to call macro and a procedure in an access database.

    I do not know how to do this.



    'I am sure you need to create and object

    dim...
  24. Re: Access 2003 - Authenticate w/Active Directory

    Here is what I have come up with so far and it isnt working. I noted the location if fails. any ideas?


    Public Function AccessLDAP()
    Dim con As ADODB.Connection
    Dim cmd As...
  25. Access 2003 - Authenticate w/Active Directory

    How do you authenticate a login against the LDAP/ACtive directory via VBA, in Access 2003?

    I know how in .net but I can not seem to organize it in a manner acceptable by access.
  26. Replies
    1
    Views
    617

    Crystal 9 and 11

    Is there a way to install both version 9 and 11 on the same PC?
  27. Thread: Formula Fields

    by swoozie
    Replies
    0
    Views
    479

    Formula Fields

    I need to have 2 fields that calculate the display, based on a look up (I think)

    I have 2 diffent ID fields that link to the same 'look up' fields. These field can be null so I wanted to do...
  28. Replies
    0
    Views
    694

    Word 2003 Form Template

    I have created a simple user form template using Word 2003. You know the ones with the grey fields that you leave unsecure and the rest you secure. Anyways I wanted to do 3 things.

    1) Create...
  29. Re: [Excel] How do you Load data into a listbox?

    Close, I guess i am just not quite clear enough.

    I want to populate 1 listbox that has 13 columns (if possible)
    Then I want the user to be able to click on the item in the list box to populate...
  30. Replies
    8
    Views
    542

    Re: [Excel] Listbox

    To populate the listbox yes, but After the list box is populated I need to populate test boxes with the selected records.
  31. Replies
    2
    Views
    359

    Re: [Excel] Sharing a Workbook

    just with one workbook. I have full read write access to the server it reside on, and I was able to copy the contents into another file and make it shared, but I couldn't share that file.

    I...
  32. Replies
    2
    Views
    359

    [Excel] Sharing a Workbook

    I want to share my workbook with other users so I went to Tools, and the Share Workbook option is greyed out.

    Any idea as to why or how to change it?

    Thanks,
  33. Replies
    8
    Views
    542

    Re: [Excel] Listbox

    All code is in the form, frmMain.


    There is only one form, everythign is on one form.


    The listindex is really "odd" it has ranged from 0 to 244, which shouldn't be an issue since there are...
  34. Replies
    22
    Views
    753

    Re: Set statement

    You guys, hate to interject but I think we are getting ahead of ourselves here and need to get a response from the actual user. For all we know from the original post is that he may need to add a...
  35. Re: [Excel] How do you Load data into a listbox?

    No, I can not upload :(, but the last code item I used using the rowsource was


    Private Sub UserForm_Initialize()
    'populate all listboxes
    Dim c As Control

    'this is just code I got from a...
  36. Replies
    8
    Views
    542

    Re: [Excel] Listbox

    That was the last thing I said I tried, but when I would click on the list box it would not populate the textboxes I had associated with columns.

    here is the line of code I use to populate the...
  37. Replies
    1
    Views
    356

    Re: learning VB for Excel

    Start with the Tutorials with in the forum.

    http://www.vbforums.com/showthread.php?t=358585

    If you are using VBA, record macros and see what the code look like. VBA can be learned by trial and...
  38. Re: Customize Function For Default Value Field Table In Access

    Why don't you try it and see if it works, and let the rest of us know. :)
  39. Replies
    22
    Views
    753

    Re: Set statement

    Where is the code coming into play at? do you have to incorporate "Result" into that code or something?
  40. Replies
    8
    Views
    542

    [Excel] Listbox

    Okay, I give up, does someone have a piece of VBA code that handles list boxes?

    I have a spreadsheet with 244 rows (this fluctuates) and 13 columns, this does not fluctuate.

    I want to populate...
Results 1 to 40 of 331
Page 1 of 9 1 2 3 4



Featured


Click Here to Expand Forum to Full Width

Survey posted by VBForums.