Search results

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?

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

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'm using MS Access to connect to a MySQL database through ODBC linked tables. It appears that Access (or the ODBC driver) will not process a SQL statement that MySQL has no trouble processing. It is as follows: SELECT recipelabel.labelid, parent1.lbltext, node.lbltext AS LabelPath FROM...

I've got a new problem that cropped up some time ago and only today did I find some critical information about this problem. Every once in a great while, with no consistency, a user will come back to their workstation and find the following error message on their screen: "Your network access was...

I've been working on an example database to demonstrate how to program your own Users and User Groups module. Feel free to download and test this database and then post your feedback here. This was written for Access 2007 and 2010 but the file format is 2002/2003. You should easily be able to...

I'm trying to store short text records that sometimes include a question mark or an asterisk. I need the ability to do SQL related searches like DCounts and DLookups but I can't seem to get it to work. Is there some easy way around this? Some way to escape these characters?

We are using Access 2007 and Access 2010. Our users like to change the background color and foreground color on their datasheet view subforms. I tried to maintain their settings by saving the backcolor and forecolor for each control to my text-based settings file. However, this doesn't work...

I need to call a subprogram on a subform. I'm not going to be calling this sub from the main form. I need to call it from an outside form. How can I do this?

OK, so I'm editing this post because it was incorrect. I thought ampersands where causing my problem but that wasn't true. It appears that what is causing Access to freeze is long filters with lots of fields. I'm allowing my users to perform an "any field" search which means I parse out their...

*Solved* .jpg Files Stopped Loading in Image Control (Access 2007) *Solved:* This problem was caused by the fact that Office 2010 left behind it's graphics filtering files in the following folder: C:\program files\common files\Microsoft Shared\GRPHFLT I copied all of the following files from...

I'm trying to program a short function in a stand-alone code module that will iterate through all forms and their subforms and return a human-readable string that tells me which forms are Dirty or in NewRecord state. So far I'm not having success, especially on the subforms. Can someone help...

I know you can setup your outlook contacts to be a table in Access but that's not what I'm looking to do. I'd like to have code that, when triggered, updates a given contact's details in Outlook using the information stored in an Access table. I don't need to pull any information from Outlook...

This is more of a theoretical question since it will generally be impractical to implement. Let's say I have a form that's bound directly to a table and the table has about 25 fields. Now I'd like to detect when the user makes a change to a record and simply log the change. For example, if they...

I found this code to embed one email in an outlook email using VB or VBA. http://www.outlookcode.com/d/code/htmlimg.htm I also found this discussion but it didn't help me out very much since I could find the complete code anywhere as a final solution...

I've figured out how to reposition an Access form but I have a new problem. I have one form I'm using mostly for testing right now. When the user closes it, I'm saving the width, height, top, and left, so I can position it at the same place the next time they open the form. However, if the...

We have a timeclock application shared out on our network. The backend is a 2002/2003 .mdb file stored on our file server with very liberal permissions set on the share. If more than one user has a bound form open then bound forms take 5 to 15 seconds to open for all users. Also, if one user...

Is there a simple way to have the background color change on a textbox when the user enters it and change back to default when he exits it? The only solutions I've come up with so far mean that I have to call a sub or function on_enter and on_exit, or else use a form timer. Is there some way I...

I'm working on building a system that will allow me to close a user's database. We have too much trouble with users leaving databases open overnight. 1) Does anyone have a suggestion how to do this or a method they have tried that worked or didn't work? 2) Would it be possible for me to design...

I'm getting multiple entries for one computer in my .ldb file. The best guess I've come up with so far is that this occurs when a machine/user runs compact and repair on it's frontend file while others are using the database. The only way to resolve this problem is to have everyone get out of...