Search results

Hi all. I'm trying tosetup a pop up calendar in my Access Database for users to select start and finish dates of activities. I have a calendar from here: http://www.utteraccess.com/forums/showflat.php?Cat=&Board=codearchive&Number=413286 Here is my problem, When I run the database...

Can you give me more of an idea of what I need to do with this?

Hello, I've currently got a Combo Box (in the form of a drop down list) in the main part of my form for data entry. I have recently created a seperate form called 'edit' to change current values that may be incorrect. As a part of this, I would like to make changes to the values displayed in...

Cheers mate.

Hi, I have a form containing several fields for users to import data. The data comes from multiple sources, and I have arranged my layout the way I want it on the page. I have noticed though, that when you are using the database and pressing the TAB key, it isn't in a particular order (shoots...

Hi all, Im stuck atm. I would like to create a simple macro that will have the same effect as HTML mailto:email@email.com. Thats all. When the user clicks on the macro, their email editior would open a new email, with my address (and if possible specify a subject as well). Here's what I've...

thanks ansentry. your idea works a treat :)

Hi, I have a database that contains a navigation menu. It links to several other forms throughout the database, providing users with easy access to the databases features. At the moment, when each link is clicked, it opens another seperate window with that form as the contents. As you can...

all fixed :D

Hi all, I Have a question regarding lookup tables. I have a table called tblActivities. In this, I have created a field called ActivityBudget. I would like this to be a lookup field (select entries from a list). In order to do this, I have created a table called tblBudgetLists with all the...

Hi all, I'm working on a database for my school that is designed to keep a record of each staff members activities that they go through during the year. With the activity information, all their expenses for that activity are listed (see database for more information). Anyway, for anyone who has...

http://forums.whirlpool.net.au/forum-replies.cfm?t=439525

Thamks for your help llkhoutx. I have search for the code and got a copy of it, I think it's what im after. Only problem being I have never attempted to do coding in access before. Can someone tell me where I need to start, or if you have some spare time, edit and save the changes to the...

Dont worry, its all fixed now. I do have another question though in the Tables forum.

Hi ppl, Anyone who thinks that they may be able to help me, there is a copy of the database at : http://members.iinet.net.au/~a.beardsley/database/StaffProLearning.mdb Here is my problem, as you will see. In the from called frmStaff, I have created 2 lookup tables that work fine in the main...

Thanks for your reply, but im not sure i completely understand what your saying. I have removed the link between Staff and Activities tables in the Query that I have created to try and recieve the total expense, but when I create a form i'm still getting 4 entrys. Further guidence would be...

Ok that would be great. I have put a copy of the database I have so far online at this link for ppl to download: http://members.iinet.net.au/~a.beardsley/database/StaffProLearning.mdb I noticed something pretty interesting as well. When there is only one set of data in the activities table...

Hello All again, I am working on a form for my database this time and I have noticed something odd that I cant figure out. I have managed to make the following form (http://members.iinet.net.au/~a.beardsley/database/1.jpg) from a Staff Table, Activities Table and a Total Expense Query, all in...

Thankyou very much x0reset. Thats exactly what I was looking for. Your help is much appreciated.

Ok. I just created a new query from scratch. Here's what i've got: Field: TotalExpenses Table: tblActivities Sort: Ascending Show: Yes Criteria: "FoodExpenses"+"OtherExpenses" I tried to remove the quotations but access puts them back when I click off the field. When I run the query, i get the...