Search results

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...

i am in a real pickle. ive got my main form named frmSupplier and it can populate the table it links to called tblSupplier, the subform however does not populate anything in tbl Person. Ive messed around with the code for quite long now. What i want it to do is to firstly get the autonumber...

Thanks for the reply :) okay below is my stripped database, if you look at the suppliers form and mess around with it, you can add data into the main form and it will quite happily save, and the data wil save in my tblSupplier also, however when i try to add data into the sfrm the information...

im not really sure where im going wrong but this is the problem, i got a form and subform, both unbound, i got a data create, update, delete system. the main form is fully working, when i press my add button to enter data i am able to create/update/delete records however my subform just...

hahahah that first line made me lol, i fixed it though, it was my .addnew .update .edit and .update which were jumbled around and i also had to get this line of code in; Me.SupplierID.Value = DLast("SupplierID", "tblSupplier") thanks very much for helping me earlier also, god bless Bilal

Firstly i am only displaying the ID on the form for my reference, until i get it right, then i can easily make it invisible with a few clicks, secondly, it is unbound because im playing around trying to accustom myself with unbound forms, i can easily do bound. If you have a look at my...