Search results

Well the only thing that I found out is when I removed the "SUM()" function, it works great. So thanks for your assistance. I just found a way around it by first using the "SUM()" function to gather the total and then taking that data and inputting it into the conversion formula.

Still didn't work. This is frustrating. I can't understand why it didn't work.

Are you talking about: Sum([Est Time]/60). That's how it's entered. I don't understand.

Help. I have entered onto the Report Footer a calculation to add up all the estimated minutes on the report and convert them into HH:MM. Got close but it's off. For example: 360 minutes is being converted to 6 Hrs. 06 Min. This is the code I'm using: ="Total Estimated Time = " &...

Thanks for all your help. Nanscombe I took your coding and it works just like it suspose to. Thanks a MILLION.........

Thanks to both of you. I took out the ALevel and just made it ReturnAccessLevel() and it worked. But now my problem is how can I have it reset when another person logs in and make the ReturnAccessLevel() reflect their access level?

I took your idea and entered it. Below is a copy of the New Standard Module. Does everything seem correct because when I try to retrieve the Access Level it gives me an error. Standard Module: Public Function ReturnAccessLevel(ALevel) As String Dim db As dao.Database Dim rs As...

Thanks. I'm going to try this, it does look pretty basic. As for recalling it, I'm going to use it with an IF statement prior to opening a form from a Control Button. Looking at something like this: If strAccessLevel <= 2 Then DoCmd.Close DoCmd.OpenForm "Name of the Form to Access" Else...

I'm using MSAccess 2007. I have a Table called: Personnel and a field called [AccessLevel]. I'm trying to set the numeric value within the [AccessLevel] field as a Public Variant so I can call it later in the application. Could you please give me some help. I have copied my Standard Module...

The relationship is: Table "Assets" = [Asset ID} and Table "Task History" = [AssetID]. When I create a new record within "Task History" and edit the data with a Form called: "Task Sign Off Form-One Time" I want the [Asset ID] from the previous Form called: "Asset Form" to be copied to the...

How do you post a copy of the DB?

Still didn't work. Wants to append 64 records instead of just carrying over just the field data. So lets try a different way. I'm trying to open a table called "Tasks History" and create a new record. I'm wanting to bring over the [AssetID] from a table called "Assets" and place it into a...

Still didn't work. Just wondering if I do this from within a Macro

Sorry it didn't work. Still wants to look at all the records and I only want it to look at the current record. How do I have it accomplish that?

How do you tell the Select Query Condition to only look at the current record.

I'm super new at this and this question probably seems extremely simple to most but I've tried the Append Query and it wants to append all records. I have and Assets Table which has an AssetID field and I want to Copy the current record field data to my TasksHistory Table and put it into the...

Outstanding. It works wonderful. Your the best. Thanks alot!!!!!:)

I am very very new to Access and have been building a program to track tasks. The problem I'm having is I have my Assets table open by use of my Assets form. There is a subform called Tasks, in a database format, that only list related tasks to the Asset that is on the Assets Form. When I go...