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

    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...
  3. 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...
  4. 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...
  5. 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...
  6. 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...
  7. 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...
  8. 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...
  9. 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...
  10. B

    Duplicate tables

    Hi, After my database got corrupted at one point and after running compact and repair, Access automatically created a duplicate of every table in my database with a 1 next to the name. Example- if i have tblClients, then i also have tblClients1 . And if i add records to tblClients they are...
  11. B

    Record numbers at bottom left corner of form missing

    Hello, I have a strange problem that i cant figure out - please help!!!:banghead: I have a database with numerous forms all of which function normally, except one my my forms which recently does not display the records indicator in the lower left corner where it should say Record 1 of 6504 for...
  12. B

    Query Criteria syntax problem

    Hi, Would someone please help me?! im not sure what im doing wrong here. I cant get my listbox to filter to a specific set of records based on the query criteria for the listbox. I have a list box on a subform of my main form. here is the criteria i have in the [acct] field of the rowsource...
  13. B

    How to check is combobox requery contains data

    Hi All, I have a combobox called BillTo, and after a selection is made, another combobox named ShipTo is requeried for corresponding records. I made the following code, but it does not do what i want. I am looking to populate bound Ship to fields with the info in the BillTo combobox upon...
  14. B

    How to Append to table from Unmatched query results

    Hi Everyone! I am not sure how to append records to a table from my unmatched query. I have run an unmatched query on my tblClients and tblShipToForClients. The result is that i get 4138 records from tblClients without a match in tblShipToForClients. How do i get those 4138 records added to...
  15. B

    Match Listbox to current record

    Hello, I have a form in which i put a listbox that finds records when selected, as well as a search box which locates records. Both work fine, but i am trying to figure if theres any way to make the listbox show or scroll to the record that im on if i use the search box to get to the record...
  16. B

    Messagebox in macro if applyfilter is null

    Hi, I have little experience using the macros in access. Would someone be able to direct me on how to make my macro work! below i attached a screenshot of what ive got so far, and the filter is working fine, only i cant get the messagebox to work. i named the applyfilter 'FindRecord' but that...
  17. B

    Query to make Subform show filtered record set of form

    Hi, I need to make a subform on my main form show 2 fields from the filtered recordset of the main form. right now i just have the query set to mimic where the main form record is. it is: SELECT qryOpenOrdersByCustomer.SO, qryOpenOrdersByCustomer.Notes2 FROM qryOpenOrdersByCustomer; what i...
  18. B

    Uneditable query

    Hello, i am having a problem with a query i built based on three tables. I have found the reason why my query is uneditable but dont know how to correct this so i can edit one field in particular. the query is built on these tables: tblSalesOrders - primary key is 'So' tblClients - primary...
  19. B

    Syntax for Tab Control on form

    Hello all, I am trying to set focus to a specific field on my form every time that this particular tab is selected. I have tried putting the following code into the 'on click' event of that tab. Me.TabSalesOrders.Pages("SALES ORDER")!SearchSoNumber.SetFocus TabSalesOrders is the name of my...
  20. B

    VBA Syntax for Tab Control on a form

    Hello all, I am trying to set focus to a specific field on my form every time that this particular tab is selected. I have tried putting the following code into the 'on click' event of that tab. Me.TabSalesOrders.Pages("SALES ORDER")!SearchSoNumber.SetFocus TabSalesOrders is the name...
Top Bottom