Search results

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?

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

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

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

I am trying to write a basic dlookup expression in a query. The lookup will look at In the query it will look in [tbl Idle Vehicles] in column [GARAGING ZIP / POSTAL CODE] to match what's in [tbl Zip Code Data] in column [zip_code]. This seems to be an easy lookup but I can't get this work...

Hello, I wrote this code but doesn't seem to work. I have a combobox (Combo565) that has a drop down list. I also have a check box (LetterRecieved) on a form. I am trying to lock down the combo box when value "3. Oracle Order Sent" and the check box is NOT checked. Once the user receives the...

I have found a ton of requests for this issue online but none of them seem to work. I am simply trying to lock a field after the user inputs a date into a field on my form. Below is some code I found from another thread from years ago that seemed to work for the person that requested it but...

Hello, I am trying to conditionally format a field on my form. This what I wrote so far. <code> (([OXI Install Date]-Now()) And [Integration Status]="Oracle Order Sent") Between 22 And 13<code/> I am trying to make the "OXI Install Date" field change to red when the current date reaches 21 days...

I have spent hours trying to find out how to change the path to a spreadsheet that I have linked with a DB in access 2010. Either its impossible or no one has ever had this problem. I used the DB wizard to create a new DB. I chose to link the DB to my excel spreadsheet in My Documents folder...

I built a form for about 25 people to use. Once a certain process is complete in a record, the user must find the record and then select a date from a list of available dates. Each day there would be 5 open slots, only Mon, Tues, Wed, and Thurs. I am looking for a way to create a field that the...

I am trying to add a sub-form to an existing form and I have a pop up that says... "The code contains a syntax error, or a Microsoft Access function you need is not available." Has anyone seen this before and any ideas how to fix it?

I'm new to Access 2010. I created a imported DB and then created a form which works fine but after realizing that the DB does not allow formulas in them, the imported DB will not work. I built the DB in excel and some of the columns have formulas in them, such as "if C2 = "sales" then return...

Hello, I'm brand new at using Access and using runtime. I installed runtime on a pc that does not have the full version of Access just to see how the program looks and works. I saved the DB (accdb file) to the desktop first then double clicked the file and runtime opened with a warning saying...