Search results

Actually, there are already connections to that server/db before I do the test, so I don't think adding another connection will change anything. The issue is with tables with large number of columns or with columns that have varchar greater than 254. They are converted to memo in ms access...

I'm going to try this later on today. I'll let you know if it helped.

Sorry, I'll remember to keep that in mind next time.

How can I set the HorizontalAnchor and VerticalAnchor on a form via vba? I am able to do it manually but can't figure it out in vba.

I am using the function below to check if my Linked ODBC tables are good. It works, but when it gets to tables that have a lot of columns, it takes about 5 seconds to return. I am checking about 56 tables and it could take up to 10 - 15 seconds. I tried using "Select 1 from tablename" and...

Nevermind, I found my error.

I am moving the columns in a subform and then running code to save the order of the column names and other properties such as order, width, hidden, DS caption,etc... When I loop thru the controls in the form. It is not capturing the order of the columns that I moved them to. Why is this not...

Forms(CurrentForm).Tab05ID does work, the issue was there was no record source. I fixed that.

It's the same form. What is another way of saying Me.Tab05ID ?

I had this line GBL_Tab05ID = Me.Tab05ID and wanted to change this. I have this on the On Current event and it gives me an error because the data is not in the record source when the form opens. How can I change the me. to the formname? The form gets dynamically created so i have...

I finally got it to work. I did set the on current to a public, but what did it was this line below. I only needed .Parent once Me.Parent(TopForm).Form.Form_Current Thanks!

I get an error when i try the error below, "The expression you entered has an invalid reference to the Parent property" TopForm = "Dyn_" & Trim(str(Project_ID)) & "_SubFrmTab05Main" Me.Parent.Parent(TopForm).Form.Oncurrent I also tried: Me.Parent.Parent!["Dyn_" & Trim(str(Project_ID)) &...

Tried this: Me.Parent.Parent!(TopForm).Form.OnCurrent got an error: "The expression you entered has an invalid reference to the parent property"

Subform_A is a variable that has the name of the subform. So how would the syntax be?

Actually, I want to call the On current of another subform from the same parent. parentform - > Subform_A parentform - > Subform_B parentform - > Subform_B -> Subform_C I want to call the On Current of Subform_A from Subform_C

I want to call the "On Current" event of another form. I have a parent(mainform) form and then I have a subform(CurrentForm) and in that subform(CurrentForm) I have another subform(mysubtab01). From the mySubTab01, I want to call the On Current of the parent form. How can i do this? This is...

I have made an application into a dynamic application and the form names change. I capture the form names in variables. I want to make my formula below which is in a textbox in my form dynamically. (In the control source of a textbox) This works in my old form...

Tried stripping it down and recreating the issue but it does not happen.

need to step out...will try to post a bare minimal app and replicate the issue when i get back.

Here's a few lines before and a few lines after...but i have stepped thru it and it goes to the "on close" of my already open form as soon as it starts to executes the DoCmd.openform line. When it is is done closing my other form it steps to the next line Set MyFrm.... Select Case...