Recent content by DPACAccessWiz

PHV's last post works. Thanks

More clarification: I need to round up to the nearest penny allways when the number has more the 2 places to the right of the decimal(any fractional amount of the penny to be rounded up to the next penny). I tried this in Exel INT((5.454545455+.005)*100)/100 = 5.45...

I need to round tax up to the nearest penny. Round() works in both directions like it should, but I need to RoundUp() like you can in Exel, but I can't seem to make it Work In Access2000 Thanks.

I have payroll application where I would like to lock one record at a time when a Yes/No field has been changed. I would also like to lock that record based on a users security level.

Thank you JeremyNYC. It works like a charm. I am using this in a multi user environment. Thanks

I have a function that runs an Update Query then an Append Query. Access prompts the user to confirm each action. If the user cancels one or the other I do not get the correct results. The updated records are only true if the Append works. How do you tell Access not to ask thes questions?

So I found the answer, If you want a "Compound Index" Select only ONE name for all of the fields in the field list, leave the name field blank in the others, so in my case: Name: Fields: Date Worked field1 field2...

I believe that what Ken has described, is a simple index, which the oracle guy does not want, and which I have already indexed the table. What I need is a single index on many fields?

I have a project where an Oracle database is linking to one of my tables. The Oracle guey has asked that the table have a Compound index on fields: [DateWorked], [DepartmentID], etc. Insted of the Simple indexes on these fields. How do I create a compound index in Access.

I'm with you on that brother. I asked them the same thing. Thanks for the help with the page break suggestion.

I have a request to put a total of the page, not the report, on a report. I have a field called [Total] that I calculate the total at the end of groups and the report with the control source: =Sum([Total]). This works. But when I copy the text box to the page footer I get #Error as the...

I have a report that shows a total at the end of the report and a total at the end of any group. I have recieved a request to show a total at the end of the page, and I have not been successful. I have a field in my report detail called [Total]. I have a total of this text box in the report...

I have multiple users on a network with different printers. Different brands and models. I have a split database with the data on the server, and the application on the users PC. I am currently developing this database application while it is being used by the users. I may have to make...

I have a form with a data sheet subform with payroll records. The main form sets the query criteria for the subform query. Now I would like to add a subform to the subform that I can view with that handy little plus/minus on the left. I can get there mostly, but the problem I have is that the...

I have a payroll database that I need to export to another department in a .dbf format. I have created a make table query to get the results that I want. I need a code that will allow a user to export the table that was created by the query to a .dbf with the press of a button. I would like...