Recent content by lightray

Hi, this post has been of some help to me. My challenge is to set a variable after an on click event [country flags] I will later interrogate this to display appropriate pricing on another page, with if statement. I have good HTML skills and still coming up to speed with PHP and javascript. I...

the # is a default, you would normally enter the link name to link off to. If you don't want it to show until you're ready to put the links in, remove 'href="#"' If you didn't want a link at all, remove <a href="#"> and </a>

Thx for your idea jdraw. I have bounced off that to consider just a counter in the loop, which is zerod down.. Here is my code [much thanks to the forum] Private Sub SendEmail_Click() On Error GoTo Err_SendEmail_Click Dim stDocName As String Dim db As DAO.Database Dim rs As DAO.Recordset Dim...

Would need to know how each table is structured to be able to get a better understanding of your problem.

Hi there, My exercise is to split a thousand or so email addresses down to managable groups of 100 [ISP prefers this too] I have easily created the query to extract the email adresses and used sendobject to get them to outlook. But what I need is an idea of how to select them in groups of 100...

This was a great help to me today.. Thanks for the post and thanks for the reply, RuralGuy :)

Hey RuralGuy, as usual that is awesome spotting.. many thanks. It worked amazingly well. I looked at so many examples on the site, I just couldn't spot it. Probably the 2 am thing.. :):):)

Hi, after resourcing my Runtime 3075, I've now backed into this one. I'm trying to check a condition that a user has a previous certificate type and then pop the User to show the condition. Print is a yes/no field, ID fields are numeric. Have I got this right? Appreciate any help it's almost...

Hi there, you've got the start of an idea. Yes it is best to create a query first If you want to create a calculation in a query it goes on the top line or you can create it on the page itself, best in the query though as you can run the query and see the results of what will eventually be on...

Start by using the Form Wizard to create your form, selecting the table name Master and choosing the field name 'Name' to appear on the form. The next step: While in design mode select the command button and place it where you want your button to appear on the form. Click/hold and drag right...

Do you have a table created already with a text field in it named 'Name'?

:) Thanks RuralGuy, that was just what I needed. Worked a treat! I had the format already setup as a global constant, but didn't realise I needed it here. So the final solution was; rst.FindFirst "[HoliDate] = " & Format$(StartDate, JetDateFmt) If Weekday(StartDate) <>...

Will try that out and post back, many thanx

Hi RuralGuy, would this happen on a open recordset as well? In NZ we use dd/mm/yyyy format as well. This is part of my modified Arvin Meyer module. When I add a new holiday to the holiday table it gets counted (shouldn't), however it seems records for xmas and new year are???:confused: any...

I think when it comes to calculations in a report you have to fill each calculation out in its own right. Therefore the third calculation should be, = sum([TransactionAmount]) - sum([GST]) Remember if you were doing it in code you would have to assign a variable to each value. As far as...