Search results

OK. sorted. Usual embarrassing error of not getting the right name on the subform:mad:. Thanks

Nope. Now looking for frmCAmendmentssub as a field.

I know there are multiple (thousands) of sites that deal with this issue but I can't get any of them to actually work. No matter how I reference a subform 2 I get an error. Basically I have a main form (frmCContractBrowser), a subform (frmAmendmentsListsubfrm) and a sub-sub form of...

Always the simple stuff that trips me up. Thanks!

I have extracted a series of numbers from a list box and now I want to total them and store the result in a variable. When I do this I get 12345 which is just the numbers as extracted (Dim as Integer). How do I get them to actually add them together? I am sure this is simple but I can't see why...

Thanks for this. I was thinking of something like this although I hadn't thought to check it against the network BE before releasing. I like the idea of moving it through a stage or two. The detailed notes on the BE are the bit I was hoping to avoid but if thats what it takes, thats what it...

I do that on a regular basis to both BE and FE so sadly that will not change my development speed although it does keep my file size down and minimise the occasional code problem in production.

Thanks. My executive is well aware of what I am doing but he is also the CFO so saving money.... When I have it stabilised and it does what I think it can, then I will probably push for funding and get it formalised. Hopefully I avoid the arrows!

It is not actually a law firm. I work for a large insurer. If I waited for IT support to design and do what I wanted, I would be retired. So I did it myself. So, yes, it really is outside of IT support. I backup every morning to two different locations, both BE and FE. I have yet to lose any...

OK. Context. I am not a professional programmer. I am actually the head of a legal department and we use Access to handle legal data - contract records, product records, IP records. We don't store documents only links to documents. I do all the development work and everything is self taught -...

I have a spit database FE on computers/ BE on shared server. The compiled version works at about the speed I would expect it to but when I am adding features to the FE (which also sometimes means I edit the BE and add new tables or fields) the FE is incredibly slow - opening forms, queries...

Thanks all. I though DLookup/DCount would be slower but quite possibly the Seek function is not working because it is a linked table, as suggested. There won't be thousands of records, more like a few hundred so I will use DLookup/ DCount. Thanks for the help

I am trying to get the database to check if a record exists. I am using Seek to do this where the code will pick up the record number from the primary table and search on the related table for that index number (IDContract). The code is: Dim db As DAO.Database Dim rst As DAO.Recordset Dim...

The problem is that most reports need filters at the time of viewing so printing is easy but having to select criteria makes it a bit more complex. I am looking at partially using Allen Browne's Search Criteria coding, combined with the idea of listing the criteria that are needed to produce a...

This gives me some good ideas. I sort of was working along some of these lines but I can see from this that I can make it better. Thanks

I am working on a database where we are going to have to have a great many reports - at least a few hundred. I can see a looming issue as more reports are developed as to how to handle the criteria selection and generate the report - most reports will have different criteria and will look...

I changed that back as suggested. I had it like that originally and then tried different syntax in case I was making a mistake. ID is numeric and it works smoothly now. Thanks

Ah. I knew it would be something incredibly simple and stupid. DataEntry was set to Yes. Problem solved. Thanks

This should work but it produces a blank form and I just can't see why. I am opening a popup form with additional information by clicking on a CommandButton. The OpenForm line looks like this: DoCmd.OpenForm "frmCOutsourcing", , , WhereCondition:="ContractID = '" & Forms!frmCContractBrowser!ID &...

I am using the Replace() function to replace a placeholder in the body of an html email. The function works absolutely fine except that it is truncating the string. The string is a text based URL to a file location on a network folder and the string picks up the URL fine but when the Replace...