Search results

Hello All, Quick Questions..Can I add a button from wizard to create a new record and then add some more custom code to the same button. I mean for example when I click the button before it would create a new record in an edit mode. I want to make something visible before performing its...

Hey Hey VbaINet@ I've sorted it out...I was so Naive with this problem spent donkey's ears on this but i am glad I've found it. I've had a one to one relationship but forgot to lookup from the sub-table and rather was generating autonumber..I hope you got what I am tryin' to say...but thanks a...

Not exactly the response to your suggestion but I've just realised that the fields in the main form are actually connected through a query which inturn is pulling or pushing data to three different tables (though all three use the same issue ID). Is that some thing I shouldn't be doing? However...

Unfortunately I cannot as there is a lot of confidential data on my forms n tables and it is too much work for me to replicate the db with dummy data..Thank you anyways...

Yes it is indeed. I've just dragged n dropped the child table into the main form onto a tab control and made it a datasheet view.

the main table is issues with a primary key Issue Id and the sub form has a table called activities where activities related to an Issue Id. its a 1-2-Many relationship

But apparantly In Access as soon as I get focus onto the sub form the main forms data is saved to the underlying table. So do i need to do anything before that to ensure that the parent record is saved?

Hello, I have a form and a subform. On my parent form I have a field called "IssueId" and a tab control on which I have put my subforms (on each tab a subform which are all related to the IssueId on my parent form). The field “IssueId” is a unique field, so I can’t create double records for...

Are these combo boxes in a Single form, Continuous form or Datasheet? How did you set up Combo A to filter Combo B? Yes they are combo boxes... Table A has list of all the Main categories like Color,Drink.... Table A ID strMainCat 1 Color 2 Drink 3 Phone Table B...

Hi I've got a table with Two Columns Col A & Col B Col A is linked to a sub table called list Col B is linked to a different table as wel COl A - has for Ex: COLOR, Drink, Phone COL B should refresh depending on Col A's Value ...For Ex if I select COLOR in Col A Col B should Drop down only...

I am relatively new to access as have been working with C Stream earlier. I want to save a record in the main table when tab control gets the focus in access. I've tried RunCommand DoCmd.Save with no success. I've also used If Me.Dirty Then Me.Dirty = False but i still get an error msg saying...

Can some one tell me what property shall we use to see if a toggle buton is pressed or not apart from figurin' out from its forecolor. I know my query is very simple as i can accomplish the task using a check box or a cmd button. but I want to use this toggle button deliberately. Thankin' you...

Re: MS Access DTM Picker - Query - Reg Sorry...Just becoz you've been tagged as VIP & also appeared to be online and I din know any other way to chat, I've tried to pass my message to you....:confused: I Hope its only the way I tried to get connected to you has irked you and not my actual...

MS Access DTM Picker - Query - Reg Hi VBANet, I am working on MS Access 2010 and am wondering if there is a way to cross out the dates from a date picker (*Like in travel agents websites) For example I've got two text boxes which have a datepicker attached to them. It works fine but then I...

Hi, Why not use the Control Tip text property of that particular component/Control. Its definitely Control TipText property Good Luck

Hello All, I am working on MS Access 2010 and am wondering if there is a way to cross out the dates from a date picker (*Like in travel agents websites) For example I have got two text boxes which have a datepicker attached to them. It works fine but then I want to add this functionality...