Search results
-
M
Update doesn't hit table from form button even though recordset closed
Hi JHB, no, unfortunately that's not the issue- Comments is the actual name of the field. Thanks! -
M
Update doesn't hit table from form button even though recordset closed
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... -
M
Can set listbox data but not combobox data in vba
Jesus, you're right! Thank you! I feel ever so slightly embarrassed.... -
M
Can set listbox data but not combobox data in vba
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... -
M
Problem with truncating data
I am glad that you found a solution, but I'm just curious why you were having problems with text truncation to begin with. How long was the longest string in your original excel sheet? -
M
Does Access use Round() to display different levels of precision?
Hello, the update statement was what I was going to use. I just wanted to first make sure that using round will leave me with the values that the user currently sees displayed- because this is the actual value that we want stored. You have all reasurred me. I am going to go ahead and update the... -
M
Does Access use Round() to display different levels of precision?
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... -
M
Problem with truncating data
Are you sure it has been truncated? When you set focus to the cell holding the number, do you see it expand and give you more precision (i.e. more digits after the decimal point)? If it DOES expand into more digits when you click on it, then the number is not really truncated- it's just that... -
M
How to stop currency control from displaying with more than 2-digit precision
Haha I compeletely ignored the fact that that's a link! Thank you! -
M
How to stop currency control from displaying with more than 2-digit precision
I have not used round for these sums. I am going to give it a shot. What would be my other options in terms of accuracy? The fields are either sums from currency fields in a table, or sums of the detail section of the form itself (also formatted as currency). Thank you. -
M
How to stop currency control from displaying with more than 2-digit precision
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... -
M
Combobox default- works but gives error at the same time??
Thank you very much, I most definitely will! -
M
Combobox default- works but gives error at the same time??
Oy! That sounds too complicated for my simple little set up. It's very clever- I will save your idea for reference for other forms. I haven't thought of making a separate control to hold the current record that I want to return to after re-querying. Creating new objects is something I think of... -
M
Continuous form conditional row color in Access 2003
Wow! This is so fantastic! I was looking for this forever! I had no idea this was so simple- no code required or anything. Thank you so so much! -
M
Combobox default- works but gives error at the same time??
Yes, I got the refresh to work as follows: -The code with the actual calculations for the textbox in question is contained in the form's OnCurrent event. When the form loads for the first time with the default value in CounterNumListbox, the textbox is calculated correctly. -the listbox... -
M
Combobox default- works but gives error at the same time??
Hello, Thank you for the offer! Luckily, I finally got it to default without an error like this: CounterNumlistbox.DefaultValue = CounterNumlistbox.ItemData(counternum - 1) I'm pretty happy that it now works. However, now I have a problem with capturing the change if the user picks... -
M
Continuous form conditional row color in Access 2003
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... -
M
Combobox default- works but gives error at the same time??
Hello, I tried your suggestion just now. Unfortunately, the default value now gets skipped. It doesn't give me an error, but the form opens with setting the default value. I'll post back if I find a solution. Thanks for your suggestion! -
M
Combobox default- works but gives error at the same time??
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... -
M
#Name? when populating text box with stored query
What we've had happen is when we're creating the budget, we may not know just how much to set aside for the vendor for that object code and we create the line in the table and then come back to add the amount when the amount of money avaialable is verified. So it's 'required' in that the creator...