Search results

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

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

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

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