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 Chriss Miller 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. Jphillis

    Expression within forms

    I have an SQL server database which is linked to Access via ODBC link. It is based on a fantasy football system. The problem i am having is one to do with validation. On an Access form I have 2 combo boxes. one containing a Home team, the other containing an Away team. At present a HOME team...
  2. Jphillis

    #Delete in Subforms

    I put the following code under the me.requery that makes it work DoCmd.GoToRecord , , acLast Thank for your help people
  3. Jphillis

    #Delete in Subforms

    I checked the links and they were fine. Added the Me.Requery and this seemed to work. :o) A minor problem has occured as a result. Say i was working on record 250. When i input the info now it takes it back to record 1. Is there any code that will keep it at record 250 after the requery...
  4. Jphillis

    #Delete in Subforms

    the record is inserted into the table but doesn't show up on the form until i close and open it again.
  5. Jphillis

    #Delete in Subforms

    I have a subform that is linked to a main form in the following way: Main form PK quest_id - AutoNumber Subform1 PK sheet_id - AutoNumber FK quest_id Subform2 PK age_id - AutoNumber FK sheet_id FK quest_id I can enter information into the main form with out any problem. After entering info...
  6. Jphillis

    Email list

    I have a table 'person' that contains details of individuals including email addresses. Each email address is an individual record. My objective is to have one list of email addresses, semicolon seperated, so that i can copy and paste this list into the TO box in Outlook Any ideas on how i do...
  7. Jphillis

    Trouble linking a combo box with a subform

    I have a combo box on my main form containing a list of premises_codes that come from a query (the query comes from the 'company' table) . On my sub form i have details of staff members. These details come from a 'staff details'table which does not contain a premises_code. The link between the...
  8. Jphillis

    Problem with time

    I have inserted the line of code as follows 'CONSTRAINT check_times check (start_time < finish_time)', however i get an error saying 'missing or invalid operation' what am i doing wrong?
  9. Jphillis

    Problem with time

    I have a start and a finish time. I want to ensure that the end user cannot insert a finish time that is less than the start time. eg Start time 10:50 Finish time 10:40 I want to make it either impossible to do the above or to bring up an exception, which ever is easiest.
  10. Jphillis

    Criteria within a query

    When querying the database I want to be able to type in a particular Client Code within that query so that it produces the information selected for that particular company and only that company. Can anyone help with the criteria needed to do such a thing?
  11. Jphillis

    The use of Timer

    I have two problems related to time. P1 I want to start a timer going when i select the Open form Contacts button on a switchboard. The timer must be on a Form Contacts. When the form is closed the time used must then be subtracted from an amount of Time Available, also a text box on form...
  12. Jphillis

    Problem concerning Time

    Access 2000 Is the code that you have suggested supposed to be written in the Expression builder or in the Code builder, (which i presume is VB code?)
  13. Jphillis

    Problem concerning Time

    The syntax error is still coming up, is there anyway i can find out more information about what type of error it is or where it is happening? is there a compiler on access?
  14. Jphillis

    Problem concerning Time

    I have modified the code as follows: private sub TimePurchased_AfterUpdate() dim frm as form set frm=forms(Calls) if not isnull(me.TimePurchased) then me.TimeAvailable = iif(not isnull(frm!TotalTime),frm!TotalTime-me.TimePurchased,0) else...
  15. Jphillis

    Problem concerning Time

    Excuse my ignorance, but where do i put this code? I'm still a novice at access.
  16. Jphillis

    Problem concerning Time

    I have Two text boxes on one form, Time purchased, and Time available, and another text box on a different form, Total Time. I want to be able to input the Time Purchased (which i can do), I then want to up date the Total Time when a new call is taken (which i can also do) The problem is i want...
  17. Jphillis

    Microsoft access can't find the macro......

    Thanks....that has done the trick.
  18. Jphillis

    Microsoft access can't find the macro......

    yeah on a form
  19. Jphillis

    Microsoft access can't find the macro......

    I am trying to calculate the total time from a start and finish time. I am using the experssion: txtDiff = DateDiff(&quot;h&quot;, txtStart, txtEnd) & &quot;:&quot; & DateDiff(&quot;n&quot;, txtStart, txtEnd) Mod 60 as show in a thread, but when i try to execute it the message &quot;Microsoft...

Part and Inventory Search

Back
Top