Search results

Hello, I found the following code on Microsoft and applied it to my BackEnd which obviously only had the Admin logged, which is me. I would like to alter this code to check if someone is in another Database - such as the accde. I would like to find out who is in the database so I can reach...

I have a form that opens in datasheet view and allows the user to select options from dropdowns in some of the fields. When I use the form on its own the dropdowns can be selected, however, on once it's in the Navigation form, the dropdowns drop down but I can't make a selection. What is missing?

I have a main form (Form A) with a subform embedded (Form B) When I click a button to open a second form (Form C), gets embedded Me.FormB.SourceObject = "FormC" ' - no problems there Form C has a double-click event to open the specific form to the record: DoCmd.OpenForm "FormD", ...

HI All, I have a main form (frmIncRetEstimates) with three combo boxes and a SubForm sfrmEstimateLogSummary) that opens in Datasheet view and is linked by the Link Master Field and its Link Child Field The SubForm when opened on its own has a filter and the Filter On Load is set to Yes. I...

Scenario: Form A contains: a combo box to select a requestor VBA - Form Load: ComboBoxControlName.Requery (I tried this OnActivate too) VBA - combo box AfterUpdate MyFormControlName.Form.FilterOn = False Form B (datasheet view) Form B Form Load will filter the records on the current user...

I have a subform that OnLoad will filter by the current user but sometimes they'll need/want to see other tasks (primarily for supervisors). So the OnLoad of my SubForm filters on the current user. On the main form, which only contains the combobox to select another user the parent/child...

I've been searching all over because I know you all hate navigation forms but I have to bite! I have a form that's already been built and looks like this: Main Navigation Form includes the Edit Details button (among others). While I'm on the Project Details, I want to set focus to the Cost...

Hi All, I've searched and only found ways to pass values from main form to sub form but not the other way around. Example: I have a form that when a button is clicked, another form opens to write a reason for the decision. This text will be used in an outgoing email. So Form 1: Form 1 is in a...

Hi, I have a Navigation Form and I've added a report so that it's linked to the form by a field - Link Master Fields and Link Child Field so that the report displays the selected record. How can I get it to print? When the Print window pops up, the whole report is displayed rather than just...

Hi All! I want to add as part of a datacheck when the user clicks on Submit and Close. I have coding already there for other things, but how do I code for this? i.e. If Me.bFinancial = -1 then Me.txtFinancial not null I know that's not right, but I'm having trouble writing in the Not Null...

What is the best way to accomplish this? In my table the field is set to Data Type:Format = Yes/No (Default Value is No) Under Lookup I changed it to Text Box so that it displays Yes/No instead of a checkbox on the table. When I add the field to my form I'd like it to display as a dropdown to...

I have a Navigation Form in which the first button is defaulted to show a blank form (Request form) where users will enter information. There's an option on this Request form that if there are multiple requests under this request, `a box is checked and another form opens (Multiple Requests)...