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: act2
  • Content: Threads
  • Order by date
  1. act2

    How to Make control Charts

    I've sumitted this as a FAQ but since I asked the question here, I thought I would post what I have found. After spending a lot of time trying to figure a workaround to the Glitches in Access 2000 Charts, I think I have come up with a procedure for making control charts. I believe this...
  2. act2

    Pass an existing query criteris using VB

    I would like to be able to reference an existing query and pass it criteria using VB. I have tried DLookup and the DoCmd with no luck any suggestions. Thanks
  3. act2

    Show line based on available labor hours

    I have a bar graph that shows the amount of machining hours by function per week. I want to be able to have a line based on the available labor for that week. Here is a sample of the data. I have not done a lot with graphs in access so any help will be appreciated. Thanks Graph SQL...
  4. act2

    get a value from a field in a query and store it in a variable

    I’m trying to get a value from a field in a query and store it in a variable using VB. I’ve tried many suggestions from the post but noting seems to work. The query is called qryReportGen and the field within the query is JobHr . Thanks
  5. act2

    Force Moday start start date no matter what is selected in calendar Wk

    I have a combo box which activates the Calendar Control 9.0. I want to be able to change whatever date someone may select in the calendar control to the Monday date for that week. Tried using the Weekday function with out any luck. Any suggestions. Thanks
  6. act2

    Using Table as Key for Combo Box Data

    I would like to be able to set some defaults based on the week number by using a table. I'm not sure how I would go about doing it in VB any suggestions? Something like this wk# Combo Box Value 3 Me.cbo.xxx1 7 3 Me.cbo.xxx2 14 3 Me.cbo.xxx3 21 3 Me.cbo.xxx4 28 3 Me.cbo.xxx5 35 3 Me.cbo.xxx6...
  7. act2

    Books on VBA coding

    Can any one recommend a good VBA resource book? I’m what I would consider on the low to mid intermediate stage and would like to learn more. The books that I have seen at the bookstores seem to focus more on using the application than constructing the code. Any suggestions would be appreciated.
  8. act2

    Date Problem Rolling week number at change of year

    My database needs to keep track of week numbers and at the change of the year start at wk 1 again. Some of the jobs tracked can run for several weeks. So data can look like this. WK 51 06 WK 52 06 WK 53 06 WK 01 07 WK 02 07 I used DatePart() to extract the weeks and year but for the...
  9. act2

    Storing results from each pass of a For Next loop ?

    This may be a dumb question but here it goes. Is there a way to store the result of each pass of a For Next loop. I want to see the value from each pass stored in a varuble that I can call later.
  10. act2

    Loop Problem out of control

    I been looking at this for a couple of hours and can’t figure it out. The program gives me the results I’m look for, however it gives it to me multiple times. If I check one ck boxes I get the information in the groups I expect except it copies it 27 times. If I have both ck boxes checked...
  11. act2

    Recording information from multiple check boxes in to list

    I have a form with 5 check boxes, the check boxes relate to answers the user must select. I would like to record the answers in a sub form list. I have the code so it will show if one of the check boxes is selected but not multiples. Not sure how I would do that. Option Compare Database...
  12. act2

    Recording information from multiple check boxes in to list

    I have a form with 5 check boxes, the check boxes relate to answers the user must select. I would like to record the answers in a sub form list. I have the code so it will show if one of the check boxes is selected but not multiples. Not sure how I would do that. Option Compare Database...
  13. act2

    Loop through CkBoxs and if cecked copy caption to Text box

    I would like to be able to look at the captions of 5 check boxes and based on if there’re checked copy the name (caption) to a sub form text box. I’m not sure if I can do it and what the syntax should be. The code that I’m playing with is this: Dim ctl As Control, flg As Boolean Dim...
  14. act2

    Add Record to sub form using loop on parent form

    I’m trying to use a loop on my parent form to add records to the sub form. For each week in the loop I would like to have a new record in the sub. Here is my code so far. Suggestions? Option Compare Database Option Explicit Private Sub cmdEnter_Click() Dim b As Integer Dim x As Integer Dim...
  15. act2

    Code to auto fill field with previous record information

    Does anyone know of code I could use to auto fill a form field with the information from the previous record? Thanks
  16. act2

    Interesting 2

    This is an expansion of Interest problem Well the idea is that the program is reading data from many digital clocks which are position from many Location, the guys in the company, of course, use to pass their cards every time they enter the building. Some time they pass more than once (only...

Part and Inventory Search

Back
Top