Search results

The DB that has this issue is NOT split. I work on this DB for updates and then move it and split it. So this issue is happening before I split. I've made some mod's to it but nothing big, just a new form and a few queries and reports. I am running the same DB on another network and its split...

No, this seemed to come out of no where. The issue is every time I click in a field I have to wait about 8 seconds to click to the next field. I've seen online others having this issue but haven't found anyone that can answer why its happening.

Recently my database has now begun to show "calculating..." in the lower left corner. Every time I click on any field on any form it does this. Any idea why this started all of a sudden?

Pat, Thank you, this is exactly what I was looking for. You told me this in the beginning of this thread but it didn't seem to make sense. After you explained again it worked. Thanks for your help along with all the others that contributed!

Hello, thanks for responding to my question. I want to maybe simplify this request. All I need is to have my combo locked at all times, when its blank, when its populated, all the time. What I would to do when I come to a new record is have the ability to click a button and make my selection...

This is the code i have in the button on the "On click" event. Where would I insert

Hello, I have been searching online for ever trying to find some thing that will work for my issue. 1. I have a combobox set up on a form with a list to choose from. . 2. When the user comes to a new record, the combobox would be blank. 3. I have set the properties to "Enabled NO". 4. I...

Thanks arnelgp! I used option 2. I believe this will be the best option for my application. Thanks again for your help along with all the others as well! There some great people out there!

The Doc Man, thanks for responding. This is a bound field so using Bob's expression would not work in this case unless I unbound, which is a possibility if I can't find another way to to do this. Do you have another way the will just auto fill the field and allow it to be saved in my table...

Hello, I am trying to find a way to have one field match another field on a form either by conditional formatting or some other way. I have one field where i enter an appointment date [txtOLConedate]. I have another field that I would like to show the appointment date 7 days before. This field...

After hours of searching, I can't find how to make a multi parameter criteria form. I found info on how to work with dates but not names or numbers. I want to be able to open a form and have a pop up window ask "Who do you want to research?" and then another window pop up and ask "Which...

Hello jdraw, To answer your question about stepping back and really seeing what the bigger picture is, the answer is yes. We all know we have a bigger problem with the process flow. I am tasked with trying to remove some bumps in the road and still try to kepp things moving. I created a...

jdraw, Thank you for building that DB! It has been the closest locator tool I've seen so far. That said, I attached a sample file that I need to load into the DB every Monday. The vehicles are constantly changing and the data in the DB must change with it. This DB will just be used to locate the...

Right now I use an excel spreadsheet to do calculations. On one sheet I have a list of all zip codes in the country in one column and then the coords in the 2 columns next to it.. On another sheet I have my data which shows all the vehicles which includes addresses and zip codes. On the data...

Yes I found that tread as well but it has to do with adding 2 zip codes to determine the distance. I have a DB with zip codes of vehicles around the country. I want a to put a combo box on to a form which has a drop down of every zip code in the country then select or type the zip for the area I...

Thank you Gasman. I inserted the expression into the criteria area in the [storage lat] field and i am still getting syntax errors. I made sure that every character is correct as well. Any idea's? Also I would rather do relationship joining but I'm new to access and can't see how this can be...

Looking for help on a dlookup expression. I created a query named "qry idle" that has a list of addresses for various vehicles around the country. I have another query named "qry Zip Codes" with all the zip codes in the U.S. along with the coordinates for each zip code. In the "qry idle", I...

Who uses this? A customer calls and asks for a vehicle. I would look to see what vehicle is the closest to them with this tool. I would verbally share what have for options to the customer. Once they chose a vehicle I would basically take the VIN number and go to another system I use and send...

I need to see what vehicles are the closest to the location where the customer needs a vehicle and then also choose a certain type of vehicle. Some times a car is needed and other times a pickup or semi truck. What works best is to see the closest vehicle at the top of the list and then I can...

I opened that DB in your post reference. It's an incredible tool! Maybe I'm missing it but I don't see how that would work for my scenario. That DB wants 2 zip codes to determine distance. I need to have 1 field that I can insert a zip code for where the vehicle is needed, then have a query or...