Search results
-
J
Enter StartDate and EndDate 9 times
Hey Smart, Tried it, but I get a run time error from a code that I have to determine the bonuses in the report. A Run Time Error that I never had before, I previewed the report before. What triggers this Error, is it the from? I cannot attach the example file as this is to large (843 kb). But... -
J
Enter StartDate and EndDate 9 times
I have a report, based on 2 queries. As you can see in the attachment I have ShopID header, and a report is mostly reporting for 8-9 shops. In that specific query I entered: Between [StartDate] and [EndDate]. The annoying thing is, every time I create a report, it asks me for the StartDate... -
J
Now () when adding (form), in a table NOW () must 'freeze'
When I add something in a table using a form, I always want an automatic date, namely today's date. So I set this in the form with NOW (). The only thing is, when I view my records a day later, it automatically adjusts the dates. I don't want to type in the date every time, because it's always... -
J
Changing list content
I have 3 tables in my database; 1) Policies, 2) Salespeople and 3) Shops. We have a several shops, and each shop has their own salespeople. In the table Policies we have to select the shop where the policy is sold, but also the salesperson that made that sale. As soon as we receive a policy from...