Search results

attached here

I'm not sure where this is coming from exactly, it only appears in the SQL and doesn't make sense when i look at it in MS Access design view. I removed it and tried to run again but no luck... A crosstab query may be better here, i just haven't worked with them much so i will need a bit of a...

Except that this would only get me the count for one category, while i need counts for 9 different categories, all on the same datasheet that can be used for a graph. Year-Month is just a reformatting of the PCL_Date field which is a time stamp. Its just a column heading. here's all the...

I'm not quite following here, I thought the In() Clause essentially provided a dataset to the main query to further refine. So i thought it would require a common key but I guess i'm not understanding its function entirely. Unfortunately i'll have to create a mock up to send out which may take...

True, you got me there, it just doesn't display the results the way i expected.. it returns the following... Year-Month Count of Material variation 2017-11 200 2018-08 221 2019-05 181 where i should be getting months 01 to 12...

I have a report containing a series of line graphs showing the number of service calls (for maintenance on equipment) performed each month. The service calls are categorized based on the reason for the service call. Im attempting to give a further breakdown of the progression of each category...

I did, the only issue i had was that i had to click out of the combo box for it to execute. I tried the Before Update as well with the same result. It worked ok with OnChange so i stuck with that.

Just for anyone who may be having the same issue, to fix this i simply created a Private subroutine and called this subroutine for each event that needed it. Private Sub UpdateComm(intTabNumber As Integer) Dim strSQL, strWhereSQL, strEmpID As String Dim CommCount As Integer On Error GoTo...

Good point. I've made the recommended changes but still no luck. would it be possible to call the Form_Current event from another event? so rather than requery from the after update, i simply call the Form_Current from within it as if it was a function?

Im sure this is something simple but i cant seem to get it working and my deadline is fast approaching. I have a simple form that contains some combo boxes used for filtering data and a listbox to display the results of the query. The query SQL is executed with the forms OnCurrent event, which...

The only one that may not be a variant would be the varAction variable, but only because i havent done anything with that variable yet (didn't mean to even copy it over). The rest have to be variants.

So here is something I built years ago that I've continuously refined and built on but now i need to build on significantly more to make it work the way it needs to. Here it goes..... Background: I have one main database with multiple specific forms that somewhat correlate to specific...

Ah... that got it! Thanks Pbaldy!

if you search one of the part numbers (Should be '12345') it should return multiple values and display the form with the listbox.

took a while but here's the stripped down version

the table does but i can create a mock with some filler data. Will have to wait for Monday though. Thanks for all the help, i'll be sure to post something up when I get back in.

Same here, i feel like its something stupid simple like a spelling error or something but i've looked over it several times and couldn't see anything. Tried hard coded rowsource = "SELECT partmatrix.PM_PartNumber AS [Part Number], partmatrix.PM_ToolNumber AS [Tool Number]...

this gave me a "Invalid use of Null" error. Not anytime soon, pretty massive DB with confidential data so i'd need to make a copy and strip it down. probably would be able to post till monday.

This may be the culprit, although i'm not 100% clear on how. I added a breakpoint at the DoCmd line and both variables returned Null wile using the form Private Sub lstMultipleValues_DblClick(Cancel As Integer) varToolNumber = Me.lstMultipleValues.Column(1) varPartNumber =...

so the popup form itself containing the listbox is unbound, tried dynaset and snapshot recordset types with no change. the unbound listbox properties are as follows Row source = 'Populated from the SQL statement prior Row Source type = Table / Query Bound Column = 1 Allow Value List Edits = No...