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

PHV and MajP thanks for your help. Worked great

I have been able to get what I want in excell but no luck in Access.

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

MajP, Thanks for your help, your code worked great. Here is how I used it. Thanks again Dim cboOriginator2 As ComboBox Private Sub ocxCalendar2_Click() ' Copy chosen date from calendar to originating combo box Me.Recalc Do Until Weekday(ocxCalendar2.Value) = 2...

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

Lameid, Just got back from a trip and saw your reply. This is exactly what I wanted to do. The code worked great after making the adjustments you suggested. I’m in awe of the talent on this site. Thanks again.

Not sure if I could use Dlookup to get what I want. Currently I have a start date and complete date on the form. I used DateDif to get the weeks to build. I would like the code to take the weeks to build (wtb) number and compare it to my table and if there are matches return all of the...

Thanks for the reply Lameid. I'm not sure if I understand your reply and I don't think I stated my question very well. I’m fairly new to programming in VB. Let me try to explain my problem again. I have a form that has combo boxes that I want to set a default value based on the estimated...

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

Thanks everyone Great Information

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.

CautionMP and PHV, Thank you for helping me with this, It solved all my problems. Stars for both.

PHV, You'll have to excuse my ignorance but I'm not sure how to get it in to my code correctly. I may have misled you with my original question showing my data. What I have is a sub form with a field for weeks and one for years. I tried putting your code in and looking at it in the debug...

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

Zion7, Thanks for your help on this I think I finally have my problem solved. It may not be pretty but it works. I have to do some more, add error checking and clean up. Here’s the Code: Option Compare Database Option Explicit Private Sub cmdEnter_Click() Dim wtb As Integer Dim x As Integer...

Thanks this helps a lot, is there something similar for storing and retrieving text from String variables ?

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.