Search results

For the second part try enabling the "unique values" property of the query. For the first, you could always just have a field displaying the date field in a custom format and replace the minutes and seconds with 0's. Of course this would mean they are always rounded down to the earlier hour...

Take a look at the message box function (msgbox) and see if that does what you need. You can set different code behind each button (yes / no, ok / cancel, whatever buttons you choose from the available options) if you need to. http://msdn.microsoft.com/en-us/library/sfw6660x(v=vs.85).aspx

A simple DLookup willreturn the contents of a field based on set criteria. e.g. DLookup("dbPermissions","tblUsers","userName = '" & Environ$("username") Note that while I have a function to pull the username I just used what you typed in this example, if you have a custom fuinction to get...

No worries. :) As the error message implies, an action query (append, delete, update, make table, etc) are designed to take actions, not to display records. What is the command button doing with the update query? Is it trying to run it or use it as a record source? If it's trying to use it...

FYI the 2nd arguement in the Msgbox function defines the buttons. Some available options are:

If you just want a date field in a record (or all records in a table) to be updated each time someone opens the database then create an update query to set the field to =Date() and use an AutoExec macro (or just in the on open event of your switchboard) to run it each time the database is opened.

I haven't read the whole thread, so excuse me if I'm wrong, but I assume you are using the form Frm_ECP_Date_Range_Search_Parameters not only to input the criteria but to hold the command button to open the appropriate report? In which case you could check for null values in the 2 date...

Well, I can't see a way to have it work on multiple tracking numbers but work as soon as you click a number because it would just load the page for the first number which you click on rather than waiting for you to select all the numebrs which you want. You could either have users input the...

Ah, simple. Comma seperated. http://www.fedex.com/Tracking?language=english&cntry_code=us&tracknumbers=795171133672,797501491177 his should mean the textbox control can have multiple commas seperating tracking numbers and create the URL the same way as your existing code.

Ah, then ignore the code but note the general idea. When you can create / find a function to allow you to do it you can put it in the Outlook VBA and self certify it. You can then call that Outlook function from Access to bypass the warning message as Outlook is running its own code.

I don't have any tracking numbers to test with, but if you enter multiple tracking numbers in the tracking page (http://www.fedex.com/Tracking) does this give a URL which shows how multiple numbers are handled? Or does it do the work in the background and give you the results with a generic URL...

If you are able to add code to Outlook and (this is the important part) certify the code, then yes. Use this function in an Access module to send emails: 'This is the procedure that calls the Outlook VBA function... Public Function SendEmail(strTo As String, _ strSubject As...

I've not used FedEx, but can you give an example tracking number & URL so we can see the relationship between them? Obviously a false tracking number is fine, as long as the format of the URL is the same and we can see if it's possible to construct the URL from just the tracking number.

Sounds to me that the subform in datasheet view mode should do what you want. It basically displays the underlying recordsource like a query or a spreadsheet. Unless Allow Additions is set to no they will be able to add as many records as they want.

Both pieces of data can potentially be displayed on that form, but it has been specifically told that the default value is =Date(). If something else is coming in and saying "I know you've been told you should display that normally, but as I'm here you will display my value" then it sounds...

If you don't want to propose adding new signons (and specifically passwords for users to remember) you could simply pull the name of the windows login. Unless they don't have unique windows logins either!

If the form which this control is on is bound, then the stored value overrides the default value (assuming the control is bound too). If it's an unbound control and/or form then it should be calculated whenever the form is opened (i.e. when the control is loaded). Of course, if you have the...

To confirm, the Openform command is expecting an SQL string to apply as an additional where clause on top of the existing record source for the form which is being opened (the WHERE clause without the WHERWE keyword, e.g. "JoinDate > Date()") It's to apply an additional filter, not to control...

You can attach it here (zip it first if you don't have enough posts to upload a database), however please use .mdb rather than .accdb as this PC only has Office 2003. It goes without saying but ensure no sensitive data is in the database before uploading, and a sample (just the tables, forms &...

The form doesn't matter, except to identify what record source we are talking about. I don't need to know what controls you have on the form, I need to know the data structure to advise you how to alter the data. I need to know what tables / queries the forms are bound to. If they are...