Recent content by dinoc

Wow I really am having a "special" moment today. Thank you MarkK

Good Evening Word. I'm having another one of those days but I'm getting a file path and file name from a dialogbox and forgotten when the VBA property is to return the full file path and file name. This code works fine for return the filename only: Private Sub TEST() Dim f As Object Set f =...

Do you get the input boxes when you first try it and then no longer works or you just dont get them at all? Sorry pr2-eugin didnt see your post, I was too busy look at my quotes and hash marks haha

Sorry forgot to ask, where are you getting your dates from? e.g. from a form control?

Sorry I meant the end of the DLookup is how to format dates. But try something like this (I havent checkted it though): WhereCondition:="[Date Submitted] <= #" & Date1 & "# AND ([Date Submitted] >= #" & Date2 & "#")

The format should be like this: DLookup("FieldName" , "TableName" , "Criteria= #date#")

Not sure about the border but you have a search of google or on here for access button properties then you will find aritcles on what features/attriutes can be changed. At the end of that article I sent, there is some extra code to return it back to its normal state.

Is the form linked to a query or a table? I say that as you can change the ODBC Timeout option when using a query based form. Go into design mode for the query, switch to SQL view and select Properties (have to be in SQL view or you dont see this option). Not sure if this will work or not...

I cant post links yet so you may need to add www to the below experts-exchange.com/Database/MS_Access/A_3506-How-to-code-Mouse-Over-effects-for-MS-Access.html

If you are using access 2010 or up (possibly 2007 also), then there is now a field type called Attachment that you can use in a table. It allows you to upload attachements of just about any type. When you add the field to a form you get a little paper clip (or double click) in a text box that...

Thanks namliam, I'm ok checking if the folder exists etc, the bit I'm having a problem with so that it works dynamicaly is the checking for the number if its between a range of 500 e.g ID 1234 would would create a folder called 1234 in a parent folder of say 1000 - 1499. That folder would...

Maybe try turning off the display warning message when excel opens usings something like this: xlApp.Application.displayalerts = False But dont forget to turn them back on at the end, possibly after the save step. xlApp.Application.displayalerts = True

Hello All, I'm trying to create some code that will create a new folder depending on the ID that is currently being added to the database. What happens at the moment is a new ID is generated which in turn is job reference. When this is added to the database a folder is created with a prefix of...