Search results

Paul, I played with that some and researched some. That option is not going to work for me. I will need to make this VB work. My subform is in datasheet view. An employee may have 100 cases total, but only the most recent 5 will show on screen due to size restrictions. If their 18th record is...

OK I see what conditional formatting is. One problem with that is that only changes the one field. I need it to do something more noticable. Can it change that entire record not just the one column the condition is set on?

because I have no idea what that is. If that is a good solution I can try to find something...

I then tried this: Private Sub Form_Current() Dim Yellow As Long, Gray As Long Yellow = RGB(250, 250, 210) Gray = RGB(192, 192, 192) 'this script will change a box color on current form If Forms![frm_ESKER_HISTORY]![TestResult] = "Positive" Then Me![BoxAlert].BackColor = Yellow...

Access 2000. Main Form: frm_ESKER_ENTRY_TERRI (Standard Form View) Sub From: frm_ESKER_HISTORY (Opens in Datasheet view) The main form will bring up an employee based off of their social. Then the subform will list all of the jobs they have ever done. In the subform there is a field called...

I use the underlining query for a couple different reports, but this one needed a coversheet with this info on it.

Actually I think this might work for the numbers. =Sum(IIf(Left([CompName],1)<"j",[REASON COUNT],0))

That worked PERFECT! Thanks for that. The only real change is what about companies that start with a number? I have "3M Construction" and similar names. Can numbers be added to the first section? Thanks!

Access 2000 I have a report right now that works fine. I have a field that sums all records =Sum([REASON COUNT]) There is also a field [CompName]. I want to add three new fields that will give me that same sum but for three sections of the alphabet. So my report will have: Total Number of...

i have a date field with time and date each record is entered. results look like this Date_Complete 4/9/2007 8:26:11 AM 4/9/2007 8:31:25 AM 4/9/2007 8:34:14 AM 4/9/2007 8:34:21 AM 4/9/2007 8:34:29 AM 4/9/2007 8:34:36 AM 4/9/2007 8:34:49 AM 4/9/2007 8:41:27 AM 4/9/2007 8:41:49 AM 4/9/2007...

thanks I see where you are going... I will play with something. There is one form they use to enter data, that is all I truely do not want them to use. I can maybe play around with the time functions and if they open that one form on Wed between 8-10 it might pop up with a message maybe...

OfficeXP Access 2000 I have an issue where I need all but 2 users out of my DB on Wednesday morning for billing reasons. I thought of writting a batch file that would delete the frontend DB from all computers from 8:00 - 10:00 every wed morning. However if a user comes in before 8:00 and have...

first off thank you for the ideas so far. I do not fully understand your suggestions, but I will sit down Sat morning and see if I can change my system the way you guys are saying. If I have problems I will be back. Thank you very much so far...

thanks so far... it does it for update queries too. My account dept each week has to updatew a couple thousand records from not billed to billed with a checkbox. Right now when she clicks the update query it will give her the defualt windows prompt. if she hits yes it works fine. if she hits...

I have 3 or 4 update/delete queries. Right now if a user clicks one of the queries it will first prompt "you are about to update X amount of rows...are you sure you want to do this action?" if the user hits "YES" it works fine. if the user hits "NO" it still finishes the act as if yes was...

I found this on a microsft page Year([TestDate])*12+DatePart("m",[TestDate])=Year(Date())*12+DatePart("m",Date())-1 that is a beast. Does anyone have something better? If not this will work. I just thought I saw something much more simple a couple years back. Thanks.

I searched but could not find a simple answer. I want to see all results from last month for [TestDate] Month(Date())-1) ? ? ? ? ? ? ?

BobLarson, Thank you for the response. I have been out for about a week and a half. I have one followup question. The query type is Select type where I ask for totals. When I change the format as listed above and say return the MAX for that field the query changes from "Max" to "Expression" and...

simple query that shows results with 5 columns, one of which is a date based field. I set up a macro which allows my user to click a button which creates an excel sheet. The dates do not stay correct when exported to excel. What is wrong here?

I would love the option of PDF, but Access 2000 does not list this as an option.