Search results

I’m looking for a way to have my queries headers change their dates automatically each month or when the date changes. I have a query that exports to an excel file. My query changes automatically each month with using the formula below Month12: Min((IIf([CORRESPONDENT_PURCHASE_DATE] Between...

Thanks everyone for the advice and help. Looks like I’ll need to wait until I split my database. Thanks again TCB

DCrake, I think this is a great way to log people out of the database. Could you please provide more details so I can set this up on my db

I have one database that on our server that 5 people login to. Sometimes throughout the month I need then to logout so I can add, update ect. Is there a simple code or way I can log everyone that’s logged into my database. I’ve seen code that will log people off if the database is split; I’m...

CBrighton – Do you have a example within a access database you can send me?

Thanks CBrighton, I'll let you know how it works out for me Thanks again

yes please can i see the code you put together

did you mean by saying have them run the code on there computer, just opend the attached database on thier system and see it if runs and then closes?

the version is office access 2003. Would you have another recommendation for a type of auto log off?

Maybe I missed that, so I need a front and back end to make this one work?

I’ve been trying to get this Auto-Logout.mdb to work. Problem I’m having is that it looks like it’s working on my end but doesn’t kick the users off, but it will close on my end. What I’m expecting to happen: If anyone is in a cretin database I should be able to open the database and...

Thanks lagbolt - once again you were right

Thansk lagboltThe error message Im getting is Run-time error '9' Subscript out of rang Then when I hit the Debug button I get this row highlighted IsDimensioned = ((UBound(TheArray) - LBound(TheArray)) >= 0) Let me know if I can provide any further help to help me

I just started getting this error, can anyone help me debug it? Public Function getSTDev(ParamArray varVals() As Variant) As Variant Dim varVal As Variant Dim intcount As Integer Dim Arr() As Variant For Each varVal In varVals If IsNumeric(varVal) Then Arr = AddElement(Arr...

I’m very new to VBA but would like to use this VBA code to export my access tables to excel with proper formatting Could someone please describe how I would go about importing this code into my database? Thanks for taking the time to help a new be understand

Thanks hbrems, that’s a good start. Hopefully we hear other ways also and find the best one that works Thanks all TCB

I’ve read a lot of different article on the internet about being able to export a table from MS Access to Ms Excel. Problem I’m having is that I don’t know which one would work best for me, so I thought since I’ve gotten such great advice from this form I will ask. I have a query that...

do you have an example you can show me?

I need to be able to export it to a spread sheet, so I'd like to to it in a query

I'm trying to understand this formula. To be exact I'm trying to make this formula work as rolling months I see that the DateAdd is looking back 6 months and the and Date()) is looking at today’s date. I need to be able to change this formula so I'm able to pull that date for January/ 13th...