Search results

The control name for the combo box on the form is Owner Name and it is pulling from a query: SELECT [Owner Extended].[Owner Name] FROM [Owner Extended]; The Owner Name is then passed to the report control named Assigned To which is numeric

Your question made me realize that I had a numeric field and that I had it in the wrong place. This is what I have now: stLinkCriteria = "[Assigned To].[ID]=" & "Me![Owner Name]" however when I run it I get asked for the criteria for these two items, which I don't want. I just want it passed...

Hello all, I'm using the code below to filter and open a report in access 2007. When the code fires I get the following error message: Run time error '438': Object doesn't support this property or method. Debug goes the line in bold below. I'm not a VBA coder by an means, so any help would...

I've looked at every post I could find in the forums regarding this, and tried every thing, but I still can't get it to work and it's giving me a headache. All I want to do is make a selection in the combo box and have it open a report filtered based upon the combo box selection. The combo box...

Just shows how much a of a newb I am...didn't even realize you were giving me an example. Tried what said, works like a charm. Thanks!

I'm still using 2007, but doing it in a query should work just as well. My next question is if you don't have a field in a table how can you pull it into a query, i.e., if there's no "date" field in the table, how can you create a "date" field in a query?

I have a table that contains several dates, two of which are an opened and closed date. I currently use datediff to calculate the number of days between those two dates and display that number on a report, but because it's a calculation instead of data in a table I can't sort/search by number...

You do or you don't want to protect the fields. And is it the field you want to protect or the data in the field?

Sounds like ItemNum has a data type of number, but you're using numbers and text. Try changing the data type to text.

Figures it was something right in front of my face. Ugh. Thanks much!

I made one slight change, from Opened Date to Mangement Close Date. =IIf(IsNull([Management Close Date]),DateDiff("d",[Management Close Date],Date()),DateDiff("d",[Opened Date],[Management Close Date])) I only want two scenarios: Management Close Date is Null - datediff between Opened Date and...

Hi all, I've currently got a report that takes two date fields and calculates the number of days between the two dates. The problem I am having is that I need the number of days to be calculated even when the Management Close Date field does not have an actual date entered into it, i.e. it...

I was wondering if it is possible to use a text box to look up data as opposed to a combo box. For some reason when I try to use OpenForm for a click event on a combo box it won't open the form I need to open, but with a text box it works just fine.

I'm trying to get an embedded macro to open a form when the field is clicked. I would think this would be pretty straightforward, but apparently not. The control is a combo box and the onclick event is set for embedded macro. The macro calls OpenForm with the arguments of Reports...

Any other thoughts on this?

At present there's a disconnect between the reports and the issues within the reports. DB1 contains the high level report information while DB2 contains the issues associated with the reports in DB1, but they are not tied together. Tying them together will allow for better reporting on reports...

Hello all, I have two DB's: One that holds reports, the report writer, and other details, and a second DB that hold issues that are associated with the reports, who owns the issue, etc. These were built separately and before my time, and it appears it was done this way because they were trying...

Awesome. Worked like a charm. Thanks!

Hello all, I've got a form with two subforms in it. The main form is named frmReports and the subforms are frmExeceptionsSub and frmResponseSub. When the main form is opened the Exceptions subform will pull in all records relating to the Report identifed in the main form, and the response...

Nope, all of the tables are still there.