I've created an Access database with the tables on our SQL server. The database only has about 400 records so far, but the size of the .accdb file has grown to nearly 200 meg. The tables where the data is stored is on the SQL server, so I don't know why the .accdb file is growing...
Okay, I’ve almost have most of the bugs worked out so I can release my project to the masses. One of the items I have left is:
I have a data entry form. How can I lock one or more fields on the form after data has been entered onto that form. For example, once someone enters a last name...
I have a report that lists people sorted by a status code. I need to have a color separator line between the different groups. I can I accomplish this?
Thank you to those who helped me with my first question on TekTips last month. It got me moving in the right direction. I’ve nearly completed my project to the stage where it can start being tested! A bit of history. I am developing a database that will track veteran patients in community...
I am working on developing a database to handle transfers of patients from community hospitals to our hospital. I have a report that contains data, including one field that should display the hospital name. Instead of displaying the hospital name, it displays the record ID number for the...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.