8/13
I travel frequently and it is helpful to my email recipents to know where I am located. Currently when I construct an email I type my current location, current date, and current day at the top of the email e.g.
From Somewhere USA
8/13/09
Thurdsday
Can via VBA a series of combo box be...
Solved!
The syntax is correct, but it will not always return the correct value e.g.
In row 4., the IIF would stop after the comparison of [ABC] > [BCD], returning 1/1/05 vice 4/1/07;
Original
......[ABC].....[BCD]....[CDE]....[DEF]
4....1/1/05...2/1/03...4/1/07...12/1/02
The Maximum/Minimum...
This seems to work;
=IIf((Nz([ABC]))>(Nz([BCD])),[ABC],IIf((Nz([BCD]))>(Nz([CDE])),[BCD],IIf((Nz([CDE]))>(Nz([DEF])),[CDE],IIf((Nz([DEF]))>(Nz([ABC])),[DEF],[ABC]))))
Gunner...:p
I have a report based on a crosstab query with columns [ABC], [BCD], [CDE], [DEF]. I want to compare the data (dates) in the four columns and display in a new column [XYZ] on the report only the latest date.
Original
......[ABC].....[BCD]....[CDE]....[DEF]...
I want to develop a report from my database with various "assignments" across the top with the start date underneath.
I have a query named NextOccurance. All assignments i.e. SMART are text, Start Date is Date/Time (mm/dd/yyyy).
On a report using a unbound text box for the control source I...
I want them to only be able to change the data (assignments) for which they are responsible for. Changing the data means entering or changing the date. The users will 'not' be able to add or delete 'assignments'.
I hesitate to redesign the whole database, but if I have to I will...
The user will belong to 'only' one department. I want to keep all the data in the current table 'Assignments' and use only one input form "MRTINPUT".
The users (no more then 8) will all have edit capability but only to their department's 'assignments'. Therefore, once the user logs in and has...
3/24/2009
I have "inherited" an Access database, because I have some training and can generally 'get' Access to do what I want, albeit, not efficiently. This Access database tracks the start and end dates of 'assignments' for many units (ships).
The database appears to be 'normalized' as...
Obiviousily, I had the closing commands in the wrong place initially, not at the end. The excel file closes properly now and opens without error.;)
Gunnerp245
2/24
I have read with great interest this thread http://www.access-programmers.co.uk/forums/showthread.php?t=157331&highlight=query+export+excel and with some modification it does what I want to do; Almost.
I am using Access 2003 and this is the code...
I have a macro that files a particular set of reports; It works properly. Some of the reports occassionally will not have any data, depending on the data being analyzed.
I would like to NOT file the reports without data. How would I go about it?
Thanks,
Gunner...:confused:
Information in the thread you pointed to states to ensure you can unhide the controls. Would opening with the shift key pressed return the controls? And secondly, could one hide the 'unhide' command on one of the forms?
Gunner...:)