Search results

I'm trying to use a file dialog to allow users to select the spreadsheet they want to import, but when I use the following code, I only get the folder path - the file name is left off. Private Function GetFileName() as String Dim dlg As FileDialog Set dlg =...

If this system was used to store actual vendor data (contact info, history, etc.) then I would do that - I like the "active" check box idea - very clever. However, in this instance, the only info we're storing is, in fact, the vendor's name. There's a much larger database doing the heavy...

Thanks, Gina - that's an excellent suggestion. I've never really used that before, and I definitely will in the future. I like that there's a meaningful message box to let the user know it's been added and it's a neat way to save some programming, depending on the situation. That said, I'm...

I'm working on a form where I have a couple combo boxes. In the past, I'd create/link a Lookup table - in this case, I have about 30 values from which the user can choose, but I also want to allow users to enter a custom value if the one they want isn't on the list. But I'm now toying with...

Oh, and thanks for cluing me in on the fact that there's a "Code" tag to use...as you can see, I'm relatively new to these boards...

I figured it had to be something like that - the lack of meaningful control names tipped me off, but I just wanted to make sure I wasn't missing something. The form I'm working with has 7 tabs, each of which has anywhere from 10 to 25 command buttons that are simply used to open other forms -...

I took over an old Access project and have been going through the code. I have no formal development training - my skills come from a lot of experience. Can someone explain the benefits of using "stDocName" in the following code? My question is, why wouldn't you just use: I'm sure...

Hey everyone, Just got my first Access developer contract after a decade of a non-IT career. I love the new interface and all the cool things that come with Access 2010 - but I need a quick primer on SharePoint. It's not required for this job, but from what little I know about the product, I...

Here's a very simple solution to what I was talking about. First, develop an aggregate query based on your Contact table, that groups by all fields except first name (which only returns the value from the first record using the FIRST aggregate function) and then calculates the total number of...

If you wanted to get really fancy, you could develop a query that would identify if there are multiple records, and if so, set the first line of the address to "The Jones Family" rather than simply selecting a name from one of the records. But Trevor is right - a lot depends on how your data is...

The client confirmed that there is a carriage return at the end of the string - I'll give it a test and post the code if it works (in case anyone else faces this dilemma...) Thanks everyone!

Right now, the OCR returns a string "x1,y1,z1;x2,y2,z2; etc." with commas as a field separator and semi-colons as the record separator. The string ultimately ends with a semi-colon. But my guess is, as spikepl suggests, that the OCR software can be updated to add some sort of "End Of Line"...

I got a real noodle scratcher here... I've got a form that parses a data string into individual records, and inserts them into a table. Currently, the string is pasted into a text box, and the user must click a button to begin the parse/insert process. My client recently informed me that the...

Hello everyone - my name is Will, and I'm excited to be a part of this forum. I'm a seasoned Access pro, and by seasoned, I mean I was an developer for several years...10 years ago. I've spent the last decade in the marketing field, and it's left me wrung out. I've got a wife and a 16 month...