Search results

From VBA Help:

I recently decided to split my database into a front end/back end environment. What I noticed though was a huge slow down in performance. One subform in particular takes 5-8 seconds to load, as opposed to less than a second before the split. I know that splitting the database comes highly...

I really appreciate the link. The article was very interesting. I have already replaced every instance of Round() in my code. I'm still not sure why I would get one result in the intermediate window and a different result in the query, but I do think I can safely chalk it up to the rounding...

You might look into replicating the database. I have never actually setup a database for replication, but I think it was designed to what you want. The drawback would be that the whole database would be copied and depending on how large it is, that could be problematic. The only problem I...

I came across something I don't understand. I think I could work around it, but I don't understand what is going on. I create a function to round a given number to the nearest fifth: Function RoundToFifth(dblNumber As Double) As Single Dim intNumber As Integer Dim dblRemainder As...

Sorry for the delay in response. No. It did not work.

Rich, what you typed was a little backwards from what I was looking to do. Form1 is attempting to save the current record on Form2 if Form2 is loaded and is dirty. So what I want to do is initiate the following when a button is pressed/depressed on Form1, If IsLoaded(Form2) then If...

The alternative runcommand did not work when I checked it. It's ashame that there isn't a built in access command to save the current record on a specified form.

SJ McAbney, I tried breaking out the code that runs on Exit in a separate procedure; but I'm still left with the same anomolies. Really my whole problem boils down to Access not wanting to switch records simutaneously with running code On_Exit of the active field. I could fix the problem...

I just did a quick search on the site on rs.close and memory. I found the following on this post: http://www.access-programmers.co.uk/forums/showthread.php?t=63083&highlight=memory+rs.close It would appear that rs.close does not free the memory, but it is the other way around. Which actually...

I work with recordsetclones quite frequently, and the syntax is correct. There might be alternative ways to reference it, but the syntax I chose is the same syntax access generates when dealing with recordsets in the wizard for creating code to lookup a record on a form. I don't need the...

I don't know if I explained my issue in enough detail. Form1 actually makes updates to Form2. Form2 is a time log, and one of the things it records is activity that takes place on Form1. When certain things happen on Form1, I automatically make entries on the time log. People can also type...

I have multiple forms open that are working in conjunction. A button click on Form1 will either create a new record or update a field in a particular record on Form2 (Form2 is a continuous form). I then reflect these changes by requerying Form2. My problem is that if a user is editing Form2...

Unfortunately it wasn't, but I do appreciate your taking the time to respond. I tried the resume next code, but then it just didn't do what it was supposed to do. Something about the code breaking and then resuming, caused it to work. I just put in a cheap workaround when the cursor is in one...

I originally began this question under a different thread, but I ended up answering my question and then coming up with a new one that is not necessarily related. I thought it would be best to just start a new thread. I have written code that overtakes the up and down records to move between...

Forgive my stupidity.... Screen.ActiveControl.Name

I was reading this thread, and I need to do something similar; but not quite the same. I have implemented code, that overtakes the Up and Down arrows to actually move up and down on my form. This works fine. However, I have two fields that are running code when the user exits the field...

I believe I have ran across a method of doing what I am looking to do before, but I cannot seem to find it anywhere. I want to query for similar words. I thought I had seen an expression that would allow you to retrieve entries that were 80% similar, etc. I may have dreamed it. If anyone...

Pat Hartman gives the following link www.databasecreations.com in this post: http://www.access-programmers.co.uk/forums/showthread.php?t=63838&highlight=quickbooks. This might be what you are looking for.

I have never had the problems you experience with Excel, but I have a guess as to what might be going on. Review the basic code I use to interact with Excel. The comments I have included point to the items that I think might produce the problems you mentioned. Dim wsFax As...