Search results

Hi all, I'm hoping you can help before a hole appears in my wall....:banghead: I am trying to use the DLookup function in a form. I have a few unbound boxes which have calculations in them to show dates based on another field. Now I need to have a DLookup to pull a value associated with that...

I am creating a database for a sports club which has membership details and finance details. The tables are:- tblMembers (FullName, Address, Email, etc) tblFinance (ID, TransactionCategory, TransactionDate, TransactionAmount, TransactionMember). The tblFinance "TransactionMember" is linked...

I don't know if this should go in the reports section or the queries section but here goes:- I have a simple table which tracks dates for various projects on different geographical sites (the test data is over 600 records). I would like to have a report which lists months down the left and...

I'm currently working on a project database which tracks various milestones on various projects. As part of the process, there are regular update meetings between the project managers and the "people on the ground". At these meetings, actions are given to each person to focus on what needs...

I have created a database with a front end and back end. Each user has their name listed in a drop down box on the menu (the users' names are stored in tblUsers). Now, everytime a user opens the database, they are presented with the menu (frmMenu) and they select their name from the drop down...

OK, I don't think this is possible but thought I'd ask in any case. I have a database which is split front end and back end. There are different front ends for the different teams. Admin team receive instruction from client. Admin team insert new records into database and choose a surveyor's...

I've created a database and I distribute the front end using the ACCDE format. One of the forms I have is set to open Read Only and I have disabled editing, deleting, etc., in the property sheet. However, when I create the ACCDE I hit a problem. On opening the ACCDE file, I click the button...

I have created a database but I have absolutely no experience of VBA so I'm hoping someone can help. The database I have created is designed to keep a record of sites we have (address, owner, location, site type, etc). I have 2 separate fields for the Easting and Northing values. I have...