Recent content by thedude1971

Hi there, We have written some VBA code now. The code kind of works, but seems to loop and lock after its running. How do we get the code to stop after its finished? Or is there something wrong with the code? Attached is a screen grab of the code. TIA.

I will change my naming conventions for sure, thank you for that. However any idea which command/s to attempt the code? We were looking at the If then else command, but not sure.

Hi there, I am using MSAccess2010 and I am struggling to write some vba in my database. I'm not very good at the vba side of Access, so if someone could help me the code. I would be able to learn from that. On my form, I have a Payment Type dropdown field. When someone selects a payment type I...

Thanks for everyones suggestions.

Hi there, I'm running Access'2010. I have a table with two fields thats stores find/replace data in it. They go to a form select what needs changing and then the form runs the query. So I need to update 40 fields and I have a update query. My problem is it only completes the first field it...

Hi there, I have a embedded Macro button using the SendObject command that will compose an email with the Access 2010 database, its almost working but there is one problem. Is there way where I can use the data from field, like someones name. I have a field called Account manager and I want the...

Excellent, that works a charm. Thanks very much :-)

Hi everyone, I am trying to write two queries that will generate reminders for a staff member to action. The first query will list any records, one month before they happen. The second query will list any records, one week before they happen. I have searched on the forums here and can't...

I have had a look through the pages and there lots of info/code there. I found some code and it creates a email for me. However its not taking the data from the database, for example taking the email address Access into outlook. I have not found any code that does that, if anyone knows? The...

Hi there, I am running Access 2010 and I have created a IT helpdesk system. I want it to create an automatic email confirmation when we create helpdesk jobs. I really need someone to help me with some code that will email the staff using Outlook 2010. I am not a expert on the code side of...