That's the thing I never opened the query. My database is set up that you can't get access to the back matter (DB, querries, etc.) without doing a certain procedure. I was just in the front section, the forms which allow one to open the reports...
oh well it's fixed now, it was just scary
JamesDC
Last Activity: Apr 17 '07, 12:12 PM
Joined: Feb 6 '07
Location: Niagara Falls
-
Alright, I freaked out :S
I copied the SQL from the blank query from a backup and now it's running again.
I'd just like to know why the query could suddenly go blank like that? Does this happen often or maybe somebody intentionally did it... which I doubt.Leave a comment:
-
Destination Field?
Hey all,
I'm having a big problem right now...
I'm using Access 2002 with my Database.
The program was running fine yesterday, and I went to use it today and found that all my Reports would come up blank. SO I checked my queries and I get this error:
Query Must Have At Least One Destination Field.
I don't know what this means, or why it happened. Can somebody please shed... -
Hey Denburt,
The program was used over the weekend and all of this morning so far without the issue arising. It looks like that little problem has been solved.
I've replaced the sendkeys code for all the other areas with the same code and it works like a charm :)
Thank you so much for your help,
JamesLeave a comment:
-
Aha! I tried the same thing with the suqare brackets and it worked! It called up the last entry.
I'm going to copy this code for the rest of my fields, hopefully I can figure those parts out now. Then I'll put it on as the program used and see if the not bringing up last data bug occurs again.
Thank you so much for your help :)
I'll let you know how it turns outLeave a comment:
-
Found the DAO 3.6 Library and added it and moved it up,
Now I get this error:
3265: Item Not Found In This Collection
With this highlighted when error is traced:
LngValue = rs!Employee_Nam e
Happens when LngValue is set as String or Long.
I tried to use
Me("Employee_Na me") = rs!Employee_Nam e
instead but it still comes up with an error.Leave a comment:
-
I have the following boxes checked:
1. Visual Basic for Applications
2. Microsoft Access 10.0 Object Library
3. OLE Automation
4. Microsoft Active X Data Objects 2.1 Library
5. Microsoft Calender Control 8.0
I cannot find any DAO references. Also it appears that you are using a newer verion of the Access object library, does 11.0 introduce the item in the code causing the error?Leave a comment:
-
I tried the code with String and got the same error.
tracing the error ended with this line highlighted:
Set rs = Me.RecordsetClo neLeave a comment:
-
On the Employee Name text box on the form, under control source is Employee Name.
Employee Name is a Field heading in the table MainDB.
In MainDB the Field Employee Name is Data Type Text with a Display Control of Text Box.
I'm not really sure where RecordSource comes into play. Is this the information you're looking for?Leave a comment:
-
Still getting the type mismatch error :(Leave a comment:
-
The text box for Employee Name is a regular text box. Other areas are dropdown lists but I haven't tried this code there yet. Here is what I have under Employee Name On Enter Event:
...Code:Private Sub Employee_Name_Enter() On Error GoTo Err_Employee_Name_Enter Dim rs As Recordset Dim strCriteria As String Dim strNme As String Dim LngValue As Long If Me.NewRecord Then
Leave a comment:
-
Sorry it's actually:
13 Type mismatch...Leave a comment:
-
Hey,
Thanks for trying to help by the way,
I used the code with the error check and there are no debugging issues. When I click on that text box, however, an error comes up as follows:
17 Type mismatch
Also what is the H in:
strNme = rs!H
Changing this to Employee_Name still causes the same error to come up.
EDIT: I just noticed that the variables are...Leave a comment:
-
Hey Denburt,
I tried your code but I got this error:
Compile Error: Use-defined type not defined
It then grey highlights:
rs As dao.Recordset
And yellow highlights:
Private Sub Employee_Name_E nter()
Both my field name and text box are called "Employee Name", so for the !myName's I replaced them both with ![Employee Name]
Know why this...Leave a comment:
-
You could do what I did.
I have two seperate Access files, one for the workers to use for inputting data and one for admin to use to evaluate data. The main DB is stored in the Admin version where the Worker version is linked to the Admin DB. By locking the forms and removing all access options on the Worker version they can only navigate through the set up forms in order to input data and cannot gain access to the DB. The Admin...Leave a comment:
-
In an attempt to solve the problem I changed the location of the code to the On Got Focus event property. After having the program used for a few hours the same problem would show up again. Here is the complete code for the data entry form:
...Code:Option Compare Database Private Sub Area_GotFocus() SendKeys "+^'", True End Sub Private Sub Date_GotFocus() If IsNull(Me!Date)Leave a comment:
-
Alright, I'm going to try putting the code under On Got Focus to see if that stops the problems.
That bit of code was under On Click and On Enter, and it still worked if someone tabbed accross. Just sometimes when clicking it would stop working......Leave a comment:
-
On the form one can clikc forward and back buttons to view the entries. Eahc entry is given an AutoNumber. When the New Entry button is clicked it clears all the Text Boxes and starts a new record with a new AutoNumber. I would want for the Name Text Box for it to automatically bring up the Name in the Name Text Box of entry n-1 when the New Entry button is clicked and a new record is created.Leave a comment:
-
So any idea on why it would stop working randomly?
I'm looking for other methods to complete this task. Is there a way to use the Defualt Value property to show the last entries data when a new Form is loaded?...Leave a comment:
-
See edit at end of last post. I don't know what the code means.Leave a comment:
No activity results to display
Leave a comment: