Search results

Hello, This is I guess a purely vba in Excel question, but I'm trying my luck here anyway. I've been trying to understand how to use the find method in vba to locate a row where Column A equals something and column B equals something else. I know that in my sheet this row will be unique and I'm...

Hello, I want to get payments per employee which are over 2 standard deviations over/under the average. For this I have two subqueries below and the main query which picks out the individual payments. Both subqueries run successfully. The nested subquery in the FROM clause of the main query also...

Hello, Can someone provide a concrete explanation as to why exactly it is not recommended to create a sql server database on a network drive? If anyone has had an experience with sql server on a shared drive, can you please share what ups and downs you've had and would you, based on this...

Hello, I have found this week that after linking to a SQL Server back end I am having trouble running some queries- I get a 'call failed' error (with no error number). I searched the causes for this error and the first thing that I came across said that this may be due to not having the latest...

Hello, We want to migrate the data tables only to SQL SE but keep front end the same, which I understand is not a overly complicated thing to do in itself. However, to make it efficient and not run into a lot of network-caused slowness, I understand that the queries that are needed for reports...

Hello, I am trying to filter a form based on a listbox selection made by the user: Me.Filter = "[FiscalYear] = " & Me.listbox1.Column(0) & " And [Num1] = " & Me.listbox1.Column(1) & " and [Num2]= " & me.listbox.column(2) This works for me ONLY if I have one column in the listbox by which I...

Hello, has anybody had this happen- scroll wheel stops working in one table- the rest you can scroll in as usual? I know there can be issues with scrolling when you're missing some driver for your mouse, but this happened all of a sudden to just this one table, so I can't imagine that it's the...

Hello, I am in for a huge headache because one of the users just discovered that the form that we use to update two tables isn't updating one of the tables. I was very careless during testing, so now we have a bunch of updates to trace and put in manually, so I am feeling pretty awful and...

Hello, I am able to set the recordset of a listbox in the on load even of my form: Me.PONumtoSearch.RowSource = " sql here..." but when I try with a combobox, the combobox is blank for all records on the main form Me.Itemstosearch_combo.ControlSource = " sql here... " Why won't a...

Hello, I have some currency fields in a table and I set their decimal places to 2 so only 2 are displayed. But some have more digits so that the actual value in the cell can be slightly different than what is displayed. I want to replace the value in the cells so that the ACTUAL value is the...

Hello, I have a form with textboxes that display various sums from a table. The summed fields in the table are currency and display precision only to the hundredth's place. The format of the textboxes on the form is also currency. When you just look at them, they display two places after the...

Hello, I know there are a lot of threads on this topic out there. Having read a lot of them, I am still not sure whether what I want is possible in the 2003 version of Access. Is it possible to base the background color of a row of a continuous form on a condition in Access 2003? From what I've...

Hello, I am trying to set the default value of one of the columns in a 3-column combobox. Private Sub Form_Load() ‘some calculations to arrive at CounterNum here … CounterNum = rs_getCounter.Fields(0) CounterNumCombo.Column(2).DefaultValue = CounterNum - 1 End Sub The strange...

Hello, This is a long question- please read to the end. I really need help! Users want to see a simple form where for each vendor in the database, they can see the total budgeted amount, spent amount, and left over amount- per vendor, per budget code (BC), and per object code (OC). They need...

Hello, for the Change event of Control2 on my form, it is important to know whether the control that was last in focus was Control1. Based on this, Change of Control2 will do certain calculations. Will doing this: Dim prevCtl As Control Set prevCtl = Screen.PreviousControl If prevCtl.Name =...

Hello, I am working in Access 2003, vba 6.5 In Form1, the user clicks one of two buttons, each button sets a different value to a public variable called manual_or_auto. In Form2, the procedure of the Save Record button does stuff based on the value of manual_or_auto. The only way I got...

Hello, I apologize if this is in the wrong section- I wasn't sure whether this belongs in Vba or Forms. My users use the AddInvoice form to add invoices to the Transactions table via unbound textboxes and listboxes. The user's job is to type in the invoice total amount, and allocate that whole...

Hello, I just noticed that one of my forms is not ordered by the right field. When the user scrolls through it, VendorName field should go in alphabetical order. VendorName is specified in the form's Order By Property. But for some reason the form is ordered by VendorCode instead, so when I...

Hello, How does one handle an insert statement in vba in which some fields (values coming from unbound textboxes) may or may not be blank? Specifically, the problem is with date fields which are not required and may therefore be left blank by the user. I did an extensive search, but all the...

Hello, On my form, I designated the textboxes and comboboxes which the user has to fill in in order to save a record by making their back color yellow. In the on click event of the Save button, I want to check if any of the yellow controls are blank: Dim ctl As Control For Each ctl In...