Search results

  1. mistyinca1970

    "invisible" box on form in layout view

    Can someone tell me what this red dotted box is? This is on a form within a navigation form. This shows in layout view, and it doesn't appear on any other form in the navigation form. I also do not see it when I open the target form on its own in layout view. I can't seem to select it. Any ideas?
  2. mistyinca1970

    Solved Combo Box with multiple columns: using respective column in vb code

    Sorry if the title is confusing. What I'm trying to do is use both columns of a combo box in different ways. My combo box (cboSendTo) has two (visible) columns: one's name and then one's email address. Is there a way to specify the column of the combo box to use in code other than whichever...
  3. mistyinca1970

    Solved Criteria in query to return all records

    Hello, I have a query that is tied to a form that will show records based on the user's division in the org. The criteria comes from a TempVars captured at login. What value would I need to get in this field to return records for all divisions? SELECT tblContracts.ID, tblContracts.Division...
  4. mistyinca1970

    Solved Using recordset match to set TempVars

    OK, I have a login form that uses recordset to validate the associated password entered into the login form. I have been using this information entered to capture TempVars that will be used throughout the many forms in this DB. Up until now, it set the useraccess of the person who logged in and...
  5. mistyinca1970

    Solved OpenArgs prompting "Enter Parameter Value"?

    Good afternoon, I'm trying to pass a value from one form to another. The originating form has the following code: Private Sub btnUpdateStatus_Click() DoCmd.OpenForm "frmUpdateStatus", , , , , , Me.txtContractNo End Sub and when we open frmUpdateStatus a box asking for a parameter value...
  6. mistyinca1970

    Solved What event is this?

    I have this scenario in several forms in my DB: clicking a button will open a pop-up form that will update a record. When the pop-up form is closed, I would like to refresh the main form, but I don't know which event that is. So currently, I have a button I manually click to refresh. Can anyone...
  7. mistyinca1970

    I guess I should introduce myself

    So I have gotten a lot of great tips and education from this site for a couple of months now. I guess I should share a little about who I am and what I'm doing... My name is Misty. I am an analyst for a local government office that deals with emergency data. My duties have shifted a bit lately...
  8. mistyinca1970

    Solved Query issue with currency and extra pennies

    I have converted a beast of a spreadsheet into an access database. I am working on a query that is being used for an access report. Here's the gist of what it does: The amounts in here are currency, and there is a specific amount, so coming up a few pennies more or a few pennies less is not...
  9. mistyinca1970

    Solved Query criteria from different fields

    OK, I am stumped on this one. I have a project in which I will be using a form's combo boxes to provide the criteria in a query in order to generate a report. My problem is that I have a table that has multiple year values. Here's the table: I want to have a combo box direct to one of the...
  10. mistyinca1970

    Solved Temp Vars and switching users

    Can I simply reuse my login form to switch users. My question is basically, if I assign a Temp Vars, does it replace any existing Temp vars, or is there another bit of code I'll need to use to clear the old Temp Vars first? Here is the code for my login form: Private Sub btnLogin_Click()...
  11. mistyinca1970

    AutoExec as vba instead?

    I have an AutoExec macro that opens my login form. But I want to add some error handling because I forgot to log into our VPN this morning, and I got error 2950. So I want to have a message box deploy for that error. I used the convert feature, and it created it as a Function in a module. So...
  12. mistyinca1970

    Solved Multiple error handling on one button

    I have the following error handling added to a button, but I want to add another handling for another type of error. This one in particular is if the user fails to select a report from the list box prior to clicking the "Email Report" button. Private Sub btnEmailReport_Click() On Error GoTo...
  13. mistyinca1970

    Send contents of attachment field?

    Is this possible? I have .pdf files in the attachment fields of records. Is it possible to send those in an email? I can't seem to find a way to do this using SendObject. Thank you,
  14. mistyinca1970

    Solved How to get rid of "Save to SharePoint Site" prompt?

    I cannot find a way to get rid of this prompt. Of all my databases, this is the only one that has this prompt. I want to get rid of this before distributing the FrontEnd. Thank you,
  15. mistyinca1970

    Login Access for Navigation Form

    I have created some user access IDs and I have a login form that transfers the user's access ID into a TempVars. Here's my issue. I'm using a Navigation form, and I have an Admin tab that only I will have access to. I know the "If" part of my On Load event is working because when I log in as...
  16. mistyinca1970

    Solved Using a wildcard in vb code

    I have discovered that the "*" does not seem to work as a wildcard in my code. I want the graphic to show up for records whose Company begins with "EMD". What is the correct way to express wildcards in vb coding? Thank you, Private Sub Form_Current() If (txtCompany = "EMD*") Then...
  17. mistyinca1970

    Solved Saving Query creates ghost "duplicate" query with appended numbers

    OK this is the weirdest thing I've ever seen. I'm creating queries that have a criteria column that is a multi-select lookup. When I use this in my query, there are two queries saved: the one by my title and one that doesn't exist. I'm going to post screenshots because I know that does not make...
  18. mistyinca1970

    Solved Sending email with QueryFieldAsSeparatedString

    Good morning, Let me preface this with I do not really know vb coding. I basically find bits and pieces here and there to try and make it work for me. I am stumped on a send email code. I have built a contacts database. This will house name, org, and contact information such as email and phone...
Top Bottom