Search results

firstly its not the ageing access developer thats the problem it the learner access developer(me) thats the problem LOL. Secondly to the problem at hand Basically this form is to be used to enter purchase orders which once working will be e-mailed to the suppliers. The problem im having is...

ok i can get it working if i remove the Enforce referential integrity from the relationship window but im thinking that is not a good idea.

Thanks for the info and help bob

Ok thanks for all the help so far. The form that i am working on is not for checking po`s but for entering them so i think i may have mislead you. Basically what i wanted to do was for someone to enter a supplier in the posupplierselect form and when they select the correct supplier it opens...

Ok im getting a serious headache with this now. I have attached a copy of my db in the hope that someone can spot where ive gone wrong. The problem is that whatever i do i either get an error about LinkMasterFields or the order detatils dont show in the purchase order table. I know its a link...

the form is opened after i select a row from a list box withthe following code in the afterupdate of the text box. DoCmd.OpenForm "FrmPurchaseOrder" [Forms]![FrmPurchaseOrder]![SupplierCode] = Me.LstSupplierSequence.Column(1, TxtSelect.Value - 1)

Thanks for the quick reply bob but i dont think i made myself very clear. The Problem is on the second form when it opens with the supplier code in the text box it doesnt register that there is something in the text box so i have to manually retype the supplier code to get it to register.

Hope someone can help with a strange problem. I have a form(form1) which is used to add details, when i have finished entering the details i press the enter key which then opens up another form (frmOrders) and the supplier code is passed to this form(this bit works).The focus is set on the part...

Ok ive seperated my tables into the four tables. And ive hit a bit of a snag when it comes to adding a new customer, I created a single form based on a query(including all fields from all 4 tables) to add a new customer and the relavant details but it doesnt work(The form is completely blank ...

Thanks for the quick replies guys makes a bit more sense now

Hope this is in the right forum Ok im trying to understand normilisation and am a bit baffled. I have a table(TblCustomerDetails) with the following fields: Accountcode CustomerName Address1 Address2 County Postcode TelephoneNo FaxNo E-Mail Website DAddress1 DAddress2 Dcounty DPostcode...

Superb Works like a charm Thanks for all your help Thomas

Sorry Thomas forgot to say in the last post that i have taken your advice and taken the on error line out. I also figured out that the SEQUENCE word had to come out of the SQL statement. Here is the latest code i have Private Sub Customer_AfterUpdate() Me.LstData.Visible = True Dim StrSql As...

Thanks for clearing that up Thomas. Its nearly there, the problem now is that when i enter something into the text box and press enter it lists all the matching records but the sequence number for all of them is the same(which is the amount of records displayed e.g. if there are four records...

Ok thanks for the help everyone ive nearly got it working but a small problem has now reared its ugly head. At the moment i have the following cod in the FORM BEFOREUPDATE event :- Private Sub Form_BeforeUpdate(Cancel As Integer) DoCmd.SetWarnings False Dim response As Integer Select Case...

Thanks thomko I added your code to mine but not sure if its right as the lstbox now doesnt display anything. Here`s what ive done: Me.LstData.Visible = True On Error Resume Next Dim StrSql As String 'SQL statement for the record source Dim sText As String 'Contents of the criteria control...

Thanks for the reply thomko. Ok i understand what your saying but not sure how i would put that in the sql.And do i have to delete the sequence from the query if so i may as well delete the whole query and use the actual customers table.(or am i just talking rubbish) Thanks Gareth

thanks thomko i tried the listbox.requery but it didnt seem to help. Here is the complete code for the textbox afterupdate event. Me.LstData.Visible = True On Error Resume Next Dim StrSql As String 'SQL statement for the record source Dim sText As String 'Contents of the criteria control...

I have a search form (form1) that is used to select a customer from a list which is generated from a query and has a sequence column but I can’t seem to get the sequence to re-sequence itself when it is displayed. Basically on the form the user types part of the accountcode presses the enter...

Please can someone help with what i thought would be a simple problem but has turned out to be very annoying. I have a form bound to a table with about ten textboxes with the first one (accountcode) as the primary key in the table being required. I have tried the following code in the before...