Search results

  1. A

    Excel VBA: String or variant variable showing empty when it is not

    Hello, I have not completed working on the code below, but it is hopefully going to uncheck an item in column B's filter (Filter:=2) of the Billing workbook if the address in column D of the Billing workbook is found in the AddrList workbook. I have a question about why my variable...
  2. A

    WHERE statement with 2 criteria and involving Dates

    Hello, I have a BeginDate field and an EndDate field on my form that filters via a command button the data on the form to just the dates within the range entered by the user. I just have a form, frmNetworkPerformance (no subform), based on a table, tblNetworkPerformance. The code in the On...
  3. A

    Can you turn a one to many relationship between two tables into a many to many relati

    I didn’t know how else to title this--and I am in the process of learning some things in Access--but I have a database where I have, I believe, a one to many relationship between two tables. I have created a main form that is based on tblHub and a subform based on tblNode with a combo box on the...
  4. A

    Updating Field with multiple criteria using Update Query

    Hello, I am updating the StatusID field in a table using an update query. Can I update one field with different values in the Criteria field and the Update To: field? I have to update the values if StatusID says "Complete" update to "1", if StatusID says, etc. (pic below)...
  5. A

    VBA trouble opening form for newly added record

    I’m creating a database for the first time and am new to VBA Access, please. When I click a button on my subform (which is in continuous view) it opens another form, Node Setting Form ("popfrmNEWNodeSetting2" in the code below). The pop up Node Setting Form will open blank with no fields for...
  6. A

    Good practice to have subform in Single Form view?

    I have a main form and a subform with a one to many relationship, having many orders that appear in the subform under one customer in the main form. I have the subform in Single Form view b/c it looks nice, but I have to have the navigation buttons turned on the subform to be able to scroll...
  7. A

    Form based on multi-table form (many to many relationship)

    **Poster's Edit 10/11/2016 8:45 a.m. - the new, correct database has been uploaded to the post. Pardon any inconvenience. I would appreciate any help.** **Poster's Edit: Pardon the error, but I have uploaded the wrong database. I have removed the attachment and will need to upload the correct...
  8. A

    Formula to see if value exists in another field in another table

    Hello, I’m using Access 2013 in Windows 7. I’m trying to use a formula that will tell me if a value from a field in the Design table exists in another field in the Schedule table. If so, then return an “A” in a new field I created in the Design table; if not, return a “B”. I know in Excel it...
  9. A

    New to Access Forum

    Hello, I'm from the U.S. and I am new to this forum. I've used Access (as a user) for a long time, but not at an advanced level and my current job is requiring that I use it at almost an Administrator level, creating a database from scratch, creating relationships, etc. So, I believe I'm going...
Top Bottom