Search results

I had some more time to work on this and I developed a second version (also Access 2007 file format). This includes some bug fixes from the first example file I posted but it also now includes code that creates a temp database, creates the temp tables, adds a TempID primary key to each temp...

First off, Galaxiom, I'll admit you've done a good job of refuting my complaints with ADO recordsets. I found while programming my example database (more on that in a minute) that some of my complaints were true even using DAO. As far as filtering and sorting using Menus and/or form properties...

I've been experimenting with Fabricated ADO recordsets and they do work OK. However, I've found there are quite a few limitations with binding forms to fabricated ADO recordsets. 1) The Form's filter property doesn't work. 2) The Form's Order By property doesn't work. 3) User's cannot use the...

This is great information, although I do find some of it slightly difficult to follow. Perhaps because you tend to use some different conventions and different methods (both figuratively and literally) than I do. I prefer to use DAO to insert and update data. I find that it's much easier to...

I came across this post/thread because I'm facing the same problem (and am of the same mind) as SteveManser as well as the original poster Thales750. Not to be cantankerous or augmentative, but somehow I just can't wrap my head around the position of Gemma-The-Husky or GalaxiomAtHome. It seems...

According to this post here the poster called kliler was able to resolve this issue by disabeling SMB2. Here's the instructions he used to do it. I'm currently testing it on one workstation to see if it makes a difference. I cannot say for sure if disabeling SMB2 is a good or bad thing. Windows...

Does your code compile without a problem? I suspect not. Debug > Compile

I think you will have to customize the Audit Trail functions to get this functionality. I did change mine so that the audit trail function doesn't actually do the deleting of the record. There's a section towards the top of your Audit Trail function that handles New Records differently. You...

What new value are you talking about. The new UniqueID value? Usually this audit trail function makes one entry for every field that changed. Does it not show any changes for you? Or does it just not show changes if you change the UniqueID value?

If you have the Unique ID in there you shouldn't really need the name. You can always make a query that will link your contacts table to the audit trail table and show you the name or company name for the contact.

To disable the prompts you just need to comment out the line that prompts the user to fill in a reason. It should look something like this: gsReason = InputBox("Reason for change(s)?", "Reason for change(s)?")

Have you tried setting the Form's PopUp property to True? Would you like the form to popup over top of the forms located in the tab view?

Is there any way to check to see if the current record has been deleted on a bound form short of trapping for the -2147352567 error that occurs when you try to run code against the record?

Thanks for the feedback. It dawned on me while driving to lunch that you could get the same results in many cases using some combination of Left, Right, Mid, Len, InStr, and InStrRev. While my code my require more clock cycles I do think it is more natural to use but I realize that point is...

I'm unsure if something like this already exists somewhere or not. Maybe someone has already programmed a better function than this. I do occasionally need to get a certain portion of a text string like the last part of an email address for example. Here's a fairly powerful function that will...

Well, I haven't written mine yet. :) I wouldn't brag about writing the most elegant or efficient code. What I did start writing consisted of a function to strip off and return the decimal value in a string. From there I just wrote a select case statement to evaluate the most common decimals...

figures. :)

I wasn't able to get my SQL Join with the expression to work so I created a MySQL View and linked to it as though it is a table using ODBC. I consider this one solved for now.

I'm wondering if there is an easy way to convert a whole number with a decimal to a whole number followed by a dash and a fraction to represent the decimal? I can program a function that will do this but I was hoping someone knows about a canned solution. Example: 2.75 becomes 2-3/4

I know it doesn't help the OP with his question but I was getting my laughs for the day trying to figure out how you would put AVG Antivirus in two fields in MS Access (as per the post title). :)