Search results

Sorry for the late night post. I am midnight coding and need rest. After work tomorrow I will check post and keep truckin' on this project. Also sorry for code format. I had to manually type the code because the machine I am coding on is not connected to the internet. I have learned the...

That is the one! I will do some more homework on the automation processes and make a new thread when I have more questions.

Summary revised: I want one to be able to call chart formatting for any individual facility from the fleet-pool of 99 facilities using one workbook containing one chart. This would be scaled up to over 10,000 facilities if the user interface is simple I would be willing to explore controlling...

Well geez. I'm a noob. Thanks for helping me learn. This has been an experience in learning about how to use message boards and Access. I am very grateful for "vbaInet", 'GinaWhipp", and "Uncle Gizmo's" willingness to help.

Seems to work nice. I do not see any changes in code...did I miss something?

Greetings, I am trying to solve a problem that seems to require a tag team effort by excel and access. My current solution resembles a broken car that is only running because of the amount of duct tape currently holding it together. I am now thinking out of the box on a way to override the...

I expect 2, client ID 9 & ID 12...

I posted the code inspired by Uncle Gizmo's method shown above. Allen Brown and Gizmo's code have the same outcome. Also, I just experimented with your remarks and there is no change in my outcome. Are your referring to the syntax?: Like "*" & [Forms]![Form1]![FormControlNameHere] & "*"...

Original post that prompted my question : http://www.access-programmers.co.uk/forums/showthread.php?t=266241 Allen Brown's solution: http://allenbrowne.com/ser-62.html Uncle gizmo's solution: [video tutorial] https://www.youtube.com/playlist?lis...AN0Jg9soJpBVvw Sample DB is now attached

My apologies.

I built a search form to experiment with the conversation on the following post mentioned at the end of my post, ( if you want to view the link just navigate through the instructions. As of now I can not post links). I too am trying to create a search form with dynamic values but seem to run...

I have tried Allen Brown method and uncle Gizmo. The only difference is Allen uses a set filter command and uncle gizmo uses a record source command on the control. Both work well but break the same way when used a certain way..................Suppose someone typed the entire string in for the...

Check out this link. Your problem is solved for ribbon security. I am not able to post real link becuase my post count is low so add the http prefix and www to the front of the link text below. I recently had this same problem you had and this helped me solve it. iaccessworld <dot> com...

I asked about the consequences and appreciate all of your insight:D! I should further clarify my question by asking if temp variables can cause issues on a database that is not split. I am trying to sell the split database concept to my supervisor but that also means I will need more time for...

Could someone address the consequences of using [TempVars]![tmpYourTempVariableHere] with multiple users for client only applications? I did not see that addressed here in this thread.

Howdy! I am not an access/excell vba wizard but I hope to be one in the future.