Search results

An all in one parameter query possible? I would like to use a default report to display results of a users search. On a form, a combo box would allow selection from one of several values, dealer#, invoice#, reference#…etc…of course these fields would appear on my report. After a user selection...

hi Alex, I’m good, how about you? Hope things are ok. I’ll try and get back to you on this on Monday, it’s the weekend y’know?

this users short date format is dd/mm/yy under the regional settings date tab, would that be causing it? should i request a change to mm/dd/yy?

I’m using 2 objects in the query, a table and a separate query. The table is a left join to the query based on a the Type in my chart above. The problem at this point is that if I group by Type, Month, and then Director….my repeating data starts. The I get all the months all the types and all...

cannot get query results right I have a main query with my transaction data. Transaction are separated into 2 types. I am trying to get a report that lists, by type, every month and the totals of the transaction data per Director, for that month. So my query ought to look like this: Type...

1 mde form shows 2 diff date formats for users My .mde front end improperly formats a date from mm/dd/yy formate to dd/mm/yy format for one of my users. They’re pulling the .mde off the suerver which is slow I know, but when I try to see the problems using the same file, the formatting is fine...

9/14/01 my users have all of their startup options stripped in my system, but I’d like them to be able to right click on a report and have a menu popup that will allow them to print the report. What should I be looking at?

well Charity i'm trying something else right now in case of future I need to lock something else, so rather than hard coding 4 control names I wrote function to lock any control I pass as a parameter. Here’s the current event of the form: Private Sub Form_Current() 'determine the region...

in my form I’ve managed to lock a group of fields based on their tag property. But since some of these controls need to be unlocked (based on the user) I’m having difficulty working around that. What property could I use other than the tag property to go back & open a few of them. I’d written...

is a pop up box required? On my data entry form I’d like a notesButton to open a popup text box that when closed will save data for the record to a notes field. I’ve never used pop ups & have no idea if this is what I should be using for this scenario.

ok this works better as query criteria but I’m trying to get it to work for more than just one true criteria (7) IIf([PromotionType]="be" And [Manager]![Code]=1203,7 ) How might I get the equivalent of something like: IIf([PromotionType]="be" And [Manager]![Code]=1203,7 and 14 and 15 ) ?

I created a report based on a query but must further restrict the report results. I’ve got 2 grouping levels & then in my detail section I tried inputing a series of if-then loops that verify what values are contained in the group & then exit the detail section if the record contains certain...

i find that when i write several trailing periods (...) in my memo field they're not saved as such. could someone explain why not and if there's anyway around it?

compile error in hidden module now that I’m trying to test out my workgroup security I’m getting an error on my data entry forms that their hidden form modules have compile errors. This ought not be happening as I’ve applied front end & back end security that will allow users to use the forms...

I.T. was working on my profile & the dbase in particular at the time, once they were done everything went back to normal.

Mystery error – report not showing query builder behind report When I click on the record source of my report it is only showing the sql view of it, its not showing the query grid I used to create it from. This has just started, and this report is no longer displaying itself in print peview or...

report grouped by month is skipping months My report is grouped by month but is skipping some months altogether, as they do not appear in my tables as data. I’m interested then in providing some sort of code (I’m assuming) behind my groups that will determine if a month is missing & then print...

ok I fixed my problem people, I was improperly filling out my function! Thanks so much!

Some of the totals in my column show up as blank & others show #Num! or #Div/0! When I use the suggested NZ( FieldA,0) to remove the errors, the ONLY fields receiving a 0 are the totals that initially were coming up completely blank. My #Num! and #Div/0! Errors have not changed for the other values.

My report is coming up with a smattering of #Num! And #Div/0 errors, sometimes both in the same column in my report. I have 3 levels of grouping so far, byDirector, byMediaEndDate & then a grandTotal. These errors appear in all these headers. I’d like to write some code that will format a...