Well I tried that and I am still getting the error "Invalid Qualifier"
Any other suggestion here is what I have on the ON CLICK button
Me.FormName.Filter = "[ALLW]>0"
Me.FormName.FilterOn
Me.FormName.Requery
I need to filter a form by a command button that will only show column of currency [ALLW]'> 0'
It is on ONCLICK.
How do I get this to Filter the form to only show values greater than 0
Need help with this code, I need to do a Between/And for the FROM_DATE and this code has something wrong with it and can not figure it out, Please help
stlinkcriteria = "HICN = '" & Me![HICN] & "' and UPIN = '" & Me![UPIN] & "'" & _
Between "[FROM_DATE]=" & "#" & Me![FROM_DATE] & "#" & _
and...
I have a print problem. When my users goto a form and click the Print button on the tool bar it prints the current screen they are viewing, Thats fine. But if the go to File Then Print it prints a form that is a few screens behind the current form(first main screen). Has this ever happened to...
I need to get the total yrs, months, days from a beginning date and ending date. EX:
Begdte:1/1/03
Enddte:2/4/04
should get something like 1yr 1month and 4days
I need to build a tickler form that will popup and remind a user to do something. For instance: if the are logged on to a database and the form was set to remind them on feb 20th to do something, then I would like a form to popup and remind the user they need to do something. Can this be done.
How do you update a table from data entered into a textbox on a form. I have a txtbx on a form and a subform of a table one column. I want to enter data into the txtbx and have it entered into the table and see the refreshed data in the subform showing what was just added. Anyone?
Can you search 2 different columns in a table(columns are exactly the same)using only 1 criteria. For example 2 columns contain zipcodes, I want to enter on a form in a text box one zipcode and have it then search both columns to return those records.
Can this be done??
[morning]
BY GEORGE I'VE GOT IT...
The easy way to do this is to create a button with a hyperlink to the excel file you want to open. Then make visible-false, then if using a macro that runs a bunch of queries like I'm doing to update a linked excel spreadsheet, then add a GOTO CONTROL for that button...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.