Search results

That would have been the smart thing to do in the first place. Sorry.:o =Forms!TableObjeMapping![ObjectTableAttributeMapping subform].Form!ParentTableAttrId=[TableAttId] I had removed this line from the "On Current" event to try something else, but now when I put it back it is giving me a...

I think it helps. In SubformA in the OnCurrent Event I placed an expression setting the value of a field in SubformC, but I get the following error: The expression On Current you entered as the event property setting produced the following error: Microsoft Office Access can't find the form...

Hello All, If I want to select a row from subform A and a row from subform b and click a button and have the keys stored in another table what would be the best way to do that? Thanks.

Thanks guys. That cured my brain lapse!!!!!

Hello All, I am struggling with how to do this ( I am sure I am having a bit of a brain lapse). My form has two ids from two master tables (MstrTableA_Id & MstrTableB_Id). The two MstrTable Ids are tied together by a surrogate key to show that they are related. So I should be able to scroll...

Thanks Rich. That is almost too easy.

Hello, I have a very long SQL statement that I want to assign to a variable, but Access keeps chocking on the length. Is there some way to define the String data type as bigger than 255 characters? Thanks.

Hello All, I have a continuous form that I want to sort/re-sort based on clicking a button in the header. One button is for sorting the records by Project Name and the other is sorting by Project Tracking Code. The form is based on an SQL Select statement. Here is the click event code for the...

FoFa, Thanks for the tip! I see the problem. The data I thought was there for all records is, in fact, only there for some.:rolleyes: Boy, do I feel dumb. Thanks for the catch!

FoFa, I am not sure how to dump a record in Access. Could you help me understand what you mean? Thanks.

My BOUND property is set to 1 Here is some further detail that may help: ComboBox1 = Project Type In the "AfterUpdate" event I have the following code: On Error Resume Next ParentProjectId.RowSource = "Select Project.ProjectTrackingCd " & _ "FROM Project " & _ "WHERE...

Hello All, I recently added a couple cascading combo boxes to one of my forms and now the data from the underlying table that has already been entered does not show up unless I go in and reselect the options. Anyone have any ideas on how to fix this? Thanks,

Hello All, I was wondering if it is possible to invoke PHP from w/n Access and return the results from the function to a form? Thanks.

Yet again, thanks. I am about 99% sure I would not have figured that one out. Craig

OK, now I am trying to tack an "AND" to the end of the selection so it would look like : MsgBox "Item count found = " & DCount("[ItemID]", "tblItems", "[ItemID] = " & ItemFnd AND [EffDate] <= [txtDate]) Where [EffDate] is a field on the record from the [ItemID] and [txtDate] is an unbound...

Woo-hoo! That did it! Thanks Wayne!

Hello All, I have the following DCOUNT statement: MsgBox "Item count found = " & DCount("[ItemID]", "tblItems", "[ItemID] = [ItemFnd]") Where ItemID = Primary Key on table tblItems ItemFnd = a long Integer variable that gets populated programatically, not from the form. It is internal to the...

Emp, Thanks for the reply. The DCOUNT() function will certainly prove useful to me in the future. The code I posted is because I am trying to take a "phased" approach to what I am doing. I am new to using SQL in Access and did not want everyone to pitch in and code for me. I would not learn...

OK, all, this is making me crazy. I am simply wanting to display the number of records in a table when some one clicks on a button. This just displays the msgbox w/o the record count. I am sure I am missing something simple. Any ideas? Thanks in advance. Craig...

Does anyone know of a good SQL tutorial for Access. I already have a decent understanding of SQL so what I am looking for is how to use SQL within Access. Any suggestions?