Search results

Hi All, I have a form that contains a listbox which is used to select a product and the form navigates to the selected record. I also put 2 radio buttons on the form called Active and disactive. These buttons toggle what the listbox contains: here is the code for one of the buttons: Private...

Hello, I'm having a problem getting the proper value from my calculated field in my table. Does anyone see the problem here? my calculated field is: StdCost = ([R1]*[R1Percentage])+([R2]*[R2Percentage])+([R3]*[R3Percentage]) R1, R2, and R3 are all lookup fields that look to another table and...

Hi All, I could really use some direction on this please! I'm not sure how to go about it. I'm thinking it will have to involve multiple queries, not sure at all what i need to do. I have a table with 5 fields. ResinCode R1 R2 R3 R4 There are some ResinCodes that are only comprised of R1 in...

Hello, Does anyone know how to wrap text in a combobox dropdown? I set the combobox "can grow" property to YES but it still wont wrap text on items longer than the specified column width. Any suggestions would be much appreciated. Thanks, BJF

Hello, Is it possible to reference columns of a combobox in a query on another form? Thanks for any information, BJF

Hello, I want to hide or show a column on a subform thats in datasheet view by pressing a button on the main form. Here is the code that I tried so far on the button but neither of the code below are not working...

Hello All, I am losing decimal places when I copy from Access, whether from a table row or a form in datasheet view and paste into an email, or anywhere including here for that matter! This is a copy and paste from 3 rows of my table, but what I see in my table is: $0.0610, $0.0800, and $0.1040...

Hi, I'm attempting to make a report with multiple invoices in the body of the report and could use some guidance please! So far, what I have is a form that has a multiselection listbox. First, the listbox can be filtered to a specific set of customers invoices. After the user filters the...

Hello everyone, I don't understand why this happens - please help! I have a form to look up customer info. The form has a combo box where i can select a customer and it take me to the record via vba, something like this Me.FilterOn = False Me.RecordsetClone.FindFirst "[acct] = " &...

Hello, I cant seem to figure how to reference a subform field in a macro on my main form. I use the macro on a listbox so when a record is chosen, it locks certain fields. The macro is working fine to lock main form fields but when I add an action referencing my subform field, I get the error...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...