Search results

do you have an example of what this looks like because I am not sure what you are after - if you can provide a visual I can point you in the right direction....

Hi If you attach a copy of the db I'll have a look for you.

Think you could achieve this with one button, two record sets (one for each query). To be clear are you looking for example code covering record set and outlook or just the outlook ode? Thanks

Not sure if I am grasping it or my understanding of vba isn't there (I'm by no means an expert) but just because the combo box has a row source doesn't make it bound?? I thought that was if the form was built directly from table etc. Error is to do with the recordset wanting to save record...

Not sure if I am grasping it or my understanding of vba isn't there (I'm by no means an expert) but just because the combo box has a row source doesn't make it bound?? I thought that was if the form was built directly from table etc. Error is to do with the recordset wanting to save record...

I've always found conditional formatting to be temperamental. It either doesn't work or it corrupts my form so I always code it. I now create a function that I can pass a control value to, a case statement then selects what colour it needs to be.

I've just thought is the query a saved query. In design view and your referencing that?? I'm not 100% certain but not sure if that only works with querydef cmd. I had an issue so I declared a string and assigned to it the SQL statement and passed that to record set which then worked....

Hi No problem. That errors is normally to do with the sql statement. Is it typed correctly?

Sorry I can not be of any help, it doesn't make sense to me, never come across it and without seeing it it would be hard to tell.

Ok. The loop looks good to me I would personally use Do Until but I guess its personal preference. I just noticed you have " " around AddressMailList, is this how it is in your code? You wouldn't need it if that is a variable. Thanks Carl

I have just tried this (Access 2010) and it works. The only difference is I declared as below: If Me.txtTitle.Value < 0 Then Me.txtTitle.ForeColor = vbRed Else Me.txtTitle.ForeColor = vbBlack End If

Can you provide the db to have a look at because how you have explained it seems correct.

Are you sending the emails automatically though Access via Outlook?

Hi I guess you have declared - AddressMailList as I can not see it above.... Also have you tried shortening the variable name? to something like sqlAddMail. I also can not see how you want to open the recordset which is important. The most common is dbOpenDynaset as below. I have had a...

Hi In order to populate the textboxes you would do something like: me.textbox1 = rs![field1] me.textbox2 = rs![field2] you dont need the [] unless the field name has a space but its good practice :-) to set the defaul combo box value you will need to declare something like: Me.cboBox.Value...

Even easier. I have attached an example of how I would do it. This is by no means exhaustive as in practice you would want to add password masking, deny access after failed attempts etc but that is beyond what you was asking form. You can try the following logins: Username: Carl Law...

No problem. What version of access are you using? Thanks Carl.

Didn't even think of that!! I'll give a go and report back :)

Maybe i am not sure. The end user opens the logging form with numerous controls on, the user fills in and when they enter a number affected textbox a new form pops up asking them to enter the policy numbers into it. This could be between 1 and 100 policy numbers. the policy number form is then...

Hi Trisha A good way, or at least the way i return the logged in user in a corporate envirnoment is a function: Public Function ReturnUser() ReturnUser = Environ("Username") End Function Then call the function: me.lblUserName.Caption = ReturnUser If this has the undersirable effect...