Recent content by 303factory

  1. 3

    'If Date = Date' not working?

    Ah I see, thank you kindly good sir! and +1 on your sig
  2. 3

    'If Date = Date' not working?

    Hi people I've got a bit of a headscratcher I'm trying to loop backwards through time in 15 minute slots until I match a variable. However the my code doesn't seem to recognise my date variable as 'equal' when it is! I.e. I step through and when I get to the line: If t = firstAppointment...
  3. 3

    Should I migrate to VB.net?

    Good afternoon. Apologies if this is a topic that has been discussed before, I performed a search but did not find anything useful. We've been developing a MSAccess front end for our database for nearly 10 years now and it has grown to many thousands of lines of code with 8 modules and nearly...
  4. 3

    Thumbnails appearing in bound object frame

    The images are taken by a webcam so this has been tried with hundreds of images now, I've also reproduced the error multiple times on standalone machines with numerous images created in paint or downloaded from the internet The problem occurs with 100% of images once the particular machine has...
  5. 3

    Thumbnails appearing in bound object frame

    Suspicious indeed! Yes the Display Type is set to Content
  6. 3

    Thumbnails appearing in bound object frame

    Hi all My form has a bound object frame that links to a table with OLE Object type The user can drag bitmaps into the frame which are then stored in the table and displayed on the form However after a time (it seems to randomly break on the computers in our office) the frame stops showing the...
  7. 3

    Unusual result from empty XML nodes

    Thanks for your help I liked your approach to going through the nodes and the trimming functions will be very useful
  8. 3

    Unusual result from empty XML nodes

    Good afternoon I'm writing code to read in some XML files and the nodes which are empty seem to be returning strange results with a non-ascii character Dim MessageList As IXMLDOMNodeList Dim MessageNode As IXMLDOMNode Dim childNode As IXMLDOMNode Set MessageList =...
  9. 3

    Strange behaviour with default values on bound form

    Hi all I've recently been trying to upgrade my software so instead of access queries I have sql server views. The continuous subforms will be bound to an editable recordset instead of a sql statement using an access query I've got this up and running but I'm getting some strange behaviour of...
  10. 3

    Data going missing

    Yep it only does this for every 10 records. heh dont underestimate the bureaucratic shackles of my company ;) ill take a ganders at network monitoring software too
  11. 3

    Data going missing

    Ingnore this.. I've told it to do do a requery then goto new record on the after insert.. things will re-order but only if the user hasnt been filling out the time and date information.. still interested to know why this is happening and if there is some cunning 'check network' function i can...
  12. 3

    Data going missing

    is there anythign that can be done in my client to flag up network problems? I'll need some sort of proof this will work before I can get funds released for this. I'm not having any luck with the Requery - if I do it on a timer and go back to the record using a bookmark it puts the cursor in a...
  13. 3

    Data going missing

    Yes it does seem to happen to certain people and not others. What doy ou mean by NIC? Each computer has a copy of the FE
  14. 3

    Data going missing

    Thanks for the pointer on getting back tot he current record I'm not using the executem method in any code, i simply have a continuous subform bound to a query. the form itself may have no code at all. Could this be related to my problem?
  15. 3

    Data going missing

    Yes up to 15 people use the front end client which connects to a single backend. I know nothing of tempt tables or them getting deleted/truncated, can you point me at some literature on this?
Top Bottom