Search results

I can't use "" because my parameter is a Long. Besides this I suppose that "" is really an argument so the isMissing("") will return false.

Reducing the size is not my purpose right now. I'm just experimenting on DB splitting and I assumed that a result of a greater front end shows that something went wrong.

Maybe you are right I don't know much about this, but what makes me believe that 30MB comes from data is the comparison between the clean DB (~5MB) and the DB after filling in the data (~30MB).

Thanks for the immediate reply. What do you mean call it from a MessageBox? I don't think posting function will help because after some debugging you can figure out that execution marker never goes inside function.

I've just successfully spitted a DB of 30+ MB of size to front end and back end. However the size of front end is roughly the original one and the size of back end is some KBs. Shouldn't have been the exact opposite considering that data are stored to the back end?

I am trying to call a function (contained in Form's own module) from the onClick() event of a button by assigning the function to the button through its properties as below =myFunction() The function has a single Optional parameter as below myFunction(Optional arg as String). The problem is...

I'd like to implement the visual effect of extending a (MEMO) field when mouse hovers over it. I mean something like the pop-up menus on websites. One solution I came up with is to use the onMouseMove action and then opening a form at modal view, without any margins containing only a text...

So, any other ideas on how to implement such an effect?

Sounds a really smart idea! But do I keep it always dropped? I don't know of any relative property

Is it possible to highlight the rows of a list box as the mouse moves from row to row? You know just like it happens with combo boxes.

First of all thanx for the reply I used Text1 name inadvertently as I copy-pasted from another page. It is a combo box indeed and I what I want to accomplish by highlighting it is user to be able to erase whole text by just hitting Delete/Backspace. You see, I use the combobox to move to the...

I have a combo box and I want to highlight all its text text upon Click or Enter events. Doing so for GotFocus event is easy Sub Text1_GotFocus () text1.SelStart = 0 ' Start selection at beginning. text1.SelLength = Len(text1.Text) ' Length of text in Text1. End Sub and I...

Never mind I got your point. It's a really smart way. Thanks for your reply.

Thanks for the reply, but I didn't quite understand what do you mean by [Avail]

I have a report which has two nested grouping levels like the following schema. Report --Group1 ----Group2 Inside Group2 there's a field holding the cost of the product and 3 True/False fields indicating whether the corresponding features of the product are available. What I want is to add 3...

I am not quite sure what the RoundACT Composite Score stands for in your expression, but the formula you need to give the rounded average is Fix((( [Column1]+[Column2]+[Column3]+[Column4] ) / 4) + 0.5)

Sorry I was confused with the Fix function. Fix() function trims the decimal point of a number so it's more versatile than round as you can customize it your way to round up or down. So, for your case use Fix(yournumber+0.5) If the numbers you want to round are only positives then you can also...

Try to make a search on Access samples. I'm sure that I came across a sample with just what your are looking for, when I was looking around a week or two ago

Maybe it's because you haven't set the column widths of your combo box? Access tries to display all the fields in a combobox when the focus is set to it, but when focus is lost, only the ones that fit are the... lucky ones to be displayed. Set them to an enough width along with the total width...

Then why not using two queries? Make a Select query to get only the records you want. Make an Update query based on your previous Select query.