Search:

I've got round it for now by setting the "Initial Value" property for the field in Access to "Now()" but I don't know how that's derived - presumably on the server the .mdb file is on (??)
But I am...

Hi all,
I'm using Access as my DB and ado stuff to access it, so far so good. I would like all the clients to use the date/time from the same machine when stamping things to avoid confusion......

How are you writing the file? Try using "Print #" instead of "Write #" ???

------------------
* * * * * * * * * * * * * * * * * * * * * *
AndyC
London
email: andy.collyer@bigfoot.com
* * *...

Hi all.
Given that I can start a process using "CreateProcessA" or "Shell", any ideas how I could find out if *that* process is still running?
BTW, I need to be able to carry on running other...

Hullo again,
Can anyone tell me why I can't say:
Dim myRTB As New RichTextBox
or
Dim myRTB as RichTextBox
Set myRTB = New RichTextBox
??
It keeps saying "Invalid use of New keyword"
I've...

Right, for those interested, here's some code to do the job...



Private Sub ListBox1_MouseDown(Button As Integer, Shift As Integer, X As Single, Y As Single)

If (Button = vbRightButton) Then...

Thanks for the replies...
Cabal - Unfortunately it's a listbox not a listview and there's a lot of code already associated with it so moving it to a listview might be more hassle than it's worth,...

Hi folks.
When I rightclick on a listbox, I've got a menu popup. But what the menupopup displays depends on the selected item. How can I get the listbox to select the item like a leftclick before...

Happy new year all!

I have a bunch of fields of a database bound to textbox controls on my form and a richtextbox control, bound to a different table, that holds a template of a letter - including...

:o Point taken! It was early and I'm not so hot in the am!!

Thanks for the code - had a quick play but evidentally it's going to need much more! Looks like a fun weekend ahead :)

If you...

:o Point taken! It was early and I'm not so hot in the am!!

Thanks for the code - had a quick play but evidentally it's going to need much more! Looks like a fun weekend ahead :)

If you...

Beg yer pardon you're absolutely right I knew I shouldn't have got up this morning.

Apologies.

AndyC

[This message has been edited by Andy Collyer (edited 12-09-1999).]

Beg yer pardon you're absolutely right I knew I shouldn't have got up this morning.

Apologies.

AndyC

[This message has been edited by Andy Collyer (edited 12-09-1999).]

Format(2,"mmmm")

HTH,

AndyC

Format(2,"mmmm")

HTH,

AndyC

Hi again!

I've got a load of tables - an unknown amount. I can (thanks to your help!) find out what they're called and do all sorts of stuff with them, but I want to include on my main form a...

Hi again!

I've got a load of tables - an unknown amount. I can (thanks to your help!) find out what they're called and do all sorts of stuff with them, but I want to include on my main form a...

That's it! Absolutely perfect. :D

heyessj, you are a genius (that's not to say that you aren't, Serge! :))

Thanks again,

AndyC
London

That's it! Absolutely perfect. :D

heyessj, you are a genius (that's not to say that you aren't, Serge! :))

Thanks again,

AndyC
London

I'm using adodb throughout my app so far but that doesn't mean I have to keep that way (although I do need to keep using ODBC DSN Connection strings, not references to filenames).

I'm trying to...

I'm using adodb throughout my app so far but that doesn't mean I have to keep that way (although I do need to keep using ODBC DSN Connection strings, not references to filenames).

I'm trying to...

highlight the label, right click, "cut". Then click your frame, right click, "paste". The label should then be inside your frame.

AndyC

IsNumeric! How close!

Thanks all - yes, I was just being thick :)

AndyC

IsNumeric! How close!

Thanks all - yes, I was just being thick :)

AndyC

Can't find this anywhere - is there a way of checking that a string contains just digits and can therefore be converted to an integer before trying it? I thought there was an IsNumber function but...

Can't find this anywhere - is there a way of checking that a string contains just digits and can therefore be converted to an integer before trying it? I thought there was an IsNumber function but...

Is the control included in your components?

AndyC

Is the control included in your components?

AndyC

Combo1.Text = "-- Please Select Data Type --"

HTH

AndyC

Combo1.Text = "-- Please Select Data Type --"

HTH

AndyC

Excellent - ta very much!

AndyC

Excellent - ta very much!

AndyC

Not actually VB but I'm sure someone will know and it is related to my VB app...

I've just had a new disk put in and win95 put back but the fella who did it didn't install (amongst other things)...

Not actually VB but I'm sure someone will know and it is related to my VB app...

I've just had a new disk put in and win95 put back but the fella who did it didn't install (amongst other things)...

I always use my own function to test a file's existence because it's easier to control what it does. Here's an idea:

Public Function FileExists(ByVal fName As String) As Boolean

Dim FNUM As...

I always use my own function to test a file's existence because it's easier to control what it does. Here's an idea:

Public Function FileExists(ByVal fName As String) As Boolean

Dim FNUM As...

Assuming you don't want to wait for it to finish executing before continuing with your app, just use the Shell command.

Andy

------------------
* * * * * * * * * * * * * * * * * * * * * *
* ...

Assuming you don't want to wait for it to finish executing before continuing with your app, just use the Shell command.

Andy

------------------
* * * * * * * * * * * * * * * * * * * * * *
* ...

For some reason my ADODC control doesn't appear to receive the MouseDown event - why is that? Is it an error, a "feature" or something else?

It was aligned vbAlignTop but even without that I...

For some reason my ADODC control doesn't appear to receive the MouseDown event - why is that? Is it an error, a "feature" or something else?

It was aligned vbAlignTop but even without that I...