Search results

This seems to have me stumped: I have a table that has numeric values for tax rates. The field type is numeric. The field size is double, format is fixed, decimal places is 3. I have values in the table that look like this: Local Rate 0.005 0.010 0.011 0.012 0.020 I have a need to display just...

I used to know how to do this - in fact did it somewhere - but since it was a long time ago and I have a lot of old databases floating around - I don't recall where this might be or how to do it. Not even sure if I can still do it in Access 2007. Hoping someone knows as it might save me some...

Well thanks for the reply. That might be too difficult for me to use in my application - but I mmight try to use it if I get more time and am bored.

I have found some posts on this and a few things doing a google search. But it is one of those situations where I am not finding exactly what I hoped, possibly for good reason but, here is my question: I would like to use conditional formatting in a report but, the barrier is that there is a...

I found it on the property sheet for the text box. But what I am saying is that nothing changes when I change the setting. The setting is Reading Order. The options are: Context Left-to-Right Right-to-Left But when I change these the text as displayed on the report does not change. And it does...

I did find several reverse text generators online - http://textop.us/Text-tools/Reverse-Text Would there be a way to reverse the text within access?

The upside down font is a viable option. But I do have to type the text in backwards - unless I can find a way to automate that. I don't understand the reading order property - I can change it to right to left - but it does seem to actually change anything regardless of how I change it.

I think I will give the upside down font a go and see how that works. What I don't like about it is I can't use the same field - ideally I would use the item name field twice, once right side up and at the top of the label upside down. The upside down font means I have to key data twice, and...

We have considered an image to represent the text and I may have to resort to that. The data is "non variable" so it could be an option. The need is legitimate, we are using data in a table to create a label (report) in Access. What we are doing is we have a sample tile, the sample is approx...

I have a question that I don't think can be solved - practically speaking - in access. But let's try: I have a report that has a text box bound to a field on a query. I want that text box to be rotated upside down on the report. Any way to do this?

I know how to make a parameter query - to prompt the user for a value. And I know how to create a query using In: In("red","blue","yellow"). Is there a way to have a parameter query that lets a user input multiple values, maybe sperated by a comma?

I have not been able to get this to work. Maybe it is not possible? I have re-attached a 2000 version of the db.

Bob, A couple things: 1) I would hate to go back to earlier versions of Access after using 2007. If at all possible check it out. Especially given your abilities - you should have it. 2) I understand your solution. On the same subject; is there a way to show records that are open or Awarded -...

Hello, I have a form that uses a list box to display records and a search functionality. I am wondering if there is a way to have a toggle button on this form that would use the field status. Meaning: is there a way to have a toggle button that would toggle between a view of all projects are...

Bob, Your suggestion seems to have been what was needed. Here is the problem, and I know it sounds stupid of me but...what the heck: I am not very good at VBA. What I have been able to do is use code examples from various sources to incorporate into my databases. Then I also have a habit of...

I hear you loud and clear and will give this a try. And yes sometimes I do work on it from a network drive - a practice I will try and eliminate. I suspect your answer may be the correct one but, any thoughts on why it appears to behave normally when used on the other two computers but I get the...

I am at one of those moments when I want to take a big hammer to this computer and go live in a cave somewhere - forsaking all forms of technology. I have an Access 2007 database that I have been working on for days. Have spent hours on this thing and it is getting close to the point where I...

Well it must make sense because I added a button to the form and pasted your code into the on click event property of the button, changed the reference to my checkbox and it works great. This is very cool. Thank you!!

I have a form, based upon a query that has multiple fields. One of the fields is a yes/no field with a checkbox on the form. I was wondering if it was possible to set the checkbox to yes based upon or after the filtering of the other form fields? In my example I am using Access 2007. So say I...

Found it. It is from Tools - Autocorrect (imagine that). Thanks, now I can move on.