Search results

Is this form bound or unbound? In other words, does it store the record automatically when you leave the form, or do you have code that stores everything for you when you push a button to 'confirm', etc? The usual method is bound forms, but it affects the answer/solution. Also, will all...

Yeah, having to rely on tables from other applications is a pain...

Did you delete a thread about this from earlier today? I swear I answered this one already... Anyway, we need a little more information to help you. In particular, what do you want to do with the 'remainder' of a bill - if the total is $250.76 and there were ten diners, who gets to pay for the...

That's a Continuous Form, which Mihail offered you about 13 posts ago. Size it so you get six records on the same screen. Understand that this will not let you ENTER all six simultaneously (though you can flip between them at will). If you think you need to do that, I suspect you need to...

You can consider the subform to be a complex 'control', especially if it only contains one field. Subforms give you flexibility and leverage the strengths of a relational database - i.e. connecting one-to-many in this situation. Why might you not have control over your tables?? Don't let other...

A mockup we can look at (critique) sounds best. The line " I'm wanting to have the same information entered/stored in the table exactly over and over again." concerns me because it sounds like your data tables are not set up correctly for a relational database. Have you learned about...

Welcome and good luck!~

Yup. Since you had "0" in your example I figured you were using a string variable for some reason. Glad you got it working!

Stupid question, but does your report have WorkID as a control in it? It's not enough that it be in the recordsource, it needs to be on the report... though you can set it to .Visible = False if you want.

Generally when I want to do this sort of reporting, I build a popup form with two unbound date fields on it. Then I build a query/report/form/whatever that points to those two fields for its Criteria (>= the left one, <= the right one, etc... remember to account for 'time' if these are not pure...

Your question still does not make sense. What is the purpose of entering six (identical?) records at once? Have you tried a Continuous form, like Mihail suggested? In what way does that not meet your needs? Help us help you. Be specific and concrete.

What is the purpose behind storing the calculated value, versus just putting it in a query?

IIF already has an Else clause. http://office.microsoft.com/en-us/access-help/iif-function-HA001228853.aspx You can do ANDs with parentheses. So probably something like:Total_Cost: IIF(([Canceled]="-1" AND [Paid]="0"),"0",Sum( insert calculation here))

This is called Pascal's Wager, and it breaks down the instant you realize that somebody ELSE's God might be right. http://www.iep.utm.edu/pasc-wag/#H3

What error message does it given when it stops? What happens when you hover over the CustID and rs!CustID in that screen? Do the values there make sense? Also hover the variable a just for fun...

Can you open the database on that PC in developer mode, add a breakpoint, and step through your code? Do you know at what point it freezes (switchboard load, first saved record, etc? I've had that happen a few times when some bad reference or whatever hits my code...

I love that this is flagged [SOLVED]... :p You greeted everybody, that quickly? Well done, and welcome!

Especially since you've already gone to the effort of setting up the API call.

Post back if you need help, but it worked on a copy of your data for me, even when things weren't exactly spaced always exactly the same...

Yes, much clearer, thanks! :) Unfortunately while I know what you want to do IS possible, I am not at all sure what the best way to do it is, so I'll leave that to others... my method would involve abusing recordsets and arrays a great deal, but that's because this week I am working primarily...