Search results

There's probably a better way to do this, but this is what I ended up doing : =IIf([transamt],(Left([balfwd]+Sum([transamt]),(InStr(([balfwd]+Sum([transamt])),"."))-1)) & " DOLLARS AND " & Right((Format([balfwd]+Sum([transamt]),".00")),2) & " CENTS",(Left([balfwd],(InStr(([balfwd]),"."))-1)) &...

My text box has this in the control: =IIf([transamt],Format(([balfwd]+Sum([transamt])),"#") & " DOLLARS AND " & Right((Format([balfwd]+Sum([transamt]),".00")),2) & " CENTS",Format([balfwd],"#") & " DOLLARS AND " & Right((Format([balfwd],".00")),2) & " CENTS") When I test the report, the part...

Try this: =IIf([RESOURCE TYPE]="EMPLOYEE",([Sum Of BILLABLE HRS]),"No Billable Hours") Iff statements are like saying if this do this else this. Missing the else part could be the problem. Try the above and let me know if it solved your problem. Deb

If you want them one letter on top of each other, put a s p a c e between the letters and adjust the box vertically. It should wrap into one row. Or can do it Illustrator or Photoshop and put it in as an image. Hope that helped. Deb

Hi everyone. I went to this web page and followed the directions, but it does not work: http://www.mvps.org/access/reports/rpt0013.htm I have an unbound textbox in one of the group headers called "GrpPgInd" by grouping field is called "PTNum". I have replaced the code where asked for at...

Sorry - wasnt done... :P Then for example the new column is SumOrders: sum(orders)in your query, Then in your report, SumOrders is in the group footers for each order. Then in the report footer, sum(SumOrders). Deb

Can you put a new column in your query and have a sum of the total orders in the query? Then put that field in the appropriate footer sections? Deb

Sorry - any VBA coding on on format events for group footer that contains the subreport do not work.. if anyone can solve this would be a miracle!

I'm not sure if this is what you want, but if I'm understanding you right, you want a user to type in a date then your query runs based on that date and returns the age. Have you tried to create 2 unbound fields on your form for the user to input a date the other does the calc? You do not need...

Can try this: If it's an unbound field, in the format line, do not pick short date, can type in mm/dd/yyyy or mm/dd/yy. If it's a field bound to a table, you can chose short date then put this formatting in the input mask area of the table def to this: 99/99/00;0 If the form is referenced to...

Think perhaps your assignment tables need a diff primary key. The ssn primary key field in all of your assignment tables should be foreign key fields which link to the student table via the ssn number primary key field in the student table. The primary key field in the assignment tables could...

Thanks -- I will give it a try next week--I never thought of capturing the Windows login id. Deb

Thanks. Split the database...hope you mean load the program on their local drive and place the data on the network. That's what I was planning to do. Let me know if this is wrong. Deb

I'm sorry - I didn't understand.. where would I put the code you had mentioned? In the on format event for the group footer? 'For the header: Me.Section(5).Visible = False 'For the footer: Me.Section(6).Visible = False And will that just make the header and footer not visible? Wouldn't it...

If you can separate it, you can put it back... lets say that field1 changed with this: left([field1],5) That will give you field1 without the bad ending. Try left([field1],5)&"J20L" in your append query - try displaying it first -- it should take the 2 parts and put them together...

You are probably saving the sex answer in a table? If not, you need to have a field called sex in your table. The form needs to be based off of that table. After you do that: 1. Using the toolbox in forms design, click on the drop down tool and place the dropdown box on your form. 2. The...

I had a similar problem with visible=false fields on continuous forms. It cannot be done on CONTINUOUS forms. Every forum I posted this problem on responded with the fact that it just cannot be done correctly in ACCESS or ACCESS vba.

Hi - it looks like my post did not post for some reason - so if it does later, I apologize for a dupe post... I do not want to use ACCESS's built in security to establish user logon id's. I would like the user to type in their "userid" on a main form into a text box. In the after update...

Hi everyone - hope someone can answer this question. I have two reports. An Invoice and a Lien. The Invoice has Patient information in the page header like Patient name, Insurance co name, address, etc. That needs to print on every page of the Patient's invoice. In the detail section of the...