Search results

  1. B

    Filter listbox to forms recordset

    Hello, Its been awhile and i cant figure how to do this: I have a listbox on my form that shows company name [company], and theres a macro on the click to go to whichever record is slected from the listbox. The query for the listbox is 2 fields: [ACCT] and [COMPANY] [ACCT] is the primary...
  2. B

    Subform not matching Form from vba open event

    Thanks for the responses everyone. I still have not gotten this to work. I will have to look into it further.
  3. B

    Subform not matching Form from vba open event

    Hello, I’m having a problem when I put the following code on a DblClick event of a form that I open from my sales order form which organizes info for me: DoCmd.OpenForm "frmSalesOrders", acNormal, , "[SO]=" & Me![SO] It opens the form (actually the form is never closed because i am coming...
  4. B

    If then statement in a query field

    I am looking to have a total field (which contains an amount in every record) = whatever amount each record has.....unless another field in the query is populated...and if that is the case, then i want my total field to equal 0.
  5. B

    If then statement in a query field

    Hi, Up to this point i have used more VBA then exploring the power of queries, but I could really use some help with something that I think is possible but can not figure out. If I have a query that has 2 fields, and i want to make one field = 0 if the other field is true, how do i go about...
  6. B

    Form and Query Question

    here is my row source for my listbox - at this point it contains all records instead of a filtered set pertaining to the parent record (Acct) that i am on. The listbox also has a macro that filters the subform of the main form and works fine but id like to narrow the contents of the listbox...
  7. B

    Form and Query Question

    Thanks for the response Pbaldy, I unfortunately wrote the post just before walking out of the office this afternoon and will return on Monday and will post the syntax in the morning on Monday! Thanks again and look forward to your assistance. Sincerely, BJF
  8. B

    Form and Query Question

    Hi, I am having a problem referencing a field in order to filter my listbox. I'm been driving myself crazy with possible solutions and nothing works yet. Please assist if you can and i will do my best to be articulate in what i need and currenty have.... TO start, This is a form with a tab...
  9. B

    Format problem in Text box

    Thank you both June7 and Micron! Finally got it between both of your help and input. I really appreciate it
  10. B

    Format problem in Text box

    I dont know why, maybe because i have the word standard in quotes before it???? my code was: =Format([Forms]![frmSalesOrders]![fsubProductNew].[Form]![QtyYardsOrdered],"Standard",0) & " Yds" and i get 30,000.00 Yds if i swap out the 0 with "#,#" i get #type! and if i just put #,#...
  11. B

    Format problem in Text box

    Thanks for the response Micron but unfortunately that wont work, however i can live with the decimal places. Thanks for everyones input
  12. B

    Format problem in Text box

    Thanks for the response, I forgot it turns it into a text string! i was able to use format function before the number portion of my control source and it worked however i cant seem to control the decimal places. my control source is now...
  13. B

    Format problem in Text box

    Hi, I'm having a weird format problem. I have a text box on a form that I use to display a number from a subform. I use it because its on another tab of the form. It works fine but the format only works under one condition. The control source is...
  14. B

    Parameter query syntax for multiples

    Hi, I wasnt quite able to find an answer anywhere yet for what i am looking to do, so here it goes... I have a parameter query set up to run a report which is simply asking for an employee id. So in the query I have [Enter Employee ID] in the criteria section for the EmployeeID field. When i...
  15. B

    Macro Action selection

    Hi, I'm not very familiar with using macros and I am wondering which action i need to choose to do the following: I have a combobox and a listbox on my form. The combobox uses a macro to find a record on my form but i need to add another action to that macro. I want to set my list box to...
  16. B

    Back End Crashing

    Thanks for the info Ridders, Hopefully i can find a solution somewhere within the links youve provided. I appreciate the response! Brian
  17. B

    Back End Crashing

    I am using Windows 10 ver. 1803 .
  18. B

    Back End Crashing

    Hi- I am running Access 2013 with a Front End and Back end. The four people using the front end each have their own separate file on their c: drive. The back end with the tables is on a shared network drive d: Recently the back end seems to crash out of nowhere - Ill be entering information...
  19. B

    Filter a combobox

    Hi- The rowsource of my combo is the following: (i used the wizard to create it to select records on my form) SELECT tblStandardCost.ProductNum AS [Product#], tblStandardCost.Category, tblStandardCost.Description, tblStandardCost.CustNum AS [Customer#] FROM tblStandardCost ORDER BY...
  20. B

    Filter a combobox

    Hello, I have a form with a combobox that selects records. Is there a way to filter the combobox based on the form filter? For example: My form holds a recordset of 100 records, and without any filter applied, my combobox also holds 100 choices...... I want my combobox to reflect the curent...
Top Bottom