Search results

Hi, all - I'm an offsite administrator of an Access 2013 database with the backend on a shared server and each user with a front end on his or her hard drive. We this arrangement has worked but has become more complicated with the site using the DB having users working from perhaps more than...

Thanks, all, for your responses. Here is a small sample of the original data: ID Start Date End Date 282 7/22/2015 9/23/2015 286 7/22/2015 9/16/2015 242 7/23/2015 9/23/2015 253 7/25/2015 9/9/2015 235 7/30/2015 10/7/2015 236 7/30/2015 2/10/2016 265 7/30/2015 9/23/2015 What I would want is to...

Hi, All, I have a query that produces a recordset with each record having two date fields, a sort of start date and end date. I am interested in creating a query or VBA that would produce a list of dates within a date range with each date having a count of all records in the original...

Agreed. We have those - but this was a new replacement database (front end) which I was trying to install offsite from a copy I had sent which worked for me. The transporter beam must have created a mutant.

Greetings - I am thinking of upgrading to Access 2016. I work with others who use Access 2010 and 2013. If I create a database in 2016 will those with earlier accdb versions be able to open it and have it function appropriately? Similarly, if I created a database in 2010 but work on it...

Thanks for your reply. It was unnerving, especially when there is pressure on delivery. My solution seems to be fine. Unfortunately, doesn't one have to be able to open the file to repair it? Any, as you said, who knows how or why it happened. Thanks, again.

Hi, all - I have a A2010 FE application that I made revisions to - nothing radical, but some additions, corrections, etc. When I tried to install the revised file offsite where the users are using A2013, I found that all I would get when trying to open the file was the A2013 main page that...

A good question. Actually, I'm confused now. While the functions are working, I am getting new records added to the audit tables when I don't want them to. I only want edited or deleted records. As you said, I thought the the "me.new record" would result in leaving the sub.

Thanks to both of you. All I can say is "duh.." You are both correct. I forgot the Options Explicit and bWasNewRecord, both at the top of the window. thanks...

I am using Allen Browne's coding for setting up an auditing process for my database containing multiple tables that will require editing. I successfully did it for one table and then copied and pasted the code under other tables, changing the specifics of the call function. It seems for all...

Here is the problem in context. The only two issues are the pwchangedate and the calling of the security procedure. In the latter, the correct number is generated but doen't activate the case in the Security procedure. In the case of pwlastchange, as you know, it is generating null...

Thanks for your response. I guess I'm not following. txtUserName is a field in a logon form not associated with a record source. The value entered does generate as the value through the procedure which I had used previous in another situation. I could see if there was no value in that...

Hi, all - I created a variable to use in a dateadd function in VBA. It goes like this: DIM pwlastchange as Date DIM Test as Date pwlastchange = DLookup("[PWlastChange]", "tblEmployeeList", "[UserName] = '" & Me.txtUserName.Value & "'") test = dateadd("d", 90, pwlastchange) When running...

Thanks. I'll check it out.

Hi, all - I've converted an older mdb database to Access 2010. In doing so, I'm creating user-level security as much as possible. Question: If my BE database is encrypted and I link it to the FE database, entering the password, will that link hold up for if the FE is copied and put on...

Hi, all - I developed a process for having our users create passwords of a certain complexity (at least one each of upper case letter, lower case letter and number). I have it that this is done when creating the password, but the simple question is: how does can the logon password entry...

I went with Frohingslosh as it is the most flexible and it works great. Thanks to you all for your input and suggestions.

Thanks for all the responses. I'll check them out. Have a great New Year! Paul

Hi, all - I've been researching how to test password complexity for an A2010 application through VBA and haven't found much. I would like a new password tested to assure it has at least 8 characters (pretty easy) and contains at least one capital letter and one number (not so easy). Has...

Thanks for your response. What's strange is that they seemed to function, or that the functioning is inconsistant. I understand about the references as I've gone through most of that already and thought it was done correctly. One added issue was that in doing this I had to change an initial...