Search results

Is there VB code that I can use to set the folders properties, and if so what would it be?

I've read a lot of thread about barcode scanners, but I'm unable to locate a thread on how to call up a default scanner. I have an office with 17 workstations and each may have a different scanner. I would like to know how to if there is software that I can call up from a button on an access...

I am using ShellExecute to open word 2007 documents. I don't understand fully how it works but it works good. But now I would like to know if someone can tell me how to use ShellExecute to open the word documents in Read Only mode. How do I pass the information through ShellExecute to Word...

In revisiting this post again, I realized that I did not follow up on what I did. I solved this problem in Access 2007, by using the conditional formating on the control for a subform. The limitation is that you can only have up to 3 conditions. But if you choose wisely you can make it work.

Thanks, I'll give it a try. Do you think this will slow things down?

Does anyone know if there is an event that will run when there has not been activity (like mouse movement or keyboard activity) for a specific time? I use a timer to run a requery to update data on shared tables. However, it sometimes runs when I'm entering data and causes me to loose...

Thank you. I'll give that a try.

My pleasure. I first started my code, it was about 12 midnight, and started to build it step by step, thus the nesting. I have not had a chance to learn VB from a book but mostly from looking at other people's code. So I have never learned any rules and is mostly by trial and error. The key...

I've written code that creates word documents based on a word template, then names and saves the document with the filename = patientname & date. However sometimes a second letter may be written from another template but may accidentally overwrite the original word document with filename =...

Thank you all for the help. It works great now. It's hard learning VB without much resources. this forum is great!

I've written a function that takes a person's name and gets rid of all periods, spaces, commas, and appostrophies. When I run the code outside of a function it works. but when I put it in a public function, somehow I get a compile error. I just can seem to figure it out. Can anyone tell me...

Thank you CyberLynx. I'll study up on what you wrote and hopefully it will make my application work.

Thank you. That was the problem. It worked.

I have a table of medical procedures that I want to merge with Word. I want to know if its possible to declare the variables within a loop. Each letter that will be merged can have 1 to 40 procedures. So basically I want to declare the variables depending on the particular patient letter to...

I've been trying to adapt the 'Super Easy Word Function" to my database. I'm slowing finding out what to do. The problem I'm having is on my Vista machine the word app, when launched from Access immediatly minimizes to the taskbar. I've added a reference to MS Word library and then added...

Thanks for the great reference.

Thanks so much. I didn't know about the 'Parent' thing. It solved my problem. Such a simple thing. I love this forum!

Can anyone tell me if there is a way to look up a field on a form. I have a menu bar, which is really a subform with buttons. This menu bar may be on several different forms. Some of the buttons, opens forms based on the information on the currently open form. Since some of the forms may be...

Thanks for the input. I'll give it a try.

I'm wondering if this would slow performance down any using a continuous subform vs a listbox. How much would I be sacrificing for this effect?