Search results

If UBLCombo equals "MarriedChildren" and Primary1Relationship doesn't equals "Spouse" or "Child" or "Stepchild" Then Primary1UB equals Yes (checkmark)

I tried adding the parenthesis to include the whole statement (without the inside parenthesis and with the inside parentheses), no luck

I cannot seem to get this code to work. I've tried OR instead of AND. Am I using the parentheses incorrectly? If Me.UBLCombo = "MarriedChildren" And (Me.Primary1Relationship <> "Spouse" And Me.Primary1Relationship <> "Child" And Me.Primary1Relationship <> "Stepchild") Then...

I've asked this question before but I usually get the same response (create a user table) but this isn't quite what I'm looking for. I don't want people to log in as they open a db. I want to limit the number of machines (10) using the dbs. I have a small collection (12) of DBs (split). I...

It's not users I want to limit ... it's machines. If that's not possible. Is there a way to limit no more than 10 users at one time (or whatever number is decided)?

I have split database (front end; back end). I cannot create an exe file so I know I cant truly protect the db. What can I do to limit the number of possible users (10) without the person entering a password each time. I have limited skills (VBA) so simple (less secure) is okay. I'm not...

I have a form1. From that form1 I open form2 which typically appears in front of form1 (okay). Recently, form2 pops up but under form1. If I move form1 I can access form2. What can be causing this problem? How to I get form2 to always appear on top.

Resolved: I created a sub-report (with the signature block). I then filtered the signature block with the SigBlockCombo. Thanks Ranman256

My combo box on my form is unrelated to the data on the form (combo box for signature block info such as name, title, position, etc.). The combo block referencing a table of technicians (lastname, firstname, title, position). The combobox shows only the last name of the person. The problem...

I have the combo box on the form (pull from technician list). I need to pull record information related to the Name I selected from the cbo. I don't know how to reference the data from the cbo in my report =[Forms]![frmRetrievedPassports]![SigBlockCombo]![LastName] Help please

Thanks ... I had the combo box in the form (one name) but my report didn't show the signature block. I don't know how to refer to the combo box in the report. Thanks for the help

I have a report with a signature block that changes depending on who prints the report. With one record this is easy. The user selects a person from a option field. My problem is that I have a letter that contains names from several records. How do I create a signature block in which the...

I have two forms both with a field [Group]. I'm in a record in frmAuditSchedule. I want to open [frmInputScreen] filtered on [Group] of the record I'm working on in frmAuditSchedule. I tried ... DoCmd.OpenForm "frmInputScreen", acNormal, , Forms![frmAuditSchedule]![Group] but the form...

I have a field in a table which is linked to table2. In table2 I have ORGN (text field) and Inactive (Y/N field). In a form I want the ORGN field to only show active records (Inactive "N"), which I can do; however, if I make the ORGN inactive, then none of the previous input records will show...

I'm building a table of computer MAC addresses (authorized computers) I don't understand how to refer to a MAC address in VBA code. Any help would be appreciated.

Sorry. I have a field in the report footer. I'm trying to count the number of instances between two dates based on the date range provided by the user (between [Enter first day: DD-MMM-YR]) And [Enter last day: DD-MMM-YR]

I'm trying to count a date field between (to include) two dates (without luck) I tried ... =IIf(([DiscoverDate]>=[Enter first day: DD-MMM-YR]) And ([DiscoverDate]<=[Enter last day: DD-MMM-YR]),Count([DiscoverDate]),Null) I tried ... =IIf([DiscoverDate] Between [Enter first day: DD-MMM-YR]...

I'm working in a database where the forms are set at a certain size. When I move into another database, the forms resize to what they were in the previous database. I want to lock the forms to a particular size, so they don't change every time I open a program. I've tired ... DoCmd.RunCommand...

That did it ... THANKS!!

I need help with my DLookup code. I have a form with an unbound combo box (SigBlock) in which the user select sa technician's name (Rowsource: tblTechnicians; bound to TechID). I'm trying to pull a field (Line2), from tblTechnicians, into an e-mail I'm writing. I wrote ...