Search results

So instead of creating a new database I compiled my VBA code by fixing errors as Mr. B mentioned. Then compacted application and converted that into .accde format. It worked :)

Let me try that. I have alot of forms and reports. I hope it will be a smooth process.

Any luck? I am getting similar error and can not resolve it. -SJ

How to do that? I am very new to DB and access -SKJ

Re: Help Required in MS Access - User Authentication/Login & Password Verification Scouser/Phil, Could you please upload your full example here. I opened your older(2007) zip of this post and is very useful to what I am looking for. Please see my today's post for details. I am using MS access...

Using MS access 2010 I have designed a database for a building manager to keep track of rent. There are several sub-managers involved in this. I want to assign a control to only specific reports(not to the database) and have several weird questions-Key point-We have a shared Network and Want to...

I need to determine the maximum database size (number of records or MB/GB) for the last few versions of Access. I am using 2010 currently. Thanks SKJ

I am not sure how to add Distinct to Organization ID and to FL Name to get the unique count of the organizations and floors. I have 10 organization and 15 floors in my table here is my code. I am sure it's not that great but I am learning. Thanks! SJ

so insted of counting organization as once it counts all the entries. Correct number should come 10 as I have max 10 records in my organization table. But it is returning 52 as a count.

I don't know any other way to save this file then as I don't have any older version :( I added in the report design to combine it as- =Count([Orag_Name]) Here is the SQL code. I appreciate your time in this. Thanks! SJ

Hello everyone. I am very new to the MS access and can't figure it out about several issues.(Please see attachment) Issues- My BUILDING DETAILS query is not showing correct count of floor for that building and correct count of organization which are present in that building. I don't know how...