Recent content by Emario

Please help. I have 164 timesheets all named pp04. (pay Period) I need to make a global change to one worksheet called Activities changing the format of cells c10:c164 from the general to the number format. The spreadsheets are in a folder called SSTracking. In SStracking holds 16 fodlers of...

16 folder with team (teamA teamB etc) Each team has many members on the team. In each spreadsheet there is a cell that has the team memebers name. I would like to to make one set of 20 copies (represeting a two week period of time for dataes.) of the spreadsheet and link one cell to the team...

I have a design master for a replcaible database. the macros work and run fine on the master. However, on the replciated database. I get an error that says the macros can not be found. what did I do wrong? Thanks in advance to the gurus who can help a novice.

Thanks for the response. But now my combo is blank.

I have an Access 2000 budget database form. I have some combo boxes (2) pulling data from a main combo box. The first box is puling in the budget name from the account number. The second is pulling in the budgetype. However for each budget name there is more than one type for example. Travel has...

Anyone aware of or have developed an expense or budgeting database. I tried to use the sample included but it does not do what I want to do.

thanks for your quick response. No Line item is not needed. We just need to track where the money is going that is allocated and the real issue is that the boss wants pretty charts that give him the "pilots instrument panel". It does not have to be access but that's what I am most...

I have an access database budgeting tool 4 tables Accounts Account Types Transactions Department One one form I have an ACCTID field an Account, AcctNumber and AccountType. I want the user to choose the account and automatically fill the AcctNumber. I am able to do this with the me.acctnumber...

Anyone aware of an access database that that is designed for budgets.

How can you automate this within access. For example, push a command button and excel open with a chart in access from the query data.

Thanks. Number two option sounds good. Maybe what I'll do is after the splsh screen I'll put a input form that asks last name and use the form.filteron on on that. After that the form that is loaded should only have their recordset and I I'll put a combo box that comes from the list in the forms...

I have a customer interaction database on our server. My user open the database and all the record are returned. My users only want their record to show in choices so that they don't have to sift through other and they don't want others to see their interaction. How can I allow the user to do...

What is the best way to use an access database as a backend for a web database?

I have an access 2000 database on our server. I made it a runtime application with the office developer with the assumption that it would run on the machines that do not have access. It does not work. The runtime tries to install it on the local machine. Is this is the way it is supposed to...

toon thanks, What's your email?