Search Result

Hi,

I have the following Forms:

[Form A] - Main form - Single form type
[Form B] - Continuous form
[Form C] - Continuous form
[Form D] - Continuous form
[Form E] - Continuous form

I want to add [Form B], [Form C], [Form D], [Form E] as sub-form on the mainform [Form A].

The Forms have the following relationship based on the underlying table:

[Form...

This is an existing topic. A good solution is given, but one line of code doesn't work:

rst2!Field2Upda te = Me.SF1Field

It has to do with Update.

What is the proper VBA syntax to update a field as shown above?

Thanks!

Hi all,

I'm stumped and it hurts to have to give up and ask for help, but even the omniscient Google limited by my mere biology can't solve this, and I'm still learning Access so here goes.

I have a main form containing a subform, which lists products within an order, in the footer of which is a text box called sfrmTotal whose control source contains the expression:
=Sum(Nz([SubTotal],0))

Back on...

Hi again guys. I have a series of tables linked together with 1:1 relationships to a unique key with referential integrity enabled on the relationships. My data entry form is made up of 7 subforms. Because of the field limitation I cannot house all my entries on one form.

My problem is that when my user switches to another subform access tries to save the record. Access cannot save the record because there are required fields in some...

I'm a relative newbie to Access, working in 2003 and trying to build a very simple client database for my company. Here's the basic set-up I have so far:

-Clients Table contains all the relevant contact info for all clients. Name, address, email, contact person, etc.
-Orders Table contains each order the various clients have made, including dates, quantities, etc.

The Orders table contains a Client ID field...

Hello all,

I have a form with a subform in datasheet view. The subform shows name and phone number and a checkbox that says "use this contact". When selected, the name and number populate text fields on the main form.

The problem is that if the subform contains multiple records, the checkbox for each can be selected. The form holds the values of the last selected, but I'd like for there to be only one check -...

I've looked all over the internet and I couldn't find anything that helped me.

I have a main form called: Patient Information
On this form I have a subform called: [name_Age Qry_form]
and a field in this form is: [Age]

Also on this form is a Tab Control called: [TabCtl38]
The First tab is called: [Contact Info]
and on this tab is a subform called: [Contact Info_tab]
and on this subform...

I have a database that has these two relevent tables: "Clients" and "WeighIns"

"Clients" has these fields: "IDClient", "LName", "FName" and other information not pertinent to this post.

"WeighIns" currently has these fields: "IDWeighIn" , "IDClient" (linked to "Clients" table), "WeighInDat e", "HT", "GoalWT",...

Hi, I a several subforms in a report and for some records the subforms do not return any data. When this happens, I would like to display a message as at present the area normally occupied by the subform is simply blank. Can anyone help me? Thanks in advance.

Hi, I am a relatively new Access programmer, but have programmed computers in Fortran and done complex modeling for years. Am learning quickly, and have managed to figure everything out so far, but now am stuck. Sorry if this is a basic question. I am using Access 2007.

I have a form for data entry. Database is biological samples. One table has sample code, date, other fields. Another table has multiple records for each sample,...

Hello,

I have some specification sheets with subforms I have created. I'm having a problem where if you right click and filter/sort any field in the subform (which is tied to the main form in a 1:1 relationship), then the subform only displays the first record. This ends up permanently altering the spec sheet. I notice that when this happens, text typically shows up in the "Order By" or "Filter" fields of the subform....

I need to add modification tracking to an existing database. It's effectively the same as the std. Orders/Order Details model so I'll use that for an example.

If a user makes a change to an existing order I need to be able to deactivate the original record and generate a new Order record. The same goes for any Order Details that are also changed. The idea is that users should be able to view what an Order looked like at a particular...

I have an access db. It has a tabbed interface and on the second tab, I have a datasheet view and a subform. When they click on the + to expand, they fill out event details. I have a depart field on the datasheet that has conditional formatting such that if the stop date on the subform is blank and the start date is not null, then the formatting applies. This works well, unless they refresh (there are front office and back office people working simutaneously,...

I am new to a VBA and only a little exposure to Access 2010. I’ve been battling a problem for a few days. I have a mainform with 2 subforms. Data in subform 2 is filtered to the record selected in subform1. I have no problems with data between the mainform and subform1. The frontend is in MS Access 2003 and the backend is a SQL server database.

The particular problem I am having is when I click in subform2 to add/edit data, the last...

I have a search form with a sub data form. When i search for "john" for example I should get a bunch of records in my subform, however it is just showing the first one from the table.

Here is the VBA.

...