Search results

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

I shall give it a try. Gunner... :)

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

Okay. I shall give it a go this weekend. Thanks! Gunner.:)

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

Smart, Appreciate the response. Where and how would I call the vba code you posted? Gunner...

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

I have a report named rpt100 with two subreports srpt100a and srpt100b. The subreports are based on query qry100a and qry100b. Both queries are based on tbl100. I removed a field named 'Comment' from tbl100, as it wasn't useful; Also removed the fieldname from both qry100a and qry100b. When...

Can I do this without resorting to VBA? Or do I enter this in one of the forms 'event' function blocks? Gunner... :confused:

I have via macro that displays the main interface to my database; frmMain (Maximize). This form frmSelectUIC (Minimize) allows me to select a department number of the data imported for analysis. All is fine, as shown here; http://members.cox.net/mustang31859/access/before.gif However, after...

Only suggestion I would have is to NOT commit the number of hours on the invoice or if you must then use a time-period ie 100-200 hours vice a definitive 150. Gunner...