Search results

you're welcome @mounty76. If your report contains the fields that your form is filtered by, you can use the form Filter in the Where parameter of OpenReport dim sWhere as string sWhere = me.Filter docmd.OpenReport "myReportName",acViewPreview,,sWhere

ps, @mounty76 adding on, here are a few videos that might be useful for you. You've already gone past some of what's covered in the first video. Create a Grouped Report using the Wizard in Access, then Modify it (16:53) for a lesson on making format better Polish Reports in Microsoft Access...

you're welcome, @mounty76 ~ happy to help

@mounty76 make a query that shows data from all the tables you want in the grouped report. Use the report wizard to make a new report based on that query

you can do that using a grouped report while you can't put a continuous form in the detail section of a continuous form, you can put it in the form header or footer -- I use the form footer

@arianbet3 when you're looking at SQL, you can press: Ctrl-F to Find Ctrl-H to Replace that was added awhile back but not many know about it unless someone tells you ~

you're welcome, @Supertension ~ happy to help

@Auntiejack56 re: nuts and bolts of Excel web add-ins -- this is an old tutorial but as far as I know, the basics haven't changed ... but the user interface has! Maybe this will be helpful never-the-less. Office App Store: JavaScript API Tutorial for Office using Excel (15:16)

thanks, Colin @isladogs @Supertension the Print method doesn't work with Unicode. However, you can specify FontName="Symbol" for "a" to get "α" and "l" to get "λ" Glad you like my reference page ;) I use it a lot too

not just performance, but also accuracy. If a field is a primary key, it should NOT be a floating point number (single or double) because they aren't precise and can't reliably be compared unless you use a tolerance Integers are limited to 32K, so long integer is a better choice for a key...

Thanks for testing, Colin. I agree, not that useful -- but they weren't zip files and I was wondering

thanks for checking, @isladogs My next question was to ask about older version files like DOC, XLS, and PPT (/PPS old PowerPoint Show file -- just rename extension)

with Word, if you save file in RTF (Rich Text Format), does it show ok in the browser control, Colin? @isladogs

creating a real .zip file? It already IS a real zip file ... just doesn't have a ZIP file extension. Depending what you want, you can then open other files that were in the zip -- and I'm assuming this gives us a way to read information from other Office files with JavaScript instead of VBA...

if you change the file extension (DOCX, for instance) to ZIP, you can unzip them ...

that being the case ... wonder if unzipping a Word (/Excel/Ppt) document to get the source files would be at all useful ... maybe @isladogs can test that?

hi @alvesi re: "when I use the look up combo box on the table to select the “name text” it only show me the “id number”" You can fix that by setting the ColumnCount, ColumnWidths, and ListWidth properties Here's a short video to explain it: Combo Box properties in Microsoft Access (11:25)

my understanding is that use of the new web browser control is available publically for forms, with reports coming shortly. To respond to initial question asked by @mohsin ... in case this was missed ... re: "tips or tricks to make it work with local files" Referencing local files is...

hi Isac, you're welcome! wonderful, thanks for letting me now. > similar parameter configuration for a look up on a table? not exactly sure what you're asking ... to reference a column of a combobox value, use =me.controlname.column(#) in ControlSource of another control such as a textbox...

@Avoraightu, considering @The_Doc_Man's comments, it would be good to change the variable name for lngMin and lngMax -- and the declaration statements respectively too (which I think you've already done)