Recent content by J.Windebank

I am trying to help a friend out with delete query he needs, but it is beyond what I can do. Here is the table structure: tblSomething - ID (PK) - RVersion - RHost - RUser - RLocation - RDateTime - RCompleted Now, the program that enters this data cannot be edited, so whenever the...

My lord, what in earth was I thinking!?!? Such an easy fix, don't I feel stupid now :D Thank you Pat, thank you heaps :)

Bump before bed? ^ Hope someone here can understand my dillema.

Just found this description in the Access 97 help files: Overflow (Error 6) An overflow results when you try to make an assignment that exceeds the limitations of the target of the assignment. This error has the following causes and solutions: The result of an assignment, calculation, or...

I believe Overflow is where you are trying to place too much text in a variable. Such as trying to put 10 digits in an int would give this error. This happened to me a few times last night, and changing from int to long fixed it, so it may be your problem? Hope this helps a little.

OK, I have realised I can use an Iif statement in the query to change a value of 3 in the ChannelID to a value of 6, this will put it in the correct order for me. Now, ina normal query, this works fine, and displays exactly as I want it too, though am having trouble using it inside a VBA...

I have a query that goes through a list of TV programs, and puts them in order by Time, and then by Channel. The channels are sorted by their ID number, 1, 2, 3, 4 or 5. This works fine to put things in order, however I have come across a situation where I need to change the sort order a little...

Perfect, thank you. :)

Hi everyone, I am finally almost finished with my application, and have one last question, I think. :) I have one command that runs insert and update queries, but I am wondering if there is some way to turn of the prompts on a project level, not on an individual PC level? I can't turn it off...

This is more a matter of discussion here, but I have been delving a little into using unbound forms for everything in access, and using VBA "SQL" statements to select, and insert data. I know using bound forms is easier, but I am wondering if relying on them will hinder my work flow if I come...

Thanks for the reply. Whilst I found it a little hard to use your code, the VBA help in Word offered the sollution, eventually. :) Here it is for anyone interested: Set myRange = ActiveDocument.Content With myRange.Find .Text = "\(*\)" .MatchWildcards =...

I just looked it up for the sake of it, Dirty is an object property, and not an event. Hope this helps a little :)

I did not think Dirty was an event, but maybe I am wrong... See if this works in any case: Private Sub Completed_AfterUpdate(Cancel As Integer) If Me![Completed].Dirty = True Then Me![Complete].Value = False Else Me![Complete].Value = True End If End Sub Also in your original code, change...

OK, this my trickiest problem yet I fear. In my application we enter dfata into a form, and then hit a command button, and it creates a word file from the date based on a number of SQL queries. The problem is that there are a few choice words in the document that need to be made one size...

I am trying to work out how to insert an EnDash into a Word Document, but it seems this not going to be possible. The Command in Word to do it is "Ctrl -" though the dash is the one from the NumPad. I have tried doing a sendkeys with the normal dash and it does not work, is there a way around...