Search results

IsNull() is working thanks. Still have an issue but it's not that so now looking again at rest of vba.

Just been checking out how to use CF to hide some of the buttons on a continuos form. Can see how it might work by using a text box that looks like a button but expecting a problem because this "hides" the button just by changing the fore colour and back colour to same as the form. As the text...

Hi DBguy, thanks for replying. I'm ok with CF to change a control's format but don't understand how it might be used to enable another control.

Hi All. I have three unbound controls on a form. If all 3 have content I want to enable a Save button but if any one of them does not then I want to disable the button. I've put vba in the afterupdate of each of them and tried Len(), Nz(), IsNull() and = "". It works fine once all three have...

arnetgp. Thank you so very much. I've had a very quick look and it looks exactly like what I need. I've spent hours and hours trying to think of a running sum solution using queries to feed more queries but just tied myself in a knot. This looks very elegant.

Glad you found a way but here's an alternative which I prefer because it's just good old math. If you want to round 23006 Up but round 23004 Down then the Int() function will do it. You would use it like this: =INT(((myNumber+5)/10))*10). If myNumber is 23006 it will be rounded UP to 23010...

Hi all, It's been a while. I’m trying to avoid Make Table queries. The result needed is a where records that match are grouped and totalled along with a list of the Refs (item references) for those records that are the same specification. This is a simplified version, in reality it is, as...

If you always want the first word, then =Left([yourField;InStr([yourField];" ")-1) but you'll have issues if the first word has been entered as an initial only. Sorry, just re-read your question and this does not check for a space character. Try this. =Left([yourField],abs(instr([yourField],"...

Another option is to use the Microsoft Web Browser control from your toolbox. I use it because files are .pdf .doc or .xls and we can view/zoom/edit/save (can't save .pdf's) while we are working in the form. I retreive all files from a designated folder then filter and show them in a list box...

This is not as easy as you might imagine. You'll need a field in the underlying table that is the Row Source for the list box. This field will be Numeric (Integer) and could be called Seqnc. The field will be included in the list box Row Source but with a 0cm column width so that it's hidden...

You need to trim this down to a specific question using fewer words but I'll try to move forward. Read my previous reply. If it fills both combos with the same value then they are linked and I still suspect they are bound to the same field. Tell us the Name, Row Source and Control Source of each...

Yep, read it three times and nothing is clear... Maybe it's this. You have a table with a field called Originator and another field called Verifier. Maybe the recordsource for both combo boxes is the same field name. You might want identical combo's but bound to different fields. Alternatively...

Just an option that might suit. In my work, we need to look at .doc .pdf and .xls files so I use the MS WebControl. It's in my Access 2k tools so I guess something is around in later versions also. You'll need to store the full path in a table and call it into the WebCtrl with...

Seems a little odd. When a combo has the values Red Blue Yellow Brown. Then Y enterkey would return Yellow. BL,enterkey would result in blue and BR,enterkey would find Brown. I agree with Burrina, Allen's "Find as you type" is a clever and elegant solution. It uses a text control rather than a...

Many thanks, I now have =CDbl(Nz([FspeciesCost]))+CDbl(Nz([CoreCost])) and all is well.

First of all, I'm not that great so apologies if our learned friends tell me I'm wrong. If its not a continuous form you might try this. Put three images on the form. All with Visible = No. (after testing you can place them one on top of the other in the same place) Name the images...

Hi, I have two combos with a cost price in Column(2) where the underlying table has a field called fldCost (Number, Single, Auto). After selecting from both combos, cboF1 has 3.11 in column2 and cboF2 has 10 in column2. (eg: £3.11 and £10.00). I'm trying to add the value from both combos in an...

rscott1989: you're welcome. Top tip when viewing .pdf files. Ctrl+Alt+Minus rotates anticlockwise.

Thanks missinglinq. Quick test and it seems to do the trick.

I think your looking to enable/disable fields using code. I'll use myChk, myCtl1, myCtl2, myCtl3 in this example. You could do this with afterupdate event of your checkbox but that won't run when you open the form. It's the myChkTest procedure below that does the work but we need it to be...