Lysander
Last Activity: Jul 25 '22, 03:42 PM
Joined: Apr 16 '07
Location:
-
wow, been years since I was on this. Okay Simaonobrega, what you need to do is create a transparent input box, say, 'jump' and then use the tab order to make 'jump' the last entry on the form. Then, on the 'on entry' code for 'jump' use 'set focus xyx' where xyz is the 1st field. Sorry I can't post the actual code I used, but I last used this in 1998 and have long forgotten the security username and password to get into it, assuming it would still... -
If you are totally stuffed by a stupid error, give it to a non-programmer.
"Dear wife, look at these two lines of code, what am I missing"
"They are both the same Husband dear, except, one has a '=' sign, the other does not"
Four sodding hours of looking at this, and always looking at the SQL statement, never noticed the missing '='
Thank you darling wifey.Leave a comment:
-
Sadly, this is a compile error, not a run-time error, so I can't even open the form to run it.Leave a comment:
-
Invalid use of Property
Me again.
Just added a new combo box to my select form.
...Code:Case "HouseEditDouble", "ParentsEditDouble", "ChildEditDouble" cboSelectHouse.RowSource = "SELECT HouseID FROM tblHouseDoubleEntry WHERE VillageID = '" & cboSelectVillage & "' ORDER BY HouseID;" Case "SchoolEdit" cboSchool.RowSource "SELECT SchoolID FROM -
zmbd
Thank you. Hugs and love.
Putting DAO. in front of the declarations solved the problem.
I can only imagine that a game or something else I have loaded has used Access and caused a conflict between DAO and ADO.
And yes, I have been using this code, on over a dozen databases, over and over again since 2006
All working now.
Thanks again.Leave a comment:
-
twinnyfo, the rs!description says "Lookup tlkStatus". I copied the line into the immeditate window and used "FRED" and "PETER" as the text, same failure.Leave a comment:
-
Sadly, I wish that was the answer, but, I have been forcing Option Explict since Access 2.5, when it first appeared.
I can't post the full code, I don't think, they limit to 20 lines, but I will try. Nothing has changed for 6 years. It worked on Friday, failed today.
Here is the full code, if they let me post it
...Code:Option Compare Database Option Explicit Sub test() Dim db As Database Dim
Leave a comment:
-
Nope, no updates, no new software, last thing I loaded was a game, 6 months ago, and code was working after that. Code actually worked last Friday. As it is failing on all databases, not a database issue, either my references have got corrupt, or something else is screwing up my PC. This is critical time-saving code I have been using for years. Thankfully, the table I need to create is only 12 fields this time, so I can do it manualy this afternoon,...Leave a comment:
-
Access 2003, sudden code failure
Below is a section of code that I have been running for over 6 years on many databases. It helps me create tables quickly. Today, with no changes, when it gets to the create property line, if falls over with Error 13, Type Mismatch. On every property line, on every database.
Any idea what is going on please.
...Code:If Len(rs!Description & "") > 0 Then Set prp = fld.CreateProperty("Description", -
Hi Hameedacpa, sorry for the slow reply, it has been a couple of YEARS since I logged onto this site. First, my code works in Access 2000 and Access 2003. I have never run it in Access 2007 or later. I am using this code on a daily basis, in 14 databases with 5 languages. It certainly works on sub-forms and sub-reports. I have this, in all my sub-forms.
...Code:Private Sub Form_Open(Cancel As Integer) On Error GoTo Form_Open_Err formtran
Leave a comment:
-
Thanks Mary, so for the delay, been away a few days. Our 'Boss' basicaly says 'you lot sort it out yourself'. We have a new outsider who is anti-MS and convinced the rest of the team that Access is crap, cannot solve our problems and we MUST move to Linux and open-source databases. My boss can't seem to understand that so far, Access has provided 100% of what we need, that I have some 20 years exp in Access, and that I cannot 'pick up a new system'...Leave a comment:
-
Thanks zmbd. My position is a job for a charity at very low wage. Running Access databases, no-one in this company has any IT skills at all. But, outsiders, analysing our databases, have a patholigical hatred of Microsoft and are insting I move to Linux, Peal, and other software I have no experience of at all. No one in the company is prepared to pay for training for anyone, but the big boss is far more impressed with the tit who hates microsoft,...Leave a comment:
-
Thanks for the honest reply
Whilst this is exactly what I did not want to here, it comes as no surprise. I am in the UK, not the USA, but I am 55 and my skill-set is totally restricted to MS-Access (With some ASP work years ago)
Since now in low-paid job, no savings, guess I am going to have to suck it up and stick with this current job unless I see something juicy. I certainly afford to be unemployed for any length of ...Leave a comment:
-
Is there any work out there for MS Access Programmers?
Hi,
Having MAJOR issues with my employer atm and about to tell him where he can stick his job except, the only thing I know is MS-Access. Is there still any work out there for MS-Access programmers, do I have a chance at finding something else? -
I can't imagine how I would use this or why, but obviously you had a need, and this solution is simple and elegant. Love it.Leave a comment:
-
I like this! I have several long processes in my databases, some can take 30 mins to run and use something similar, but nowhere near as sophistaced. Two questions. What happens if your process should happen to fail, i.e. does the form disappear. (In my simple version it does not, and the user is locked out of access:( Secondly, can you say what versions of Access this runs on.Leave a comment:
-
This looks a fantastic idea. Two questions.
1)Is your application itself written in Ms-Access VBA or in Visual Basic (what I don't have)
2) Is it possible to have the report saved to a file on the generating pc, to be emailed independtly. The reason for this is most of my users are on laptops out in the field, with no telephone, no internet, indeed no electricity, so they would need to save the error report, and then email once they...Leave a comment:
-
Hi Pod,
If this was an answer to a specific question, it would be great. As an article, it would be nice to have more comments in the code and some more explanatiaroy text as to what this does and why it can be useful to people.Leave a comment:
-
Thanks, but this applies to Visual Studio .NET 2002, not Visual Studio 6.0Leave a comment:
-
Visual Interdev 6.0
I have not used asp for years but last year I tried to update my noddy web-site using my Visual Interdev and as soon as I tried to edit a page, it crashed with the message "Developmen t Environment has encountered a problem and needs to close. We are sorry for the inconvenience." I was not that bothered, assumed it was a server issue and forgot about. I now NEED to develop a new web site and I have a different configuration. I unstalled...
No activity results to display
Leave a comment: