Search:

Type: Posts; User: robm; Keyword(s):

Page 1 of 20 1 2 3 4

Search: Search took 0.05 seconds.

  1. Thread: New Record

    by robm
    Replies
    5
    Views
    380

    Thanks caveman & patt. This is harder than I...

    Thanks caveman & patt. This is harder than I thought, just to hide empty records. I don't want even the empty rows to show, until the check box is ticked. I've tried setting allow additions on the...
  2. Thread: New Record

    by robm
    Replies
    5
    Views
    380

    New Record

    I have a database for recording procedures. I have a main form for the details of the procedure, and a sub form for when the procedure is updated, and the previous issue superseded. When I start...
  3. Thread: Security Alert

    by robm
    Replies
    2
    Views
    293

    That's great. Thanks.

    That's great. Thanks.
  4. Thread: Security Alert

    by robm
    Replies
    2
    Views
    293

    Security Alert

    I created a database for my daughter in Access 2003. She has office 2010, and when she tries to open it, she gets the usual Security Alert about VBA Macros. I know that in Access 2003, you turn this...
  5. Replies
    5
    Views
    480

    Sorted it. Used your code, but created a query to...

    Sorted it. Used your code, but created a query to give me the name, instead of the table. Thanks a lot for your help.
  6. Replies
    5
    Views
    480

    Thanks RG. That looks exactly what I want, but...

    Thanks RG. That looks exactly what I want, but there is still a problem. Because I set the form up with combo's to select the name, and the way I have the tables linked (other peoples suggestions, as...
  7. Replies
    5
    Views
    480

    This part of the code iNoShows =...

    This part of the code


    iNoShows = DCount("[NoShow]", "tblEvent Assignment", "[EmployeeID] = '" & Me!EmployeeID & "'")

    is giving me a data type mismatch. I've checked all controls are spelled...
  8. Replies
    5
    Views
    480

    Three-strikes warning

    This question is related to the same database as thread, Check if control is empty. In the same for where an employee is selected for work, is a tick box, which is ticked if the employee doesn't turn...
  9. Replies
    18
    Views
    1,544

    Thanks for that. No matter what I tried, I...

    Thanks for that. No matter what I tried, I couldn't get it to work. Ended up adding the SIA number to the combo box, which apparently will do. Thanks for your assistance. I have another question...
  10. Replies
    18
    Views
    1,544

    Still not working. Let me get this clear....

    Still not working. Let me get this clear. DeceasedDte is a field on the table Hospital. PatientNo is a field on the table, and Me!Patient No is control on the form? So you're checking that the...
  11. Replies
    18
    Views
    1,544

    Sorry if I'm a bit thick but, I don't understand...

    Sorry if I'm a bit thick but, I don't understand the 'The search value from the form' bit. This is the code I've got


    Option Compare Database
    Option Explicit

    Private Sub Form_Current()

    ...
  12. Replies
    18
    Views
    1,544

    Thanks retiredgeek. Didn't see your reply until...

    Thanks retiredgeek. Didn't see your reply until after I posted. I'll try your method. It looks better than what I'm trying to do. Just one thing I'm not sure of, where do I put this code. As I said...
  13. Replies
    18
    Views
    1,544

    Ok, I've messed around with the tables, etc. and...

    Ok, I've messed around with the tables, etc. and managed to get the data into the form using a query, so I have managed to get the control I need to check, in the form. I still can't get anything to...
  14. Replies
    18
    Views
    1,544

    Is there no way I can check the value of a field...

    Is there no way I can check the value of a field in a table then?
  15. Replies
    18
    Views
    1,544

    Thanks for the code, but looking at it, doesn't...

    Thanks for the code, but looking at it, doesn't both forms have to be open? I don't want two forms open. I don't want to confuse the user. That's why I need to search the table.
  16. Replies
    18
    Views
    1,544

    How do I check a field in a table? I've tried...

    How do I check a field in a table? I've tried looking up DLookup, but can't see anything that relates to my problem. From the form, I want to check if a field in the table has a Null value. If so,...
  17. Replies
    2
    Views
    867

    Thanks. Done it.

    Thanks. Done it.
  18. Thread: Print empty rows

    by robm
    Replies
    4
    Views
    386

    No, I'm talking about an Access report.

    No, I'm talking about an Access report.
  19. Thread: Print empty rows

    by robm
    Replies
    4
    Views
    386

    Print empty rows

    I have a report which is a staff rota. At the moment, I have it set to print 20 rows per sheet. What I would like it to do is, if there aren't enough records to fill a sheet, print empty rows, so...
  20. Replies
    18
    Views
    1,544

    Ha! I forgot that. No, form two won't be open at...

    Ha! I forgot that. No, form two won't be open at the same time. Need to be able to check the table don't I?
  21. Replies
    18
    Views
    1,544

    Check whether control is empty

    I have two forms in a database. What I want to do is in a Name control in form 1, I want the text to be Red, if a control in form 2 contains data, but black if it is empty. I know how to refer to a...
  22. Replies
    2
    Views
    867

    How to link tables

    I want to create a form where a user can type in an event, and date, then from a list of staff, select who is available to work. This needs to be saved, so a report can be printed. Also, the user...
  23. Replies
    12
    Views
    1,554

    Not sure about this bit. It doesn't seem to be...

    Not sure about this bit. It doesn't seem to be working. What should it do?
  24. Replies
    12
    Views
    1,554

    I'd have to have the drop down menu in another...

    I'd have to have the drop down menu in another column then, wouldn't I?
  25. Replies
    12
    Views
    1,554

    Okay, the goalposts have changed a little....

    Okay, the goalposts have changed a little. Because quite a few of the employees have the same, or similar sounding surnames, they want to be able to select the first and surname from a drop down...
Results 1 to 25 of 500
Page 1 of 20 1 2 3 4