Search results

thank you it worked.

Hi, I have a report set up to print in landscape format, and it works in Access. When you export it into PDF format from the Report View(i have a pdf icon for users to click on to export), the page number in Adobe Reader goes up as the report itself is not displayed in landscape format as...

Hi, Is there a way to get a report to show dates in a fiscal year format? A fiscal year is April 1st to March 31st. right now users apply filters directly in the report. So they right click on a date field and pick "this year" from the selection. The report, however, filter results in a...

Hi, I attached a screenshot of the report in design. It seems I have everything you specified. The total still shows the record total instead of a count of fee_num. Thank you

Hi, I have a report that has two levels of information. Is there any way to count the first column distinctively? Please see the example below: 00001 abc cde erd Right now, it's counting 3 records of 00001 instead of 1. I want it to show 1 on the report to...

Hi, Just a quick question about the embedded objects in Access. i'm using Access 2007. When I insert an embedded object, is there a way to give the newly embedded object a new name? When I embed a word doc, it will say..."MS word document". when I embed an image, it will say "bitmap...

Hi, My database is split into front and backend. The way it's set up is that there are two front end copies. One for the administrator and one for the general users. There are multiple general users. When two general user's copies are opened, any changes made to the database by anyone...

Hi, sorry I wasn't clear in my post early.I meant that when I ran the query, it still shows the records that contains an empty date, and this is not desirable. However, I seem to have fixed the problem by changing "is not null" into "is null" in the OR criteria. It works this way. If you...

Hi, I have a memo field to be displayed on the report, and it contains the history. If the history gets huge down the road, will the report contain all the texts in the memo field? If I set the Grow property to "yes", will that do the trick? Thank you

I put it in the Criteria

Hi, I'm making a reports that pull records previously(say...in the last 1000 days) I have also attached a test database. I am having trouble with the query. The following codes doesn't seem to accommodate the situation where a cell with empty date is there for a record, as you can see in the...

Hi, I have a parameter query that works on a form. Users user the form to pass the paramter to get the results. It's a contain function.. Like "*" & [Forms]![Parameter search on lab]![Text0] & "*" When run, it keeps saying invalid bracketing. I also try to delete extra brackets, but no...

Hi, I'm testing out a db design where there is a subform that is based on the junction record table(so it's a m:m relationship).three tables in total, lab, test approval and record. PLease see the attached. Only 3 records, but the subform won't show the relationship between the two...

Great I will make the changes accordingly. Thanks.

hi Bob, could you please help me with this one? Please see the attached I have followed the steps above, but I keep getting no results on my report. The operation status is the look up in this case. However, it keep saying the expression is typed in incorrectly, or the expression is too complex...

Hi, I have a test database. In the database, three tables in total. Lab, scs and record. I also have a form from which query parameters can be passed. On the form there are only two combo boxes as you can see. When I run the query and produce the report, Access is saying that the...

Hi, I think I have been struggling with this for so long. In the attached database, there are only less than 5 records, but I'm trying to find out why this field won't fill itself as you pick from master table.... 3 tables in total. Lab, test approvals and record table. Reason for 3 tables is...

Thanks for the feedback. I'm not sure how I should make the changes. So in the actual lab table, I should make the CITY as the FK?

Hi, I have a partially working parameter query working, as you can see in the attached database. (only 5 records) The problem seems to be that whenever there is an empty row, the query stops looking further. So in the table, you can see that one of the date cells is left empty intentionally...

Hi, Users would like to do query based on dates. I have been using a filter by form, which works fine. However, when it comes to sorting based on dates, keying in parameters may get time-consuming as users would have to click on "selection" at the top and pick "between..." and specify dates...