Search results for query: *

Hi Everyone, I have a database which is used in ten different countries across Europe and Asia, and recently been having problems with different countries using different date formats. One example is one country would have their standard date format as 1.04.2005 another as 01.04.2005 and maybe...

Hi Everybody, I have an odd problem with Access 2002. I am unable to filter a form by using the following code on the Load Event for the form. Dim filter1 As date filter1 = InputBox("Please enter a date to filter data by (e.g. 19/09/2003)?", "Spoilage") Me.Filter =...

Hi, I have an access database that exports a reports data using the Output To command, then I have created a series of Macro's in Excel and placed them in the Personal.XLS file. Since they need to run for many different excel file names. The Excel Macros work fine, but after Access run's the...

Hi, I'm having a problem with a memo field which is being cut-off on a report after 255 charectors in Access 2002. I've had a search around and it appears that other people are having the same problem, I couldn't find anything about this on the microsoft knowledgebase. Does anybody know of...

I have a weird problem with selecting between two dates if the dates have been worked out using an expression. For example here is my expression. Real Date: IIf([ShiftPat]="Night",[CDate]-1,[CDate]) and here is my selection critera Between [Enter First Date?] And [Enter Last Date?]...

Hi Everybody, I have database in which I create an expression within a query. Real Date: IIf([ShiftPat]="Night",[CDate]-1,[CDate]) It supposed to change dates to match a shift pattern, which it does fine. I then create another query based on this, in which I want to select all data...

Hi everybody, I wrote some code as shown below, which allows a user to create an embedded word document from a file, this works fine. But I've been asked if I can change this so that it's an attachment instead, anybody now how I can change this code to do that. Thanks Matt...

Hi everyone, I have a field, that looks up values from a view, but if a value is not included in the view, it gives an Error message. Is their a way I can change this to give a more meaningfull error message. by the way, I do want the users to enter codes which are not in the view. Each time...

I wrote this script to open an attachment, but for some reason I can't get it to run, it complains set oe bit, that object variant net set, any ideas?? Dim uiw As New notesuiworkspace Dim filesselected As Variant filesselected = uiw.openfiledialog(False, "Select files to open.&quot...

I have created a hyperlink using Excel 2002, which is connecting to a file located on our network. When I test the link it works fine. But if I save the spreadsheet, and then try to use the link again, it no longer works. The hyperlink name has been changed to something like...