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: Scoob55k
  • Order by date
  1. Scoob55k

    How do I omit the data link to a form in my query/report?

    I open the report using a command button. I'm not so much familiar with writing WHERE statements in code. The three fields I am getting criteria from on the form that I may or may not want are [BySection], [ByTeam], and [ByHandler]. I want the user to be able to select all three, just the...
  2. Scoob55k

    On Current Event when other code closes form?

    Not sure if this is why no one answered me, however I found that it works fine when I'm not in design mode of the database. If I just open it to use, it's perfect! Thanks!
  3. Scoob55k

    How do I omit the data link to a form in my query/report?

    I have a query to a report run from a "Report" form. The query is linked to the form for things like data range and other specific information that a user may like to view in the reports. If the user wants all the data in a date range, how can I omit the link/criteria for the other fields in...
  4. Scoob55k

    Creating a Precedure to Call in other modules / Correct code

    Great idea. Continued.... http://www.tek-tips.com/viewthread.cfm?qid=1360032&page=1
  5. Scoob55k

    On Current Event when other code closes form?

    This question actually began in another thread. To review: http://www.tek-tips.com/viewthread.cfm?qid=1359644 One more question. It's working slick right now except for one form in which I have it doing something OnCurrent. It seems to error out because the form has been closed due to the...
  6. Scoob55k

    Creating a Precedure to Call in other modules / Correct code

    One more question. It's working slick right now except for one form in which I have it doing something OnCurrent. It seems to error out because the form has been closed due to the user (me in this case, testing) not having proper security enabled. I was thinking if putting code in the...
  7. Scoob55k

    Creating a Precedure to Call in other modules / Correct code

    Perfect! Thanks to all. PHV that worked perfect using the code I had. How is one to ever figure that out? TheAceMan1 I am doing much better now. Thanks for your answer as well. I kind of figured out the creation and calling of a procedure, but your code confirmed it. Appreciate the...
  8. Scoob55k

    Creating a Precedure to Call in other modules / Correct code

    Can you check this code as it is erroring out saying: "Run-time Error '2001': You cancelled the previous operation Can you tell me the error of my ways in the code below? Where should I put it (Form_Load, Form_Open, etc.?): Private Sub Form_Load() 'Checks User Security Dim UserName As...
  9. Scoob55k

    Automatic Email?

    Can you set an email to be sent out from Access automatically every Monday morning at 7am? I'm thinking no as one would have to have the Access application open as well as their email program for it to work. An Access with multiple users may just complicate the issue. Just thought I'd throw...
  10. Scoob55k

    Sum in footer multiplied

    I so apologize, however the issue has been solved. The issue was in the query actually. I had to change the setting for Unique Values to Yes and all is good. Again, thanks so much for your assitance and accept my apology. Have a great Monday!!
  11. Scoob55k

    Sum in footer multiplied

    It shows the record per employee in the multiple of the amount of units the manager has on the reports, in this specific case, 2 units or twice. We do not want the sum for the employee as it is only one record for the employee per report. I tired it, but the report still multiplies the data...
  12. Scoob55k

    Sum in footer multiplied

    OK, hopefully I can make sense of this to you. The report is broken down and summarized by MANAGER, UNIT and EMPLOYEE. The data for the Detail section is simply a tally of occurrences. The MANAGER has a header and summed values in the footer section. The UNIT has a header and summed values in...
  13. Scoob55k

    Sum in footer multiplied

    I'm thinking this is an easy one and I've figured it out before. Anyway, not today. I have a report that has a couple of headers and footers asssigned in the sorting & grouping section. It was set up originally using the wizard summing feature, but changes, of course, have arose. We are...
  14. Scoob55k

    Data entry field formatted for percent

    I tried some code that AfterUpdate for that field it took the whole number in the field, divided it by 100, and reinserted the decimal # in the field. Didn't work, but I think its the syntax not the idea that's hurting me here. Take a look: Dim Calculation Calculation = ([PercentCancelled] /...
  15. Scoob55k

    Data entry field formatted for percent

    Thanks for the response. Do you know how to correct this so the user only has to put in a whole number?
  16. Scoob55k

    Data entry field formatted for percent

    I have a field on a form where I am trying to enter a number that would be recorded as a percentage. In my table I have the field formatted as a percent. However, when I put in 25, for example, in my form, it records as 2500% instead of 25%. Seems like a no-brainer, but I can't figure it out...
  17. Scoob55k

    Auto-populating the "next" in line value on form

    I back. Thanks for your previous help. I have a new problem concerning the same issue. I got a query that gives me the next employee ID however my issue comes when more than one person is using the DB. I had it set up to populate the other fields once the Task field GotFocus. To avoid more...
  18. Scoob55k

    Auto-populating the "next" in line value on form

    Yes. It is bound to a table that will keep the data entered. The table has only 3 fields (tasknumber, ID, DateStamp). The [DateStamp] is kind of an AutoNumber that uses Now() for it's default value. This will assist in reporting later. I can sort decending on this value in a query to get...
  19. Scoob55k

    Auto-populating the "next" in line value on form

    The values are 4 characters long (ex. "A1XY") and I need it to select the next one after I use "A1XY" in the form to create a record. Example being maybe "ADVB" and the next few being selected from the list below in alphabetical order: CODF F678 F78B SI5K There will be hundreds of these...
  20. Scoob55k

    Auto-populating the "next" in line value on form

    I have a form of which will open and I want to auto populate a text box in the form with the "next" in line value/person. The values are in a table, ordered alphabetically. The twist added is that I have a yes/no field that will be "Yes" if the employee is in the office and of course "No" if...

Part and Inventory Search

Back
Top