Search results for query: *

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

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

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