Search results

Was not sure whether to post this on forms or tables. This is odd in that I have never had a need to do this particular thing - but it would seem to be a common need - so there must be an answer: I have created two tables: Table one represents customer accounts Table two represents literature...

Thanks Jeanette, I was able to use the article to make something that is working - at least it has passed my early tests. Here is a sample of it - maybe it will be useful to someone else.

I know this is a common question, lots of stuff found in Google searches. However I am still not sure how to best handle this. Have a query that looks like this: IIf([LFGen]>55.99,"Z",IIf([LFGen]>51.99,"Y",Iif([LFGen]>47.99,"X",Iif([LFGen]>43.99,"W",Iif([LFGen]>39.99,"V",Iif([LFGen]>35.99,"U"...

It works brilliantly! Thanks so much - you have saved my life! (Ok...not quite...but thanks anyway)

OK, I have a form that is in continuous forms format. It has data from an underlying table. The table and form have a checkbox (yes/no field) called - select. I also have a list box on the form that is used to filter records. What I need to do is: 1) Filter the records (this works) 2) Set the...

Am sure this can be done, but have not found the right way...yet. I have a form and the form uses a query for its underlying data. I have a field on the query that is not a field on a table, it is a concatenated field on the query. With the concatenation the result is a hyperlink (if pasted...

Well - somehow I got it to resize and move as well - confusing, not sure exactly what I did - but it seems fixed.

Here it is - it is a 2007 version - can this be that hard??

Sorry - that did not work - don't understand why this is so difficult.

OK - this is driving me crazy, hope someone knows what I am talking about here and will be able to provide an answer. I have a form with a subform, the subform is being problematic - in that: I have added a new filed to it (the subform) and I cannot get the new fiield to be at the posistion nor...

I have a database where a user wants to insert or attach Outlook messages to probably a form. This seems logical to me and I see why she wants this. Any good ideas on how to accomplish this? Thanks!

Hope I can word this in a way that makes sense: I have created a form that is to be used to calculate and convert square meters to inches. So we have material - slabs - and when we receive these we have packing lists that come in M2 (square meter) and we need to convert to inches. There is a...

Bob, That works...thanks!

So...how can I concatenate something with a "? For example I have a field (name) that contains a name - bob - and I want a concatenate query to show bob" If I try "&[name] it does not work. If I try """&[name] still does not work What am I missing? Thanks!

I did figure out that if I open Word I can go to the Insert tab (Office 2007 or 2010) and then go to symbols/More Symbols there are quite a few more fractions in there. And these can be copied from a Word document and used in find/replace function in Access.

I see/understand how to use the replace function. Would still be interested in finding out if it is possible to add custom characters for the less common fractions (5/8, etc) Also, would it be possible to construct a form to use for the repalce operations? For example: a simple form with to...

Can you show a basic example of how I might use the rplace function to do this? Also, is it possible somehow to create/add custom/user defined characters?

Does anyone have any information on using Single Character fractions in Access reports using data from a table or query? So, I f I have data like 12 1/2 X 12 1/2 it will appear as 12 ½ X 12 ½ on the report?

Yes, this is what I need. Thanks!

They do represent percentages, but are now in decimal format. I think I am just dense. It looks like I just need to multiply the number by 1000 and I will get what I want.