Go Back   Access World Forums > Search Forums

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
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?
add new values to a different table? (combo has only 1 value)
Forum: Macros 12-02-2019, 03:24 AM
Replies: 5
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
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
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
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
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
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
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
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
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:

Addresses, shipto, mailto
prod line,...
Forum: The Watercooler 11-07-2019, 09:31 AM
Replies: 51
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
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,
Forum: Modules & VBA 11-05-2019, 03:48 AM
Replies: 1
Views: 139
Posted By Ranman256
Forum: General 11-01-2019, 02:39 AM
Replies: 3
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
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
Views: 132
Posted By Ranman256
Forum: Queries 10-24-2019, 10:56 PM
Replies: 4
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
Views: 169
Posted By Ranman256
Re: Family tree

I use:
tPerson table

tParents table:
Forum: General 10-16-2019, 08:16 AM
Replies: 4
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
Views: 176
Posted By Ranman256
Re: Davg in report group footer

in the report, add a GROUP band (for what ever group you need)
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
Views: 191
Posted By Ranman256
Forum: Tables 10-09-2019, 02:45 AM
Replies: 13
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
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
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

Forum Jump

All times are GMT -8. The time now is 04:04 PM.

Microsoft Access Help
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post

Sponsored Links

Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World