Search results

can't help it - Travis : (-1) + (-1) = -2 add them up and *-1 or ignore the sign In built functions can be laaaaazzzzzzzzy - I'm learning C and trying to get by without them. It makes you a lot more cunning, forget they exist and you can get much more done - even if it does take twice...

you've got lots of options and it depends on how complicated you want to get! I'd set the vaildation rule of the combo box to Is Not Null if you don't want Null values. OR go into the On Exit or After Update event of your combo box and drop in something like - let...

what you need is dim retVAL As Double retVal = Shell("MSAccess S:\FINANCE\RISK\DATABASE\AVIATION.mdb", 1) It will then find Access ( the application ) for you, you don't need the path [This message has been edited by KDg (edited 02-14-2000).]

Hi, not exactly sure what you're after. Are the codes already in a table and you're pulling them onto a form ( in which case you could use a query ) or are they now being added? If they're being added you could use an AfterUpdate event to check the value of the box for the relevant codes...

Having tried this myself just now it looks like its one of those "non-dynamic" VBA things - you set it once and live with it, you don't change it for each user. If you want to restrict user access you may have to play with the menu bars and change the "Shortcut Menu" in the other tab of form...

you should also check on Fix, CInt and Int in the help files as they behave differently and treat -ve numbers different to +ve. If you look those up you'll see a reference to Abs as well, which will change -ve numbers to +ve HTH Drew

Hi, my solution was to do the following. It prints the dates in two text boxes at the top of the report Private Sub GroupHeader0_Print(Cancel As Integer, PrintCount As Integer) Let Me!txtStart = "From :" & MyStartDate Let Me!txtEnd = "To :" & MyEndDate End Sub Private Sub...

I don't believe that you can do this by trying to concatenate into a field name. What you are trying to do sounds more like either an INSERT INTO query if all your calcs are done by the time you're writing the record* or an UPDATE if you want to do it one at a time. For example, if you have 24...

For the multiple mailings you should have a look at Travis' reply to Buster below. Is there any reason why you don't want a DB on your server? ASP is probably the 'easy' way to do it.

You need to turn the echo back on at the end of the code- ensure you also turn it on in the On Error - DoCmd.Echo True. Otherwise although Access is still running fine you've locked it. You may also want to give your users an hourglass ( DoCmd.Hourglass True ) to let them know stuff is...

Hi, thanks for your suggestions. I haven't set up user groups or even a password as the one available for use is a completely locked up mde, if I need to make changes I have a development one elsewhere. The solution I'm going to try is below - I haven't tested it yet so it probably won't work...

Thanks Pat, I was afraid that might be it. It's really difficult to do as I work in a call centre and staff only stay for 3-6 months ( usually ). I think i might have created an administrative nightmare for myself...

I have a DB that doesn't use any tables... basically it contains only 3 forms and writes to text files that are imported once a day into a seperate DB with reports etc there is no direct link between the two My problem is that my simple front end is standing up to a thoroughly good using by...

It wasn't meant to be a fix - just an oddity to add to the list. Is this affecting Now() as well as Date(). In case it helps any(?) I'm on NT4 and Access97

yeah Date() has gone on me too, but once data is entered into the form(s) in any field it picks up and turns into Date() as it should be

Thanks Travis, I've taken your advice and went for the appending fields approach, works like a dream. Annoying you can't change datatypes though, Cheers, Drew

does anyone know how to change the data type of a pre-existing field in a table from text to long in VBA?

You only really need one as the default is dynaset ( I think, but it might be snapshot , either way the other 2 are optional. [This message has been edited by KDg (edited 12-14-1999).]

think I posted my reply on the wrong question - try putting WHERE (Asset.Cusip = " & chr(34) & CusipX & chr(34) & ") -> this will then drop "" around your string variable and keep the SQL happy Similarly you need surrounding # - chr(35) - for date/time [This message has been edited by KDg...

I'd put in [field]=" & chr(34) & partnumber & chr(34) this drops in "" around the text then, otherwise it won't recognize it.