Recent content by fitshase

I seem to have done it with a bit of fiddling around with the formula. I removed the # symbols and it works a treat. Thanks all for the help. =DLookUp("[SalesTotal]","tblSalesData","[SalesDate]=[SalesDate1]")

Hi Minty, Thanks - just tried that but the same thing happens - no value comes into the box. =DLookUp("[SalesTotal]","tblSalesData","[SalesDate]=#" & [SalesDate1] & "#")

Best way I can describe it is visually (see below/attached) Ranman256 - thanks for the formula but it brings up a blank field (no error). I've changed the headers and table name to make them a bit shorter (i.e., easier for me to remember!).

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...

Sam, That's perfect - works a treat now. Cheers!

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...

http://www.databasejournal.com/features/msaccess/article.php/3548586/Auto-Logout-Users-for-DB-Maintenance.htm aha - 10 posts so can post a link now.

I've had the same issues with users not logging out when I want to make back-end changes. After a lot of searching, I came across a solution but I cannot post a link. I'll see what I can do though. I have implemented it on my database front ends and it works a treat.

Paul, Thanks for the reply, that's done the trick. Cheers

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...

pbaldy, Thanks - that's just what I was looking for. I'm still trying to get to grips with VBA and most of it is just looking for examples online and tailoring to fit but I couldn't figure out what function this would be. I've got it working fine now but would like to streamline it a bit...

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...

Doh:o! I didn't even click either! I thought it opened the ACCDE file when it created it. I can rest easy now and release the version. Cheers