Search results

If you search this forum for Outlook.Application you will find a number of posts detailing how to use VBA to check Outlook. There is some code to get you started in this post: http://www.access-programmers.co.uk/forums/showthread.php?t=182395

You forgot to move to the next file in your last loop so if the first file on F-drive was not on D-drive, then you created an endless loop. Do While MyFile <> "" For N = 1 To UBound(Folder1Array) If Folder1Array(N) = MyFile Then Uploaded = True Exit Do...

When is the code snippet meant to run? You didn't include the function or sub declaration in your post. Is it triggered by a button click, or in a stand-alone module?

Check out the tutorials on using the FileSystemObject You could loop through the contents of the first folder and test that each file does not exist in the second folder using FileSystemObject.FileExists("filename")

Did you really mean that you have the IsShipmentMade field as the control source for a Textbox or a Checkbox? Your checkbox needs to be bound to the IsShipmentMade field.

Could you not create a new merged store so that A and C become historical and a new merged store 'D' becomes current as of 25/09/09. All sales transactions for the merged stores are allocated to D. A and C would show no sales after the date of the merge. Just a thought. If that doesn't work...

This is your problem, the query does no include the inactive stores. You could change the Row Source of the combobox whenever an existing record is opened. You would add code to the form's On Current event to test that the form is displaying an existing record, perhaps by looking at the value of...

Also, don't forget the free SQL Server version - called SQL Server Express. You would be hard pressed to find a better alternative for most web applications - although you may want to check the file size limitations if you are planning on processing a huge amount of data. You can also use the...

With 300 users hitting the application, including some remotely, I would suggest you're looking at a web application. Microsoft have the free Visual Web Developer (VWD) that offers most of the functionality of the paid versions of Visual Studio. It also supports Access and SQL Server databases...

As wiklendt has said, what date is being entered into the database when the code runs? It is not a date format issue, for example the date is being stored as mm/dd/yyyy instead of dd/mm/yyyy? You could put a Breakpoint in your code to see what value is being sent for the FldName variable on...

The answer to your initial problem is that you have got an open connection to the database, which you are using when you create the first recordset using the command .ActiveConnection = CurrentProject.Connection. You then attempt to explicitly open it again to create your update recordset using...

Going back to your original post, the reason you are getting and datatype mismatch is because Count(State) returns a number, but in your criteria you are adding the text value of the State's name. I suspect what you really want is not the count of how many States are in your table, but rather...

No problems, let me know if you need any help implementing this solution.

Have you taken a look at this post? http://www.access-programmers.co.uk/forums/showthread.php?t=130802

If you haven't gone very far in the development, I would suggest using ASP.NET, as even in the freely available Visual Web Developer (VWD) edition, there is great support for Access databases straight out of the box. VWD also has a calendar control, that is farily easy to setup and use. With...

I agree with Vassago that up-to-date certification can certainly show you know something about the technologies, but as Alisa points out, relevant industry experience will win hands down. Try and get whatever experience you can, including doing your own projects and building apps for people you...

what version of Access are you using?

Date returns the current System Date, not to be confused with the data type Date:) The following will show a message box with the current system date. Dim myDate As Date ' declare a local variable of the Date data type myDate = Date ' assign the current date to the variable MsgBox myDate...

So your main data entry is being done via an ASP website? Which version, classic ASP or ASP.NET? Secondly, you wouldn't normally delete the old records but simply no longer display them. You can achieve this by adjusting the SQL query that is used to populate your page to have a date criteria...

Use the AfterUpdate event on the combo box to populate the textbox value. Use DateDiff to calculate the number of days between the start and end dates. An example using the field names you gave: Select Case Leave_type Case Is = "CR07" Me.leave_total_days = 0.5 Case Is =...