Search results

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...

Firstly, I want to admit that my knowledge about data base construction is fairly basic. I am trying to build a data base for humanitarian projects that do not at all resemple of the usual examples including customers, invoices, suppliers and what have you. My problem in constructing the DB is...

Thanks all, you convinced me. Niels

Thanks for your comments. However, with the kind of data base I am developing I think it will be most practical if some fields in one of the tables include severaL values (they are seperated by a semicolon and a space). As mentioned before I use a form to enter the parameters...

I am using a form where I select values from combo boxes to enter parameters for a select query. It works fine where the table queried only has one value in the field concerned. However, it does not work on the fields that have several values (entered through a multi-selection box). Are there...

I wish to insert in a table, not the date, but just the month and year (yy/mm or mm/yy), for example 05/10 or 10/05 for October 2005 (the order of yy and mm does not matter). In addition, I need to be able to sort the records chronologically using the same field. I have tried various solutions...