1. gheyman


    Can you use VBA to Filter a filed in a Query I have a Query (qry_OnTimeDelivery_MetricData) I want to Filter Field: "MONTH0_Active" to the value "1" I want to do this from a form using a Button. Can it be done using code?
  2. L

    Form from Options--> All commands vs VBA form

    Hi I just found that I can create a table then Ctrl+T then I can go to Options-->All commands-->Form and use that command to create a data entry form. My question, what is the advantage/disadvantage of that form compare to a one that I can create using VBA? Thank you very much.
  3. M

    Not able to submit a HTML form

    Hi, The following code tries to populate the login form of my library account and submit the form. This code used to work fine until a few months ago. Now I am able to populate the account information but the submit action doesn't seem to work. On the other hand, if I stop the macro...
  4. G

    Error 1004 Method "Range" of object global failed

    Hi All, I have one spreadsheet set up with a form detailed within the sheet using VBA and name manager to print data onto the form and save as a pdf. However I took the sheet and created a new one for a different purpose changing the form and all of the names in name manager to match the data...
  5. gheyman

    VBA code for "Calculate"

    I have a form that has some formulas in unbound fields. When I open it, I see in the bottom left corner that its "calculating". Is there VBA code to make a form Calculate. I know there is in Excel, but is there an equivalent for Access My form name is frm_Home_Page. I don't know if there is...
  6. C

    Bound vs. UnBound Forms

    So I created and administer an MS Access DB -- approximately 20 end users -- they each have an .accde FE on their desktops, while the back end sits on a network drive. The primary data entry form has approximately 70+ fields, with currently 50k plus records. There is a subform on this form as...
  7. A

    vba form

    Hello I need a vba form with two fields, one of which is a drop down list of names and the other is a decimal value to store names in the cell and a decimal in the comment. Then I want to formulate and calculate on the decimals inside the comments. Can anyone help me?
  8. gheyman

    Change a Criteria in a Query with VBA?

    Can you change the Criteria in a Query using VBA? I have a query [qry_OnTimeDelivery_MetricData]. In that Query I have a Field [MONTH0_Active]. What I want to do is from a form, if the User Clicks a Button, the Criteria for MONTH0_Active changes to Like "1" Right now I have an unbound...
  9. J

    User Form or Formula?

    I have a list of 200 names in column A and a corresponding list of rates in column B. What I need to do is be able to enter one rate and have that rate be entered next to each of the 200 names. So if I enter $1.00, $1.00 appears next to each person's name. Would I use a user form or formula...
  10. B

    User Form Label format (date)

    Hi all. Long time watcher first time poster. Have searched he’d for a few days and am stuck on the below I have a user form that populates Labels with a date from a cell in a worksheet the date in the worksheet is in standard format. dd/mm/yy and is imported to the user form with no issue...
  11. S

    Show (2) Form Tabs Open when Access is Opened

    I have the access settings to show one form through options when Access is opened, but is there a way to show (2) form tabs when access is opened?
  12. TAPS_MikeDion

    Need to pass one variable to another form, but it's not passing the value.

    Hi everybody, Even after looking over examples found on the forum I still can't seem to get this super simple thing to work. I'm obviously missing something small. I have a main userform that has a "GET CLIENT INFO" button which opens a small userform displaying the client information, but I...
  13. gheyman

    Refresh DSUM Values

    I have several DSUM fields on a form. The fields are looking for values from a Query: =DSum("MONTH0_Active","qry_OnTimeDelivery_MetricData") But unless I have the query open at the same time as I have the Form open, I don't get values. How can I get this to calculate without having to open...
  14. P

    If userform is already open then MSG box to open saying Userform in Use

    Hi I am trying to put a code together into a command button which opens the userform1, but if someone else has the userform open already I want a msgbox pop up to say that ‘userform is in use’, I have put the following code togetherbut getting no joy. Hope you can help? Private Sub...
  15. M

    use excel while user form open

    I ma trying to set my project so that when my userform is open, I can still select and edit cells. I have tried setting the model to false and using vbmodeless but when I do that the form just blinks and goes away. Any ideas?
  16. S

    Bound Column Change Not Working

    I am using Bound Column 1 - which works fine, but if I want the Combo Box to use Column 3 to filter the form, it doesn't do anything?
  17. willow1985

    Formula to determine next sequence of number starting with 3 letters and in random order

    Hello, I have a list of form numbers that are in random order (see below example). Is there an excel formula that could check the entire column, only look at numbers starting with IAF and determine what the next form number would be? IAF 1234 IAF 1201 IAF 1300 IAF 1001 So it would return: IAF...
  18. D

    Prompt for number of copies to print out

    I read several threads here and they seemed really close to what I need but not quite close enough. I have the following existing code that prompts the user to answer Yes or No when asked if they need to print the NMR form. I would like to add code if they say Yes, it asks how many copies are...
  19. gheyman

    Access: Date in an unbound field on a form

    I want to add a field on my form that will act as a "Title". Actually I have 6 fields. In the first one, if todays date is in the month of September I want it to say "September" in the field. I would even be OK with the Month and Year (But not the day). In the next box if today is 9/17/2019...
  20. S

    Access Database Form Wont' Allow me to Update Records

    I'm ultimately trying to setup an access database form, that has current data in it from an imported excel file that can allow updates. I have the form built but when I try to type in the fields it says "This Record set is not updateable". I do keep trying to setup the primary key but it won't...

Some videos you may like

This Week's Hot Topics

  • Finding issue in If elseif else with For each Loop
    Finding issue in If elseif else with For each Loop I have tried this below code but i'm getting in Y column filled with W005. Colud you please...
  • MsgBox Error
    Hi Guys, I have the below error show up when i try and run my macro in File1 but works fine if i copy and paste the same code into file2. [ATTACH...
    My Cell Format is [B]""0.00" Cr". [/B]But in the cell, it is showing 123.00 for editing. (123 is entry figure). (Data imported from other...
  • Show numbers nearly the same
    Is this possible. I have a number that can change very time eg 0.00001234 Then I have a lot of numbers 0.0000001, 0.0000002, 0.00000004...
  • Please i need your help to create formula
    I need a formula in cell B8 to do this >>if b1=1 then multiply ( cell b8) by 10% ,if b1=2 multiply by 20%,if=3 multiply by 30%. Thank you in...
  • Got error while adding column and filter
    Got error while adding column and filter In column Z has some like "Success" and "Error". I want to add column in AA if the Z cell value is...