Search results

Also, maybe a SELECT...CASE statement might work here? Sent from my iPhone using Tapatalk

Bit of a newbie as well. Where are you putting this code and initially noticed that none of your IF statements have END IF closing statements. Sent from my iPhone using Tapatalk

Hi, been following this thread and though I would add an idea which may help with using a rough typed in estimate vs a total of the underlying "estimates". I have developed a database very similar to the one you are talking about. What I did was have a checkbox chkEstimate and a field Estimate...

Well. It would appear that I've worked out a way around this. As all the staff using this software have office 365 business, and MS have recently come to the party and included full versions of access 2016 in the subscription I have abandoned using access runtime version and just added a runtime...

Just wondering whether anyone else out in the Access Development world has any other ideas as to why my original code would work in the Access 2007 environment but not in 2013 runtime? Still trying to find a solution to this....

I've been developing in Access 2007 as we have a copy at work - I purchased Access 2010 some time ago and was originally using this to develop while at home. Then as we have a number of copies of the database - FE/BE. I have these running in the 2013 runtime, probably mostly because I prefer...

It is definitely installed on my computer, as opposed to one of those click to run cloud ones. We have office 365 which comes with install versions of word, excel etc and I've used vba to automate word.

Now no matter what i do I get: 429 error or another error about license error. The only time I don't get this is when I base my code off my original post, but this will only still open a new instance of Outlook but won't create the message. Aaaaarrrrggghhhh! Sent from my iPhone using Tapatalk

Hi Gasman, I'll have a crack using your declarations. Note: While I am using 2007 version for development, that actual runtime environment is a 2013 version. Also, whether this makes a difference, but the outlook version is the 2016

Hi Gasman, Trying this and getting "429 activex component can't create object" That's within the 2007 environment, let alone trying on 2013 This is happening on: Set objOutlook = CreateObject("Outlook.Application")

Hi Ranman, I looked at the DoCmd.SendObject method, however I want to attach a previously generated PDF file which is stored on our network. The link to this file is stored in the tblQuotation.QuotationLocation field which then gets added as an optional argument of the Function. That way I...

Hi All, I've been trying to get this block of code to work for a while now and can't seem to find the answer. I have found some code and edited it to suit (from: http://www.devhut.net/2014/10/31/createobjectoutlook-application-does-not-work-now-what/) For some reason this works perfectly when...

Sorry for the late reply. I'll get some screenshots tomorrow morning and post them. Thanks for the response Sent from my iPhone using Tapatalk

Hopefully someone out there can help... Sent from my iPhone using Tapatalk

Hi GohDiamond. Thanks for your reply. Yes, I do want to insert into tblItemInput, this table handles the many-to-many relationship between Items and Inputs. Have just realised that I didn't show that table on my attached ERD. When a user adds an Input to an Item, tblItemInput keeps a...

Does anyone have any ideas? P.S. Just noticed how terrible my code looks, thought I had indented it correctly but it hasn't shown up. My apologies

Hi Everyone, I have another issue. I have borrowed some of Allen Browne’s code for duplicating a record and its related subrecords from http://allenbrowne.com/ser-57.html I have this assigned to a button on a form [frmItem]. The form allows staff to add materials and labour (Inputs) to an item...

Btw it is now working Sent from my iPhone using Tapatalk

No just needed a list of all jobs. Every job must have a client but not necessarily a contact. Cheers again for your help Sent from my iPhone using Tapatalk

Hi CJ, You sir are a bloody legend! You weren't quite there with the join method, it worked by saying "Include all records from tblJob and only those records from tblContact", but the premise was there. I had forgotten about double-clicking on the relationship and setting other types...