thanks for the reply,
if i remove the requery methode it works, but the problem is that the fields in the subform are then cleared, and i need them to show.
So im thinking the problem is in the Requery....
christinamasalha
Last Activity: Mar 28 '07, 07:54 AM
Joined: Jan 30 '07
Location:
-
why dont you use the add new method for the recordset object.
for example:
...Code:Dim myConnection As ADODB.Connection Dim tbl_MailingAddress_Table As New ADODB.Recordset Set myConnection = CurrentProject.Connection tbl_MailingAddress_Table.ActiveConnection = myConnection tbl_MailingAddress_Table.CursorLocation = adUseClient tbl_MailingAddress_Table.CursorType = adOpenDynamic
Leave a comment:
-
Do you mean you are trying to connect to the database from another database?
can you be a bit more clear :)...Leave a comment:
-
Change focus on form
Hello again,
Im hoping somebody can help me with this problem :)
In my database i have a from called "Farms", on the from i have 1 fields called "Farm_Name" and a subform called "Houses". When the focus leaves the last field in the Houses subform i want the cursor to return to the main form and for the last record entered in the subform to still show.....to do this i used the following... -
Thanks alot for your help, i went throught all of the code related to the range field and found that i had typed in the wrong field name like you said.....Cant believe i did that. All is working now :)
Thanks again for all your help,
Christina...Leave a comment:
-
Thanks for you response,
I get what your saying but the problem is that the field range is not the first control.....the event is getting triggered when i click on the actuall first control which is a field named "Farm".
i would really appreciate any help with this.
Thanks,
Christina...Leave a comment:
-
Hello again everyone,
Since i havent gotten any replies im guessing maybe my question isnt clear. I will give it another go. My problem is that i have an "OnGotFocus " event for a field called "Range" triggering, when i give focus to the subform the field is on, instead of when focus is giving to the field itself.
Any ideas what's going on?
Thanks again,
Christina...Leave a comment:
-
Event triggering incorrectly
hello all,
I've been trying to figure this out for days but i don't know what the problem is. I have this form which contains 2 subforms on it. On one of the subforms there is a fields called "Range" which has an "OnGotFocus " event on it. My problem is that when i click on the first field in the subform (not Range), the Range field's OnGotFocus event is triggering. Does anybody have any idea what the problem might... -
Thank you Mary,
Turned out i had a code error that showed when i compiled the DB. After i corrected it i created the MDE file and it worked.
All is good :)
Thank you again very much!!
ChristinaLeave a comment:
-
Dear Mary,
im sorry for the late response.
These are the answers to the questions you asked:
1- the size of the DB is 9 MB
2- I have 15 tables
3 - I compacted and repaired the DB but i didnt see any changes in the size or anything so im not even sure it did it right.
Thanks alot for you help. I apreciate the help.
ChristinaLeave a comment:
-
Thank you all for you help.
Mary i have tried to convert my database to an MDE file but it keeps returning an error and refuses to convert. Im not sure what the problem is. Could you possibly help me with this. I have pasted the message from the error below.
Thanks alot.
Christina...Leave a comment:
-
Dear Scott,
i used this code to create a search form on an application of mine, and it works great..... it will find the results to any number of criteria. All you need to do is customize the code to fit your application.
PLease fins below the article for the search from (i have copied the whole article for you so you can better understand the code before using it):
...Code:Experts, please don't answer this Q,
Leave a comment:
-
preventing users from accessing tables and design
Hello all,
I am wondering if anybody can help me with a question I have.
I am planning to create an Access database application, this application will be used to keep simple records and stored locally on the users computer. What I want to do is the following:
1- When the user opens the application I want only a form to open, and from this form all the other forms may be accessible.
2- I don’t want the user to... -
Hello All,
Thanks alot for your responses.
i am going to use mary's approach of copying the tables from one db to another since my application is pretty simple and therefore small :)
Thank you all again for helping me out of jam, i really appreciate it.
Christina.Leave a comment:
-
Hello,
From what i can see you need to check your while condition. It is not correct.
The loop will never work because it will not be true after the initiall "n" is entered.
Double check it.
Hope that helps.
ChristinaLeave a comment:
-
Copy database design to new database
Hello everyone,
Im quite new to MS Access (i am using MS Access 2003 on Windows XP ) and i have a little question ( i hope).
I have created a small database application and it is up and running nicely.I would like to create a copy of this database but i need all the tables to be empty. My question is: Is there a way to copy only the design elements of a database (without the data in the tables) into a new one?
...
No activity results to display
Leave a comment: