Search results

Thank you all for your input. For now, I incorporate Linq's suggestion. It works for now when the data consist finite number of components, but in the future, if additional components are added, then I would have to adjust the code.

Thanks for the quick reply. I was afraid of that. I was hoping for one function that may do the trick :) I'm not that seasoned of a programmer. It may take me hours if not days, but I'll give it a go.

I have a field in a table that I'd like to extra the texts from. The are stored in below format (separated by colons). They don't always the same amount of characters and not all of them have the same amount of texts, some may only have Text1:Text2::, while some may have Text1:::Text4.

Sorry, super VB noob here... How do I create procedure so that when the mouse touches an object, such as a label or textbox, the object changes color? I want to be able to use this code for many objects in the form. Apparently, I can't do something like I get the "NullReferenceException was...

You're right. I seemed to have compared VBA to .NET in my verbiage. I guess I meant more in line of Visual Studio vs MS Access. To me Access is such an easy database management system, coupled with the ease to create forms and reports. Furthermore it has the capability of using other bigger...

I have been an Access advocate for a long period of time. Although I do not have a programming background (at least educationally), I have managed to learn as I go with numerous applications I've developed. I am at a point that I want to get very serious about becoming a programmer and learn...

Hmmm. I'm not sure what went wrong, but since I incorporated your code, I can no longer modify the file. I keep getting the I do not have privilege...I tried to open it exclusively, as if the file is open, but I cannot find it anywhere, even in Task Manager.

I have changed numerous features in "Current Database" under "Options", but I am unable to achieve what I need. I just need a popped form to show up when the program is initiated (no other background), meaning, I want to hide all the Runtime menu. I am able to get to the point of just the form...

Thank you for tip. Your code works great. However, due to the number of variables I have (way too many), I am getting the "Too many line continuations". Do you have any suggestions to overcome this issue?

I'd like to be able to see the values of all the global variables in runtime by clicking on a command button. I don't know if there's readily function for that. If there's no aforementioned function, how do I list out the variables in a message box with the below function I have already...

Thank you for your response, Wayne. I just now realized the computer I have does not have a RJ12 output :o. Currently the cash drawer would open if the printer prints out when the cash drawer is connected to the printer. You have any idea how I can send a signal to the printer to open the...

I want to build a command button to open a cash drawer without going through a printer. I learned the printer codes for this particular printer are 27,112,32,25. Can anyone help me with the VB codes to achieve this?

Thank you, thank you. I just can't seem to get it.

Paul, I tried to refer to the link you gave me to come up with the syntax for the below scenario with three conditions, but keep failing. I'd appreciate it if you can help me again.

Thank you Paul. Your code worked beautifully.

Needing help with syntax involving a number type variable and date () as conditions. Below does work for me.

Thank you, JHB. That worked perfectly. I never quite understand the methodology of the syntax structures. The only way for me to write dlookup's is to reference past expressions, and whenever I have multiple conditions with different combination of datatypes, then I'm clueless :(

I've read online that the ODBC connection to remote database is not secure, but I cannot find the exact reasons. Is it possible that hackers can intercept the data that is being passed? If so, what is the best way to make this connection secure?

Sorry Paul, I was out for a few days on another project. I still have not figured it out. Based on the variables above, I've tried... I get Type Mismatch error message. I know the fields and the variables are text/string type, so I suspect it's the syntax, which I can't ever understand them...

Hi Paul, I've seen that page before, but I still can't figure it out.