Search results

can you help me solve two things please? i got two fields in my form that i am dealing with (these two fields are not working and giving me too much problems) the first one is supplierID this is a autonumber field and second is personID this is a numeric field and a foreign key, these both...

i've got a data entry form. when i click the button add all the other buttons go grey, i am in mode "New" also i am able to add, edit, records in this state, when i press save i want the supplierID field to automatically populate itself with the next SupplierID record THAT IS EMPTY. So say that...

Thank you very much, this helped! :)

okay i think i confused you, basically when i open up my form it always shows the first record, then if i want to see the last record i have to use my buttons to flip through all my records until i get to the last one, however i want the user to be able to see the last record immediately as soon...

i want to run btnLast in "Private Sub Form_Open" that way, when i open my form it wont display my first record, rather my last can anyone please help me with the syntax :)

Private Sub tblSave() Dim tmpCN As Double Dim newStd As String Dim frs As DAO.Recordset With rs If InMode = "New" Then newStd = "SELECT tblSupplier.PersonID FROM tblSupplier WHERE tblSupplier.SupplierName = " & Chr$(34) &...

im getting an error on my =dLast function line and its going red, if you check the attached file you can see what the problem is. Can someone please help me this is confusing me. basically what i need the line to do is when i add a new record it automatically saves the supplierID as the next...

or alternatelysomeone has told me that to get my code to work i have to do three things in my tblSave code 1. Save subform table first 2.Get personID from sub form 3.save the master table second this is my tblSave code Private Sub tblSave() Dim tmpCN As Double Dim newStd As String...

has anybody got a data entry unbound form with subform that they can send me, a tripped version of database will be really really helpful :) i just can not get my unbound form to work

yup thanks, looks good enough :) if it dont work as intended i can tamper around with it, as long as i got something to work around

No Problem mate, il put my latest version in mdb format, because ive made a lot of changes since, and ive learned a lot, got a few problems such as; 1.cancel button not working, need the form to go back into normal mode or previous state IF nothing was entered in the fields, if the fields have...

this is very very similar to what i want, however yours is bound, i want to keep mine unbound and carry on, sort of as a academic exercise what would i have to do to get a similar end result. i remember a few posts ago on this exact same thread i was basically saying i didnt know what a bound...

I really appreciate your help. this really helped to take me towards what i wanted to do, i was slightly confused because the add,delete and save button were quite important im not sure how to add that on now, but it has helped me work on another route (im trying to puzzle together al the basics...

what would i write in the onclick private sub of my 'btnCancel' i need it to do a number of things depending on whether there is data entered in the form fields or whether its completely empty, is there is data being entered in some fields and the cancel button is clicked it should ask whether...

i understand what i am going to do and how i want to do it but i still can not get my head around vba syntax. i got an unbound form that also has a subform. i got an add,delete, save, and cancel button (cancel doesnt work yet, need to make it go 'inMode' normal somehow) in the main form is...

Thanks boss

how do i get rid of the bar below (marked in red shape) in my form view, its an unbound form and i dont want to confuse myself

this is the mdb format of my database, if anyone could check and help sort out my suppliers form

hi, sorry for the late reply, here is the mdb format of my database

i thought that is the only way i am going to get this job done...what other ways are there?