Search results for query: *

When I changed from Access 2003 to Access 2010, some single forms open with a previous filter so that I always have to click 'Clear all filters' before I can use the form. In Access 2003 it opens without a filter. I cant get the form to open without a filter.

In MS Access I have a 'to-do' table populated with tasks that need to be done throughout the year, and a check box for 'Done'. Right now I use a query that uses julian dates to refer to tasks that have not been done yet in the past 30 days to dates over the next 30 days. In the query I have in...

On an MS Access form, I want the user to be able to select a date from a drop down combo box that shows a range of dates from 10 days before today to 20 days in the future. Right now I have a table that has dates and I use a query that shows only dates that are 10 days before to 20 days after...

I have an unbound form for the user to enter numbers, then they click on a button that updates a table based on those numbers. My problem is that there is an unbound control (text box) formatted as Fixed with 1 decimal place. When I click the button to update the table, the field on the table...

I have an issue with a replicated database where I take field data using the master database on my laptop then synchronize with the replica that is on our server at work and used by several others from the server. The problem seems to be that the references I set on my laptop do not seem to...

I opened a table in Access in design mode and found that one field had "Aen_" before the field name and another case had Gen_Field Name. Does anyone know what this means?

I have a replicated database with several formatted text boxes that work well on the design master but not on the replica. Example 1: On Reports where I inserted a Date text box in the footer. When you open the report on the replica, you get a message, 'Enter Parameter Value' for Date. Example...

I would like to use symbols similar to Consumer Reports for an access report for a ratings table. For example: an open circle, circle with a dot, circle half-black and black circle. Is there any way to make a field that would store a symbol? I would rather not do it by inserting an image

I tried to store the current year as a long integer and it is not working so far. Can someone help me with the correct format? Here is what I did: Dim myear As Long myear = Year(Now())

Is there a way to create a mouse-over event on an Access 2003 form? I would like a popup form to appear when I hold the mouse over a field, then close when the mouse leaves.

Thought this would be simple but cant figure it out: I have a table with fields that represent each year with a number (usually) in each cell. Fields: 2003, 2004, 2005, 2006. I wanted to create a calculated query field that would average those four cells for each record. So I created the field...

I have a routine to update a status field and it needs to be able to run from several different forms when records are updated. Do I put that routine into a Module and call that module from the different forms? If so, what is the wording on the Event Procedure?

Currently, if we want to send the output of a filered form to someone, we Print to CutePDF to create a pdf of the form, then save the pdf to a folder, then open Outlook and attach the pdf. My users want to be able to filter a form to the information they want, then click a button to open Outlook...

I have a hyperlink field and the user has to right-click and select Edit Hyperlink then browse to the file to insert a link. Could someone tell me the code to use if I want to have a Double-Click Event to Edit Hyperlink. Also is there a way to specify a folder to automatically browse to?

I have a form that shows 112 records (based on a query) but I want the user to be able to 'view all records' or just the normal 112 records. Is it best to use a button? and what is the code I use for the button event?

I have a control, 'Combo1' with an On-Update event that runs when the user enters something. But another control, 'Combo2' has an On-Update that changes Combo1. How can I force the Combo1 event to occur when Combo1 is updated by Combo2?

I want to be able to double-click on a field in a subform to open a popup form who's query is based on that subform. But I dont know the proper syntax for the query's criteria. If I wanted to reference the Main form I would use this for the criteria: >[Forms]![EVALCURRENTSINGLE]![Ripe]-7 And...

I would like to have a text box that would display "07" in 2007 and "08" in 2008, etc. I though I could simply have =Year(Now()) formatted yy. But that doesnt work. I know that if you were to format Now() as mm/dd/yy it would show the year as "07" but you would have the rest of the date as well...

I have a main form and a subform. I want to move to a specific record in the Main form when I click on the field 'Name' in the subform, but when I do I get the message, "Not a valid bookmark". Here is the event that runs in the subform when you double-click on the 'Name' field: Dim Main As...

Can someone tell me the proper code for putting a "Where" clause onto this: Dim md As DAO.Recordset Set md = CurrentDb.OpenRecordset("MDQuarantineShipmentID") I would like the dataset to include only those records Where MDQuarantineShipmentID!ShipmentID = Me!ShipmentID. And ShipmentID is an...