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!

Register Log in
  • Congratulations derfloh 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: nickrugado
  • Content: Threads
  • Order by date
  1. nickrugado

    loop through records on a form, run code on each record

    thread705-544592 I have a form that is based off a query (using certain criteria). It displays 1 record at a time. I want it to do the following. Run queries (These update queries use criteria from each record on the form. Queries already created) Move to the next record. Run the queries...
  2. nickrugado

    Does this date fall between this date range?

    I have one query that retrieves a record with a date. I have another query that retrieves a record with a date range. I want to if the 1 date falls between the range... Any idea on how to do that?
  3. nickrugado

    Range in one query to determine which row in another query matches.

    I have two queries one that pulls a record in the current year with an EffDate of 5/1/12 and the other query for the previous year that has multiple rows. I want to find which of those 6 records was the one that was active 1 year ago using the EffDate from the current year query. Anyone have...
  4. nickrugado

    Help.... look at this reference to a sub/sub form is it wrong?

    DoCmd.Requery Forms![dsh_dshbd_layout]![dsh_tab_HDMI_forSUBTABS].Form![frm_MITerms].Form![MktRent]
  5. nickrugado

    Referencing a subforms subform.

    On one(main) form I have a subform(sub1) with a subform(sub2) that I want to requery. Can anyone help me with referencing and requerying a subform? DoCmd.Requery (reference to sub/subform)
  6. nickrugado

    loop through email addresses to send 1 email to all help in vb code

    I found some code and now I'm trying to troubleshoot it. I have 2 issues. the line with the ~~~~'s errors out and highlights the entire code to the end of the ~~~~'s The second question I have is that I have placed this in a module, how do I call the module from the form when a button is...
  7. nickrugado

    phone number typed in comments, help me get it out

    If I have a phone number in a comments field with words before, before and after or after with any of the formatting then I want to pull that data out and put it in a field called phone number. An update query or vb behind a form would be cool too. phone numbers could be formatted...
  8. nickrugado

    Outlook Macro to get data from a field in an MS Access DB

    I want to get data from an ms access database using outlook to create a formatted e mail that can be sent out by the user. This e mail would use about 10 fields in a temporary table. In the table the user name of the person wondering if the person's e mail address could be used and linked to...
  9. nickrugado

    msg box

    I want to prompt the user to make sure that they want to add a record. There is one exception... if the client is equal to clientid = 100, otherwise prompt text in the box "Are you sure you want to add the record?" Yes, then add No, then cancel
  10. nickrugado

    SQL Syntax Help

    I have this query that uses MRI database if anyone knows that software. The query has 10 sub queries... I'm having trouble breaking up the 1 into it's 10 to find the problem... Any help would be appreciated. Thanks, Select distinct name.unitid AS [Unit ID], (Select Distinct chgcode from...
  11. nickrugado

    MS Access on Web based servers security and encryption

    I have the desire to put my database on a web server. There are companies out there that host them. I am however concerned on the security of the data on the server and the transmission of the data from them to my sites. What options should I ask for to ensure that my data is safe from point...
  12. nickrugado

    if value is 1,then run rpt A, ..., ...,

    I want to be able to have the report that's being run be dependent on a value in a record. i.e. if reportvalue = 1, then run reporta if reportvalue = 2, then run reportb if reportvalue = 3, then run reportc I know as much as that it is a nested if then statement... can anyone...
  13. nickrugado

    Inhereted bad vb code... please assist

    This is the problem area that is being highlighted by the debugger, this is a MS Access 2003 DB. txtCurrRent = Me.MktRent - forms_frm_MoveInDECredit!txt30Percent - forms_frm_MoveInDECredit!Gas - forms_frm_MoveInDECredit![W/S] - forms_frm_MoveInDECredit![Electric] -...
  14. nickrugado

    2 list boxes with dates. Box two default value driven 1st

    I have two list boxes with dates in them for the user to select from. List box 1 is the beginning date and 2 is the ending date. When the date in box 1 is selected I want box 2 to be set to the last day of the next month. i.e. box 1 selection 6/1/08, result box 2 default value 7/31/08 box...
  15. nickrugado

    Ambigious name detected....

    Compile error: Ambigious name detected.... first line is highligted in yellow... 5th line where it says 'displaymessage' is highlighed in blue. Several areas in the DB where this code exists... is something formatted incorrectly?? Private Sub PhEmDate_Enter() On Error GoTo...
  16. nickrugado

    Password if then statement

    Hi, I have a form that will have a place for the user to enter a password. I want to use visual basic to compare what the user enters against the field on the form (hidden) and run macro 1 if it matches, run macro 2 if it does not. Any help would be appreciated. Thanks field names PIN(field...
  17. nickrugado

    Password with If then statement for validation and action

    Hi, I have a form that will have a place for the user to enter a password. I want to use visual basic to compare what the user enters against the field on the form (hidden) and run macro 1 if it matches, run macro 2 if it does not. Any help would be appreciated. Thanks field names PIN(field...
  18. nickrugado

    strip the letter off of a code

    I have many records, all of them are at least 10 spaces some are 11 or 12 ... The 11th and 12th spaces are letters. I want to strip off the numbers and the letters and import them into seperate fields. An example of the data... parsing left 10 to a field and right blank to 2 charachters to...
  19. nickrugado

    Columnar instead of rows

    I have a report requirement that shows quarterly sums in columns instead of rows. I have accomplished something like this before by making each column it's own subreport. I don't know that this is the best way. I have the following data summed up by company name and detailing out the...
  20. nickrugado

    >3 ... ellipsis changes changes to a Verticle bar in field.

    >3 ... ellipsis changes changes to a Verticle bar in field. A High End user wants to be able to add more than 3 ellipsis and when that happens it changes them into a bar. Any way to get around this? Any help would be appreciated. Thanks

Part and Inventory Search

Back
Top