Query in code not working
  Home FAQ Contact Sign in
 
 Advanced search
MATCHING GROUPS



more...
POPULAR GROUPS

more...
found 13561 articles for 0.666 sec
Re: query in macro not working     

Group: microsoft.public.access · Group Profile · Search for Query in code not working in microsoft.public.access
Author: John Spencer
Date: Aug 26, 2008 15:39

... qryAppendNewEmail (View: SQL from the menu). Perhaps there is something in the query that is causing the problem when it is not run directly ... reason, the second to the last query (qryAppendNewEmail) that's supposed to run in the macro doesn't work. Warnings are set to...experienced this before? Some time ago, I converted some macros to code with a built in tool. Does anyone know ...
Show full article (1.30Kb) · Show article thread
Re: query in macro not working     

Group: microsoft.public.access · Group Profile · Search for Query in code not working in microsoft.public.access
Author: Allen Browne
Date: Aug 26, 2008 15:29

... turn SetWarnings off.) A better solution is to use Exeute in code. You don't need to turn SetWarnings off, and you can be notified if it fails ... reason, the second to the last query (qryAppendNewEmail) that's supposed to run in the macro doesn't work. Warnings are set ...experienced this before? Some time ago, I converted some macros to code with a built in tool. Does anyone know ...
Show full article (1.67Kb) · Show article thread
query in macro not working     

Group: microsoft.public.access · Group Profile · Search for Query in code not working in microsoft.public.access
Author: WPW07
Date: Aug 26, 2008 14:14

..., and update). For some reason, the second to the last query (qryAppendNewEmail) that's supposed to run in the macro doesn't work. Warnings are set to no on the first macro line. All the others seem to ...it runs fine. Has anyone experienced this before? Some time ago, I converted some macros to code with a built in tool. Does anyone know what that is, and do ...
Show full article (0.64Kb)
Re: Need Help - How to do a "make table query" by code     

Group: microsoft.public.access.modulesdaovba · Group Profile · Search for Query in code not working in microsoft.public.access.modulesdaovba
Author: FatMan
Date: Aug 20, 2008 14:18

... to our Stock Take Database. This has been a project that I have been working on and constantly trying to improve now for about four years.... to my table used to capture the count. Since their code APPENDS the data to their table there is a chance for duplication... different things... use code and the query grid. Why not give us a bit...
Show full article (8.61Kb) · Show article thread
Re: cfquery group = not working with date     

Group: macromedia.coldfusion.getting_started · Group Profile · Search for Query in code not working in macromedia.coldfusion.getting_started
Author: ChiTownJohnnyB
Date: Jul 23, 2008 16:21

... Bob Dobbs suggested. Here's a copy 'n paste of that bit of code: <cfoutput query="qryWIRDate" group="OutageDate"> <P></P> #...cfoutput> The data from the message from 7/22 4:39 is the recordset that I get from the query. I posted that to show that the date conversion is working ... date/time field. I just ran the report again, double checking and the grouping is still not working.
Show full article (1.07Kb) · Show article thread
Re: Simple queries not working     

Group: comp.softsys.sas · Group Profile · Search for Query in code not working in comp.softsys.sas
Author: Hari Nath
Date: Jul 9, 2008 18:26

... of "dft_ind" mostly are either "1" or black. I got thrown off when I query it by using SQL and data step. I just don't understand why code 2, 3 and 4 did not... 0 rows and 2 columns.*/ /*~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Data Step: ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~*/ /*Code 4: Not Working*/ data test2; set AZ....
Show full article (2.57Kb)
Re: Simple queries not working     

Group: comp.softsys.sas · Group Profile · Search for Query in code not working in comp.softsys.sas
Author: Hari Nath
Date: Jul 9, 2008 18:23

...dft_ind" mostly are either "1" or black. I got thrown off when I query it by using SQL and data step. I just... and dft_ind="1"; quit; /*OTE: Table WORK.TEST1 created, with 48 rows and 2 ... and 2 columns.*/ /*~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Data Step: ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~*/ /*Code 4: Not Working*/ data test2; set...
Show full article (2.36Kb)
Simple queries not working     

Group: comp.softsys.sas · Group Profile · Search for Query in code not working in comp.softsys.sas
Author: yingtao
Date: Jul 9, 2008 17:52

...The value of "dft_ind" mostly are either "1" or black. I got thrown off when I query it by using SQL and data step. I just don't understand why code 2, 3 and 4 ..., with 0 rows and 2 columns.*/ /*~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Data Step: ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~*/ /*Code 4: Not Working*/ data test2; set AZ.Loan (keep=...
Show full article (2.06Kb)
RE: Msgbox code stops working in report     

Group: microsoft.public.access.modulesdaovba · Group Profile · Search for Query in code not working in microsoft.public.access.modulesdaovba
Author: HelenM
Date: Jun 25, 2008 12:28

... just redid the whole thing, just to check and it's still not working. I don't get it lol, coz I know ...three dots on the right of the on close row and select code builder and just write onclose (this is to call ..." wrote: I'm using a report based on a parameter query, and I'm trying to bring up a message box when the report ...
Show full article (3.93Kb) · Show article thread
Re: Trim not working     

Group: microsoft.public.access · Group Profile · Search for Query in code not working in microsoft.public.access
Author: BruceM
Date: Jun 18, 2008 20:32

...fields. If you are working with imported data that you are not storing, it would probably be best to use a query to parse the data into the three fields. "Schwimms" <Schwimms@discussions.microsoft.com> wrote ...>> RYAN W FREITAS DAN G GODBY I tried using the trim function but it is not working...Any suggestions.
Show full article (1.19Kb) · Show article thread
1 · 2 · 3 · 4 · 5 · 6 · 7 · 8 · 9 · next