Hello, I had some forms showing data from an Access 2003 database and doing some calculations as the number of records or the sum of an amount. Now the data is...
Valentin- What are the calculations? What is the Record Source of the Form (the SQL)? Do you have indexes defined on the criteria fields used to pluck 4,000...
John, the calculations are like this "=Sum(IIf([FG-Colect]="O";1;0))" in a form control. I have six similar calculation in the header of the same form which ...
Valentin- It sounds like JET is fetching all the rows and applying the filters for year and month locally. The form without the calculations will probably ...
I am wanting to upload files by ftp transfer, and send links by http and receive the result into a string, from vba. Is there a source of information on how to...
Might I also suggest that is the data does not have to be modified by the user that you use a view with SQL in-line functions. That would put the calculations ...
I know we are doing something wrong when we have 11 distinct DBs. Yet due to fear of corruption it happened that way. I'd like to condense into one DB but...
Hello, it's me again. I have gotten the search from to work by responding to specific error #'s. Now I am working with a form that I used to either add new...
Shelly, this sounds like something we may be able to help with it looks like you are trying to understand a back end front end solution. I am assuming that all...
When I had to do this many moons ago, I found a scripting language happenned to come along with my Ftp client. It was so cool I used it all the time with the...
Well the brass is committed to spending money to keep a zip/city/stat list updated, so you can pick the zip and the city and state is filled in. I am having...
Jessica Yes, you can test for DataEntry mode like this: Private Sub Form_Load() Me.cmdGo.Visible = (Me.DataEntry = True) End Sub In this case, if the form has...
Hi everyone! Got a project that I need to import a text file using spaces to separate the data. I can then manipulate as needed to clean the data up. The...
Thanks!!!! I knew that is was something simple, I just didn't know where to start looking on my own. One of these days I will remember what stuff is called,...
You have to create an Import Spec first. Import the text file manually to set up the spec the first time. When you get to the import wizard with the different ...
Over the long run is it faster to store the city and zip as well as the zip in a table, or use the stored zip to query the city and state? ... zip/city/stat ...
You're welcome, Jessica. Glad I could help. Bill _____ From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf...
Bill, That is beautiful indeed! Best wishes, A.D.Tejpal ... From: Bill Mosca To: MS_Access_Professionals@yahoogroups.com Sent: Tuesday, August 01, 2006 23:53 ...
Jessica You need to completely understand about ZIP codes or you might run into trouble. A ZIP-to-City relationship can be a 1-to-many or a many-to-1. More...
A.D. That's one of those "maybe-I-better-test-before-I-post" responses. Since I don't use the Switchboard wizard, I wasn't sure if it would work until I ran a...
I know about that issue, I brought it up and the brass didn't care. So when we run into that, I get an "I told you so" because they bought something before...
I'm like most people; I use wizards to start and after I understand what they are doing, I stop using them. I have the gist of what a switchboard does, but I...
I'm running out of time here. Maybe someone else can jump in. But I would create a separate table for tower-ZIP, using ZIP as a foreign key to your ZIP table...
Hi all, Is it possible to create a new blank database with all table structures and relationships by VBA code? My new task is to create a button "create new...
Hi all, I've searched through threads on form sizes, but none seem to help me, if i can even be helped. ok, all of the main forms on my database open...
Jessica Your approach is a good one. Seeing what wizards do as far as code is a good way to learn. Once you get that stuff done, you'll want to go beyond it to...
Looks like I found my answer to how to use the zip to assign cit & state. I am planning to use unbound combo boxes to make them show up (I need city and state...
If the structure of the new database will always be the same just create an empty copy and copy it to the new location. Even if they are not, if they are close...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
