Search results

Great i'll take a look - thanks Chris

Thanks for your reply Chris, Do you know what kind of code I use to filter record on the Oncurrent event in the frmArea subform? Thanks

Hi I have a main form frmproject which is linked to master/child to frmArea (this was a single form) by [projectID] frmArea is then linked to another subform frmProcess master/child by [AreaID] I'm trying to get frmArea and frmProcess as two continuous forms - I've embedded both forms on an...

Thanks missingling for your help, I'm going to give it a try now.

Hi, I have a continuous form with a delete button for each record - however when the user hits delete - I want a pop up message to appear with something like 'you are about to delete this record are you sure?' - If the user presses "yes" - pop up message disappears and the record gets deleted...

Hi, I have 9 buttons my forms and 9 labels set to visible.false - using the MouseMove event for each of the buttons, the labels become visible to highlight them. To reset - I use this bit of code: Private Sub Detail_MouseMove(Button As Integer, Shift As Integer, X As Single, Y As Single)...

Hi MStef, I've taken a look at the demo - the button is in the subform footer - I need the button on the main form to do exactly as it would do if it were placed in the subform. I will take a look at the VBA - vbaInet - I'm going to have a look at the link now -

Hi. On my Mainform [frmMain] there is a subform [subEmployee] I have a command button on the main form - i'm trying to get it to open another form [frmSales] where [EmpID] of [subEmployee] is equal to [EmpID] of [frmSales] (the form I want to open). I/m stuck with getting a command button...

Hi, I have a datasheet form, on this form are two fields [DateStarted] and [DateEnded]. I want the Default Value of [DateEnded] to be that of [DateStarted] as it is on the next record on the form. So on ID 1, the [DateEnded] would have the default value of ID 2 [DateStarted] So that...

Thanks Rural Guy It worked a treat!!! Thanks again.

Hi, On the OnLoad event of my main form is DoCmd.Maximize - I like my forms to fill the whole screen because it allows me to get more stuff on the screen. But when I click on a button on my main form to open up a pop up form - the pop up form opens and displays behind my main form which means...

Hi, I have subform [FrmEquipmentSub] (child) linked to my [MainDocumentForm] (parent link) via [ProjectNumber] - I also have an unbound combo box on my main form, and I want it too lookup only Equipment that have the same project number in my subform as my mainform (hence the...

Hi - I should know this but drawing a blank. On my main form [FrmMain] - I have a subform [FrmMainSub] - (the data they display are from the same table [tblProject] [FrmMain] is a data entry form and [FrmMainSub] is a datasheet that lists all the records associated with that project...

Hi Trevor, Thanks for the help, I will try this tomorrow and update you with how I get on. Thanks Again. Spirited Away

Hi I have a table [tblDocuments] with a field [Status] which is a combo box to update the cycle of the document. (i.e/ not started, draft, review, executed, approved etc..). The combo is a lookup field from a look up table [tblLookupStatus]. The user now wants to be able to do this: Each...

Hi I have a question about table relationships - one to many. [tblProject].[ProjectID] has a one to many relationship with [tblDocuments].[ProjectID] [ProjectID] in [tblDocuments] has a lookup row source: SELECT tblProjects.ProjectID, tblProjects.ProjectNumber FROM tblProjects ORDER BY...

Thanks John - I will pursue the links you've provided and let you know how I get on.

Hi, I have a form [frmInterface] with a combo box [globalcombo] - what I had it mind is having the combo box with a lookup where I can populate it with names from my global address in Outlook. After I have selected the person I want - I want to then be able to come back to that record at...

Thanks dbDamo I've looked at the thread - the code allows access to populate outlook email with subject, body message and email. But will this code look for due date for example 06-Sept-2010 and automatically create an email with info pulled from the form and send to the recipient without...

Hi, I'm building an appointment reminder db The idea is that I have a form, [frmjob] - in the form are four fields [scheduledate] - the date job is due to start [jobdescription] - description of the job needed doing [assignto] - email address of the person who will be assigned to do the...