Qbe
  Home FAQ Contact Sign in
 
 Advanced search
MATCHING GROUPS



more...
POPULAR GROUPS

more...
found 1059 articles for 0.317 sec
"Gabriele Bertolucci" <"info[at]pbsoft[dot]it"> ha scritto nel messaggio news:1jreybgwnrlr5.1o06iy2673our$.dlg@40tude.net... > Qualcuno sa come fare per memorizzare una volta per tutte le dimensioni e > la posizione della finestra del QBE? > > Ogni volta che la apro per creare una query mi appare molto bassa e devo > allargarla in altezza per poterci lavorare decentemente: è veramente > fastidioso     

Group: it.comp.appl.access · Group Profile · Search for Qbe in it.comp.appl.access
Author: Carlo Costarella
Date: Apr 28, 2008 03:47

On 25 Apr, 19:19, Gabriele Bertolucci <"info[at]pbsoft[dot]it"> wrote: Qualcuno sa come fare per memorizzare una volta per tutte le dimensioni e la posizione della finestra del QBE? Ogni volta che la apro per creare una query mi appare molto bassa e devo allargarla in altezza per poterci lavorare decentemente: è veramente fastidioso. Non sò se sia memorizzabile in modo strutturale
Show full article (0.58Kb) · Show article thread
Hi, here a sample code: http://www.mvps.org/access/modules/mdl0014.htm -- Best regards, ___________ Alex Dybenko (MVP) http://accessblog.net http://www.PointLtd.com "Ian Shaw" <IanShaw@discussions.microsoft.com> wrote in message news:ED2ABA9C-D6C3-4E8E-B603-3893798C750E@microsoft.com... > Thanks Mate!! > > > Your code does not have the ability to already exist in the database.     

Group: it.comp.appl.access · Group Profile · Search for Qbe in it.comp.appl.access
Author: Alessandro Baraldi
Date: Apr 28, 2008 03:25

Thanks Mate!! Your code does not have the ability to already exist in the database. I have some code that shall work if the "qrytemp" query already exists but I don't know how to check if the query exists already in the database. The code that i use if the query exists is by using the following code: SET qdftemp = Currentdb.Querydefs("qrytemp") qdftemp.SQL = vsql Docmd.openquery "qrytemp"
Show full article (0.48Kb) · Show article thread
Hi, you can either set some query sql using: currentdb.querydefs("myquery").SQL="Select ..." and then open in using docmd.openquery or make a datasheet form and set this query to it recordsource -- Best regards, ___________ Alex Dybenko (MVP) http://accessblog.net http://www.PointLtd.com "Ian Shaw" <IanShaw@discussions.microsoft.com> wrote in message news:6E154CE9-5AB0-4019     

Group: microsoft.public.access.modulesdaovba · Group Profile · Search for Qbe in microsoft.public.access.modulesdaovba
Author: Alex Dybenko
Date: Apr 26, 2008 22:54

BRILLIANT!! Thanks for the help last time and thanks for the help this time!! Ryan-- PS, thanks, in advance, for the help next time...there will probably be a next time as well... -- RyGuy "Jeanette Cunningham" wrote: Ryan, the general idea is to use 3 double quotes instead of one double quote, one single quote and another double quote Separated for clarity that
Show full article (1.69Kb) · Show article thread
Ryan, the general idea is to use 3 double quotes instead of one double quote, one single quote and another double quote Separated for clarity that is: Use " " " instead of " ' " use """ & Me.lstBroker.ItemData(varItem) & """ instead of '" & Me.lstBroker.ItemData(varItem) & "' Jeanette Cunningham "ryguy7272" <ryguy7272@discussions.microsoft.com> wrote in message news:D870C84A     

Group: microsoft.public.access.modulesdaovba · Group Profile · Search for Qbe in microsoft.public.access.modulesdaovba
Author: Ian Shaw
Date: Apr 25, 2008 20:35

In the QBE Grid, with Like "INT'L" in Criteria, my Query works fine. It fails when I try to create a dynamic Query with this VBA: ' Build criteria string for Broker For Each varItem In Me.lstBroker.ItemsSelected strBroker = strBroker & ",'" & Me.lstBroker.ItemData(varItem) & "'" Next varItem If Len(strBroker) = 0 Then strBroker = "Like " * "" Else strBroker = Right(strBroker, Len(strBroker
Show full article (1.33Kb) · Show article thread
Here's one example: http://support.microsoft.com/kb/290136 -- Ken Snell <MS ACCESS MVP> "Ed Brancheau" <EdBrancheau@discussions.microsoft.com> wrote in message news:BACC5162-B4D4-42F4-9DD1-B5DB1E73B69D@microsoft.com... >I think I understand what you are saying, but I need to see an example of > applying it in a QBE grid in the Total row as we would see GROUP BY, MAX, > MIN     

Group: microsoft.public.access.modulesdaovba · Group Profile · Search for Qbe in microsoft.public.access.modulesdaovba
Author: Alex Dybenko
Date: Apr 25, 2008 01:54

Show full article (0.75Kb) · Show article thread
    

Group: microsoft.public.access.modulesdaovba · Group Profile · Search for Qbe in microsoft.public.access.modulesdaovba
Author: Ian Shaw
Date: Apr 24, 2008 23:19

Show full article (0.30Kb)
    

Group: microsoft.public.access.queries · Group Profile · Search for Qbe in microsoft.public.access.queries
Author: ryguy7272
Date: Apr 23, 2008 22:04

Show full article (1.52Kb) · Show article thread
    

Group: microsoft.public.access.queries · Group Profile · Search for Qbe in microsoft.public.access.queries
Author: Jeanette Cunningham
Date: Apr 23, 2008 15:35

Show full article (1.18Kb) · Show article thread
    

Group: microsoft.public.access.queries · Group Profile · Search for Qbe in microsoft.public.access.queries
Author: ryguy7272
Date: Apr 23, 2008 09:51

Show full article (0.70Kb)
    

Group: microsoft.public.access.queries · Group Profile · Search for Qbe in microsoft.public.access.queries
Author: Ken Snell (MVP)
Date: Apr 14, 2008 18:25

Show full article (0.56Kb) · Show article thread
1 · 2 · 3 · 4 · 5 · 6 · 7 · 8 · 9 · next