Recent content by NielsE

Cannot update bound control through browsing I solved the problem and got the both the browsing and openfile buttons to work. That means that it works fine when the control where the path appears is an unbound control. When I make the control bound (I need to store the path value in a table) I...

Geeting an error Thank you very much. This seems to be very helpful. However, when I try to apply it I get an error. I have used the code for the Browse button in the "fFindOpenImportFile" form, but the code stops at varFileName=tsGetFileFromUser and I get the following error message: Compile...

I have developed an application and packed it into a runtime version. However, in the runtime version the shortcut menus do not work. The reason why I want the user to have that possibility is that the application has two hyperlink fields and it is much easier for the users to be able to browse...

I have developed a data base to be distributed to 10-15 users who do not have Access installed. I have the Sccess 2003 Developer Extensions and can thus package a runtime version. I guess that the best thing to do is to split the db in a back-end db with the tables to be installed on the server...

Thanks again RG. It works beautifully now. Niels

Thanks again, RG. However, now I get the following Run-time error on the Report_Open: Run-time error' - 2147352567(80020009)' You can't assign a value to this object. The debugger steps in at Me.lblSelectPro = Args(0) in the Report_Open event procedure. Niels

Thanks for your help RG. However, I get the Compile Error: "Wrong number of arguments or invalid property assignment" on the DoCmd.OpenReport in the below code: Private Sub PPrint_Click() On Error GoTo Err_PPrint_Click Dim stDocName As String stDocName = "rptSelectPro"...

Sorry about my ignorance, Rural Guy, but how do I do this? I wish to take the value of the label "lblList" in the form "frmParam3Test" and put it in the text box "lblSelectPro" in the report "rptSelectPro". Niels

I have a form where I through three parameters, chosen by combos, show a list of records. A code at the same time populates the label for the list showing the parameters plus some text to make it understandable. A print button closes the form and open a report with records from the form list...

Thanks for the valuable help I have got in this forum so far. Another, and probably simple question: I have a form where I ,through three parameters selected in combo boxes, populate an unbound list box with records. The list box has five columns. I want to be able to print a report that has all...

Thanks RG. Works like a dream. You saved me again. Niels

Thanks. However, it does not work. I have tried to attach the Me.lstCountryName to the ProjectID_AfterUpdate (does not work) and the ProjectID_OnChange (does not work either). When I scroll through the projects using the navigation buttons on the form, the Project ID on the form changes ok, but...

I have three list boxes on a form (lstSubjectName, lstTargetGrName, lstCountryName). The list boxes are populated from queries based upon tables that have a many-to-one relationship to the main table. The queries are the following: SELECT tblProjectSubject.ProjectID...

Thanks, it worked when I added inverted commas before & FORMS!...

I have a data entry form where country(ies) (there can be more than one for each project) is/are entered in a sub-form on a tab control. Countries not listed are entered by the following: Private Sub CountryName_NotInList(NewData As String, Response As Integer) Dim strSQL As String Dim strMsg...