Search results

Thanks Fofa, that's an approach I hadn't considered. But I still have the issue of the columns being dynamic. I never know how many there will be or what they'll be named when I import the spreadsheet. So I guess that means I'll still have to build the SQL on the fly. But now I need to figure...

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 figured it out Never mind. The problem was that I was using Str to convert an integer to a string which apparently sticks in a space, i.e. The integer "1" evaluates to " 1" using Str. The solution is to use Format. Thanks again for your help everyone.

Thanks again Yes, you're right about the recordset. It should be rsImport.MoveNext. I've stepped through the code watching the variable values and am positive that the variable evaluates to the correct table field name. But for some reason, the code: .Fields(strSkillField) = strImpSkillSet...

Not in collection error Scott, thanks for your suggestion but when I try it, I get an "Item not found in this Collection" error. Function fAddSkills(strAgtID As String) Dim rsConvSkillSets As DAO.Recordset Dim strImpSkillSet As String Dim strImpPriority As String Dim strConvSkillSet As...

Thanks! Yup, you're right about setting the RS within the Loop - stoooopid! Dunno what I was thinking. ;) Thanks for your help. I'll give it a try.

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

Thanks for responding John, thanks for your input. I guess I know what I need to do if the answer to my question is "yes" (use the acPrint parameter in the OpenReport cmd instead of acPreview). But it would be nice to know exactly how Access handles the whole process before I determine if it...

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

Never mind! I put this instead in the Detail_format of the Main report and it seems to work: Me!UnattachedLabelName.Visible = Not (Me!SubreportName.Report.HasData) The UnattachedLabelName control contains the text "No data entered yet"

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

Thanks for the input, guys I think I have it figured out though, just had to change the order a bit. Autoeng, you're correct: All users will have a local copy of the FE containing various queries and reports, but it will be locked down. That is, I'm not allowing anyone to have direct access to...

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

No joy I'm afraid That doesn't seem to work either. Thanks anyway though. I'll continue with the trial and error approach!

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 "*" &...

Believe it or not, the same thing just happened to me My back end data table file was corrupted due to an improperly entered record (missing fields - it's a long story, and I'm going to assume no one cares ;) ). At any rate, the standard repair utility within Access 2000 was unable to fix it...