Search results

go back to the startup and check all the check boxes. HTH Rpb

I dont use the built in access switchboard but I think you can make it full size when the database loads up by doing this: go to the macro tab click new on the first line click and select OpenForm at the bottom of the screen go to the Form Name field select the switchboard. then back up top go...

if you trying to pass the variable from a form to meet a fields criteria on a report try this: in the criteria section in design view of the report put [Forms]![formname]![fieldname] if the field is on a subform simply do this [Forms]![formname]![subformname]![fieldname] let me know if this...

Hi, I created a small dbase that shows you how I took care of the same problem your having if you or anyone is interested email me at Fdarouian@yahoo.com

okay I have a subform on a form. how would I undo all changes (and deletions if possible) on the main and subform via a command button on the main form. All i know is: me.undo and setting the commands button cancel property to true but that doesnt help much. well thanks for any help,

this is not working heres my code: txtname= SELECT managers.mlastname, managers.MM FROM managers WHERE (((managers.MM)= Forms![intro]!txtmm.value)); what I want is: txtname to display the name where managers.mm = txtmm on the intro form. any guidance?

Hi I'm using running sum to get a total in the detail of one of my reports, how do I only get it to show the last value (the highest one), and not one after every field? should I move the detail into another kinda of grouping? its getting a little confusing now. thanks for any help,

worked great thanks

hi okay, I have a form that has a combo box on it and a text box. When I select the a value you in the combo box I'd like the matching information to appear in the text box. The combo box is getting its data from one table that has only 2 fields in it. Report Name and Report Description...

okay I think this may help you along. If fieldname = "" Or IsNull(Subprojects) Or IsEmpty(Subprojects) then MSgBox("Item not found") end if HTH

I had a similar problem and it was my links, check your child parent links. if this doesnt help give me some more information on the situation and ill try to help

send to wallyg135@yahoo.com Ill take a look at it

open the form you want maximized in design view then right click on it go to the events on the on open or on load event put in this code docmd.Maximize and that should do it. Rpb

hey I have no idea try posting a message here: http://bbs.zdjournals.com/bbs/wwwthreads.pl?action=list&Board=ima they got a bunch of smart guys at that forum Rpb

Private Sub Site_Name_Enter() On Error GoTo cbomanager_Enter_Err <--CBOMANAGER should be Site_Name also that was my fault I forgot to change cbomanager to comboboxname. sorry

I basically do the same exact thing on my forms and the docmd.requery does the job fine, but Ill post what I do anyway. In the OnEnter event for the combo box I put ----- Private Sub comboboxname_Enter() On Error GoTo cbomanager_Enter_Err DoCmd.Requery "comboboxname" comboboxname_Enter_Exit...

Well first off you would have to know when the mouse pointer is over a cmd button so : ------- Private Sub buttonname_MouseMove(Button As Integer, Shift As Integer, x As Single, Y As Single) end sub ------- post dev ashish's code , maybe I can hepl you work through the rest of the problem

I think it could be of use definetly could I see the function? I'd like to test it

Hi thanks for hte reply but its still not working correctly, it will not apply the filter heres the code now: --------- Private Sub Form_Load() If IsFormOpen("associate/project") = True Then Me.Filter = "[LastName] like '*" & Forms![Associate/Project]![txtlast] & "*'" Me.FilterOn = True MsgBox...

okay heres my code: Private Sub Form_Load() DoCmd.GoToRecord , , acNewRec If IsFormOpen("associate/project") = True Then DoCmd.ApplyFilter , "LastName = Forms![Associate/Project]![txtlast]" End If On Error GoTo Err_Form_Load DoCmd.ApplyFilter , "LastName =...