Search results

Hi guys, I'm sure this is an absurdly easy question to answer, but after plenty of Googling and searching in these forums, I can't find the answer that I'm looking for. It's been ages since I had to do any coding, so am a bit rusty! :banghead: Anyway, all I'm looking to do is stop the On...

Hi guys, Bit of a weird (and long-winded) one this, but we have a module based in our (Access 2007) CRM system that allows our team in Production to view and acknowledge new orders as they're logged on the CRM by our Sales team. There's a number of functions in the module, but the one that...

Hi guys, Hopefully a really quick one from me, if y'all can help it would be mucho apprecianado (not a real word)! I'm using the OnLoad event of a form I've got as a placeholder to load a report from the onclick event of a button on my continuous form, and loading a chkbox into the code as a...

Hi guys, Well, another week and another new problem from me!! As anyone who regularly views my posts will know, I'm dealing with a lot of 'inherited' databases that were created by my predecessor who, sometimes I feel, probably had less of an idea of what they were doing than me (although this...

Hi guys! I'm hoping someone will be able to assist me in providing a piece of code in order to achieve the following, please! We're looking at a way that we can easily display what stage our clients' email marketing campaigns are at - in one section of our CRM our Campaign Manager will enter...

Hi guys, I'm trying to run an INSERT INTO statement via docmd.RunSQL, and I'm stumped - I keep getting the following syntax error: Syntax error (missing operator) in query expression '(((tblHistory.HistoryID) = 42848) AND ((LookUpAllocater.Publication) = AHCP) AND ((LookUpAllocater.Issue) =...

Hi guys, We've just recently taken on a new membership database from one of our clients, which currently has around 1,000 existing members. Their database came to us in the shape of an excel spreadsheet with contact details for all members (Title, First Name, Surname, Job Title, Company Name...

Hi guys, this is a bit of a weird one, and probably more to do with my rubbish VBA skills than anything else, but I'm hoping someone is able to clarify either way!! We use our CRM for entering client orders, which is done through our 'OrderEntry' form. On that form we have a subform that we use...

Hi guys, So I have a bit of an in-depth problem here, so I'll try to be brief but include as much information as I can! Our CRM is an Access 2007 database and we use it for all sorts of things, including raising orders for our clients. When our users open the database they are presented with...

Hi guys, Yet another random request from me that I'm hoping someone will be able to assist with - this time based around a membership database that we're currently running on behalf of a client. The database holds around 2,000 members, each with their own expiry date, and each week we email a...

Hi guys, I've been looking at this for the last couple of days, and I've got as far as I can with it - so I'm on the lookout for some assistance, if anyone here is able to do that! I am very much a layman when it comes to Access terminology, so I won't get offended if you guys explain things...

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 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...

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...

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...

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...

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...

Hi guys. I'm having some problems with this - clearly a bit of a basic one so apologies in advance. I'm currently in the process of creating a form to be used in an upcoming calling campaign, and I'm trying to get 1x combo box and 1x text box to update the Date/Time field that shows when the...

I'm trying to open a report from a Button on a form, but when the report opens it hides behind the other forms on-screen, meaning you have to go to Window and then select it to bring it forward. Here's the code I'm using in the on-click event of the first form: Private Sub btnPrint_Click() On...