Search results

join us Tuesday 31 October! noon Central time. NOTE: 5pm London time since y'all switched clocks back and we didn't yet ... normally 6pm for Brits (thanks, Colin @isladogs) . All are welcome and it's free. Two free tools that run in Access: (1) List Objects from Access databases and (2) VBA...

AL: Meet new Access PM, Accessibility is for Everyone - Linda Cannon, Tom van Stiphout, Kim Young (57:30)

thanks, @mounty76 I won't have a chance to look for awhile, maybe someone else will jump in!

if the child form is in the footer and you're using LinkMasterFields and LinksChildFields to show the data, it shouldn't matter

@mounty76, could you perhaps post a stripped down version of your database with sample data? And specify steps you want to do?

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 ...