Search results

Found it! It was due to the fact my regional settings differ. I changed the"," to ";", and now your formula works like a charm. Thanks plog!

At least the Chimp can upload a screenshot ;-)

Chimp's back again: I zipped and attached a simple database containing only this challenge. When I enter your suggestion: =DCount("Dates1","tbl_Occurrences","[Dates1]=#" & Date() & "#" ) I still get a syntax error?

Hm, I really feel like a chimp with a calculator. I have no understanding of codes in Access, and after some Googling I am assuming I must do the following: - create a Text box in my form - open the property sheet for that box - go to the 'data' tab - on the right of 'Control Source' enter...

Ok, thnx plog! I am going to explore that tomorrow.

Maybe pictures make it more clear what I want to achieve? The first picture would be the table, the second picture is what I would like to have displayed in my form.

Thanks to the support in this forum I am close to finalizing my first database project. For now I have one more question: My database contains a table that has two fields named 'occurance1' and 'occurance2', both containing a range of different dates. In a form I have in that database, I would...

Thnx Bob, this is helping me a lot to understand how this should work. It is working differently than I had in my mind, but that is probably a good thing ;-) I'll see if I can progress from your example and try to get it working the way I would like it to. I noticed you have not setup any...

I think I managed that. But now nothing happens when I select a name from the combobox in the form. Dadgummit, must I really get through all 795 pages of the Access 'bible' that I have, before getting this to work? Calling it a night. (Again :banghead: )

Ok, thnx, I changed that. Can you also help me with how the relations should be setup?

My mind seems not in the right state to comprehend how to make this work. (and maybe there's also a bit too much going on in my life right now) So, I would appreciate it a lot if somebody could show me the way in detail. I attached an extremely simplified database, only containing a very small...

Ah, got it. I was looking for the literal terms you used. I have now set: Criteria: 'Is Not Null' and it seems to be working fine now. thnx again

Thnx again, this is very helpful to put me in the right direction.

Damn I feel like an idiot. I cannot even find where to set Select..., From..., Where..., that you mention. I guess I'd better rebuild it with separate tables as you suggested. Thnx pbaldy!

Hi, still an absolute beginner, Suppose I need a database with customers, able to store: what different events, were performed on what date. So let's say possible actions are: a customer called, emailed or visited. (note, it might be possible that a customer both called, emailed and visited on...

I suspect I have made a beginners mistake in my very first Access database, but before I start this again from scratch, I would like to know if it is really a mistake, or if I might easily fix it somehow. I have a form with several combo boxes. All the source fields for those comboboxes are in...

thnx burrina, this is a very good piece of a puzzle that I will solve someday soon ;-)

Hithere, I am still an absolute beginner with Access, and I am currently mainly trying to see what aspects of Access I would best invest my time and effort in to get the database that I am trying to build working. One thing I would like to achieve is this: I already have a form where I can...

Nope, I am like a kid with the dashboard of an airliner in front of me ;-) Thnx a lot JHB! I'm gonna try to get this all to work in my real database now.

Ok, with some effort I think I should be able to do that. But the second point from my previous post is also very important. Is that also achievable?