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...

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...

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...

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...

Found some sample code that directly uses winsock to send a simple SMPT email message, but there's one line I'm not sure how to define. The code starts: Sub... WinSock1.RemoteHost = strEmailServer Winsock1.RemotePort = 25 Winsock1.Connect ... If a separate server isn't being used, and one...

I'm working on an application, and finally realized I don't have to reinvent the wheel - especially when there are people out there doing it better than me anyways. So was curious what vendors\companies\programmers, etc. you all would recommend for purchasing canned controls and funtions. I...

Functions typically return single values, for example: Private Function iGetResult(iInput as Integer) As Integer ... ... will take an integer, do something, then return an integer back to whatever called it. Instead of returning a single value, is it possible to define a function such that it...

I have an unbound control where the user is required to input a number. To make checking for numbers-only easier, I've set an input mask for that control, however that causes another side-effect. For visual purposes, the control is left-justified and longer than the allowed number of digits...

The Help files say that String variables come in two types - variable length and fixed length. But pretty much every other reference to strings talks about them as though they are always variable length. How do you tell whether a string is fixed-length or variable? How do you define a string...