Search results for query: *

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...

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

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...

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

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

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...

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.

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...

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.

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...

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...

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...

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...

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...

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

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...