Search results

Hi there...just a quick question...I have about 20 fields in this form that I need cleared on the push of a button. Is there an easier way to doing this than to go Me.text1 = null Me.text2= Null . . . . . . etc.... Is there a Vb command that selects all the fields in...

thanks a lot Mike...that did it!

it is not modifying the fields I am concerned about...it is saving those fields.

Yeah..precicely...only for some fields though...

Hi there..i just got a quick question....Normally Access saves all the fields on a form when you exit the form...Is there a way to make Access pick specific fields to save and not the rest? Any help would be appreciated!

I will check that out! Thanks for the tip!

Thanks a lot Pat. That worked!

hey there...this might be a newbie question, but can you build a form that links two tables without having the user enter a foreign key?

Yes it does. I dont know why this it is doing this. the message only comes up when I click the close button or to go to design view however. It does not show up when I click the save button.

Yeah...I am pretty sure they are. However, what type of link should I be using(1, 2 or 3)?

You mean like a count of the primary numbers? If so, look into the Count(*) function. probably something like Count(primarynumbers) or something like that

Hi Pat, Thanks for your reply. However, I am still getting that stupid message. Any further thoughts?

Hi there, I have got a form where I have three foreign keys in them. when I try to save a record, it gives me this error message. "The Microsoft Jet Database Engine cannot find a record in the table [name of table where the foreign key is being linked from] with key matching field(s) [name of...

Thanks a lot namliam. I finally got it to work. Appreciate the help buddy!

hmmmm...how would I fix that? Please keep in mind that I need the variable as it is part of a string.

sorry...but after I posted this, I thought it would be better if I posted it in the vba and modules forum...I am new here :) Besides...there is still no answer to how i can retrieve multiple records using the recordset...I am only getting one record back!

thanks a lot man...but this way only selects ONE record in the column...I would like it to select all the records. This is the code I have right now. Dim ElementName As String Dim rst As DAO.Recordset ' Dim dbsCurrent As Database ' Set dbsCurrent = CurrentDb() Dim...

Hi Milo...I checked the first column and it is indeed a text data type... This is driving me crazy :mad: I will paste my code again... Dim ElementName As String Dim rst As Recordset Dim dbsCurrent As Database Set dbsCurrent = CurrentDb() MsgBox "Not here" '<---just testing...

ok...after many hours of torture...I have managed to narrow it down to this... I am getting a data type mismatch error at this statement Set rst = dbsCurrent.OpenRecordset("SELECT [Data Element].[Standard_Data Element Name], Compound.[Standard_Cluster Compound Name] FROM [Data Element]...

hey there... I have this code now and I am getting a type mismatch error. could someone please tell me what is wrong? Dim ElementName As String Dim rst As Recordset Dim dbsCurrent As Database Set dbsCurrent = CurrentDb() Set rst = dbsCurrent.OpenRecordset("SELECT [Data...