need help with ms access database!

Closed Posted 5 years ago Paid on delivery
Closed Paid on delivery

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?

Database Programming Excel Microsoft Access Visual Basic Visual Basic for Apps

Project ID: #17397111

About the project

21 proposals Remote project Active 5 years ago

21 freelancers are bidding on average $30 for this job

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 More

$50 USD in 1 day
(323 Reviews)
7.9
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 More

$30 USD in 0 days
(264 Reviews)
7.5
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 More

$15 USD in 1 day
(236 Reviews)
7.4
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 More

$25 USD in 1 day
(516 Reviews)
7.2
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 More

$30 USD in 1 day
(161 Reviews)
6.6
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 More

$30 USD in 1 day
(48 Reviews)
6.3
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

$30 USD in 10 days
(73 Reviews)
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

$30 USD in 1 day
(53 Reviews)
6.2
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 More

$30 USD in 1 day
(90 Reviews)
6.0
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 More

$25 USD in 2 days
(59 Reviews)
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 More

$23 USD in 10 days
(3 Reviews)
4.1
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 More

$10 USD in 1 day
(1 Review)
0.0
prithwirajdtj

There is an existing VBA app that connects to Access DB. Need to enhance/fix it so that same form can be used for running query more than once. Relevant Skills and Experience I am a highly experienced Excel VBA, Acces More

$30 USD in 3 days
(0 Reviews)
0.0