Search results for query: *

Hello, I have a factor table that looks something like this: Dep. 20% 30% 40% 50% 1 26500 35200 41200 45500 2 30000 36000 45000 51000 3 32000 37500 41250 47000 The numbers under the percentages are earnings, so with one dep up to 26500, you get a 20% discount. Two...

Does anyone know how I can use drawing tools on a protected Word form. I have a "graph" area that I want to be able to draw circles, squares, etc. on. I tried to protect only the other sections of the form and I can TYPE in the graph section, but the draw tools are disabled. Thanks...

Does anyone know why the status bar option would not be available in Excel 2000? It is listed on the View menu, but it is grayed out. No files open or anything happening. Always happens this way-cannot view status bar. ?????

Hello, In an Excel spreadsheet, I used a nested IF statement in each cell to do this, but the number of variables has increased and I think I have to go VBA with it. I have one cell that is assigned a cost factor. It is determined by checking a combination of 2-3 different cells. E.g., If bldg...

Hi, I haven't found an answer to this, so... I need to find the salary of a person as of 8/1/2003. I have a history table that lists the date of a salary change and the amount. For example... Emp 1 5/3/01 54,000 Emp 1 6/4/02 57,000 Emp 1 8/6/03 59,000 So, I need the 6/4/02 record at...

I have a crosstab query that counts students by gender and breaks that into ethnicity. It works fine, except that the grades don't sort the way I want. An ideal sort would look like this: EE PK K 01 02 03 etc...through 12 Presently, it sorts the numbers first, then alpha with EE, K, PK. Is...

Hi, I have a combo box on a switchboard form that lists all of the reports in the database alphabetically. The code looks like this: Private Sub Form_Load() Dim knt As Integer Dim i As Integer Dim j As Integer Dim aryNames() As String Dim temp As String Dim values As...

From what I have learned about db design, you always create a primary key and if there is none, you at least put an autonumber field. So, let's say I have a table I am just using to help the data entry process. It's basically used to populate a combo box so entries are consistent. Example...

I have a combo box that looks up the reports available in the database. I saw a way of making this dynamic in a VBA book with the following code: Private Sub Form_Load() Dim objAO As AccessObject Dim objCP As Object Dim strValues As String Set objCP =...

I am trying to create form letters in Word from an Access database. Checkbox fields come across as 0 or 1. How can I show the actual checkbox? Thanks-- Susan [lookaround]

I need to update a grade field using several parameters: if age = 5 and grade = PK then grade = K if grade = k then grade = 1 if grade = between 1 and 11 then grade = grade + 1 otherwise don't change Is this doable in an update query or is there another way? Thanks, Susan : )

I have a query with 4 tables-campuses, students, student tests, and accomodations (these are items students can use for testing, e.g., highlighters, calculator, etc). I am trying to show the last date of tests taken with the accomodations. So it would look like Student name took Math, Reading...

I want to put an input mask on a password field so it shows as ***. My question is: How do I convert it back to the actual characters to let some users view it? I want to then include it only on certain forms. Thanks for any suggestions!

I have a field called Equivalent in a table named Residents. There are certain users who should not be able to see this one Equivalent field. They need to be able to access the other fields though, like name, room, etc. I have security set up for the database, and from what I understand they...

Hello, Two questions: 1. I have a database that I just put security on. That is working well, but what about actually deleting the whole db file. When I go in to the network server folder, I can just pick it and delete it. How can I prevent someone from mistakenly deleting the db file? 2. I see...

I have several multiple parameter queries that ask a Request #, Date, Type or a combination thereof. The problem is if, in this case, the Type field is null, the record is dropped out. I used: LIKE [Enter "fieldname" or click OK for ALL] & "*" on all the different fields...