Happy Holidays Everyone! I have a major problem.
I need to write a VBA macro for more advance sorting.
For example: if i have numbers that I must sort by and they range say from 1 to 200, some numbers have say 78A and 78B. When I sort, excel automatically puts them to the bottom of the list, not the acompanying 77,78A,78B,79 etc. place. What can I do to make excel sort it correctly? Please help, many thanks.
...
artromanov
Last Activity: Dec 26 '06, 09:33 PM
Joined: Oct 30 '06
Location: NYC ,NY
-
artromanov replied to Setting query criteria in a form and running a query from that form by pressing a cmdin AccessEverything works perfectly... Thank you so much and I am terribly sorry to be a pain in the behind.
Everything worked except for some reason if I do not enter any value (I do not want that value to be entered, the query turns out blank. Its Okay, thats tomorrows concern. Thank you very much.... I really appreciate what you guys do. I never knew that a forum can be so helpful and fun. Thank you - everybody and i'll see you guys tomorrow.... -
artromanov replied to Setting query criteria in a form and running a query from that form by pressing a cmdin AccessI am getting an odd message.
It reads: The text file specification "FISA Link Specification" does not exist. You can import export or link using the specification.
Sounds terrible...Leave a comment:
-
artromanov replied to Setting query criteria in a form and running a query from that form by pressing a cmdin AccessAnother thing: How can I tie the Command button to run the query based on what I inputted in the text box?...Leave a comment:
-
artromanov replied to Setting query criteria in a form and running a query from that form by pressing a cmdin AccessBy the way, if I want the field to be a wildcard entered from the text box, how would I do that?Leave a comment:
-
artromanov replied to Setting query criteria in a form and running a query from that form by pressing a cmdin AccessYou have perfectly understood the point. I will try this out and leave feedback about it. Thank you very much....Leave a comment:
-
artromanov replied to Setting query criteria in a form and running a query from that form by pressing a cmdin AccessThats pretty cool. Here is what I have.
SELECT [September Employee Roster].SS, [September Employee Roster].[Title Code], Title_codes.Dec ription, [September Employee Roster].[Last Name], [September Employee Roster].[First Name], [August Employee Roster].Leave, [September Employee Roster].Leave, Leave_Codes.[Leave Description], [September Employee Roster].BC, [September Employee Roster].BL, [September Employee Roster].Paycode, Pyrl_Dist_Codes .[WORK...Leave a comment:
-
artromanov replied to Setting query criteria in a form and running a query from that form by pressing a cmdin AccessInstead of replying, I have accidently REPORTED that message (which took me about 30 minutes to write) Oh no. If you are the moderator (or admin,can you please check your report messages?) I am so sorry.
Thank you....Leave a comment:
-
artromanov replied to Setting query criteria in a form and running a query from that form by pressing a cmdin AccessThanks, but where am I suppose to write the statement that you gave me: beginning with the select distict. Would it be possible for you to e-mail me the db with this example? I think it is something that I can use to build on?
If you can and dont have much info there that you cannot share (which I dont need) that would be cool. my e-mail is: ArtRomanov "AT" gmail "DOT" com
Thanks for your help....Leave a comment:
-
artromanov replied to Setting query criteria in a form and running a query from that form by pressing a cmdin AccessThank you for the help.! :-)
Although I am still quite lost, I need the form to be linked to a query where instead of me entering criteria into the design view of a query, I can use the input text boxes to enter the criteria and click a cmd button "Search" and the query will run. I am creating a more user friendly environment so that people other than me can use this at work without knowing much abouit access. I think it...Leave a comment:
-
artromanov replied to Setting query criteria in a form and running a query from that form by pressing a cmdin AccessBy the way, it is sort of like a Find A Person. In other words, if I enter many different criteria, it will give me the results in a separate form. If I enter a unique criteria, say Social Sec #, then it will pull up all the needed information just about that 1 person. Thank you alll so much..........p lz help :-(...Leave a comment:
-
artromanov started a topic Setting query criteria in a form and running a query from that form by pressing a cmdin AccessSetting query criteria in a form and running a query from that form by pressing a cmd
Hello everyone. I am somewhat new to access and this forum. Hopefully it will be a great and helpful experience.
My problem is this. I have a database (about 65,000 records).
I get a run from another party every month in a text format (notepad) which I import into my database and make a comparison between the previous months and current months tables (some fields) by running a query. What I am trying to do is create...
No activity results to display
Leave a comment: