Search results

:o !!! Thank you. I had no idea it would be so easy. I guess I could learn what each individual built-in text function does, in order to know I to combine them like that. Thanks!

I've search the forums...If you can find a thread that discusses this, or can give me some advice on this topic, let me know. Is there any built-in function that will allow me to delete any text before a certain point in a record... Or perhaps a way to use the REPLACE function to do so? All of...

I had an issue similar to yours, but only 255 characters appeared in my memo field of my TABLE, not just my query. See, I had my tables linked to an Excel spreadsheet...And although there were pages of data per record in Excel, only the first 255 characters came through on my table. Check out...

According to your profile, you HAVE posted two threads...Only, the forum search only gives me this one. Did an admin delete one?

More or less. Search this forum, or Mr. Clipit (Access Help) for articles concerning OLE objects. With these, you can LINK a variety of files to a record on the database. You cannot import them. You'll still be able to view them on a form, as OLE objects are just like any other field in a...

Indeed....I'm not sure which one to respond to. I don't suppose you're forgetting to to include the <<Next Record>> command? (My syntax can't be right...but it's something to that effect.) Andrew

Solution for this I've struggled with this issue myself for a few months. I tried Jim's links, but I didn't find them of use, because I really don't know VBA well enough. I did find, however, a Visual Basic project that was helpful (I could understand the code). I downloaded it...And then...

- Ooh! I like the idea of downloads too... It would depend on the size of the database that houses these forums, though. Perhaps if it were broken up into the different categories... I see your point with people not having CDs handy, if they also don't have the internet... I agree. In my own...

I had a bit of an... This may have been suggested earlier, I dunno: I had a bit of an idea earlier today, while working in MS Access on an older laptop of mine. This laptop has no connection to the internet, though I badly wished it did, as I really wanted to search the archives of this forum...

Success! Thanks Pat! For anyone who has this issue later down the road, here's what I did: Since I don't have the time to learn the VBA needed to do this, and then troubleshoot it until it works, I took a cheaters way out... Take a look at the advice given Simplycongy in this thread. (I must...

I know that you can use vba to open another application. (I don't know how, but I know it can be done - I've seen it) So... Is it then possible to use vba to work within that application? I'm trying to have vba open Excel and then execute a macro... two macros, actually. Is this possible? Andrew

If I had a simple module, like the one below.... function simple () docmd.openform "simple form" a_subroutine: docmd.gotorecord acdataform, "simple form", acdatanext goto a_subroutine mtairheads_subroutine: docmd.close acdataform, "simple form" end function How would I get the function to...

Ok...So, I have "Date ()" in the default value property of the field. I also have "MM/DD/YYYY" in the format value....And nothing is appearing in the box when I display for form... What am I doing wrong? Andrew

Ok. That's actually what I started off doing.... The reason I feel so stupid asking this question is...Well... What do I put in that default value field, to make the date appear in "MM/DD/YYYY" format? Andrew

I've searched these forums, but I haven't found anyone as clueless as I... All I want to do is put something in the "Control Source" of an empty field in a form to create a date... Specifically, in the following format: MM/DD/YYYY I know this has got to be easy, but I can't figure it out. I'm...

Good ol' Error 3349. I have a make table query, which filters data from a linked table and creates a new table of results. The linked table is (Of course...) linked to an Excel spreadsheet. Whenever I run the query, I get the error message "Numeric Field Overflow." I've done some research on...

That sounds like it could work...But how do I do that? Andrew

I need, in some way or another, to be able to import an HTML code from an HTML file into Access. It would be ideal if the end result is a table with one memo field named "HTML". I know is seems strange, but I need the code itself. I've managed to do a bit of duct-tape work, and import from...

If I have several tables with the same fields, but different data. Can I use VBA to change the table source of a query? Thanks

All I can say, is that you rock.... All is doing well so far. I have been able to link all data, and am working on a VB sub that matches data with relevent keywords. So far, the most accurate conclusion I can give you is that it's slow...Painfully slow. I can live with that, though. It's not my...