Search results for query: *

This database has issues. The database has a password. When I open the database, it asks for the password. I put the password in, and the database opens. Then I try to do a compact and repair and it asks for the password. I type the password, and it tells me it’s the wrong password. Of...

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...

How do you open a form in Add mode and Edit mode?

How do I set a field on a form to locked after data has been entered into it and then that field is exited? I’ve tried to create a macro, but for some reason, I keep getting errors.

Yes, that would be ideal. By in my world, they (one in particular) have very hard heads. The data is too important to allow the to write over it. I appreciate your sentiment. But do you have an idea how I can make these fields write once only?

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...

Well, we are getting there. Perhaps I omitted that those on the list that are under "Admitted" would have yellow line, those that are "En route" would have a green line etc. This method, putting in the header only lets me add on color line between each list status type, not a separate color...

Yes, there is a table that holds the 7 list status codes.

This is a bit complicated. The end users are switching from using an Excel spreadsheet to an Access form and report. These users had a design criteria that demanded the new Access report mimic the old Excel Report in appearance. The report is a transfer list used throughout the day. People...

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?

Actually, the item that is different seems to be the PCP. However, I created a new form last night, and this time it worked. What I am thinking is that my query was messed up. I combined fields, but think I also kept the un-combined fields. Anyway, I'm plugging along. I kept the bad form so...

I only have 13 people in the database, so it is very easy to see who is in each table. I'm thinking, and I don't know if this is an issue or not, but I think I may have pulled some information for the report from a query, and some from a table. I know I only have one record per person, but as...

Percent SC is the level of their service connected disability. From NSG, or not service connected to 100% SC. I have a total of 13 tables. Yes, you may have multiple transfers. I have 13 tables. The veteran data is in one table, LastName, FirstName, etc. data about the veteran that will not...

lameid, here is the SQL view. Just so you know, I am very new at this. SELECT TransferMaster.AdmitDate, TransferMaster.AdmitTime, VeteranMaster.LastName, VeteranMaster.FirstName, VeteranMaster.LastFourSSN, VeteranMaster.DOB, VeteranMaster.PCP, BedType.BedType, TransferMaster.FeePay...

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 used the create buttons to create the tables, queries, forms and reports. I’m not sure what the underlying code is. The hospital table is a lookup table. So this is what I did, I created a table to store transfer data for each transfer patient, including the hosptial they are coming from...

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...