Search results

Well I cant convert it it too much new things added

to understand my next problem you have to look at my database. Currently Im working on an query that suppose to output alot of data. My problem is that its not outputing the right and all the data. Im currently working on the "Asset to Bu" Query. And the password page is not link so dont...

I fixed it i put me.requery in my docmd.runcommand but dont go anywhere im going have more questions lol

it is but im entering infomation into it from my subform and when i click my button i want it to do my first line of code then save it then requery Private Sub CmdUpdate_Click() DoCmd.SetWarnings False DoCmd.RunSQL "Update [Order] SET [Order].[CER Number] = '" & Me.[CER Number] & "' WHERE...

ok but now im using an me.requery that seems to work. But before it saves it deletes the data i want to enter. I have it linked to an click button this is the order i have the code in. autofill code save me.requery but it doesnt save just deletes my information

Im trying to figure out how to have my subform refresh its self when I press button. I dont know how to find the name of my sub form is my biggest problem. Do you need to see my database?

Ok that seem to work thank you

Yea doesnt work either Private Sub Command7_Click() DoCmd.OpenReport "Purchase Order Report", acViewReport, , _ "[PO Number]=" & Me!PONumber & " or [DateOrdered]=#" & Me!DateOrdered & "#" End Sub

Yea they are both on the same from as the button. Im getting an "Syntax error (missing operator in query expression 'PO Number = 3011 or [DateOrdered]=##)' "

I took out the strFilter too Private Sub Command7_Click() DoCmd.OpenReport "Purchase Order Report", acViewReport, , _ "PO Number =" & Me!PONumber.Value & " or [DateOrdered]=#" & DateOrdered.Value & "#" End Sub

thank you i will change it but could you like at this post http://www.access-programmers.co.uk/forums/showthread.php?t=228801

I actually fix this a while ago thank you all Private Sub CmdUpdate_Click() DoCmd.SetWarnings False DoCmd.RunSQL "UPDATE [Hardware Asset]" & _ " SET [Hardware Asset].[OS] = """ & Me.[OS] & _ """ WHERE [Hardware Asset].[AssetNumber] = """ & Forms![Hardware Asset Update...

Po is a number an date i use the date picker and its mm/dd/yyyy

Yea make sense but it should be an "or" instead of an "and" i want people to be able to search by either. When i add an "or" i get runtime error 3075

Ok i tried to combine both ways still no luck strFilter = "[PO Number] =" & [Forms]![PO Search Report]!PONumber DoCmd.OpenReport "Purchase Order Report", acViewReport, , _ "[PO Number] ='" & Me.PONumber & "'" & " or DateOrdered ='" & Me.DateOrdered & "'" and it gives me an syntax error when...

I have a code that giving me the run time error can anybody help Private Sub Command7_Click() Dim strFilter As Integer strFilter = [PO Number] = [Forms]![PO Search Report]!PONumber DoCmd.OpenReport "Purchase Order Report", acViewReport, , _ [PO Number] = Me!PONumber.Value End Sub I know it...

Yea I did that thank you

ok but im reading how to do this and they said save my macro to the desk top and have the window scheduler open the macro from there. My question: is there any way to have my code run from the macro? Because right now it is link to a button and runs when clicked. I dont want to change it to a...

Yea I just did some research on the Window Scheduled Task but why would you create another db?

I have a code that saves an report every time i click an button i have created. Can you tell me a way to have this report automatically save every 10 days. Without pressing an button. Dim stDocName As String mystr = Format(Date, "dddd-mmmm-yyyy") If Len(Dir("C:\Documents and...