Search results

  1. J

    Keep form on Top.

    Hi, I have a large main data entry form which has a button on which opens a second smaller form. The Main form is still visible behind it. I want the smaller form to remain on top even if the user clicks on the Main form in the background. - The only way the user should be able to get rid of...
  2. J

    Count current records entered on data input screen.

    Hi, I have have a data entry form from which i have removed the built in record navigation and replaced it with my own. I am trying to build a record counter that will display "record x of y" where "y" is the number of records entered in this session and not the total number of records in the...
  3. J

    NotInList function within VB?

    Hi, I have a combo box that selects its values based on a query. This Combo box displays a list of companies for selection. It is possible that the user can enter a company that is not in the List. I have a seperate button to add the company to the list, if and when the user decides to...
  4. J

    IF disabled shift Key

    Hi, I have implemented GHudsons Enabling/Disabling Shift Key code into my database. http://www.access-programmers.co.uk/forums/showthread.php?t=36043&highlight=bypass+shift This works great and i now have the ability to enable/disable the shift key to protect the database. However, when the...
  5. J

    Adding a new autonumber field to a table using VBA

    Afternoon all, Having a problem here. I want to be able to import a table using a specification but for some reason, when i use a specification i cant seem to bring in a new autonumber ID field. Very Odd. How would i go about automating a process that adds a new autonumber field once the new...
  6. J

    Run Query when Last record reached.

    Morning all, I have a form that is used to view a table of data. When the last record is reached i want to run a query/report. How would i go about this? Thanks in advance
  7. J

    Please help - Write Conflict

    Hi, i know there are about 700 posts on here regarding write conflicts but i have searched them all and cant get this to work. Private Sub OrgansiationSendingReferral_AfterUpdate() DoCmd.SetWarnings False Dim stDocNameRec As String Dim stDocNameSen As String stDocNameRec =...
  8. J

    Referrencing a specific field in a table

    Hi, How do you compare a field in your current table to a field in a different table? I have: If [OrganisationSendingReferral] = Tbl_HSOfficeLookup![Organisation] Then..... blah blah blah End If It doesnt like that top line at all though! any suggestions?
  9. J

    Undo Changes made by Query.

    Hi, i am stumped. I have two tables Tbl_Referrals and Tbl_CMSData. Both of these tables have an identifier in called ConflictID. I have created a query which selects the records from both tables where the conflict ID is the same. I have a form running this query. Down one side of the form i...
Back
Top Bottom