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 Chriss Miller 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: 3Mark3
  • Content: Threads
  • Order by date
  1. 3Mark3

    Delete first character in field if space is present?

    Hello all..I'm having some difficulty trying to figure out how to delete a space in a field if the first character is a space? I have a series of loan numbers..but some of them, when imported, have a space as the first character. How could I construct a query to look for those and delete that...
  2. 3Mark3

    Question regarding Fee's and applying to multiple records

    Good morning, I'm having a problem building a query on a type I've not worked before. Here's the situation. I have a field (we'll call this a FEE) within a table that contains multiple fees for a given loan number. I have another field (we'll call this a REMAINING AMOUNT) that contains an...
  3. 3Mark3

    Build event to close db at pre-defined time?

    Hello all, I'm trying to figure out how to build a timed event that will close my access database at 6:30 in the evening. Now I know I can use the timer event and based on a certain intervals, but that won't work well. Can you advise of a solution? Thank you in advance! Mark
  4. 3Mark3

    How to calculate Odd/even days?

    Hello all....I can't seem to find a way to query Odd or even days. I'm working with a date field....although I imagine it would work with a number as well... Could anyone help me? Thank you! Mark
  5. 3Mark3

    ? Regarding count on control...

    Hello everyone. I have a problem I'm Trying to resolve. I have a control in a report called [Completed]. I have, at the bottom of my report footer, a count for that control. The range of values in this control is either "yes" or "no". I can't seem to count these individually. Can someone...
  6. 3Mark3

    Possible to require a password for an on click event?

    Hello all. I may be going about this the wrong way, but I'd like to password protect a control that will open another form. Is this possible? Or is there a better way to go about this?
  7. 3Mark3

    problem figuring a date minus 10 years

    I'm obviously doing this wrong..can anyone figure out how to fix my problem? Thank you! DatePart("yyyy",[date_maturity]-10)
  8. 3Mark3

    Help with deleting duplicate records....

    Good morning everyone, I have a question I hope someone can help me with. I would like to delete any duplicates in a query. Now I understand I can use the "find duplicates" query to identify, however if I were to delete those records, woudln't that also delete all instances? How would I go...
  9. 3Mark3

    Help with an On Load event....

    Afternoon everyone and Happy Friday! I have a question I'm hoping someone can help with. I have a subform that is tied to a query. I would like to have a box which will ask the person their first name (I already know how to do this part). What I would like to do...is based on what name they put...
  10. 3Mark3

    Query to append controls into Memo field

    Hello all, I'm trying to figure out how to add a return when pasting several controls into a memo field. what I'm trying to do is add return lines after each field. For instance: [Control1] [[Control2] [Control3] When I'm creating the query, I use: [Control1]+[Control2]+[Control3] How...
  11. 3Mark3

    Iff (w/ or) statement not working, tips?

    I have an iif statement that I'm not doing right. Can someone correct this? Thank you! F5: IIf([Welc_AK20060328]![Field5]="000" Or "TX75087000","good","Not good") right now it just returns all "good"...even though there are all kinds of different data.
  12. 3Mark3

    Query to remove first 4 characters in table

    Does anyone know how to setup this query? I'm trying to find out how to delete the first, say 5 characters. Example would be Pre-qry 0001974668845 post-qry 74668845
  13. 3Mark3

    Calculated field not working

    Hello everyone, I'm hoping someone can help me correct my code (which I know isn't done right). Here's what I'm trying to do. What I'm tring to do is sum up the field "Clundquist". However, I only want it to sum that field if the current month (formatted date part in date_today) is equal...
  14. 3Mark3

    Am I doing something wrong? Query problem

    Ok I'm trying to run a query. I'm formatting a certain field as follows: Audit Date: Format([audited],"Short Date") In the criteria, I have the following: >=[Enter start date to report] Now the problem is, no matter what date I put in the criteria, I still get all records. I have even tried...
  15. 3Mark3

    Query to append x number of records from a control

    Hello all, I have a form that contains two drop down unbound controls. One of these controls selects how many records in a subform (below) that one can view. What I've been trying to figure out is, I want to create an append query to append however many records that are indicated on the drop...
  16. 3Mark3

    Confused! Need help with email and checkbox

    Hello all, I've tried fixing this to no avail. I'm hoping someone here can help me. I have a button that is on a form that will send an e-mail based on some selections on this form. What I need to have it do is send an e-mail to every rep that has a checkbox. Please see below code. As it...
  17. 3Mark3

    Current record and a query

    Good morning everyone, I have a question regarding the "current record" and a query I have. I'm trying to do an append query based on a few fields in a form. I have two fields in the append query that look at the values entered in two of my subforms in my main form. The criteria in those two...
  18. 3Mark3

    ? Regarding Cancel event in module

    Hello all, I'm hoping someone can help me. I have a command button, that when clicked generates an e-mail. I noticed once I create an e-mail, then decide to close it without sending it, I get the following in the database: Run-time error '2501': The SendObject action was canceled. Is...
  19. 3Mark3

    combining 1st initial and another field?

    Hello all, I have a query and I'm trying to create a field that will be used as part of a form for creating e-mails. The field I'm trying to create will contain the first initial (or character) from the first name in my query, and combine it with the last name. An example: John Doe = jdoe...
  20. 3Mark3

    deleting records in a query...after record #5?

    Hello all...I have this excel table that I have linked to my access database. I want to run a query that will delete all records after record number 5 (the 5th record). Is it possible to do this? I tried googling it and checking my books, but I can't seem to find anything. Any help suggestion...

Part and Inventory Search

Back
Top