Search results

  1. S

    Form Views

    Resolved the problem it appears that the max records that a continous form can display is 10. After the tenth record it automatically opens on a new record.
  2. S

    Form Views

    I've just done some testing on the database where this worked. I have found that where there are over 100+ records that have been entered previously it will automatically go to a new record and only show that row in the subform. Is there a property somewhere either in the subform or in Access...
  3. S

    Form Views

    Yes Allow Additions is set to yes. Data entry is set to no so we can still have visibility of the other records. We want a data entry type view to start with so you can see only the new record your about to enter, but after you've entered that record, you can still see after you've other...
  4. S

    Form Views

    I already have both scroll bars enabled. It appears as if its a bit of code thats not executing (but I don't understand why because I've made a replica of the database). This is the code after update: Private Sub cboanalyst_AfterUpdate() Call SetupForm DoCmd.GoToRecord , , acNewRec - I...
  5. S

    Form Views

    I have a form where after you select an option from a combo box, it will show a new record ready for data entry, however it is a continuous form and so you can view the previous records on the same form which is really handy. However, I've recently copied this database, renamed it and for some...
  6. S

    Combining text and a date value as a default value on a text box

    Thanks alot, I think I had tried about every other combination! :D
  7. S

    Combining text and a date value as a default value on a text box

    This may be a really simple but just can't figure it out. In the default value in a text box on a form I would like it to say "Checks Completed on" =date() but all it returns is a 0. If using the date function on its own it comes back with the date fine in the field. Any Ideas how I comine...
  8. S

    Running a Query from Combo Box and displaying result in Sub Form

    Forms and Queries Hi In reply, I put Team in the Checktype table, so for reporting I could query checks made by for example, the Helpdesk which were not completed. I suppose the team field could have gone in the Analyst table, but I think it would work this way also. It is also easy to add...
  9. S

    Running a Query from Combo Box and displaying result in Sub Form

    Hello I haven't used Access for a while, and think I may have a difficult first project. The aim of the system is to allow support analysts to record results of daily checks, backups complete etc. There are 3 different support teams with analysts that are assigned to different check types...
Back
Top Bottom