Search results

thanks thanks Blorf, worked fine. Appreciate your help.

Hi, I have a form for entering a new communication. I've set the default property for the Landlord_ID field to update automatically with the following line: =[Forms]![frmNewLandlord]![Landlord_ID] However I need to open the new communication from two different forms. And depending on which form...

Solved sorry, found solution from WayneRyan in another thread. Make the DefaultValue for the fields on the new form: =Forms![YourMainForm]![SomeField]

Hi, I have two forms, NewLandlord & NewCommunication. A button on the NewLandlord form needs to open the NewCommunication form and copy the Landlord_ID data from the NewLandlord form into the Landlord_ID field in the NewCommunication form. Anyone know how to do this?

thanks excellent, thanks WayneRyan - worked fine :)

Hi, I have a form which is used to input new properties data. When I tick a checkbox field this opens a history form. I want to be able to copy the data from a few fields into the fields in the history form when its opened. What is easiest way to do this? I was thinking store the data (eg...

Resolution! A work colleague showed me a way around this problem if your interested. Basically using the IsNull(parameter) Private Sub Form_Load() Me.Visible = False If IsNull(Me.Landlord_ID) Then Msgbox "There is no data for the information you have entered.", vbInformation, "No...

yeah your right, however there are too many street names to place in a combo box. At present if there arn't any street names that match then the form just opens with all the fields blank. I might just have to settle and leave it at this and then the user can close the form.

thanks for the replies. I tried the code & am getting a run time error: "The expression you entered as a query parameter produced this error: 'The object doesn't contain the Automation object 'Enter area of property" My query has the following statement asking the user to input an area: Like...

yes and no one replied

Hi, I have a form based on a query which asks the user to enter a street name. I'd like to display a msg if there are no records matching that street. Tried using this code from SJ McAbney in another thread but with no luck. If DCount("[ID]", "qryYourQuery") = 0 Then MsgBox "There is no data...

Hi, I have similar question to that posted by puthenveetil today. I have a form based on a query which asks the user to enter a street name. I'd like to display a msg if there are no records matching that street. I'm not sure how to do a count on my query as it uses DISTINCT. This is the SQL...

Found answer Found the answer in another thread.

Hey, I have a report which asks the user to input the start and end dates. In the header of the report I want to display whatever the user has input in a textbox or label field. Does anyone how to do this? The report runs off a query.

thanks for the reply. Sorry, probably should have posted in the macro's forum. Still getting an error with the underscores. Didn't like the path I was giving so tried putting into a variable. Keep getting a 'Expected End of Statement error' and highlights Rows("1:1") loc = "C:\Apps\"...

Hi, I'm trying to create statements for a macro in Excel. However am getting several errors. This code works fine: ' Add a macro to the module... Dim strCode As String strCode = _ "sub MyMacro()" & vbCr & _ " msgbox ""Generated macro"" " & vbCr & _ "end sub"...

Thanks! Thanks, appreciate your help. Worked fine :)

When I open a form, I have a question asking what type of landlord will be entered. If the user selects 'No' I want to open another form. This is my code, I'm just missing the correct syntax to call the Load_Form proc of another form. Private Sub Form_Load() Dim Msg, Style, Title...

Thank you!!! Worked perfectly - thanks, appreciate it. (Started at no 97 simply cause that was the number of the first label and couldn't be bothered going through and changing them all).

Hi, I'm trying to set several fields to a false visible property when an option is selcted in a combo box. Does anyone know how to use a variable in a loop to set the visible property to false. This is the code I'm using, the line in bold being the problem. thanks in advance. Private Sub...