Search results

Hi all I want to run a query that when runs only shows words from a specific column but does not show duplicates of words is that possible? for example if the list was: BODYWORK BODYWORK ENGINE ENGINE ENGINE WINDSCREEN TYRES I would like the query to run but only show BODYWORK ENGINE WINDSCREEN...

Hello, I am a little confused as I currently have these in a table already called TBLDefaultText with the following field names IDFKAutonumber Category (will be Level 1) Default TextTitle (shows on the Level 2 list) DefaultTextBody (Once the user has selected this data is pasted into the TxtBox)...

For anyone that needs it, here is what worked for me :) Public Function FUNC_AutoPopulate() With Forms!FRMOrderDetails!SFRMCustomerDetails.Recordset .AddNew [Forms]![FRMOrderDetails]![SFRMCustomerDetails].[Form]![TxtOrderingDate]= NOW() 'ADD OTHER FIELD ENTRIES HERE End With End Function

Hello, I have updated my post a little with the details :)

Hi all I have records in a sub Form that have tick boxes and Text Boxes, is there a way to possibly have a button on the main form that you can click that pulls this data from the previous record sub form and copies it into the new one? 1 Record per form page The form details are Main form...

No need to be rude, your code helped just needed to change some bits

Hello, I have solved the issue the code needed was, and seems to work fine Public Function FUNC_OrderConfirmationt() With Forms!FRMOrderDetails!SFRMCustomerDetails.Recordset .AddNew [Forms]![FRMOrderDetails]![SFRMCustomerDetails].[Form]![TxtOrderingDate]= NOW() End With End Function

Hello, I am not sure how you have made out like I am saying you are at fault I am asking for help, hence the original post With regards to how I come up with that the code is in a module so I was under the impression I had to write exactly what form to look in sorry if this was wrong? I have...

Hello, as I said the button is on the main page and want the action to take place on the sub form named SFRMCustomerDetails?

Hi, This is the error I now get using the below, Run-time error 3000, Reserved error (-1104) There is no message for this error. Public Function FUNC_OrderConfirmationt() With Forms!FRMOrderDetails!SFRMCustomerDetails.Recordset .AddNew .Fields...

Hello, This is already set to yes :)

This doesn't work in a module, runtime error 438, object doesnt support this property

Not sure what you mean by this?

No error messages, just overwrites the current line

Hi all I have a form with a tabular sub form, I have a button on the main form that the user clicks and when they do I want to automatically create a new record in the subform and to populate certain fields in the sub form how do I do this? Currently running in a module Main Form...

Hi all I have a main form with a sub form on it, is there a way to stop the last field in the main form tabbing into the sub form? in the design > Tab Order it is showing the sub form so is there a way to remove this? currently I have done it a bit of a crude why using a tiny text box it tabs...

Hi All we have a combo box list showing numerous different products, to make it a little easier is there a way to put sub heading (ENGINE & BOSYWORK) within it that cannot be clicked on and maybe even Bold? There isn't enough on the list to warrant a second dropdown list to choose the type but...

Thank you, the first code kept freezing still but the second one worked perfectly!

Morning Edgar Thank you for the below, I have put the code into the on Click event and popped the first bit of code at the top of everything, I put the timer up to 5000 but still having the same crashing issues? The IE page loads buts thats as far as it goes Dim IE As Object Set IE =...

Hello, I tried this code, it opens the IE but then it seems to crash the database with no errors?