Problem opening form- program

[bigbatica]

Hi,I have accd and mde packed app. All of tables, querys, reports, forms are openable. And VBA also. Problem starts when I put the user name and pass, access showed me the main page of the program and shuts down. I bring the accd and mde from office (my company). What shoud I do? Thank you

 

[theDBguy]

Do you also have the original accdb and mdb files?

 

[bigbatica]

I think so

 

[theDBguy]

I think so

Do they still work?

 

[Pat Hartman]

Can you open the .accdb on your home computer? If so, the issue may be that you have 32-bit Office installed on one PC but 64-bit installed on the other and the .accde/.mde files are not interchangeable. The compiled database MUST be run by a version of Access of the same bit-ness as the one that created the .accde/.mde

 

[bigbatica]

my pc runs x64, but I installed office 2007 x86. And I know that. I can open .accdb and .mde

 

[azhar2006]

Did you create this database? Or did someone else create it? It may be protected by the motherboard or BIOS number. If you can, attach a copy of it here.

 

[arnelgp]

mde/accde can only run on the bitness they are created.

 

[Gasman]

I think so

You had better hope so.

 

[bigbatica]

I am gonna copy from database what I need. But its another problem. What do to?
Thank you

 

[Gasman]

What are you trying to show?

 

[bigbatica]

I am trying to print a report and this is shows up. Yellow line is what my problem is

 

[Gasman]

Well you have option explicit, but have not defined MyDb or MyRst?
Does it even compile?
What is the error message?

Help us to help you.

 

[bigbatica]

MyDB
It is compiles
Run-time error 2427. You entered an expression that has no value

 

[Gasman]

What is that Zakljucan put that sql into a variable and debug.print it.
Then use that variable in the openrecordset.

OK, I can see it is boolean, but you still need to test if it is True.

 

[The_Doc_Man]

As a simple experiment, at the top of that module (in the declaration area of the module) put a breakpoint on the line that starts with "Set MyRs=" and when it breaks, move your mouse cursor over MyDb to see if it says "nothing" or says something other than "nothing." If it says "Nothing" then your Set MyDB=CurrentDB didn't take for some reason. Need to find why if that is the case. I'm certain that you have an external definition for MyRs and MyDb since you have Option Explicit and got a run-time error. (You wouldn't get that far with compile-time errors.)

 

[The_Doc_Man]

@Gasman - the value of Zakljucan doesn't enter into the picture until that recordset opens, and WHATEVER it is, to get that error highlighting the Set MyRS line means it isn't open YET. One more debug step and it might be, but in that context, it isn't significant quite yet.

 

[Gasman]

I believe a debug.print will show ' Where -1 AND '

 

[The_Doc_Man]

I believe a debug.print will show ' Where -1 AND '

Why? The FROM clause names a single table and there is no concatenation going on so the field name (that has no space in its name) should automatically be assumed to be a field in the named table. Why would a Debug.Print delve into a table value at that point?

At worst you might need parentheses to force a particular grouping, but syntactically that is a valid SQL statement. (Semantically there might be problems, but not syntactically.) Further, since logical operators are used AFTER math/comparison operators, I think even the semantics is OK.

 

[Gasman]

Sorry Doc, was on my phone and thought there was concatenation in there.