Recent content by Alan#

Control Names, thanks paul i'll try that

Function SaveData() As Boolean Dim db As Database Dim rs As DAO.Recordset Set db = CurrentDb Set rs = db.OpenRecordset("Skips Delivered") rs.AddNew 'rs("No").Value = txtNo rs("Deliver Docket").Value = txtDel rs("Customer").Value = cboCust rs("Name").Value =...

Must be all coded unfortunately, nothing bounded:mad:

Hi, i'm having difficulty updating an existing record in my form. I can enter a docket number on my form and when i hit my button (Find Docket) it brings up all the customers info (name, date, invoice, vat, total, etc.) What i want to do then is be able to amend/update the record. Just...

Hey sorry for late reply, i got done what i needed but now i want to add "a no matching record" message box vba code to what i already have, that it would be easy but having difficulty:( Function FindData() Dim rs As DAO.Recordset Dim strSQL As String strSQL = "Select * From [Skips Delivered]...

Hi Guys, I am working on a database for a Skip Delivery Company, I have all relevant tables and Forms done and can add customers and so on. I have a field name in my Skips Delivered table called Delivery Docket which contains a long list of customer dockets. What i want to do is, be able to...

My Table is Called Skips Delivered and my text box is called txtNo Error 94: Invalid use of Null Public Function NewNo() As Long On Error GoTo NextNo_Err Dim lngNextNo As Long Find highest No in the Skips Delivered table and add 1 lngNextNo = DMax("[txtNo]", "Skips Delivered") + 1 'Assign...

Hey guys im looking for help with coding a text field in my form, its looking for the last record and adding 1 to it everytime. This is basically an autonumber but i don't want to configure it as an autonumbe, i want to code it in my add record button!

Hey Paul thanks for your help, as it turns out it was just a simple bit of code in the after update of the combobox (cboCode) txtName = [cboCode][column](1) and then bound it to Name:banghead:

Okay i have unbound the combo. The combo box was initially set up by the wizard. There are no event proceedures. The row source code is SELECT Customers.Code, Customers.Name FROM Customers ORDER BY Customers.[Code];

Yea i'd say you need a bit of patience for people like me :D The drop down has records, two columns code and name, its just blank when the form opens like normal. The combo is bound its control source is Code. I think what im trying to do is not possible but anyway, i want to add a new customer...

In the combo when you click on the drop down there's two columns, code and customer which are pulled from the customer table, if you select an option from the dropdown it will only be the code that will stay in the combo box and the customer name will automatically be filled into the...

Thanks for reply Paul, yes the combobox is used to filter the form and it is bound to the customer table!

Hi Guys I'm new to access and wondering can anybody help me, i have a customer form with a combobox (cboCode) and a text box (txtName). The textbox is bound to the combobox ( =[cboCode].[column](1) ) However i want to still be able add a new record for a customer. Is this possible...