vba - Access: Setting a source object to another source object path -

-

i'm trying crazy again. use line of code:

reports![prntrep].sourceobject = forms![search form]!subform1.sourceobject

the source object of subform1 dynamically depending on query need search. want source of report set same query, don't need make bunch of different reports. throws error 2465, application defined or object defined error.

a report not have sourceobject property. reason access throws error #2465, "application-defined or object-defined error" when attempt reference it.

here immediate window example system:

' first demonstrate report accessible ... debug.print reports!rptfoo.name rptfoo  ' when referencing sourceobject ... debug.print reports!rptfoo.sourceobject ' <-- error 2465

perhaps want alter report's recordsource instead:

' current recordsource ... debug.print reports!rptfoo.recordsource select rmy.id, rmy.reportdate, rmy.gainorloss record_matyields rmy; ' change recordsource saved query ... reports!rptfoo.recordsource = "qrybar" ' confirm recordsource altered ... debug.print reports!rptfoo.recordsource qrybar

the report displayed 6 rows original recordsource. saved query includes where condition limits results 2 of rows. altering recordsource above caused report display 2 rows without forcing report design mode, unlike macro approach mentioned in comment.

unfortunately don't know enough macros fix yours. avoid macros.


Comments

Post a Comment

Popular posts from this blog

javascript - gulp-nodemon - nodejs restart after file change - Error: listen EADDRINUSE events.js:85 -

-
i'm running nodejs 0.12.3 - gulp 3.10.8 , gulp-nodemon 2.0.3. gulpfile.js : gulp.task('serve', ['build'], function() { gulp.start('fb-flo'); nodemon({ script: paths.server, env: { 'node_env': 'development' }, // env: { 'node_env': 'production' }, execmap: { 'js': 'node_modules/babel/bin/babel-node --stage 1' //es7 cote server }, delay: '0ms', watch: ['src/shared/', 'src/server/'], ignore: ['src/shared/components'], tasks: function (changedfiles) { var tasks = []; changedfiles.foreach(function (file) { if (path.extname(file) === '.jsx' && !~tasks.indexof('bundlejs')) tasks.push('bundlejs'); if (path.extname(file) === '.less' && !~tasks.indexof('compileless')) tasks.push('compileless'); }); return tasks; } ...
Read more

Fatal Python error: Py_Initialize: unable to load the file system codec. ImportError: No module named 'encodings' -

-
i trying make simple python program opening list of webpages user manually download reports site. don't have previous experience preparing exe files.. , i'm in learning process python coding. of done on windows 7 x64 this python code: #!c:/python34/python.exe -u splinter import * import time import os import csv #---------------------------------- raporty = [] open('../raporty.csv', newline='') csvfile: contents = csv.reader(csvfile, delimiter=' ', quotechar='|') row in contents: r = ', '.join(row) r = r.replace(',','') raporty.append(r) #--not implemented yet zmienne = [] open('../zmienne.csv', newline='') csvfile: contents = csv.reader(csvfile, delimiter=' ', quotechar='|') row in contents: r = ', '.join(row) r = r.replace(',','') zmienne.append(r) print("start") browser = browser(...
Read more

javascript - oscilloscope of speaker input stops rendering after a few seconds -

-
the following script reads audio user's microphone , renders oscilloscope on html canvas. the source taken example of mozilla developer network: visualizations web audio api and here fiddle: http://jsfiddle.net/b7j8pktp/ mozgetusermedia (note: code has no fork mechanism different browsers: works firefox) it works fine few seconds , stops rendering. whereas works totally stable: http://mdn.github.io/voice-change-o-matic/ the problem can reduced following code. microphone activation icon (next the address bar in firefox) disappears after 5 seconds: navigator.mozgetusermedia({audio: true}, function() {}, function() {} ); ( http://jsfiddle.net/b7j8pktp/2/ ) this known bug in firefox. take stream getusermedia call , hook window so: navigator.mozgetusermedia({audio: true}, function(stream) { window.stream = stream; // rest of code }, function err() { // handle error }); hopefully can fixed soon. problem we're f...
Read more