Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
combo's latest activity
-
combo replied to the thread Query expression negative to a 0.I agree that UDF is the best tool to structure conditions. For simple calculations I frequently use: Function Max2(Val1 As Double, Val2...
-
combo replied to the thread Convert PDF file to text.In Word VBA: Sub test() Dim wdDoc As Document Application.DisplayAlerts = wdAlertsNone Set wdDoc =...
-
combo replied to the thread Printer.Print to PDF.Using Office VBA code makes sense in case of automating one of Office applications. They use internal configurable converters for...
-
combo replied to the thread Power Query Split by Table Group by Rows into a new set of group by tables.You can add subindex to each 'Face List Table' tables, expand, split subindex to GroupID, group again using GroupID (if grouping is...
-
combo replied to the thread Problem with Excel pasting into filtered cells.It's just an Excel feature, hidden rows have still data and can be referenced in other cells. It seems that Excel copies visible cells...
-
combo replied to the thread SQL data types in CREATE/ALTER TABLE queries.Thanks, it seems that there is a total mess here. I tested some types, my observations: Access will not save query with not recognized...
-
combo posted the thread SQL data types in CREATE/ALTER TABLE queries in Microsoft: Access Queries and JET SQL.I found a list a list of Access SQL data types from MS here. However, this article refers to Access 2013. In the meantime Access...
-
combo replied to the thread Calculate amt due.With a layout as in the workbook, IMHO the only way is to manually arrange output. If it is possible to rearrange data, I would use...
-
combo replied to the thread Open Word as ReadOnly.Actually, Word may repaginate document for different printer, update fields or styles. NB, read-only document can be changed, next...
