Search results

IM so sorry about that I was trying see where my co workers code was lined up at. We were trying to figure out how to set more records to update. All the quotations were confusing me.

How would I add multiple criteria to this statement this doesnt work Private Sub cmdUpdate_Click() DoCmd.RunSQL "UPDATE [Hardware Asset]" & _ " SET [Hardware Asset].[OS] = """ & Me.[OS] """ [Hardware Asset].[State] = """ & Me.[State] & _ """ WHERE [Hardware Asset].[AssetNumber]...

Private Sub cmdUpdate_Click() DoCmd.RunSQL "UPDATE [Hardware Asset]" & _ " SET [Hardware Asset].[OS] = """ & Me.[OS] & _ """ WHERE [Hardware Asset].[AssetNumber] = """ & Forms![Hardware Asset Update Form]![AssetNumber] & """" End Sub

yea something like that

i need an equation that counts the number of "in storage" i have for each giving record number. so i have 1 record with 10 in storage i need an equation to out put total number of in storage = 10 Record----------Location------------ Status--------------------- Total...

Im trying to have my status column count the number of "in storage" in one record. Ex: I have 1 record with 3 "in storage" status. I need for access to output 3 in a column that im going to create called "Total Number Of Status" should look like this Record--------Status------------Total...

Nevermind i fix it!!! it looks something like this. Thanks Private Sub PO_Number_AfterUpdate() Me.[OS] = DLookup("[OS]", "[Order]", "[PO Number]= Form![PO Number] ") Me.[Memory] = DLookup("Memory]", "[Order]", "[PO Number]= Form![PO Number] ") Me.[Processor] = DLookup("[Processor]"...

Im getting a run time error when i try to pull infomation from my Order table to my Hardware form. can anybody help body Private Sub PO_Number_AfterUpdate() Me.[OS] = DLookup("[OS]", "[Order]", "[PO Number]='" & Me.[PO Number] & "'") Me.[Memory] = DLookup("Memory]", "[Order]", "[PO...

I have two tables/forms Y & Z. Table/form Y has two fields order number & date. Table/form Z has three fields first name, last name, order number. Without using an subform I want to be able to enter information in Table/form Y and hit my (created) button then allowing me to automatically pull...

Exactly thank you

Hello im trying to add a on click condition to my form, where when I click on my checkbox that i have created (Recieved Data Known) it will enable a button (Enter Data) to my form automatically.

basically im trying to have the person looking for data, type in any part of information of the patient they are looking such as: name dob etc.............. when typed in the Search Form the results go to the Search Results subform then when you find the data you are looking for it...

oooooooooooooo i see thank you but the response to the last question in the other form access wont let me convert it back to 2003 because i am using a multivauled field. http://www.access-programmers.co.uk/forums/showthread.php?p=1098339#post1098339

I have another problem can you guys help basically im trying to have the person looking for data, type in any part of information of the patient they are looking such as: name dob etc.............. when typed in the Search Form the results go to the Search Results...

I have done more stuff to it basically im trying to have the person looking for data, type in any part of information of the patient they are looking such as: name dob etc.............. when typed in the Search Form the results go to the Search Results subform then when you find the data you...

boblarson thank for the help but its still no change can you look at my database for me. https://rapidshare.com/files/2180047708/final3.rar

Ok thank you this is my new code and it still giving me blank output SELECT General.MRN, General.[Patient Last Name], General.[Patient First Name], General.DOB FROM [General] WHERE (((General.MRN) Like "'*" & [Forms]![Search]![MRN] & "*'") AND ((General.[Patient Last Name]) Like "'*" &...

SELECT General.MRN, General.[Patient Last Name], General.[Patient First Name], General.DOB FROM [General] WHERE (((General.MRN) Like "'*" & [Forms]![Search]![MRN] & "*'") AND ((General.[Patient Last Name]) Like "*" & [Forms]![Search]![Patient Last Name] & "*") AND ((General.[Patient First Name])...

My mrn is text and i have four fields with similar code

Ok i tried that now it doesnt give me an output