Search results

I'm sure this has been discussed before but I can't seem to find any references to it. I have data imported from an Excel spreadsheet that contains data on the campaigns an agent is enrolled in and looks essentially like this: AgentID Campaign1 Campaign2 Campaign3... 12345 Yes...

I currently have a set of data describing skillsets for call center agents which is arranged as follows: Name Skillset Joe Blow Skill_A Joe Blow Skill_B Joe Blow Skill_C Jane Doe Skill_C Jane Doe Skill_D The user needs it converted to this format in order to bulk load it into another...

Quick question on how reports generate: If I open a report in "Preview" mode and then send it to the printer, does it have to re-run its base query and regenerate in order to print? If this is the case, would it be more efficient to open it in "Normal" mode so it goes directly to the default...

Sometimes I really HATE Access! I'm trying to create an import specification for a comma-delimited text file in Access 2000. Seems simple enough, right? So far, from what I've read, the only way to do so in Acc2K is using the Advanced button in the Import/Export wizard. I've been through the...

I've been using some of the suggestions I've found on this forum to reset the page numbers of a report by group. Everything seems to be paginating along just fine EXCEPT, the last page of the report always says Page 'n' of 'n-1'. For example, if my last group contains 4 pages, the last page of...

There must be an easier way to do this than the way I'm going about it. I want to filter a list box with user selected values from 3 combo boxes. The user should have the option of selecting a value in one, many, all or none of the boxes. The way I've handled it in the past and the way I'm...

I think I'm having a major brain fade or something but I can't figure this out. I've seen plenty of people asking how to get rid of the extra space left on a main report when a subreport has no data. That I can handle! What I want to do this time is retain the space on the main report and maybe...

Here's what I'd like to do: I have a split database with a password protected back end. In the front end interface, I want to create a routine that allows a user to copy the BE to the location of his choosing so that he can design his own adhoc queries/reports from a snapshot of the master...

Hi all, It's been a while since I've done any in depth work with Access so I've gotten a little rusty. Can anyone help me out with a syntax question? Here's the situation: Parent form name: frmProjectOverview Tab control name: tabProjects Subform name: subfrmFocusArea Listbox on subform name...

Hi all, I'm wondering if anyone else has found a workaround for this problem. When using a "user-friendly" criteria selection form in conjunction with a report (a technique I learned way back from the solutions.mdb sample database from Microsoft), I'm finding that whenever I use 'Like "*" &...

Hi all, I'm having a problem with memo fields on reports truncating after the first 255 characters. The full content of the fields displays perfectly on the form but not on the report. Here's the other weird item: the entire field contents display in the results of a "base" query but not in...

I have a spreadsheet-like report containing a row of text and combo boxes in the detail section. In design mode, all the elements in the detail section are the same height. However at runtime, one of them shrinks to a slightly smaller height while the rest remain at the correct height. Needless...

In a nutshell (a large nutshell!), I have a complex Budget vs. Actual expense report made up of multiple subreports - 36 in all - one for each calendar month for Budgeted, Actual Labor and Actual Other expenses. Underlying queries for subreports are all built on the fly based on user input. I...

I'm relatively new to the coding side of Access any maybe this is a silly question, but how do I return multiple values from a function? Can I return an array? If so, how do I refer to each element in the array that's been returned to the calling subroutine? For example, if I have a function...

Hi all, I have a couple of issues I need some direction on and I'm under a bit of a time crunch so I'm not above begging! Here's some of the background info without going into excruciatingly boring detail, so hopefully it's enough to provide an idea of the general structure: Reports are...