Fermé

need help with ms access database!

i have an access form/switchboard that opens a report. the

switchboard buttons open the same report but changes the

query that the report is based on so the results are a bit

different depending on which button was pushed.

if the form is already open and i hit another button, it

doesn't refresh the report using the new query. i guess it

sees it's already open so it doesn't continue.

vba code to open report is:

[login to view URL] "rptProject", acPreview

is there a way to have a report refresh/update itself if

it's already open?

Compétences : Programmation de bases de données, Excel, Microsoft Access, Visual Basic, Visual Basic pour les apps

en voir plus : access database help, need script load access database, need help database words, microsoft access 2016 help, microsoft access tutorial, microsoft access 2013 help, microsoft access 2010 help, microsoft access help phone number, ms access help, microsoft access tips and tricks, microsoft access help forum, sql, database development, database programming, microsoft access, visual basic for apps, help access student database, need access database law office, access ms access database manually, attendance ms access database

Concernant l'employeur :
( 0 commentaires ) United States

Nº du projet : #17397111

22 freelance font une offre moyenne de $29 pour ce travail

schoudhary1553

Hello Sir, I have reviewed your job details and I am sure i can deliver you the job with you satisfaction. Relevant Skills and Experience I have more than 5 year of experience in Database Programming, Excel, Micros Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(259 Commentaires)
7.5
Prashantskin

i will put code behind report to update itself Relevant Skills and Experience i have got 12 years of experience in microsoft access. i have developed 500 projects Proposed Milestones $25 USD - final version piease s Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(516 Commentaires)
7.2
%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(175 Commentaires)
6.9
branislavm

Hi! The answer is - no. The report is not like a form to have it just refreshed, it performs various things when opens, amongst them, is formatting to decide what goes where on the page. Relevant Skills and Experience Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(201 Commentaires)
6.9
%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(88 Commentaires)
7.3
paris2785

Hi. Yes, there is a quick and easy way to refresh your data. I can add the necessary code to implement this. Relevant Skills and Experience I'm an experienced and skilled Access developer. Feel free to visit my portfo Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 0 jours
(186 Commentaires)
6.9
VladimirLilenko

I am ready to carry out your project in the reasonable price and in the shortest possible time and with the highest quality! Relevant Skills and Experience Microsoft Access, SQL, vba Proposed Milestones $30 USD - Pro Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(104 Commentaires)
6.1
royalcalif

Let me review the database. I have fixed the issue then you can award me if you satisfied. Relevant Skills and Experience Ship Fuel Oil & Water Consumption Management System [login to view URL] Email sending Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(89 Commentaires)
5.9
zu02

yes here is a ways to code that - simply I've to view your db Relevant Skills and Experience vba/sql/ado Proposed Milestones $30 USD - def

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(52 Commentaires)
6.2
%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(59 Commentaires)
5.8
alaeddindhahri

Hi, I read your description and the simplest way to do so is by closing the report if it is open and reopening it. Relevant Skills and Experience vba Proposed Milestones $30 USD - default

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(63 Commentaires)
5.6
archanaoswal

I can fix the issue that you are facing with the opening of the report Relevant Skills and Experience I have excellent command on MS Access VBA and have completed many complex projects before Proposed Milestones $30 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(54 Commentaires)
5.5
%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(29 Commentaires)
5.9
dvcontact

Hi, I have read very carefully your project details about creating a VBA code that will refresh/update reports. I am absolutely sure that I can complete this project professionally. Relevant Skills and Experience Rath Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(30 Commentaires)
5.4
prabakarm23

I have 8 years of experience in .NET, VBA Macros, VB script,PS Script and VB creation with application like SAP, Internet explorer, Microsoft Outlook,PDF& Text files, MS Access and SQL Server Relevant Skills and Exper Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(59 Commentaires)
4.9
%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(26 Commentaires)
4.9
Cupilo

Of course. There are several ways to do this. Select me and I will help you immediately. Relevant Skills and Experience I have a lot of experience in the field. I have more than 500 hours in training, certifying and l Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(2 Commentaires)
4.1
%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(4 Commentaires)
2.5
suchita29a

Hello, I have seen the posting and am interested in doing it. I recently worked on exactly similar problem 2 weeks ago and have a solution for it. Thanks, Suchita Relevant Skills and Experience I have over 10 years Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(2 Commentaires)
0.9
MariaRaafat

I have done this task many times before, kindly check my portfolio ! hello there, I am interested in your data entry project, i can deliver it in just few hours ASAP , hope to contact you soon ! Stay tuned, I'm stil Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(1 Évaluation)
0.0