Search results

You're welcome! Just look in the qryEventEdit query. That's where the criteria is. Bottom line really is that you don't need that criteria as you are already filtering for the EventID on the Docmd.OpenForm line. Dave

Hi, so the problem was that you needed * on BOTH sides of the Criteria like this. Like "*" & [Forms]![frmEvents]![txtSearchS] & "*", not just on the right side like you had. I created a query called qryEventEdit which is used in the frmEventsEdit1 and frmEventsEdit. Note you can just use one of...

Thanks. I'll review tomorrow. Just heading out for the evening.

It's difficult to troubleshoot with your application without seeing it. Maybe zip it up and upload to your skydrive so I can take a look.

Like this. DoCmd.OpenForm "frmEventsEdit1", , , "EventID = " & Me.lstShows.Column(0) I have attached a sample. Open the form and click on list box then take a look at the code. This is how you need to reference the listbox. I don't know how you are doing this but this should help...

Hi Greg, sorry to hear that. My only remaining advise would be to remove MS Access completely, reboot, reinstall MS Access and try again. I read somewhere that this might help. Also if you have runtime Access installed then this might also be a cause. Good Luck Dave

2 things. 1. Are you sure that the EventID is the bound Column in the listbox? 2. Do you have single select only on the list box or are you using multi-select? I think the multi- select might be an issue. If you use a break point, can you see what the Event ID is? Finally, are you sure the...

Hi Greg, I've never had this issue before and never connected to Outlook like this. Anyway try creating a new blank Access database, don't do anything but link to an Outlook folder. Does that work? If that works then remove those bottom 3 references in your app (screenshot) and see if...

Hi, It seems to me that the VBA for that Project Task button needs to read the criteria of the Filter Sub-form and then Set the Filter for the Other Project Sub-form. Is that what you are trying to do? Or do you have code in the OnCurrent or OnActivate of the Project sub-form that is supposed to...

I usually use queries for everything that is a datasource/rowsource but the SQL is just as good, just not clean in my mind. That's if you are using the results in a form of somekind, or a control etc. Dave

Hi, I think you need to bind the lstEvents with the EventID. I don't think you intended this to be the EventID? ([ShowName] & " " & Format([StartDate],"mm-yyyy")), which is what I think is happening. Your Listbox box need to be bound to the EventID. i.e. your listbox rowsource should be...

Something like this. Group on the columns you need to group on and then Sum the numbers. SELECT Table1.Retail_Week, Table1.Division, Sum(Table1.Net_QTY) AS SumOfNet_QTY FROM Table1 GROUP BY Table1.Retail_Week, Table1.Division;

Hi Greg, Office 365 can mess things up so maybe try a re-install of Office, or repair Office. So is this when you just try and create the reference link or do you have code that is causing this? Dave

Hi, It looks like your rows are not duplicate as the right column makes them unique. If you intention is to total the last column then you'll need to group on all, the sum that last one. Hope this helps. Dave

I have written VBA code that will upload a document to SharePoint 2010/2013. Then I get the record via ADODB using the document Name and update the metadata. This all working great, however this created 2 revisions as Versioning is on, which is what I need. I would like to know how I can upload...