Here is my problem
Thre is an app (ERP) running with sql server, connected with several sites.
I want to give the users the ability to look at tables in the database without updating rights, and I think Access ùay be a good solution for this, with runtime and menus giving read-only forms.
For...
eg find first Tuesday in a month, or find last friday in a month...
I wrote a FAQ about this
http://www.tek-tips.com/faqs.cfm?spid=183&sfid=5074
--------------------------------------------------
Django [thumbsup]
bug exterminator
tips'n tricks addict
I usually use CR 9 on an SQL Server Database.
But I have to do a report to compare to tables, one in the SQL Server Database, and one in an Oracle Database.
Is it possible and How?
Thank's in advance !
--------------------------------------------------
Django [thumbsup]
bug exterminator...
it's unclear for me if convert function is used from datetime to string only or also the opposite way.
Can anyone help me
Thank's inadvance
--------------------------------------------------
Django [thumbsup]
bug exterminator
tips'n tricks addict
I've just installed mysql 4.1 on WinXP + easyPHP and I tried a few queries.
When I use variables, it looks like mysql don't update them
eg
set @carr='test';
select codeArt,artDesc,@carr myVar
from articles where 1;
the myVar column is empty...
one problem in cosmetic industry (and I think in chemicals also) is to be sure, if there is a change in the formula of Bulk (BOM), that production is knowing if the manufacturing order to make the bulk is different from the BOM the R&D has modified.
Maybe there is an OK to do this but maybe not...
suppose you have 2 tables A and B with a join on A.Id and B.A_Id.
A.Id is indexed and not B.A_Id
what is is most efficient?
1 -
select A.Id
from
A
left join
B
on A.Id=B.A_Id
2 -
select A.Id
from
B
right join
A
on B.A_Id=A.Id
I Think solution 2 is best, is it right?
django
bug exterminator...
In another post I put this information that may be usefull for all f us :
--------------
it's a good pratice for queries to put the fields alone and the operations on the other side (left).
so I modifed
{youth_goal.dt_set} + 365 < CurrentDate
to
{youth_goal.dt_set} < CurrentDate - 365
Here...
when you click in a comboBox the text is not selected even if in the
event onClick you write the following code which works with a textBox:
(cBox is the name of the comboBox)
cBox.SelStart = 0
cBox.SelLength = Len(cBox.Text)
It looks like Access is sending an event after the onclick...
CR9:
You have a lot of formatting ways in CR via the format formulas, but if you want to change afterwards your "Bold" to "Italic" (for instance) you have to go through all the places in the report.
One way is to make a formula and put it (hidden) in the report header to...
Is it possible to have with sql a query that select a list of records and use it as a part of a report.
I tried with the "command" in database expert but it's very slow on a simple query and when i try to add tables the sql view seems to show only the table and not the complete sql...
CR 9
The problem :
the subreport list a certain number of lines depending of the item of the group in main report.
If the number of lines is small no problem the items and detailed subreports follow each other items after items, changing of pages when full , but when the size of the subreport is...
I'm a newbie in CR!
Main Report :
for each item which has customer orders
detail qty of customer orders
ItemXXX
order o1 qty q
order o2 qty q2 ...
Subreport
detail of inventory (qty location)
ItemXXX
loc1 qty qInv1
loc2 qty qInv2 ...
How can I print only the Items where total inventory <...
I checked for the group footer in my report to have a new page after, but the problem is that I get a blank page after the last group of the report.
How can I suppress it?
Thanks in advance
TektipDjango
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.