Access World Forums > Search Forums Search Results

User Name Remember Me? Password

Page 1 of 20 1 2 3 11 > Last »

Showing results 1 to 25 of 500 Search took 0.14 seconds. Search: Posts Made By: Ranman256

Forum: General 12-06-2019, 09:10 AM

Replies: 6 Problem with Access with Windows Server 2019 Views: 129 Posted By Ranman256 Re: Problem with Access with Windows Server 2019 there's a bug. A Microsoft Office update could make the db unusable. we had to do a rollback and it worked. check online.

Forum: Forms 12-04-2019, 12:57 AM

Replies: 10 [SOLVED] Which Event? Views: 141 Posted By Ranman256 Re: Which Event? I don't follow, you want to pick a value in a combo, then use the event to add more values to the combo? or add new values to a different table? (combo has only 1 value)

Forum: Macros 12-02-2019, 03:24 AM

Replies: 5 Macron for a yes/no box Views: 92 Posted By Ranman256 Re: Macron for a yes/no box Yes/no cannot be empty. Not checked= no.

Forum: Modules & VBA 11-27-2019, 09:21 AM

Replies: 4 parsing quotation literals in code Views: 146 Posted By Ranman256 Re: parsing quotation literals in code I find the quadruple quotes confusing and hard to read, so I too, use single quotes. But not for people names since : O'Malley, and the like will crash it. so for that I have a global constant: ...

Forum: Tables 11-27-2019, 04:58 AM

Replies: 11 File location Views: 173 Posted By Ranman256 Re: File location correct , do not use drive letters. use the server UNC path: \\server\folder\folder\ I keep it in a tConfig table, in case it has to change. (from the programmers bible: do not hardcode)

Forum: Reports 11-26-2019, 03:15 AM

Replies: 8 Fitting 2 records on 1 print preview page Views: 193 Posted By Ranman256 Re: Fitting 2 records on 1 print preview page shrink the page layout to 2 can fit. You may not get it to if it has a lot of data.

Forum: General 11-18-2019, 09:21 AM

Replies: 12 Not-able-to-print puzzle Views: 267 Posted By Ranman256 Re: Not-able-to-print puzzle this can happen if: a form has lots of subforms in it, a query has lots of tables and subqueries in it. (your memory available be damned) 1.try to simplify the queries 2.on forms, instead...

Forum: Queries 11-15-2019, 09:27 AM

Replies: 42 User Defined Function in SQL Select Views: 519 Posted By Ranman256 Re: User Defined Function in SQL Select in a query ,you can call a field on a form by using the full path: select forms!myForm!txtSalePrice from table

Forum: Forms 11-15-2019, 03:10 AM

Replies: 11 [SOLVED] linking sub forms Views: 215 Posted By Ranman256 Re: linking sub forms you normally to Parent as master and children as children(ha) you may need 3 subforms: for the Parents record with ParentsID, FatherID, MotherID in the master 1 subform to show name of fatherID...

Forum: Queries 11-11-2019, 03:38 AM

Replies: 10 Combining two rows into one.. Views: 211 Posted By Ranman256 Re: Combining two rows into one.. Run a Crosstab query on the group key to make all 1 persons records side by side To a table, then run a query on that table to concat the row fields.

Forum: Tables 11-08-2019, 09:29 AM

Replies: 34 Table Design & Relationships Views: 617 Posted By Ranman256 Re: Table Design & Relationships you can breakup the 1 table into its relative components. run some make table queries from the source table to create the new tables and atomic values: POs, Addresses, shipto, mailto prod line,...

Forum: The Watercooler 11-07-2019, 09:31 AM

Replies: 51 Is OOP actually useful? Views: 921 Posted By Ranman256 Re: Is OOP actually useful? people want to point & click. nobody wants the old days of typing out command lines.

Forum: Forms 11-06-2019, 03:46 AM

Replies: 3 Sub Report in a Form Views: 128 Posted By Ranman256 Re: Sub Report in a Form Sub forms go in forms. Sub reports go in reports. You can open a report to show the same data as the form, Open the report using the where clause, Docmd.openreport....

Forum: Modules & VBA 11-05-2019, 03:48 AM

Replies: 1 Is there a faster alternative to a for-if loop in VBA? Views: 139 Posted By Ranman256 Re: Is there a faster alternative to a for-if loop in VBA? Paste in bulk,or copyfromrecordset.

Forum: General 11-01-2019, 02:39 AM

Replies: 3 Create DDL from existing tables Views: 171 Posted By Ranman256 Re: Create DDL from existing tables You can just ship both the FE and Backend (as access db). Then they just relink and they go. If they have a SQL server, they swap out the access tbl for the SQL.

Forum: Tables 10-31-2019, 10:06 AM

Replies: 3 (-7713) Reserved Error when trying to link??? Views: 151 Posted By Ranman256 Re: (-7713) Reserved Error when trying to link??? I'm guessing it doesn't like your driver. any more up-2-date drivers available?

Forum: General 10-30-2019, 02:27 AM

Replies: 5 Exporting Query with linked subdata in same format Views: 132 Posted By Ranman256 Re: Exporting Query with linked subdata in same format Access just exports the data.

Forum: Queries 10-24-2019, 10:56 PM

Replies: 4 Append data from unbound fields Views: 117 Posted By Ranman256 Re: Append data from unbound fields put in the full path for the update value, update table set [status] = forms!myForm!txtBox

Forum: Queries 10-24-2019, 02:11 PM

Replies: 8 Family tree Views: 169 Posted By Ranman256 Re: Family tree I use: tPerson table PersonID FirstN LastN ParentsID tParents table:

Forum: General 10-16-2019, 08:16 AM

Replies: 4 Question Validating a field based on the selection of another field Views: 97 Posted By Ranman256 Re: Validating a field based on the selection of another field answered at: https://www.accessforums.net/showthread.php?t=78555

Forum: Reports 10-15-2019, 12:42 PM

Replies: 6 Davg in report group footer Views: 176 Posted By Ranman256 Re: Davg in report group footer in the report, add a GROUP band (for what ever group you need) set it WITH FOOTER in the footer , put your AVG( field). (you don't need DAVG, but you can)

Forum: Macros 10-15-2019, 08:11 AM

Replies: 8 How much of a performance impact does declaring variables / passing arguments have? Views: 191 Posted By Ranman256 Re: How much of a performance impact does declaring variables / passing arguments hav in nanoseconds, none. all slowdown is file I/O.

Forum: Tables 10-09-2019, 02:45 AM

Replies: 13 How to find a textbox that I have no idea existed Views: 280 Posted By Ranman256 Re: How to find a textbox that I have no idea existed In form properties, At the top of the property window is a drop box that has all textboxes listed. Select yours and it will highlight on the form. Also check the query.

Forum: Forms 10-08-2019, 02:46 AM

Replies: 6 automatic data set creation Views: 203 Posted By Ranman256 Re: automatic data set creation Make an append query to add the recs to ALL. In the query ,bring in Students,and Tests and their dates. Do not join the tables. Run append.

Forum: Modules & VBA 10-03-2019, 02:39 AM

Replies: 5 Define a non-continuos excel range with unknown amount of rows from aceess Views: 147 Posted By Ranman256 Re: Define a non-continuos excel range with unknown amount of rows from aceess Can you just link the XL file as an external table, Then run a query to import the items you want?

Showing results 1 to 25 of 500

Page 1 of 20 1 2 3 11 > Last »

Forum Jump User Control Panel Private Messages Subscriptions Who's Online Search Forums Forums Home Access World     Access World News     Site Suggestions     Introduce Yourself     The Watercooler Microsoft Access Discussion     General     Tables     Queries     Forms     Reports     Macros     Modules & VBA     Theory and practice of database design     Access Web Microsoft Access Reference     Access FAQs     Code Repository     Sample Databases     Microsoft Access Tutorials     Microsoft Access User Groups Apps and Windows     SQL Server     Crystal Reports     Visual Basic     VB.NET     Word     Excel     Web Design and Development         ASP and ASP.NET         PHP & MySQL     Windows     Other Software     Hardware Questions and Answers Non-Access Issues     Politics & Current Events     Debates     Gaming     Sports, Health & Fitness     Gadgets     Small Business