Search results

Whoo! It's done! I actually was able to get it to work both with the code you provided and w/ Ghudson's browsing example. I decided to go w/ the code you provided because it only needs the one module and it'll be easier for the other sites to use. Basically, I'm going to have to give them...

I'll try the code out and see if I can get things working on it. I can't use the FE/BE because the other users...well, maybe "users" is a bad word choice. There are other units at separate locations using this db and they're not connected by any shared network. Someday...I'll try to get "spun...

I've recently made some updates to the database at work. I need to get these updates to the other users to meet current regulations. Our database here at work is used by several other off-station sites. Normally, I just type out a long list of detailed instructions (stating that most people...

Well, I got it to include a monthly average of deductions based on the number of days (30 days per month.) I used the DateDiff function found in Pat's useful date functions example. Ideally, I'd like it to group and calculate by month over a period of up to one year, but I really don't know...

I should point out a couple of things real quick. The best dates to use for the example are any one-month period up to the end of July. If you use the month of July as the timeframe, you'll see that the 317AG received a basic rate of 87.03%. When you include the deductions (4.5 points) their...

Hello, all. I posted this about a month ago, but at that time I was running myself ragged and through too many problems at once. I stepped back and made some good progess. I put this in the General forum because it could encompass VBA, queries, and reports I have a main report (Percentage...

Oh, yeah. You can keep the numbers as they were, i.e. 0.666667, but only if the field is formatted as text. But you can't use a text field in a chart to compile averages...so you need numbers...but numbers only get imported as 1s and 0s....Maybe if you make a query from the...

Nothing? Me either. I do like how the charts in Access will take all of your data and group by month (which would solve my original problem), but I just end up running into other problems. The query that all of this runs from has Between [Forms]![Request Percent Report Form]![Start Date] And...

Hey Y'all, Well...where should I start? This db report has a few calculations in it, so let me explain them real quick. The db tracks work assessments that are categorized as Pass, Fail, or Non-Rated. The first is an overall percentage rate of all assessments. Non-Rated assessments are not...

Fine tuned the sample. No more log-on issues. Hope this helps.

...and I'm in too deep. I built a db designed to copy a different db, zip it, and then un-zip it in another location. The "basic" part of this db is from GHudson (I think...). All of it is from info found on this forum. I had it working for the most part and was working on changing the...

I changed the form from before (link below). It seems there were some issues with it. http://www.access-programmers.co.uk/forums/showthread.php?t=106940 The sample db also includes a time-out function along w/ some validation requirements. It also has spell-check and calendar functions...

I was hoping not to have to close and re-open the form, but it might work out fine nonetheless. I've seen other posts that say to store the PK field in a separate table. How do you go about doing that? It seems like it would be difficult to enter the last viewed/updated record's PK into...

I found this link: http://support.microsoft.com/kb/190515/en-us and I tried it out, but I get an error saying that it can't find the NoMatch clause. It shows up in the help file, saying you have to use a Seek function (which this has). The original VBA is for Access97. I'm using 2003...

File attached.

Alright...Finally got it figured out. http://www.access-programmers.co.uk/forums/showthread.php?t=106940

Well, many people use the mousetrap database for field validation, but it wasn't quite working for me. http://www.access-programmers.co.uk/forums/showthread.php?t=38364&highlight=mousetrap The Assessment form has an OnCurrent event and AfterUpdate events for DLookUp that messes up the...

I'll mess with the debug.print at another time--One thing at a time. I was able to call the function and overcome some problems. I'm slowly but surely weeding out any issues. Here's what I have now. I added navigation buttons and a close-form button, both of which call the function...

I think I have it fixed. It's late so I'll finish it up tomorrow. But here it is... In the form's code I entered a new sub Sub Validate If IsNull(Me.TEC) Then MsgBox "The TEC is a required field." Cancel = True DoCmd.GoToControl "TEC" Exit Sub Else End If (etc...for all fields) End Sub I...

OK...I got caught up in other issues. I'm back and included the Exit Sub portion to the code. That works fine to stop the code from running which avoids the problem of running through all of the message boxes. There's a way (at least I'm looking for it) to cancel a sub in another sub. For...