Search results

As it's still not clear to me, I've uploaded a sample of my DB. Some of it is in hebrew, don't mind it - What I need you guys to check is in english. There are 2 queries there, both have a field called: Total. I need another field, in a table or query, that will be the sum of those fields...

Well, each query is based on a different table, yes. How do I use the DSUM function? Please elaborate.

Hello, I've got 2 different queries, each calculating a total. Now, I'd like to do sum the 2 Total fields of these 2 different queries. That means: Query1Total+Query2Total=OverallTotal I created a new queey to sum this up, but it doesn't work. When I run the query I keep getting: "Enter...

Hello, Is there a way to show Outlook's calender in Access 2007? I really need to know how I can do it, if it's possible. This way, I can manage Outlook through the DB. Any ideas guys? Thanks in advance, Tal.

Hello everyone. In my database, I've got a journal table, in which I have a field: Hour Thing is, I would like my customer to be able to type hours AND I will be able to make a query that will pop up a msb box IF the current time is earlier then the Hour field. Problem is, when I put "Date/Time"...

Unfortunately, I don't know VB at all. I've seen that Microsoft Database called "Marketing" in Access 2007 is doing that with a macro. Thing is, I really don't understand what they did there, and so I cannot do the same for myself. Anyone can help out please?

Yeah, I've seen the "after update", and I can create a macro that will open the report. Thing is, I don't know how to do that. I mean, what do I write in the condition? How do I tell the macro, that If the value is Finance report Then open finance report?

Thank you, but I still need a little bit more on where to type that in, I'm pretty new in Access, and would appreciate if someone could explain to me if that's all the commands I need, and where do I type it? Thanks, Tal.

Hello, I was wondering how can I make a Combo box, in which I will type, for example: Financial report and by selecting it, I will get that specific report opening. Same goes for more values, and reports that matches. There's an example of exactly what I want in Marketing Projects in Access...

Thanks everyone for the help, I'm all good with it now. SOS, sorry you've had to repeat yourself a second time, I'm pretty new to access programming, and some of the things are still a mystery to me. Thank you for explaining that.

I just read about user level security, and it seems that.. It's not available in Access 2007? How am I supposed to keep my DB safe from the user's evil hands? No way to cancel the Design view button?

Thank you for your reply. The macro isn't just opening the form, it's also executing 2 queries that are required on start up. Is there a way to cancel the navigation pane, and prevent the user from getting into "design" mode on the forms? Or better yet, is there somehow to make the DB look...

Hello everyone. I'd like to know how can I do the following: When a user opens the DB, There's the autoexec macro that opens the form on which he's supposed to be working on. (by his demand). Problem is, that on the left side of the screen, there's the "tables, forms, macros, queries" etc...

Thank you for the reply. What you say makes a lot of sense, I guess that whenever I'll make DB's for other people, I will be sure to check what Office version they are using before starting work on it. Thank you once again, for both the answer and time. Tal.

Hello everyone! I'm new to Access programming, and have a question that would help me a lot. I've created a DB in Access 2007, which works just fine. I've saved the DB as MDB to be 2003 compatible, and sent it to my friend, who needs it. He is using Access 2003, but he can't work with the DB...