Search results

I have put it in both the Format and Print events, please see opening post. ~Matt

It is strange. After previewing it, the export to PDF works. I am not that fussed now until the new year as I finish in 40 minutes :)

Hi June, If the PrintPreview option is the only solution, then I will do it this way. I was just hoping someone might know if I have put the code in the wrong event to make it work. ~Matt

Hi all, I have a report where I want to hide/show the report footer depending on a single field. When I preview the report, the code works fine. But if I direct print, it fails, unless I have previewed it first. This is an issue when I export to PDF and email as I do not preview the report...

I have just had this issue and managed to revert to the old version of Office with the below link. https://support.microsoft.com/en-us/topic/how-to-revert-to-an-earlier-version-of-office-2bd5c457-a917-d57e-35a1-f709e3dda841 Worked like a charm and now I can use my database again. ~Matt

Thank you, I shall check it out. ~Matt

Does anyone know of a way I can save a form layout as a custom theme so when I add a new component, ie command button, it uses my custom settings for it? ~Matt

I see what you mean here. So if I have the settings form to allow the user to select In or Out but the table itself stores the value as 1 or -1, that would work? ~Matt

Thanks guys. I love reading your views on questions on here. It helps me learn. I think that, as it does work, I will leave it as is for now. I have a separate table, tblTransactionType, where the users can add as many types as they like, and then specify if they are In or Out. As there doesn't...

Hi all, I am looking at reworking my MRP database to manage the stock numbers better. At the moment I have a TransactionType field which denotes the transaction type to either In or Out. The TransactionQuantity field is currently always a positive number. I have seen on other DBs that they have...

I know what you mean, I think. I would love one of you VIPs to look over my work and show me better ways of doing the things I have done. My database has been built over the years and I know most of what I have done will not be the best way, but I have learnt it all from Google and in these...

I had been thinking about the VBA method, but it is not something I have ever tried before. I will have a look and see what I can find. ~Matt

I updated the query to have all the criteria as above, and it works perfectly, but has changed the query to look as below. It has added the Is Null parts on the right for every parameter I want. Is this normal? ~Matt

Update, it now doesn't work, and it has changed my query quite a lot. I put the code in as below, but is changes the query. [Forms]![frmProductionManagement]![cboCustomerFilter] OR [Forms]![frmProductionManagement]![cboCustomerFilter] Is Null It now adds a field at the end of the query with...

Tried the code as above and it works. Thanks Minty, it was so much more simple than my mind had it. With regards to wildcards, if I am filtering on a dropdown should I always use similar parameters as above? Wild cards only for blank text boxes? ~Matt

Thanks Minty, I had tried the first part yesterday and that worked fine. The second drop down is called [Forms]![frmProductionManagement]![cboCustomerExcludeFilter] so would I do something like below? [Forms]![frmProductionManagement]![cboCustomerFilter] OR...

Good morning all, I am having an issue with a query where I want to filter a field based on 2 different drop downs. I want 1 drop down to filter ONLY by that customer or all customers if blank. The second drop down I want it to filter that customer out or show all customers if blank. I use a...

I did fear this, but I have created a desktop shortcut to a batch file which copies the FE and all images on every load. This also means when I updated the FE I only have to put it into the network location and the users always have the latest version. The files on the server are read only for...

These icons are so much better than the mso list :)

I have managed to get this fixed by using the example below. http://www.kallal.ca/Ribbon/ribbon.htm This has been bugging me for ages as I don't like picking imageMso's for my ribbons as they don't always suit. Now I can use anything I like :) ~Matt