Search results

Thanks Guys! Found the bad news. Way to screw something that works and useful. Any how, is there an option other than taking out to excel then importing the excel pivot back?

Help! Pivot Table Screwed on 2013 (SOLVED) We recently got upgraded from office 2007 to office 2013. With that said, most of the database that we built were from the 2007; other functions remain ok expert for the pivot charts. We have a form that contains a subform which contains a pivot chart...

you are awesome!!! that fixed the issue....

Trying to create a code that will search a word contained in a field... see code below: What am I missing? It returns blank. ' If Name If Nz(Me.Mname) <> "" Then 'Add it to the predicate - exact match strWhere = strWhere & " AND " & "USERS.USER_NAME LIKE ' * " &...

Browse for Excel file to import into Access table I want a user to click a button, have the file open dialog open, they select a spreadsheet, and then it imports into a table. The problem is the filename can be different every time. The table name will remain constant. Here is the...

Thanks JHB..... I saw what's wrong. It pays to get up, drink coffee and revisit items after a few minutes. :banghead: Merry Christmas!

What am I missing? I get both 1 and 2 to work. However, the 3rd combo with the red rowsource does not give me values. 1st RowSource: SELECT T_En.En, T_En.ID FROM T_En; 1st AfterUpdate: Private Sub Hos_AfterUpdate() Me.U1.Requery End Sub...

Thanks Pat. Will try that out.

I have a split form, mainform on top set to "data entry = Yes" and subform set to "data entry = no". however, they both display blank on load. Is there a way to set it where the maintop form opens blank with the subform displaying data? Thanks again.

Thank you again. Formated output worked. I am really glad I found this site... More power and ofcourse... big thanks to the experts, admins and mods.

Thanks for the Reply SuperBob. It still doesn't quite do it. Maybe a little background. I have a report thats passess through a filter... by clicking the menu button "ExportExcel", the filtered report is exported to excel and only exports the filtered values. Now that I took out the ribbon...

Good PM Access World, Just wondering if there is a way to put the Export to Excel Spreadsheet (ExportExcel) menu button onto a form. say "DoCmd.ExportExcel" kind of thing. --- I had created a ribbon that will hide the menu bar, office button and QAT... I want the ExportExcel function to...

SuperBob and DCrake - thank you for the reply as always. Yes. i just had to remove the [Project] as they are on the same record source. Solution worked perfectly.

Yes. it works very well. The only thing is, I cant isolate it to the ProjectInit = Yes

I am trying to get a total time for a project but only for those that have "YES" value on ProjectInit Can someone help fix the code? Thank you =Fix(Sum([TotalProjectTime])/86400) & " Days, " & Format(Sum([TotalProjectTime])/86400,"hh:nn:ss") WHERE Project.ProjectInit='Yes'

Hello Big Resource, I am trying to customize a ribbon for a database to only show the icons and functions for Paste, ExportExcel and FileSaveAs. The code below shows that... however, when i apply that code, it does not hide/disable all the icons. If i value startFromScratch to true it gives...

I would use a list box rather than a combo box. And Yes, Report is only output not entry. Use a form to pull a report.

vbaInet, You were right all along... the datediff was the problem. had to revise everything. Its all OK now. Thanks for the great help.

Thanks.... but its giving the wrong total.

So, redid the whole thing and now i get seconds on query. so when I do =Sum([TotalInspectTime]) - i get total in seconds... how do i get this back to dd:hh:nn:ss format. tried this but it does not work. Do you know of any other way? =Sum([TotalTestTime]\86400,"dd:hh:nn:ss") Thanks again.