Search results

We constantly test code as we build. Especially when we have so much back coding.

We ended up passing the string and then dealing with the form as a routine passing controls to a master temporary form. We found that there is a limit to the number of controls allowed on a form and just because you delete or flush - the behind the scenes control index does not flush.

I am not sure what part of this he is building - but it's a way to build forms on the fly as part of a master form based off of the end users choices to questions. Based on their answers, the master form builds off of the other forms.

@Chris - The Update Requests 1-99 is intentional.

I just sent this to my boss... so far - this is the answer that makes the most sense.

Here’s another example of something that almost works: Dim theform as Form Dim frm As AccessObject Set frm = CurrentProject.AllForms(myForm) MsgBox frm.Name Set theform = frm dummy = FixForm(myform, Me.Flowchart) I shows the message box with the correct form name in it, but bombs on the...

yes - the Docmd.Open does work. I need to pass to my function a name of a form in form type. The name is a string because it could be 1 of any 99 at a given time.

I have a string that contains the name of a form, something like “Update Requests 1”. It has to start as a string because the digit at the end will change based on user interaction. The digit could be up to 99 so a giant case statement is unmanageable. I need to populate a variable of data...

What I hate about Access 2010 is the way you have to lock down a DB so that the End Users don't screw it up! I have massive problems with this and then after all of the coding and seeing that it worked at the server level - when RDP'd into, some of the locks don't trigger. So - we have taken...

Well - I have built in a couple of different tells - like in the userlog using administrator check, using different switchboards. The other way I set permissions is using Powershell Code in the Folder Sharing permissions area per user. We host our DBs on a 2008 Win Server and for the most...

I have attached everything you need to make the security work. The UserLog is hosted in a centrally located database and used for all database permissions but I included here. There is one place in the VBA to put your domain to establish the LDAP connection.

I will try to throw something together for you be Friday. Really an LDAP connection with the UserLog Table is all you need. The code will double check against LDAP for user group and permissions and then against the UserLog for Database permissions specific to that DB. For instance - I have a...

Bob - You ROCK! Thank you!

OK - Bob - you are back up on deck! (apporpriate for the soon ending baseball season) This is building my query results into a series of stacked strings where instead of each record being on a line, it stacking them FirstRecord FirstRecordSecondRecord FirstRecordSecondRecordThirdRecord I...

Are you kidding me Bob - You are the awesomest air code writer!

Thanks! I sure appreciate it!

Hi Bob! OK - I need the query to export to a file - even a txt would be fine - pipe delimited. Is this the only option in 2010?

I need to export query results to a PIPE delimited CSV file. In the 2003 days, you could specify this in the export. With 2010, I have tried to set up a Saved Export but there are no delimiter specifications. Can anyone help? :banghead:

I have a routine that adds users to Active Directory user groups. I need to write a little check around the .Add to where if the person is a member of that group, it will skip and move on. I can't seem to get the syntax correct. Any suggestions? :confused: ' Add the user to a group...

Started reading about converting to .accdr - maybe not the best choice for this situation - forms will work in runtime but the reports won't. I think I will strip the quick menu off the top and leave the ribbon - maybe try to break into the back code off the ribbon.