need help with ms access database!
$10-30 USD
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?
Project ID: #17397111
About the project
21 freelancers are bidding on average $30 for this job
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
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
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
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
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
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
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
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
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
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