Search results

okay really strapped for time and the db is large... the mainform does not have a recordsource okay... on the sbform if i created a new button it would have the codes DoCmd.GoToRecord , , acNewRec can i modify this to be executed from another form....? if i was creating the same add...

okay i have one main form... and two SUBFORM "WINDOWS" on the form... one subform window has a form in it that "acts" like a remote control for all that is done on the other form that is currently active in the other sbform window so frmS is the subform window name that has in frmCalSEt which...

Try This I think this may help... if it does let me know... I had to do something like this for a project this year.

The Code Private Sub lstCalValue_AfterUpdate() Forms!frmMain!frmS.Form.RecordsetClone.FindFirst "[checknum] = " & Me![lstCALVALUE] & "" If Not Forms!frmMain!frmS.Form.RecordsetClone.NoMatch Then Forms!frmMain!frmS.Form.Bookmark = Forms!frmMain!frmS.Form.RecordsetClone.Bookmark Else...

i have a listbox that manipulates records on another form but in case i click on one of the records in the listbox that doesnt have any corresponding record in the other form then instead of it saying that it cant locate the record i would like the form to go to a new record.... i've been...

How do I filter A listbox by another listbox.. Just a hint plz. i really need some help on figuring out how to filter one set of records in one listbox based on other vales selected in another listox... i know how use a combo box and cascade a listbox bt im having a bit of difficulty getting...

i checked the tools > options > datasheet > and where im supposed to see my font, i have no font there or see any in the font listing.... my tables look blank but i checked the database on another computer and the data is still there... can anyone please at least drop me a hint as to what may...

how to trigger the unhook codes when double click icon in sytem tray i got this to work, got the vba332.dll and also the addressof code and i got it to work as far as minimizing to the system tray, but i would also like to double click the icon to bring back up the form.. sadly i dont know how...

Default Date Format for Records From in my table how can i format the date to show "Jan, 2006" What i would want it to do is like do a datepart thing something like datepart("M",(CurrentDate))&","& datepart("YYYY",(CurrentDate))) but im not sure how to do that so that the default value of...

GR8 Forum with gr8 minds i was just browsing through some posts and found one about creating a Compound Primary Key where the ContractId can be repeated in the Invoice tabkle (which is needed) and the Invoice Month can be repeated (Which is also needed) but not a combination of both so i could...

Hi, I have Three tables the first is a ContractTable the second is a Monthly Invoice Details Table and the third is a Detailed Payments table Contract 1 -> Many Monthly Invoice 1 -> Many Detailed Payments what I would like to do is ensure that there arent any duplicated Months for a Contract...

this is the screenshot this is the screen shot

Been Searching Is there a way to achieve this, I really need to be able to do this. Or is there an alternative solution that can be suggested Ive attached a screen shot to show exactly what is happening

Hi Good-Morning (its morning here in Jamaica) (Whatever time of day it is where ever it is that you great minds are in this beautiful world we live)... I created a form and used an image control with a filepathfield that is stored in my table,... that works well as far as displaying the...

I found a very useful calendar example on this forum that allows you to use it much like a diary/event scheduler.. when you click in a particular listbox that represents the day, the event that you clicked opens up a pop up form with the information displayed.. I've integrated it as a part of a...

Im attaching a picture of the problem im having... One the form that im using I have a subform that is filtered to show all data (which is packages selected for a particular cable box) relating to one Client... The problem is that although it already is filtered as a subform to show data for...

Im trying to display a report in the snapshot viewer object that i placed on a form, the thing is that im having a problem filtering and applying the filter fields that i used to the actual report in the window. Im having problems referring to the object, can someone help with like the syntax...

NONE OF THESE BELONG TO ME; (this is a disclaimer so that others who see THEIR work here doesnt think im taking ANY credit for this) I think its fair to say im eternally thankful to those who have been unselfish.

Here are some TreeVieew Samples. I found these to be extremely useful

These are some more files