Search results

Hi Bob, I know posting my DB would be helpful, but I can't post any of it due to security reasons. I posted the query criteria (see above) I used in some of my queries. Does that help diagnose the problem? -tungkee

There is definitely something wrong with Access in this regard.... I opened my table and filtered the "Opened date" field using predefined filters Access offers. I select the field "Opened Date"-->Date Filters-->Last week from the drop down menu, and nothing is returned although there are...

Thanks for the quick reply Bob. You may be right. My query uses the following to search on the previous week: Year([Opened Date])* 53 + DatePart("ww", [Opened Date]) = Year(Date())* 53 + DatePart("ww", Date()) - 1 I got that directly from the Microsoft Access website here...

I have a report set to return a list of items that were opened last week. It has been working flawlessly until this morning 1/2/08. I ran the report which should have returned new opened items from 12/23 - 12/29, but doesn't return anything.. I suspect this is happening because of the change...

Thanks Craig that works. I tried something similar but not exactly that... Thanks Again!

Craig, Any chance you know how to return the name of last month? For example, if I run the report today, I want the title of the report to say something like "Items from the month of November". I tried the following expression, but that returns the date a month ago...

Well then... It looks like I'll have to adopt your ways. Thanks again, -tungkee

Thanks Craigdolphin... That is EXACTLY what I was looking for. BTW, how did you get so good at expressions? I would have been stuck had it not been for you and this forum. -tungkee

I'm assuming that DateAdd is a field that you assume is in my table. In that case I'd use my Date Opened field. But is there a way to do this without referencing any fields? BTW the expression didn't work for me. I kept getting a, "The expression you entered contains invalid syntax. You...

That was something I contemplated, but thats almost the same thing as manually typing the date period each time I run the report. I need something more self sufficient. An expression that will just automatically return last week's date period without me doing anything.

The report already returns the information needed from the previous week. What I'd like is for the title of my report to list the date period for the previous week. So for example, if I run a report today (12/18/07), the report will return last week's items. The title of the report should...

I've created a report, which I can run any day of the week, and it will return new items from last week. I'd like the report to have the date period for the previous week but this needs to be dynamic. For example, if I run the report today (12/18/07), the report title should have the date...

I haven't seen anyone run into this particular problem on this forum... I'm importing data from an excel spreadsheet to an MS Access (2007) table. One of the fields in the table is a text memo field able to support more than 255 characters... Issue: The issue is that any cell in Excel that...

Hi, The MS Access file I am using is a .accdb file, not .mdb. This is where I may be on the wrong page. When I navigate to the Design View, and click on Properties, I then click on "all" to show everything... When I click on Visible, I am not given the option to type anything. It's as if the...

In fact, I can't seem to do anything in the Properties window pane. I set my form view to design view, and then click on the properties icon.. In the Properties window pane, there are a bunch of stuff that I can't seem to do anything with... -Tungkee

I have records in my database, so that's not the problem. I don't know how to set the Detail properties for visible to yes... In the properties window pane, there is Visible, with no option to do anything with it. When I click on code view, and then select the detail section, Visible is set to...

I wasn't able to find anything similar to my problem using the search so any help is greatly appreciated... I've spent hours working on perfecting my form, but for some reason when I view the form in "Form View", only the header and footer show. When I click to view it in Design View, all my...