Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 0.17 seconds.
Search: Posts Made By: Ranman256
Forum: Forms Yesterday, 04:58 AM
Replies: 3
Views: 75
Posted By Ranman256
Re: Continuous subform partly scrolls to the right on load / requery (AC2013)

in the subform:
make sure the 1st box selected it on the far left. (tabIndex=0)
make sure the width of the subform is tight with no extra room on the right
you can set the horizontal scroll bar...
Forum: Forms Yesterday, 03:25 AM
Replies: 5
Views: 84
Posted By Ranman256
Re: How to create a unique number for products

There's a field called Autonumber.
Forum: General 12-06-2019, 09:10 AM
Replies: 6
Views: 134
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: 142
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
Views: 98
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: 182
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: 207
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: 523
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: 633
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
Views: 930
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,
Docmd.openreport....
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: 173
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: 121
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
PersonID
FirstN
LastN
ParentsID



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)
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
Views: 191
Posted By Ranman256
Forum: Tables 10-09-2019, 02:45 AM
Replies: 13
Views: 281
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.
Showing results 1 to 25 of 500

 
Forum Jump



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


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
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