473,796 Members | 2,609 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Form fails to release control of table

I recently posted a question regarding a table built using an action query
in VBA. I am still having trouble. I have tried saving a record as suggested
by one post.

The problem

A form uses the new table as its recordsource. However, even when the form
is closed using either the close button on the form title bar or using the
docmd.close the form fails to release its connection to the table making it
locked and unable to be dropped or edited prior to the next create table sql
command.

I have looked everywhere for a solution without success.

Any suggestions?
Nov 12 '05 #1
3 3935
It usually helps us to help you if you post some code...

That said, I suspect that you are not unloading the form from memory, merely
hiding it. Look up "Unload" in help.

P
"Mike" <re******@hotma il.com> wrote in message
news:3f******** @dnews.tpgi.com .au...
I recently posted a question regarding a table built using an action query
in VBA. I am still having trouble. I have tried saving a record as suggested by one post.

The problem

A form uses the new table as its recordsource. However, even when the form
is closed using either the close button on the form title bar or using the
docmd.close the form fails to release its connection to the table making it locked and unable to be dropped or edited prior to the next create table sql command.

I have looked everywhere for a solution without success.

Any suggestions?

Nov 12 '05 #2
The code I am using on the close button is as follows:

Private Sub cmdMenu_Click()

Unload "frmViewDetails "

DoCmd.Close
DoCmd.OpenForm "frmMenu"

End Sub

Private Sub cmdViewList_Cli ck()

DoCmd.Close
DoCmd.OpenForm "frmListPatient Orders"

End Sub

I thought the Unload even took place before the Close so would think that
the form is unloaded at this point. Is that wrong?

Mike

"Phobos" <la******@spamm ers.co.uk> wrote in message
news:ma******** ************@br ightview.com...
It usually helps us to help you if you post some code...

That said, I suspect that you are not unloading the form from memory, merely hiding it. Look up "Unload" in help.

P
"Mike" <re******@hotma il.com> wrote in message
news:3f******** @dnews.tpgi.com .au...
I recently posted a question regarding a table built using an action query in VBA. I am still having trouble. I have tried saving a record as

suggested
by one post.

The problem

A form uses the new table as its recordsource. However, even when the form is closed using either the close button on the form title bar or using the docmd.close the form fails to release its connection to the table making

it
locked and unable to be dropped or edited prior to the next create table

sql
command.

I have looked everywhere for a solution without success.

Any suggestions?


Nov 12 '05 #3
In the previous post there is a line in the cmd_Menu event that should not
be there. I was testing the Unload and of course the syntax is wrong and sis
not work.

"Mike" <re******@hotma il.com> wrote in message
news:3f******@d news.tpgi.com.a u...
The code I am using on the close button is as follows:

Private Sub cmdMenu_Click()

Unload "frmViewDetails "

DoCmd.Close
DoCmd.OpenForm "frmMenu"

End Sub

Private Sub cmdViewList_Cli ck()

DoCmd.Close
DoCmd.OpenForm "frmListPatient Orders"

End Sub

I thought the Unload even took place before the Close so would think that
the form is unloaded at this point. Is that wrong?

Mike

"Phobos" <la******@spamm ers.co.uk> wrote in message
news:ma******** ************@br ightview.com...
It usually helps us to help you if you post some code...

That said, I suspect that you are not unloading the form from memory,

merely
hiding it. Look up "Unload" in help.

P
"Mike" <re******@hotma il.com> wrote in message
news:3f******** @dnews.tpgi.com .au...
I recently posted a question regarding a table built using an action query in VBA. I am still having trouble. I have tried saving a record as

suggested
by one post.

The problem

A form uses the new table as its recordsource. However, even when the form is closed using either the close button on the form title bar or using the docmd.close the form fails to release its connection to the table
making it
locked and unable to be dropped or edited prior to the next create
table sql
command.

I have looked everywhere for a solution without success.

Any suggestions?



Nov 12 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
12816
by: Chris | last post by:
Dear all, I would like to figure out a way to add controls to a form using specs stored in a table. Any assistance in fleshing this idea out would be greatly appreciated. I'm using VB6. Right now I am thinking I would loop through the specs table (containing control name, control type, width, max length, etc) and print lines of code to a text file. The code would look something like the following:
2
1819
by: John Beschler | last post by:
I have a c# function that runs fine in VS.Net when in debug mode; however, when I switch to Relase mode or compile the app, the function fails with "object refernce not set". Here is the whole function: private void GetETCStatus() { oConn.Open(); szSQL = "SELECT ParamValue FROM Params WHERE Param = 'ETCsAvailable'";
4
3784
by: CompGeek | last post by:
Hi there, I am trying to load a file with 1729 records into a DB2 UDB EEE 7.1 DataBase (on AIX 4.3) which is across two partitions. The partitioning key is BI_INSTITUTIONAL_KEY which is a BIGINT and is explicitly defined in the table DDL (with "using hashing" ON). The autoloader config file is attached below. The results of the autoloader are as :
13
2548
by: MLH | last post by:
I have a form with two controls: !! - combo box !! - text box A button on the form tries to run this SQL when clicked... INSERT INTO BodyMsgsSent (ToWhom, BodyText) SELECT DISTINCTROW !! AS MyTargets, !! AS MyList; When the SQL runs, it fails with msg saying "Field length is too
8
2067
by: Thomas W Ping | last post by:
Putting focus in a form element like a dropdown box and using the mouse wheel - even one click forward or backward with it - cycles through every record, in that direction, until first or last record is reached. MSKB has a VB workaround for making Access unresponsive to the mouse wheel, but I don't need to prevent that -- just the *runaway* cycling. Any ideas? I've not seen this behavior in any other applications. Logitech USB optical...
12
12963
by: swingingming | last post by:
Hi, in the NorthWind sample database, when clicking on the next navigation button on the new order record with nothing on the subform (order details), we got an order with nothing ordered. How can we prevent this from happening? Thanks. ming
5
3934
by: ortaias | last post by:
I have a form which calls up a second form for purposes of data entry. When closing the data entry form and returning to the main form, things don't work as expected. When I return to the main form, I trigger the on acitvate event to run a macro. I can use the Dlookup function to update my fields, which is OK. However, I intitially tried to use the Repaint Object command to repaint the form. That did not work. Though I solved the...
10
5729
by: gweasel | last post by:
What is the best way to apply a Validation Rule - or rather, where is the best place to put it? Is there an advantage to putting it on the field in the table vs setting the validation rule on the form the control is on? Basically I have a number of controls in a form that are required, and to check it I am setting the Validation Rule to "<>"IsNull" so that when the user tries to tab through/click out of a required area without entering...
3
4569
by: pilnyj | last post by:
My quest is to create a function that returns a string value from a lookup table given the ID. If no match occurs, then I want to load that value into the lookup table. So here's my lookup table... SQL> select * from bios_lookup; BIOS_ID BIOS ---------- ---------------------------------------------------------------- 1 Phoenix - AwardBIOS v6.00PG
0
9685
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
10239
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
10019
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
1
7555
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
6796
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5579
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
4122
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
3736
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
2928
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.