Recent content by armin

Thanks, I'll look into that.

Actually, this involves sharing database objects and DAP's (Data Access Pages) on the internet. It has nothing to do with the local network. For example, can DBs at work be accessed from a home computer through data access pages?

I installed Tomcat server on one of our computers on the network and the DB is on that server. Also, all the DAP's are in the same folder (on Tomcat). It works fine when I open them on that computer. In order to access them from a different computer I open the browser, on that computer and...

I want different users to be able to open my database at the same time. My database is on our network server. The users will be accessing the database through data access pages to add, delete or edit the data. But I'm running into problems here. When I try to open the DAP from the different...

Yeah, it would be great if you could make a sample DB so I can see what you did. Thanks

Primary Key from the table? As far as I know there are no primary keys in queries. Right? If you already made changes to it, you can email it to me ilemajic@memphis.edu

What is PK?

I really tried what you said but still no results. Maybe I'm doing something wrong here. I created a simple database with only two tables and one query based on those tables. I wanted to upload it to this board but the file is too large. If you'd like to look at it you can download it from...

No, it doesn't let me enter any values into those fields.

I created a select query which i can edit in the datasheet view, but not from the data access page that is based on this query. It seems to be read-only. Any suggestions?

I guess I'll have to use queries instead. You guys are great. Thanks for your help.

Actually, I'm not using any queries in my database. I'm trying to use only tables, and as far as I know it is not possible to perform any calculations within a table, unlike the query.

Thanks Ally. Your code works on a form or a report. But what about Data Access page? Also, when this field performs calculation, is there a way to place the result in a table? Thanks.

I created a field on a data access page that is supposed to calculate grade (A,B,C,D, or F) based on the data from another field on the same page. For example, the "Percent" field calculates and displays the score student got on his/her test as a percentage. Now I'm trying to make this "Grade"...