Search results for query: *

Hi All: The form has worked incredibly well for me for a number of months now.... but I've run into a wee problem. Can the form/code be used to generate a 'results list' in another form (or something?!) that can be used to further browse the database. i.e. if a listbox with a product line...

Sorry- I'm still a bit of a novice. Where would I use that- in an update query? and is that -1 the number of characters it will extract? A little clarification, if you wouldn't mind...thanks!!

I have imported data from a HTML file into a table in Access and I am now trying to extract part of a field and put it into a new field. In the HTML file, the data was stored in a table (at least it looks that way!) that had "Source" information on the top line in the "Segements" field, and...

I've double checked...they're all just fine! Was I supposed to have changed anything in the code??

I tried... i'm still getting the same error message thought.

Maybe I'm not correctly understanding what the form module is?? I placed the function right after the General object of the VBA code for the form. Should I have created a new module? Or put it somewhere else? The label is also showing a pop-up caution/error message when the form is in design...

Hi FancyPrairie Thanks once again!! Unfortunately, I'm still an Access Dummy and i'm having trouble. I named the controls as you specified, and put the =Process... into the OnClick events of the labels, and then cut and paste the code, but i'm getting an error: "The expression OnClick you...

FancyPrairie- you mentioned creating an All label, and "calling a function" that checks to see how many items have been selected and displaying them in a label below the listbox. Would you mind explaining how to do this too? It sounds like a fantastic way to let users know (1) how many objects...

I've figured out where I went wrong... the report is working just fin now. Thank you so much for your help!!

Here it is! SELECT tblCDissatCategories.CDissatID, tblCDissatCategories.CDissatCode, tblCDissatCategories.MainCategory, tblCDissatCategories.SubCategory, tblCDissatCategories.Description, tblCustomerComments.ProductLine, tblCustomerComments.ResponsibleAgent, tblCustomerComments.CaseID...

The results in the Msgbox displayed the primary key from the table from which the SatCodes are taken. This struck me as odd (I thought it should be displaying the SatCodes themselves), but I thought that since the primary key is also a column (hidden) in the listbox, that it would still work...

Yes- the report seems fine when I don't include the "BuildWhere(Me)" portion in the On Click event in the code. The report is based on a query. As with (almost) all of the reports in this database, the data comes from more than one table (all related).

Thanks! i've got the report opening now when I click the command button... only problem I'm having now is that the report is blank. the headings, etc. are there, but no data seems to come up...

Gotcha- thanks. The command button is now returning the BuildWhere info. how do i take this and get the query/report to work now??

Maybe I misunderstood you when i made the command button... I inserted the command button on my form, then I went into the properties for the command button> Event> On Click and typed exactly what you asked me to type: MsgBox BuildWhere(Me) Should this have been done in VBA? and if so, is...

Hi FancyPrairie- Thanks again for sticking with me! I created a new module (again)- copied the code into it, saved it as basBuildWhere. then i went back to Access, opened the form, tried selected one or two SatCodes, clicked the command button, and I got the same error message. Is the button...

Thanks once again for all of the great advice! I'm still stuck though... I have followed FancyPrairie's latest advice, but I'm a little confused. First of all, how do I link that command button to the listbox?? I'm obviously missing something because after setting the tag property as...

Thanks for the advice, FancyPrairie. I took a look at the FAQ and copied the code into a new module. It's still not working, though. Maybe I didn't understand this whole Tags thing well enough?? I'm not sure. Or maybe I have to do something to connect the module to my form? I'm really...

I'm trying to create a query that will: -let me enter a particular SatisfactionCode when I run the query to limit my results (using Like [Enter Satisfaction Code or Press Enter for all Satisfaction Codes]& '*' as my criteria) and show all of the CaseIDs associated with that code -show all of...

Wow- this is turning out to be way harder than i imagined it would be. Thanks again for your patience with me, and your help! I moved the code to the AfterUpdate event... and I fixed the lstSatisfactionCode problem... Thank you. I'm not getting an error message when I click on a value in the...