Recent content by jhansen

In response to "Question, is this geared to be approved online, or sent to someone to review each eval step and make the determination then? You may want additional information on the approval process if it is seperate." I believe that a committee will be set up within the organization to...

I am just on the edge of a new database cliff. ready to jump off, but want to make sure the planning is correct. So... I need to make a Decision Making Framework for a Client for allocation of physical space in their building from competing interests. So far, we have a flow chart which...

My expression is merging two fields. one is a text field, but contains numbers like 1.23 and 1.23.1. the other is a number field 1,2,3,etc. these are merged in my report to read: 1.23.1 for room numbers. I want it to read like text to excel, but unless I add a letter to each one, its reading...

doesn't seem to like to do this. any suggestions on syntax? I keep getting error messages.

Hello I am trying to export a report from Access to Excel, which is based upon a query and I'm having a problem. I have one expression based upon 2 fields. The end result looks something like this: "1.01.03" When I export this, Excel converts it to a decimal eg: 0.2346465656. Not very...

Just read the "Gantt Chart" topic, and found what I need. Thanks.

Hello! (love the look of this new site) I am trying to work out a facilities managment tool to help a client plan moves around a facility to allow for demolition of buildings, etc. So far, I've got the data end working pretty well, with people/programs and buildings/levels and duration of stays...

I'll give that a try. Thanks Alex. Julia

I have some reports that I've created in landscape format, but every once in a while, when I open them up, they revert to portrait. Pretty frustrating. Does anyone know how to override the default setting in page setup? Thanks,j.

Hi Mike; Thank you for introducing me to another excellent Access site. I have so much to learn! j.

I would like to compact my back end database when the front end either opens or closes (only one, not both), but so far have not been able to make this work without opening up the back-end. Does anyone know how to do this?

Wow. Thanks a million! I'll give it a try.

Hi. I am trying to figure out how to display numbers as words (eg: $124.56 = One hundred and twenty four dollars and fifty six cents), similar to an electronic cheque for a report I'm working on. Does anyone know if I can cut & paste code for this? Thanks in advance. J.

Thanks! It must have been the naming of my text boxes that was tripping me up. Works like a charm now. Do you know anything about taking a number and writing it in words? Similar to a cheque writing code, I suppose, but I wondered whether I could cut and paste one from somewhere?

I am desparately trying to put the finishing touches on a report and hate the way my text boxes don't "flow" well with the rest of the text which remains the same. This may seem like a silly question, but I thought it would be very simple to add text as follows: ="my text"&[field name] What am...