Recent content by Bilal

i have a form and subform with data. the problem is that when i open the form it always shows the the first piece of data enetered and i have to click on my button which i have called btnLast. is there any way i can get the form to run button last on form open or anything like that because that...

i have these lines of code TodaysDate = TheDate Msg = "Months from today: " & DateDiff("M", DOB, Now) MsgBox Msg End Sub Its very simple and it works however the last line 'MsgBox Msg' just shows the number up in a msg box ive tried changing it to txtbox msg, but it doesnt seem to work. help...

OMG thanks so so much, i did not know that it would be this simple! :D

Is there some kind of Time picker function , i can see the date picker however i am using a booking system and have a field named 'time of booking' and i need something that can dump the exact system/online time into the field. Thanks in advance :)

here it is, as you see the data will al go to the table once the save button is pressed so that's okay. however after i fill out the main form and subform i have to put a matching number in the main form that corresponds with my subform, if not the data wont show when im going through the records

PersonID master is bound to PersonID child. would a stripped down version of the DB help?

nope not working

It is definitely not orphaned, ive enforced referential integrity strictly, the fieldis meant to be there and is no mistake. the main reason its there is that when the save button is pressed the PersonID number on the mainform can be saved in a table, but at the moment when i press the save...

im doing this all as a bound form my main form got a field named 'PersonID'. my subform also got a field called 'PersonID' the subform 'PersonID' populates however the mainform 'PersonID' does not. i just need to write code, or maybe do something that will copy the number from subform and...

Need a sample booking system db, something i can work with to create a simple yet clever system for my aunts nursery. The Plan is to have an access database at the front desk for the receptionist to be able to manage bookings, dates, amount of children at any given time and facilities being...

if you take a quick look at my Db's suppliers form which is atached, you will understand why i want the person ID to save in to tables, one table as a primary and the other as a foreign key because the PersonID field will be the one field that links tblPerson and tblSupplier. im just unsure of...

i got a form with three normal fields where i add data i then have two auto number fields i.e. SupplierID and PersonID the supplierID works fine, i can add a new record and click save and it will save the data in the suppliers table. The problem is with my PersonID field, i need it to retrieve...

Thanks bosss

its all unbound, saving the records using .addnew .update and all that business. if you want to see a copy of the DB let me know

i have an unbound subform within a main form that i add data to. once i click save to save all the data the subform data will save itself into tblPerson and the main form data will save itself in tblSupplier. The tblPerson will have an autonumber for the whole record, i need this autonumber to...