forms and reports display blank while loaded

Question

I use NavigationButton in the main forms . And when then main form loaded. some sub form and report are blank. it's very  strange.  there are 2 forms and 1 reports. here are 3 different pc. named frmA   frmB   rep1 

1、 VPC  Not install access， I installed the access runtime 2010 ,accessrtsp2010-kb2687444-fullfile-x86-zh-cn， AccessDatabaseEngine，access2010-kb3055045-fullfile-x86-glb, mso2010-kb3114750-fullfile-x86-glb   when runing the accdb file frmA load OK   frmB blank   all report blank

2、A real PC  that not install access, and also just installed the runtime. and when loaded  the frmA is blank;  the frmB is ok, and all repots ok.  this pc has beed installed office 2016 and frmA has been load ok before, but now is blank,  the different is delete all fields datacontrls binding and change it to update using sql , and using ado object not dao object.

3、A real pc  install office 2010 and runtime 2010  and all forms and reports is loaded ok.

I has been check that the tables is not empty， can read and write。 I don't know why  and without  any message. 

 

Answer 1

Hi ltshine,

you had mentioned that on your development machine (that is mentioned in point 3) you had installed Office 2010 and runtime 2010.

if you had install Office then you not need to install runtime.

other then that , you can try to debug the code on your development machine and check what code get executed when you open the report or form.

so that if there is something wrong then you can come to know about it.

also checked that your database is not corrupted.

you can try to use compact and repair option and then again try to make a test.

first try to open it use Office on which machine Office is available to confirm that it is working correctly with office.

then try to open with Access Run Time.

if possible then try to post your database with dummy data in it.

we will try to make a test with your database to see the result.

to get some more information , you can also try to refer link below.

Basics for Building Access 2007 Runtime-Based Solutions

Regards

deepak

---

MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact [e-mail].

Answer 2

I let the blank form (frmA) load first and there are some err message. the function date()  could not run in the sql query statment : AcceptCarriage.timeremain - DateDiff('d',cdt,date())  I replace it  into '2017-10-20' and it runs ok . so that is a reason. in the new pc ,after install access runtime and still could not run function.  what is the name of the component  with this function include in. and where can i download it ?   it is the base vba component?  or dao ? ado ?  how to check the relationship when deploy the application . how to packed it up?

 

Answer 3

Hi ltshine,

you do not need to add any reference to run this function.

DateDiff('d',cdt,date()) 

I can see that you are passing cdt as a date.

so I suggest you to check whether it is passing the date correctly in cdt.

you can also try to pass date manually in DateDiff function and try to run it.

if it run without any issue then it is possible that there is some issue with cdt.

here , I don't know that how you assign the date value to cdt.

if you post the code then I can try to check it and try to find the issue in it.

so first , you can try to check it if you find something incorrect then try to correct it.

if you are not able to find the issue then post your code here.

we will try to check it and try to provide you a solution.

Regards

Deepak

---

MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact [e-mail].

Answer 4

Hi ltshine,

is your issue is solved now?

I find that you did not done follow up after my last suggestion.

so if your issue is solve then I suggest you to post the solution and mark it as an answer.

if your issue is still pending then I suggest you to refer the suggestions given by community members.

it may help you to solve your issue.

if then also you have any further question then let us know about that.

We will try to provide further suggestions to solve the issue.

thanks for your understanding.

Regards

Deepak

---

MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact [e-mail].