Search results

MLILLEY - Thanks so much for your response! I put that code into the On Load property, but I'm now getting the error, "Cannot Add or change records because a related record is required in the Customers table." I have the CustomerID as the primary key, AutoNumber in the Customer table, and as...

I'm having this same issue. I switched Data Entry to Yes, and am now coming into a blank record; however, it's still saying 1 of 1. I want it to say 4 of 4, or 5 of 5, whichever number the new record represents. Also, I want to be able to use the record arrow buttons to click to previous...

O.K. - I know this sounds stupid, but when I scroll down my form in Form View, it's not a "clear scroll". Everything is flashing very fast, and you really can't make out the text as you scroll. Any ideas on what might be going on? Thanks

Richie - Thank you SO much!! It worked - But now I've got a different problem! That control is for numerous products, as each product is a record that displays on the form. (You access the different records by arrow buttons, so that only one product displays at a time). I only want this to...

Here's my daily dilemma: I want a Message Macro to display when one of my product's (Quick Start Cards) Units Available drops below 11. So I wrote a Message Macro with the following expressions in the Condition field: [Forms]![Products]![ProductDescription] In ("Quick Reference Card - Up &...

I know this isn't an Access issue. I've posted it on the Excel page, which doesn't seem to get much traffic, so I thought maybe someone here might have an answer: Some time ago I was messing around with macros in a couple of my worksheets. I've since deleted them, but every time I open these...

I have a report that contains multiple subreports. My report is fine to begin with, then I go into Design view, and put a report footer in the first subreport. Then I switch back to Layout view. My subreports are then all screwed up. The data from my last report has now replaced the data in...