Search results

Thanks, I found it. Unfortunately for me, it's not the shortcut I was looking for (if i know the line number, i might as well just know the name of the function, heh). I did find the nice property Application.VBE.ActiveCodePane.CodeModule.Parent.Name which will return the name of the active...

Ack, I can't find the library to reference for VBE (VBIDE) does anyone know what the filename is for this library? EDIT: PS Does anyone else find it difficult to browse the list of available references? Unless I know the full name of the library it can be challenging.

Is it possible to find the name of the current executing function at runtime? Something like: sub ThisSubroutine MsgBox(This.RunTimeObjects.CurrentFunction.Name) End Sub Of course, the whole red part is just some kind of wierd object I made up. But if an object like that does exist, or...

errr, good question. I assumed VBA would have some sort of timer control, but I don't see it in my version. If you don't have it either, google for something like "timer ocx" and register it under "tools->active x".

The way that Access manages the event functions doesn't work 100% all the time, even though it's pretty smart. In the design view of the form, click the menu View->Code and look for the project explorer pane in the VB window that pops up. If you don't see that, press ctrl-R. From here you...

You could put a hidden timer on the form that requery's every 10 seconds or so... Thats the best I can think of.

Well, the title says it all really. After I click into the subform and type something in a text box, the focus will not return to the parent form, via mouse or tab. I can't even switch the form back into design view, it appears to be totally locked. Has anyone run into this before?

What you need is a field in tblIndividuals that shows if the record is person #1 or person #2. Then, when the household form is updated, change the recordsource for each of the subforms, like so: Form_Subform1.RecordSource = "SELECT * FROM tblIndividuals WHERE tblIndividuals.HouseholdID =...

:o oops sorry, i really should have checked for other threads. :o

Can anyone do this? For some reason if I try to put another tab control onto a certain page of a main tab control, Access's VBA doesn't allow it. Other applications (Excel, Word) are ok with this. Does someone know how to make it work?

I'm building a database with 23 tables (so far) and about 30 foreign keys, spread out amongst the tables. So far I haven't concerned my self with the "Enforce Referential Integrity" option in the database, I figure if the interface (read as: forms) is(are) designed right, the integrity of the...

My initial reaction on reading your post was this: In the properties window of the form, data tab, there is a property called "Allow Additions". Having this property set to 'No' will create the behaviour you described. Reading your post all the way through, I saw that you tried putting...

What you're going to want to do is go into the design of the table, and change it from being an autonumber to just a regular number. Then you can write an event procedure to calculate the next one if you like. If you are determined to continue with the autonumber, here's what to do. backup...

is it small enough to post?

I have bad news for you. The only way to get the Autonumber to reset is to make a new table. It is never a good idea to use the Autonumber data type if there could ever be a need to change or specify the next number generated. The only purpose of the Autonumber is to be unique, and it tries...

I wasn't explaining that very well, so I made a quick example of what I was trying to do

I think I see. I would probably adjust the design a little bit. You have a table of products, right? it might look something like this: tblProducts ItemNumber (Autonumber) (primary key) ItemDescription (Text) ItemWeight (Double) To make the form with 3 controls behave close to the way you...

Can you explain how the other two fields are autoupdated? Is it because changing the combo box changes the current record of the form? Or is it because the combo box has an AfterUpdate event that changes the next two controls?

Ah, ok, I have to be careful what object I'm refering to.:( I'm guessing now that SubForm1 and SubForm2 are the names of the subform controls in the parent form and not the actual forms. Try replacing these two lines with Me.Subform1.Form.RecordSource = strSQL1 Me.Subform2.Form.RecordSource =...

I've noticed this undefined behaviour myself. It doesn't through up any kind of error when using the constant warningsoff, but it will for warningson or any other. wierd. Relying on the tips from typing is what got me in that trap in the first place :(