Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: X2600
  • Order by date
  1. X2600

    Creating and selecting paragraphs - Data Extraction

    I take it that they can be referenced in vba as a whole, then?
  2. X2600

    Creating and selecting paragraphs - Data Extraction

    It is word 2010. I am not sure how the comment feature could be used to isolate content in the document. Can you reference comments in vba? Also, I wonder if the traditional vb textboxes (like ms access) are available. I think multiline textboxes might work. My other thought is a multiline...
  3. X2600

    Creating and selecting paragraphs - Data Extraction

    SkipVought, Yes, they'll all have a similar name. So for the facilitator content blocks, they'll all be named facilitator1, facilitator2, facilitator3. The regular content blocks will be named something like regular1, regular2, regular3, etc... I need the button to automate the naming of the...
  4. X2600

    Creating and selecting paragraphs - Data Extraction

    Hello all! I am new to the forums. I am working on a project and am wondering the best way to go about accomplishing a particular task. A little about the project: The project involves automating a client's training guide creation process. Training developers create training guides using a...
  5. X2600

    Retrieve Table Column based on Date Calculation (Command button)

    Very close... that was an excellent suggestion btw. I did fool around a bit with Date_Format, with no luck. For future reference: Private Sub Command74_Click() FOL.Visible = True FOL.SetFocus Dim strWhere As String Dim strSQL As String strSQL = "SELECT TicketNumber, TicketNumber FROM Tracker "...
  6. X2600

    Retrieve Table Column based on Date Calculation (Command button)

    How would I convert this field to a date field? Instead of dim as string, dim as date?
  7. X2600

    Retrieve Table Column based on Date Calculation (Command button)

    Yes Sir, and I saw the code rejected in the debug window. So my question, then, is as follows: Given the two variables: Initial: yyyymmdd (It is stored in the table in this format) DateAdd Variable (Which is in a format I'm unfamiliar with) How can I compare the two variables? I would need to...
  8. X2600

    Retrieve Table Column based on Date Calculation (Command button)

    Good news and bad newbs... the good news is, the third query works perfectly. The bad news... the first two do not. I modified the code a bit, to try to suit the needs of the tables. The format for the date of "Initial" is yyyymmdd, which makes the calculation pretty simple, but it doesn't seem...
  9. X2600

    Retrieve Table Column based on Date Calculation (Command button)

    Cancel that... I had to open both eyes to see it. ;)
  10. X2600

    Retrieve Table Column based on Date Calculation (Command button)

    Firstly, thank you very much for your help. I look forward to trying the code, and implementing the technique you've used in future projects. however... This may seem like a rediculous question, but how do I create an options group? I have three options, each created individually. I must be...
  11. X2600

    Retrieve Table Column based on Date Calculation (Command button)

    Hello All, I've been working on a project for some time now - a ticket tracker to be precise. There are three fields in the table: Initial Request Date Followup Request Date Ticket Identification Number I've been trying to write VBA code that will retrieve the ticket numbers that were...

Part and Inventory Search

Back
Top