Search results

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

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...

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...

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...

Suspicious indeed! Yes the Display Type is set to Content

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...

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

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 =...

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...

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

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...

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...

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

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?

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?

Right, three problems with this theory 1) The Me.Requery command causes the form to scroll back up to the top, which will be annoying for the user 2) When I disconnect the network cable, all the fields onscreen say #Name, which definately does not happen when we loose data, so this is not a...

yeah ill definately give it a go, better staff get a debug then carry on entering data into the black void of nothingness :P

if connection was lost at the point you performed a requery would you expect it to produce a debug error or hang?

Hi We're having a problem where data entered into our database by form is not always being saved The data entry is into continuous subforms which are bound to an msaccess query. The query links to the datatables which are SQL Server 2008 using an ODBC connection with the native client 10.0...

The data was not being truncated using ADO connection to read/write to the field. However I cant use that for my subforms linked to the tables as far as I know.. the front end of the client was stuck with the truncated data didnt try a pass through, i never got them working with bound subforms...