Search results

Hi guys, thanks for replying - Rx_, I think you may have hit the nail on the head there and I'll try that solution. mdlueck, it's a bit hard to explain, but let's say that Field A is a unique identifier for a contact on our database, and Field B is their email address. The db I'm working on...

Hey all, just a quickie as I've been searching for an answer to this for a while, but so far kept turning up blanks - so I'm happy to defer to the forum on this one! Is it possible to build a Select Case statement based on two seperate fields on a form? So, if Field A = 1 and Field B = 2 then...

Hi Dralloc, First of all, thanks for replying! After a bit of investigation, it turns out that the users' alternative email addresses are stored on a POP3/SMTP server, so this should work perfectly! I'm going to have a play with things and then let you know how I get on!! Thanks again!

Did we have any suggestions on this one at all, guys and girls?! Still struggling with coming up with a solution! :(

Hi guys, I hope this wet UK afternoon finds everyone well! :D I'm creating a routine in Access 2007 to build an HTML email by sucking information out of a form into a report. This all works tip top (if I do say so myself!), but my boss has thrown a spanner in the works by announcing that the...

NB - This post has now been solved!! Thanks to CBrighton in this post: http://www.access-programmers.co.uk/forums/showthread.php?p=1101277&highlight=check+if+outlook+is+open#post1101277 Simply adding this code does the trick: Dim objOutlook As Object On Error Resume Next Set...

Bit of a bump for the Thursday crew.

By way of a bump, I've gone forward using the create table route - see my code here: Private Sub cmdUpdatePieChart_Click() Dim obj As AccessObject Dim SQL As String SQL = "INSERT INTO tblMyTable ( Field1, Field2, Field3, Field4 )" & _ "SELECT...

Hi guys, I've got a slight problem that I'm wondering if anyone will be able to help with. I have a form that calculates the percentage of a product sold to customers. The Main Form features two unbound text boxes you can select a date from and a date to, and an unbound combo box that looks up...

Hm, as I said I'm no expert so I can't see anything there that would cause any problems - but then my knowledge is fairly limited, so perhaps one of the more experienced forum members would be able to help you on the code front. Have you tried putting a stop on the code and the stepping through...

Hi there, I can see a number of problems with this code, although none of them may be the key to your problem - they're just things that jump out at me as being wrong! 1) In your first "If" statement: If cmbDept.Value <> "" Then Else MsgBox "Select a Dept name.", vbCritical, "Dept Name is...

Ah, thanks winshent - muchly appreciated! :)

Hey guys, Just a quick one - just wondering if anyone can tell me if it's possible to open a report with one of two different queries, depending on where it's opened from? So if it's opened from Form A, Query A gets loaded as the recordsource, but if it's opened from Form B then it gets loaded...

Another user kindly PM'd me with some suggestion, and helped me come up with the following: Grabs the highest ID number from table one and then inserts it into the MyID_ID field of table two!

Hello all, I'm hoping someone can give me a bit of a push in the right direction here, as I seem to be going round and round in circles! I'm currently creating a continuous subform which acts as a data entry area, with a query containing two tables as the recordsource. The first table...

So, moving on from the above, would anyone be able to tell me if it's possible to get the code for a text referencing more than one field? The code provided in the example that speakers_86 hooked me up with is: Private Sub cmdFilter_Click() 'Purpose: Build up the criteria string form the...

Hey speakers, That's 100% done the trick - massive thanks for that! I may well be checking back with further questions however! ;) Cheers, Jeff.

Hey guys, I haven't had the need to use my VBA skills for a good few months now so I'm generally a bit rusty - hence this post. I have a form with four unbound fields (two combo boxes and two date fields) that I need to use to build the basis of a recordsource for a subform to display the...

No, not automatically - you have to browse to the next record and then back again in order for it to change. Do you know what, you've exactly hit the nail on the head - after I designed the rest of the form I tidied up after myself by renaming all the txt and cbo fields...and totally forgot...

Of course! ;) Private Sub cboStatus_AfterUpdate() Me.LastCall = Now End Sub