Search results

  1. D

    Combining Variable Multiple Fields in a Query

    Hi all, I have been asked to create a pilot database to use for Student Placements within our department at our University. My main criteria is that it has to be as user-friendly as possible, so I'm hoping to build something with a bit of automation in it. One of the things I am trying to...
  2. D

    Form Error Checking

    I have tested it many times, and perhaps the word "continue" may be incorrect when I'm asking them to check the data if it is missing. But when you press the 'no' button, it just closes the MsgBox, and when you press the 'Yes' button, it saves the entry and starts a new record, so no data is...
  3. D

    Form Error Checking

    The MsgBox allows the user to select 'No' when asked if they are sure that the data they have inputted is correct. if they click 'Yes', then a new record is created. If they click no, it simply closes the MsgBox and takes them back to the form. So: If Data missing > Highlight what is...
  4. D

    Form Error Checking

    Hi Guys, Thanks for all the suggestions! I have played around with it this morning, using vbaInet's suggestion. It's a bit lenghty, and will be more so for the other forms (this is the shortest one!) but here's the code: Dim LResponse As Integer Dim lngRed As Long Dim lngBlack As Long...
  5. D

    Form Error Checking

    Hi All, I have a problem, as those that find their way here often do. I have been in charge of administrative systems within a counselling service that I work for, and as part of that have developed a fairly complex database around confidential information, appointment diaries, statistics...
  6. D

    Filtering via Check Boxes

    Hi Guys! Having a bit of a problem trying to figure out how to do this :/ Currently I'm amending a database I have built that over the last few weeks has gotten more complicated that I had originally envisioned, but isn't that always the case :rolleyes: I'm building a database for a...
  7. D

    Autonumber Order Data by Client

    I feel as though I'm not explaining myself clearly enough :/ I am not bothered about how the data is stored - that I have covered and how it is saved is fine. What I need is a query function that will automatically number table entries by ClientID depending on the order of the Date. That's...
  8. D

    Autonumber Order Data by Client

    I've already done that, but I can't have one table with the data for 6 different forms. I have given each form it's own table - and we will only be drawing data from one table at a time. The clinic is open on Tuesday and Wednesday. David attends Tuesdays and George attends Wednesdays. Both have...
  9. D

    Autonumber Order Data by Client

    Cheers for the reply, allow me to elaborate why I want them sequenced... As a Research clinic, we need to put out reports of the data we collect - One such thing for example, is whether or not over time a person's Depression decreases with therapy. This is measured on a paper form called Beck's...
  10. D

    Autonumber Order Data by Client

    Hi Guys! I've created a database used for Researching in a Counselling Environment. Our clients are asked to fill out forms. My question is: Is there a way so that Access automatically knows, by date, the order of which the form the client has filled out by numbering it. For example...
  11. D

    Linked Table and Forms

    Bump! Any way this is at all possible?
  12. D

    Linked Table and Forms

    Hey! I've built a database that is for both research and administrative purposes. Due to Data Protection, it is important (due to these reasons) to have identifiable information unavailable to the researchers (such as name and contact details). As such, I have split the database - the core of...
  13. D

    Manipulating the 'Totals' function

    Okay, I'm up for that. So I've just created 4 queries, each with the same fields. How do I combine the four Queries into one - That is, have 9 different rows (4 from Specific, 2 from Gender, 2 from Status, and 1 from Total). If I could combine these onto one query, then I would be able to...
  14. D

    Manipulating the 'Totals' function

    Hey! I wondering if it is possible at all to manipulate the 'Total' function in a form either through VBA or, preferably, through the query itself. What I'm trying to create is a form that shows figurative data about attendance at a Clinic. There are a few categories that I want it split up by...
  15. D

    Forcing Data Entry into Form Fields to progress

    With one slight tweak, that was exactly what I was after, thank you Pat! (the tweak was that 'EditScreeingData()' was spelled incorrectly!) Many many mucho thanks! My database is nearing the point where I am unable to see many additions or tweaks myself without someone else's input, which is...
  16. D

    Forcing Data Entry into Form Fields to progress

    Hey guys! I'm trying to create a form that forces the user to input data before they are allowed to do a variety of functions. Now, the most obvious way to do this is to control the Visible variable and I want to manipulate this function to achieve what I want to do. My problem is that in...
  17. D

    Problems with Subform returning blank values

    As per! Figured it out. Had to change the relationships on the subform to get it to display a 0 value. Realised that my subform and the query it was running were duplicating the same function thus leading to my error. Yey! :D
  18. D

    Problems with Subform returning blank values

    Hey guys! Usually I start writing out my problem that I'm stuck on when I get an epiphany towards the end of the post and solve it myself. I think sometimes all you really need to do is talk it out aloud to think of something new. But this has got me beat :/ I'm writing a database for a...
  19. D

    Saving from a Subform

    Answer is: [Forms]![frmDiaryBooking1]![frmSessionNumber]![SessionNumber] Found it somewhere else (after much Googlage!) Thanks all the same! (that's [forms]![Mainform]![subform]![control])
  20. D

    Saving from a Subform

    Due to reasons beyond my understanding, I have compiled a Diary-type database for a Counselling clinic. As such, they need to record what the current session number is when that session is booked. However, because this number is pulled from a collated query (where all Attendance records are...
Back
Top Bottom