Search results

Thanks so much!!! That line of code works great! Now, one last question about it: I have one more field, called authorized, and if it is authorized the value is one, and if it isn't authorized, the value is 2. Now, how would I make it so that it only adds when the authorized value is one...

Thanks for the help. That works fine as long as I only have 1 condition. What would I do if the DayID is either 1 or 3 or 4, then add 100; and if DayID is 2 or 4 then add 240? I tried putting parenthesis around the expression then adding "or" but to no avail: TotalPayment...

Hey, how can I do a calculated field in a query based off another field in the same query? Here is what I have: DayID (number) Payment (number) I want the calculated field TotalPayment to be changed based off of the dayID. So, if the DayID = 1, then I want 100 added to Payment If the DayID =...

Hello. Right now I have a table with the field "Time" in it, and it was set as a string. So some records have a time of 1:32 and others have a time of 5:30 etc. I want to split the field into two fields - Hours and Minutes. I copied and pasted the entire Time field into the hour and...

I have a continuous form with a check box (chkDNR) a combo box (Combo20) and a textbox (txtReason). When the check box is clicked, I want the combo box to be hidden and the text box to be shown, and when it isn't checked I want the combo box to show and the text box to be hidden. Here is...

I'm getting closer. Let me describe more what I am trying to get. I have a table - tblYearsWorked, with the fields EmployeeID and Year. So the data in the table looks like this: EmployeeID Year 1 2000 2 2001 1 2001 1...

I tried your suggestion, and it almost works. I can get the cross tab query to list all the years in a row, but I feel like it could be better. I know that there will be a finite number of years that people can work. So how can I make the first year they work go into the first column, the...

Can you group horizontally in a report instead of vertical? Right now I have a group header, called Worker, then there are years that they have worked, and I want to list the years they work next to their name instead of below. It is sorted first by WorkerID, then by Year. Example: Right now...

Thanks for your help so far. I have the code set up, but what exactly is the "continue with deletion" part of the code look like? Here is what I came up with but I don't know what the delete code looks like: Private Sub Form_Delete(Cancel As Integer) DoCmd.SetWarnings (WarningsOff) MsgBox...

Right now I have a button on a form that deletes a record, and when I click on the button to delete, the default access message comes up saying, "You are about to delete 1 records. If you click yes, you won't be able to undo the delete operation..." and when I click no, it says "The DoMenuItem...

Is that combo box bound to something? Because sometimes when I set up a combo box for the first time, it lists all the choices in the combo box, but when I choose the value, it won't allow that value to be chosen because it is bound to another field.

Thank you!!! It works great now!

I made some progress... I changed the property in the query so that the format in Expr4 has to be "00", so now the "1" shows as "01" and the others, such as 32 are not affected. However, for my average time expression, it seems to ignore the fact that it is now displaying 01, and still thinks...

Right now I am working on a query that figures out average time for how long it takes an athlete to run a mile. The query works fine, all the calculations are done correctly, however, the formatting is incorrect. If the average time to run a mile is 7 minutes and 5 seconds, it should be...

I am not quite sure what you are trying to do, but from the way I understand this, you can do it one of two ways 1) Add a field called Date on table NAME and have all the information on the NAME table 2) Set up a foreign key on table NAME that is linked to the primary key on table Date. As I...

The way I get a record that I want instead of scrolling through them all is setting up a listbox or a combo box, and whatever value is selected in the combo box or list box will come up. This can be done really easily by using the combo box wizard or list box wizard and choosing the option...

I am not quite sure how I should go about this... A couple of days ago, I came across a post that had an excellent example of a login/password screen for the database. The file was called SecurityExample2000.zip, although I can't seem to find the post at the moment. Anyways, I want to...

Would it be possible for you to post your database here? I understand what you are trying to do, but it is a lot easier if I can see how the entire database is set up and where exactly you are trying to store the values. Is the database set up so that different employees have different regular...

I would use a query, and in a query you can create a calculated field doing exactly what you are thinking. -Chris

Thanks for the advice! It works great now. -Chris