Search results

I know this has been discussed countless times but here we go again. First, the form is visible as are the controls involved. The form does have a subform but it is not directly involved in this error. I have a series of comboboxes with code similar to that below. If the sequence of events is...

I have an unbound combobox with a query as the row source and limit to list = true. Is there a way to retrieve a "not in list" entry from the combobox. The idea is to use the new entry to add to the list in the notinlist event so the operator does not need to re-enter the text. Trouble is...

I recently has a situation where I had to prematurely close an accde file. This closure left a number of tempvars on the system. My opening sub checks for the existence of one such tempvar to either run the startup routine or go straight to the main menu. The result was that the main menu was...

That's pretty much what I thought, just looking for some confirmation. As an abseiler, I do jump off tall buildings and survive to tell the story!!

I have a situation where my university's IT has had to limit trusted sites within the system thanks to Microsoft's advances in technology.. To this end I have been allocated a trusted site where the Back end now resides. This has worked for us, to degree but I'm having a problem where the...

Form1 has some 90 controls and it takes a bit of time for it to open, especially over a wireless network.. If we're going back and forth, which is often the case, waiting for the Form1 to open slows down the work flow while simply hiding it means it is instantly open when needed.

I have a form, Form1, that has a button that opens a second form, Form2. Form2 searches all tables for a genus, species match. Form1 goes invisible after the button is clicked and Form2 is the only form visible. Form1 is still open. Form2 is now the active form taking input from a series of...

This is not the complete sub., only the bit relevant to the problem. In essence, a form, sTable, calls another form and sTable goes invisible. The second form then calls sTable making itself invisible and sTable visible. Only problem is sTable stays invisible. here is the complete sub...

In the code below, line 4, "sTable" is recognised as not visible but the "forms(stable).visible = true" does nothing. Tried it with and without the "Refresh", still the form "sTable" remains invisible. Public Sub isOpen(sTable As String) If Len(sTable) > 0 Then If...

Thank you. That worked. I set the recordsource in the onload event after getting the table name from args.

I have a form that is used by a couple of different tables. The form is initially unbound, but when "me.recordsource = stable" is run, the first combobox on the form gets focus. The tab stops are off and there is no other code involved. This causes no real problems other than the dropdown box...

It was hidden. Don't know how, as I never hide objects. I guess it's just Access being consistently inconsistent. Thank you to those who helped.

It is off. I have recently changed some table names and had to correct the queries manually but a check in options revealed it is not active.

No idea. Where do I find it and what relevance does it have to renaming queries etc.

That's all very good, but why is that query showing in querydefs and not in the query pane????? As for warnings, they are normally on except when I am removing data from a table or other times when I don't want the users to be alarmed by a message that will ultimately be ignored.

I am running basic code to output the contents of querydefs to a file and keep getting a query that does not appear in the queries pane, nor is it used in any procedure. I have run a compact and repair but am still seeing this query in any list created immediately after. My question is, at what...

The resume next "solved" the problem but the form's recordsource is not recorded. I'll play with this for a while. There is a problem with "currenproject.allforms" and records in that the listing is completely random. I have added a sub, "SortIt" that adds the form names to a recordset . The...

Apologies, I misread your code. I do have a problem though. when checking a form, the first dependency is a table and returns error 2002. AO2.name is the name of a table but AO shows nothing If DI.Dependencies.Count = 0 Then rs.AddNew...

Which is why, in my variation, I "Set DI = ao.GetDependencyInfo()" once at the beginning of the getdependencies sub and then check for dependents and dependencies without the need for a second "Set DI = ao.GetDependencyInfo()". The reduction in time taken is obvious. BTW> i will soon post an...

This is not an option as we have multiple front ends running simultaneously.