Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. varich

    Database exploding in size!

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

    Database exploding in size!

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

    Locking fields after data entry

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

    Locking fields after data entry

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

    Locking fields after data entry

    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?
  6. varich

    Locking fields after data entry

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

    Color in reports

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

    Color in reports

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

    Color in reports

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

    Color in reports

    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?
  11. varich

    1) Adding people twice to a report. 2)Grouping and Sorting on a report

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

    1) Adding people twice to a report. 2)Grouping and Sorting on a report

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

    1) Adding people twice to a report. 2)Grouping and Sorting on a report

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

    1) Adding people twice to a report. 2)Grouping and Sorting on a report

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

    1) Adding people twice to a report. 2)Grouping and Sorting on a report

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

    Report field displays record number rather then the item

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

    Report field displays record number rather then the item

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

Part and Inventory Search

Back
Top