Search results for query: *

A friend asked me if I could do some work for him in Foxpro, but I am totally unfamiliar with that program. For someone familiar with Access\VBA, would it be relatively easy to pickup? Also, what's special about it - why would you pick Foxpro to do an app in versus something else? Thanks in...

Total excel novice here again.... What I want to do is (for example), if an entered value or a formula resulting in "1". then the result would be displayed in cell A1. If the answer is "17", then it would display in cell A17, etc. In other words I want the value or result...

Total excel novice here, so apologize if a simple question, but... I'm trying to write a spreadsheet that would display accumulated values based on a user-entered frequency. Is there a way to change the SUM function to skip values, or is there another function that would do what I need? By...

A search turned up some simple functions for testing the status of an internet connection, but I'm getting an error. Not sure if the info was obsolete, if I'm misunderstanding how they work, or if its just a simple syntax mistake. The error message that pops up says: "Can't find DLL entry...

Got the default email app (which happens to be Outlook on this machine) to come up and preload the fields OK. But the FIRST thing it does, before Outlook loads, is a pop-up from Windows itself (I assume) asking to select a "profile". I assume this is an XP thing. Is there a way to...

In case I can't get my email routine to work, here's my contingency: just call up the default email program and fill in the blanks. I've done some searches and found a lot of routines that call Outlook, but they specificaly call "Outlook". How do I do call up whatever windows has as...

Not real familiar with the technicalities of the internet here. Unfortunately, I'm working on an app that performs email right out of Access. The app requires specifying the SMTP server you're connecting to, and I have a pretty good conceptual idea of what that's all about, but I'm having a...

I'm not satisfied with the various response-bots I've seen, so I've decided to make my own. I'm relatively well versed in Access and VBA, but this app involves something I've never really done before, namely interacting with another program. Most all my previous aps have been pretty much...

I have an application that sometimes has some pretty heavy processing going on that might take up to several minutes to complete. And some odd things are going on that I'm hoping someone can explain. The routine itself is pretty simple - its just searching a matrix for a particular value and...

Not sure which forum to put this under but... I have an application I've been working on for some time, which I plan to distribute as a stand-alone executable. It doesn't really involve a lot of data, in fact, its not really a database application, but I started doing it in Access because...

Oops! That was just a typo. My control was originally numbered Text113, I changed it to TextBox2 for the example to make it more clear, and wasn't paying close enough attention.

well, it kinda works, using SelStart to position the cursor. But the problem is that SelStart positions by character count, but its not a "solid" textbox. What I mean is that if it was "shoulder-to-shoulder" with characters throughout, then you could step through it based...

Thanks for the suggestions guys, but upon closer examination my problem seems to be something very specific. It seems related to the clipboard and not "memory" in general. Here's whats happening: I have TextBox1 that gets filled with a string value, and that string is also copied...

When doing string concatenation, is there any practical difference between using + versus & ? Anytime one should prefer one over the other, or not use one or the other? thanks

Not sure what I did or what's changed, but a previously OK app is now giving me headaches: During the course of running an app under Access (running within Access, not as a standalone), I get an Access Error message that says I'm out of memory, and to close some open programs and try again. My...

I've been going through my application doing some housekeeping to make it run faster and better, and I had a question regarding a recordset operation. I know enough to use them, but not enough to know if I'm doing it the best way, or sometimes even the right way! I want to make sure I close...

Thanks Star, but your answer reveals a new wrinkle: The list of references is not the same!! I'm opening the databases with the same program on the same machine, but when I look at the references list for each database, there are some in the first that are not in the other, and vice versa...

I have a large unbound text box on a form that is essentially used as a text editor. If I click on the box, I can then "scroll" up and down using the keyboard's arrow keys to see text that falls "off the page". The textbox must be enabled however for that to work, and the...

A tip posted on one of the forums about cleaning up and reducing the size of your database file, suggested creating a new (blank) database, and importing all the objects from the application being developed. The import worked fine without errors and the new file is a third the size of the old...

This isn't an Access or VBA question, but this is the only forum I read or post to, plus I'm not sure where I'd ask this otherwise. Simple problem, but it has me a little stumped and surprised I haven't run across it before: I saved a bunch of demos, shareware, and freebies which I collected...