Recent content by Jphillis

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...

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

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...

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

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...

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...

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...

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?

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.

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?

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...

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?)

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?

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...

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