Search results

Yup, that worked - thank you

Hi, Is it required or recommended to run the performance analyzer and fix any recommended issues. I am just finishing up with my db and I ran the performance analyzer. There were no errors with tables or queries but there is a whole bunch of 'idea' from access on my forms. I am not sure if its...

Ok thank you. Yes, I am new to this so it could be sloppy vb programming.

Yes, I should have used 2010 to build this but I had asked them for office 2013 for other excel reports etc. and I cant have both 2010 and 2013 at the same time. If I give users ACCDB then I will use VB (mostly) to secure the: - design view - vb code - tables - so they cant be deleted - remove...

Here is one for a command button: Dim strInput As String Dim strMsg As String 'Beep strMsg = "This form is used only by the user authorized to create a new project." & vbCrLf & vbLf & "Please enter the password to gain access." strInput = InputBox(Prompt:=strMsg, title:="Form...

I tried and below are my findings: #1. I took my db built in 2013 and converted to accde in 2010. The file worked just fine in Access 2010 but in 2013 one of the command button with vb code for password wasnt working and there are case statements on a few forms which were also not working...

OK would it be OK. if I open my db in Access 2010 and then make ACCDE in 2010. Would that work then for both 2010 and 2013? Or I just simply compress the db in 2013 and distribute the front end to the users? Thank you

Hi, I build a db in Access 2013 but rest of the users are using Access 2010. I converted the front end of the db into ACCDE but users were getting the message that the file is not compatible. So I had the compact the front end file. So does that mean that I can not make an ACCDE file for...

Thank you but I dont think I want to create a logins etc. at this point. I thought there is a much simpler way of finding out who has the application open. I think if you open the record locking file you can see the name computers that have access open. So I wanted something similar like that...

Sorry, I dont know what you mean :)

Ok. No problem :)

Ok I found the solution here with a couple of added steps that I took to make it work with reports. This was working fine but report windows were also getting minimized. See link below http://www.access-programmers.co.uk/forums/showpost.php?p=579909&postcount=16 I called this function on the...

Yup, that is what I am thinking about doing.

Sorry, I have no idea what that means :)

In a multi user split database environment, is there a way to get a list of users using the application? I dont have any logon for any users, just a simple split database. If its not too complicated then i would like to incorporate that into the DB else, I think I can live without it. Thank you

I am building a multi user DB and need to know what are the best practices to handle the record locking file. The locking file for back end database is I dont care about for the front end, is there a way to hide it so the user doesnt see it? In the past I have created a folder somewhere in the...

I searched the forum before posting this thread but didnt find a solution to how we can hide Access application on start up? If there a code available for this? Thank you in advance?

Ok here is what I have done. I have taken all subforms out of the tab control and shrunk the tab control to as small as possible. I put an unbound subform just under the already shrunk tab control. On the on change property of the tab control I have put the following code. P.S I did that to...

Oh man, if you (or anyone else) can help me with this, I would greatly greatly appreciate that. Can you provide me with with the full code? I am assuming that the above code goes into the on click event of each page of the tab control? Attached is all the tabs I got. You also mentioned in one...

Thanks for the links. I will go through these especially the method to keep a continuous link to the backend db.