Search results

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...

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?

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...

This project is in Access2000. I have a form with a really large tab control on it. All of the other controls belong to one of the 4 pages of the tab control. The tab control is so large, it has to be scrolled up and down. (I would make it smaller if the design of this project was up to me...

I'm using controls like textbox and rectangle to prettify my form. For example, putting a background under a control or group of controls to help the user visually seperate them. I'm having problems making the right control appear ontop though. For example, there is a combobox on one page of...

So, I have one query in two databases. The query works correctly in a minimal database, where the only existing tables and fields are the ones involved in the query. The query will not work at all in my real database, and in fact will crash Access in quite a hard manner. This is the minimal...

I've learned alot from everyone here, and I really appreciate it. So many of my problems and frustrations are due to a lack of experience with Access, which everyone here has in abundance.you all are the coolest. Today, besides almost taking a hammer to my workstation of some check boxes, I've...

I have a checkbox control in a subform. It refuses to activate. I put a simple procedure in the click event private sub CheckBox_Click() msgbox "clicked" end sub and it won't run. The same procedure in any other event will work OK, like dblClick or Enter. I think it must be some sort of...

I'd like to make the record source of a subform be dependant on the current record of the main form, any advice? Something like: SELECT * FROM tblChild WHERE tblChild.parentFK = ParentForm.CurrentRecord.PrimaryKey but i don't know the correct syntax, or even if form objects can be referred to...

Here's what i'm working on: tblPrimer PrimerID (PK) PrimerName OtherDataDealingWithThisPrimer tblPrimerPair PrimerPairID (PK) Primer1 (FK) Primer2 (FK) OtherDataDealingWithThisPair But i'm not sure how to relate these two tables. any advice?

Hi, I want to preface this post by saying how much I appreciate this community. I haven't contributed much, but my access knowledge is apprentice level at best, hopefully that will change. Thank you. My current project is a gene sequence database to store experiment/extraction results. The...

So, i want to set the `row source type' to be a query, and the `row source' to be a simple query like this one SELECT PrimerPairs.IDPrimerPair FROM PrimerPairs; But when i use switch to form view, the combo box is behaving oddly. It looks as if the values should be there. When i click on the...

I want to adjust the look and feel of the tab control in MS Access 2003. Specifically i want more rounded tabs, is this possible do you know? any advice appreciated.

How can i refer to a field name of a RecordSet variable if the field in question has a space or other funky character? REM the name of the field in this example is Field #Name Set dbs = CurrentDb Set rst = dbs.OpenRecordset("Table 1") ... SubRoutine(rst!Field #Name) SubRoutine(rst!Field\...

I'm pretty new to Access, but it seems to me there should be a way to do something like this: Dim rec As Record Dim tbl As Table Set tbl = Access.GetTable ("Tablename") Foreach rec In tbl begin if (!spellcheck(rec.TextField)) add_to_output(rec) end Obviously this isn't anywhere near to...