Search results

The attached database is intended to manage recurring tasks for a group. I am having a problem with one of the Event Procedures. On the "Task Form" form, there is a button at the bottom of the form called "Mark Task Completed". When a date is entered and this button pushed, I am trying to...

Never mind. I found the problem. Someone had unchecked "Allow Default Shortcuts" in Access Options. Thanks, Jim

I inherited a 2007 Access Database. Somehow the "right click" function has been disabled. I can get into design view, but even there right click is disabled. Any ideas what I should look for to turn this feature back on? Thanks as always, Jim

See attached image. I have a form created in Access 2007. When I open one of the forms, one of the fields will show a white background until I move my cursor inside the Reports section of the form then the background turns transparent. I have the Back Style as Normal and the Back Color as...

In a database I have a field for Name. I need for the field to contain both the first and last names. I enter the data like this - Dean John. I tried using a comma in between but Access does not like this. I have a form based on a query to launch a report. The query looks for the contents...

I still have this problem. Both the field and the Details section is set to "can grow". Any help is appreciated. Jim

I have a report based on a query that is linked to an SQL database. One of the fields normally contains a lot of text so I set the properties of the report field to "Can Grow". Problem is, it only grows some and never grows to include all the text. I looked at the query and it is showing all...

I have a form that I want to show "Record _ of __". I am using the code below in the Control Source of a text field. My question is how do I get it to update as I add records? =IIf([CurrentRecord]>(Count(*)),'New Record',('Record ' & [CurrentRecord] & ' of ' & Count(*))) Thanks, Jim

I am not trying to use Cascading Combo Boxes. I just want the combo boxes to work together to remember their settings. Would it work if I added the filter code for all 3 combo boxes to each combo box? See Code: If IsNull(Me.cbo_StatusComboBox) Then Me.FilterOn = False Else...

I'm sorry, I was referring to the form that "Manage Log Items" button brings up. The form name is frm_Data. Thanks, Jim

I resolved problem #1 by adding the following code to the OnLoad event If IsNull(Me.cbo_StatusComboBox) Then Me.FilterOn = False Else Me.Filter = "Status = """ & Me.cbo_StatusComboBox & """" Me.FilterOn = True End If I still have Problem #2. Again on my form...

I have a form [frmData] that has 3 combo boxs (cboStatus, cboCommittment and cboAssignedTo). Once the user selects the status, I am using an After Update Event to update the records showing. Here are my problems. 1. I have the default value for cboStatus to "Open" but the report when opened...

Sorry it took a while to get back (holidays and illness). When I try what you suggest it say it's an invalid field. See attachment for where I am currently. Thanks as always, Jim

Formula? Do you mean the Criteria field in the Query? Remember I am importing the Date / Time from data in an SQL database. I am not using a formula to create the date. Thanks for the clarification. Jim

Is this put into the format of the data field or the query?

I have a form that has a number of date fields. The data is imported from an SQL database locally. The data imported includes the date and time. However I am only interested in the date, not the time. I also have fields on my form that display the calculate the differnce between the dates...

The Data Type is Text. In the query that the report is based on, I am using * as a wild card with no problem. I am using Like "*1*" in the query. Attached is another image of my report in design view showing the field properties and the conditional formatting properties. Do you see anything...

I was curious so I created a local database and report. It works fine in that database. The only difference I can think of is where the data is stored but I am unsure why that would make a difference. I will continue looking at this tomorrow.

The report I have pulls data from an SQL database, not Access. Let me put together a sample using local data and see if that works. It will be tomorrow before I can do that. Do you want me to post it here or email to you? Thanks for your effort.

Not sure. Your example is in a form and mine is in a report, but that should not make a difference. See attached image. Am I missing somethign? I really appreciate the help.