Search results

We would like on the "Match:" subset the default to be "Any Part of Field" is that possible? Russ

An Access-Developer from another dept. stopped by this morning and said the DLookup would work but recommended a sub-form within the tab for getting the fields from the other DB. Two advantages: 1) less coding per field within the field properties 2) smooth process, efficiency wise, the...

Re: one form two sources help needed -working so far This is a real tricky and a pain to put in for every field. I have i going so far. =DLookUp("[Employer Name]","Tbl403bCAPSLlink","[Remitter/ Plan Number]='" & [PLAN_NO] & "'") Russ - now at RMneuman @ lfg.com

Re: one form two sources help needed - Solved! Paul - Thx for your good help, repetitively. Russ - I will probably have a follow-up on this one. That is how to use the field-Plan-id from above in the form, putting in the query as a parameter to load data into this field. - I figured...

The field displays #error now. I think I put the code you suggested in the right place. See the attached. Thx Russ

i have a Form with a data source for most the fields on the form. But I need to bring in values from another table and I am having trouble getting the right syntax. This is what I have now: Employer Name «Expr» [QryCAPSLlink]![Employer Name] The query is just pulling one record. <<Code>>...

Can you have both - if so what is the format? Thx RUss

Some of my form screens are poping up slow. So, I did the performance analysis . It came back that a batch of my forms to "Use an Option Explicit statement". How do i do this? These forms do not have macro code, they do have queries only. Thx Russ

All I needed was the: " & Me.ClientSelectBox & " I must be a sequence thing. That it was updating the table field Clientid and then some since the field name in the table was Clientid and there was a Clientid in the ClientSelectBox there was a match and that field from the ClientSelectBox was...

Re: Combo Box field selection help needed -opps closer not there yet sorry on the oversight syntax err still not on this line DoCmd.RunSQL (sql)

Syntax error on this line: combovalue = Me!ClientID.Column(0) combovalue = Me!ClientID.Column(0) If rs!Inactive = False Then sql = ("insert into TicklerData(TicklerID,ClientID,FSWID,Item,Due,Sort Order) values (" & maxid & "," & combovalue & "," & Me!FSWID & ",'" & rs![Item] & "','" & DateDue...

run-time error occured

I have a couple comboxes on the form. I cannot get the highlight value to add to the table. It is always the 1st one, even thou I have highlighted a different client. My value for & Me!ClientID & is the 1st one not the highlighted one. My value for & Me!FSWID & is the right one. I need the...

GREAT advice - I am working without a manual intervention. I build the counts into a table. Thx. SELECT WeekBillDraftCntFamiliesPart2Qry.Agency, WeekBillDraftCntFamiliesPart2Qry.FamilyCntNumber INTO weekbillfamilycnts FROM WeekBillDraftCntFamiliesPart2Qry;

Re: "Operation must use updateable query" - ongoing Thank you for the good advice on the names. I have updated the names. The update query is still failing with the error message: "Operation must use updateable query". The query that calculates the numbers that goes into the update query...

I am trying to update counts in a table. But I can not get the update to run. Attached is a snapshot. Thx for any help. Russ code - UPDATE [WeekBill Of Draft Billing query-cnt-families-per-agency2] INNER JOIN [Report-Family-Cnt] ON [WeekBill Of Draft Billing...

Re: the old divide by zero pbl was the root cause the old divide by zero pbl was the root cause I put this code in for a fix: LifeTot2: IIf([LifeTot]>0,[LifeTot],1) It seems to be good, so far. Russ

Re: query has a bad field going into report #error is in the field - i think it goes back to the zero problem divide by zero This formula needs fixed to acount for zero situations. Hmm?

I have a report abending today. The report field causing the abend is "Avg(LF2FP2)" I think the problem is a zero value in the field LF2FP2. Attached is a screen print of the error. I know it is this field because I can remove it and the report works fine. Does anyone have a suggestion...

Re: No Data Event maybe?? - more info More info - This is a billing report. And I only get a once a month complete data load of employees. Then, during the month new people might join. I do activity dumps weekly and if any new employees are added I do not know. Currently, if the...