Search results

Hi Ridders, So yes I do want to update the Available field to False. This isn't a problem as I've an extremely large number of Customer IDs (which I'm never going to reach). However I think you're saying it would disappear immediately after update, which is a contradiction so actually not...

Hi all, I have a combo box on my form that shows only certain Customer IDs from a Customer ID table that I want the user to be able to select (this table has two fields [Customer ID] and [Available]. I've done this by including that table in the Row Source as a query with [Available] set to...

Thanks all for coming back to me on this, worked when I put in arnel's solution.

Hi all, I have a field on my report that contains a mixture of decimals (e.g 0.2544, 0.4567 etc) and text statements such as "No Leads" or "No Eligible Sales". I'm trying to get the decimals to show as a percentage to one decimal place on my Access report, but keep the text statements as they...

No probs mate, no rush I'm not against a timeline or anything. Haha told you I was dumb, didn't check inside the thread! Thanks I will have a look this afternoon. The example here is exporting to my desktop but normally I export to a Network Drive, just needed to use the Desktop to test.

Hi Ridders, Thanks for taking the time to look through the db, and the detailed response is great, might as well tackle all the issues! I need to keep the two brands separate, as I need to report separately and the Tbl_(Brand)_Data for the two brands are picked from different sources, and they...

I've attached a really basic version of the database, I hope it works. A lot of this is confidential so I've had to change a lot of names etc but I think it still makes sense. As you can see the reports print out every site in one, and they're split one site for each page. However I want to...

Thanks, I have created a new LocId line "L01", and a column in a new table TBL_EXPORTLINK where I have a column that lists each unique code and the folder name that the report should be added to in the TBL_FILELOC location I have specified in "L01". FullGrpCode is the groups code with the...

Sorry it was meant to be; Private Sub CommA_Click() Dim EXP As String EXP = DLookup("[FileLocation]", "Tbl_FILELOC", "[LocId]='L03'") Dim strPathAndFile As String strPathAndFile = "" & EXP & "" & "All Group Statements- Q1 2017.pdf" DoCmd.OutputTo acOutputReport, "Rep_Grps", acFormatPDF...

Hi all, I have a report that is grouped on a group code (separated to one page per group), and have a piece of code set up below that exports the whole report into my desired location, listed in TBL_FILELOC. Private Sub CommA_Click() Dim FTP As String EXP = DLookup("[FileLocation]"...

Easy when you know how, that's worked perfectly, thank you so much.

Hi all, I'm wondering if you can help me with something that is driving me mad. I have some calculated IIf fields on a report that won't format as currency to 2 decimal places. They are stored in the source table as currency to 2 decimal places, and formatted as currency to 2 decimal places...

Hi Moke, Thanks for coming back to me, and apologies for the delay in reply, I've been away for the Bank Holiday weekend here. Thanks for posting that tool, he's a smart guy whoever created it. It says there are 253 available connections at the start. After running my code and this form then...

Hi, I'm new to the forum and have introduced myself as such in the new members thread. I've inherited a database from someone and have been running the code on it fine for the past few months, occasionally tweaking wherever necessary. However, now randomly, all of a sudden one section of code...

Hi all, I'm a new member to this forum and I'm based in Birmingham UK. I know my way around Access pretty well, I use Queries, Forms, Reports pretty much all of the time, but a bit of a novice when it comes to programming. I alter VBA code in a database that a predecessor built where...