Recent content by Graham T

The two pass solution sounds exactly what I need to do. Doing this though is not something I am entirely comformtable with...!

The problem is, how in outlook do I include the code that looks within the email body (which can include up to 9 device serial numbers) and if the same serial number exists more than once do not read the email data into Access, but rather move the email into a different folder to be dealt with...

Hi, I am attempting to modify some code that is used for reading content in an Outlook mail and need to catch and move the email if certain content is duplicated in the email. The code reads the email that is in the attached image format: As seen, this email contains 2 devices, but the Serial...

Apologies if this is posted in the incorrect forum. I am looking for an Article writer for my Microsoft Access related website. Unfortunately, I do not get enough time to maintain the website like I used to, and would like to ensure that there is some new content added to keep the site up to...

I think I had already tried something similar. Appears to work first time, but then try clicking selecting further players...

coyote, sorry its so confusing. Guess I'm not explaining it correctly, as it really shouldn't be! IF, from the example, we choose Position No 4 for a Player and check prefered, this means player 'X' can play in Pos No. 4 and it is his prefered position. This same player could also play in Pos...

coyote Thanks for looking at this. I have looked over what you have done, but unfortunately this is not quite the way the options should work. Each Player can play in any position and many players can play in the same position. When positions are recorded in the subform against a player...

llkhoutx and coyote Thanks for the replies. llkhoutx, not sure how to apply an option group in this situation. Didn't realise it would be an option? coyote, I tried the code, but can't seem to get it working. I have attached the database in Acc 2K if it is any help for you to visualise...

We have a subform that allows us to assign multiple Playing Positions to a Player, however the Player can only have one Prefered Position (shown with a checkbox) The composite primary key consists of the Player and the Position. How and where is it best to code to prevent us checking the...

Didn't get chance to look at your sample, so not sure, but this may help if it is what you are trying to do: Using the Combo Box's Not In List event with multiple fields Graham

Radion This example might be along the lines of what you are after, although you will need to be entering your data via a form, not directly into the table (which is what you should be doing anyway): Preventing Duplicates from being entered HTH Graham

mickeyblue If you add the following to a button on your form, named cmdAddColumn, it should alter the table: Private Sub cmdAddColumn_Click() Dim conDatabase As ADODB.Connection Dim SQL As String On Error GoTo Error_Handler Set conDatabase =...

qwertyjjj Maybe How to Use Visual Basic to Change the Application Title HTH Graham

The DEFAULT statement can be executed only through the Jet OLE DB provider and ADO. It will return an error message if used through the Access SQL View user interface. Taken from Intermediate Microsoft Jet SQL for Access 2000 HTH Graham

RickDB You might want to check out Checkboxes and using the Triple State Property I think this is what you are refering to. Graham