f430
Last Activity: Apr 6 '13, 12:56 AM
Joined: Aug 5 '10
Location:
-
is there any way to make the filtered results show up in a spreadsheet view, because i have a lot of data, and it would help a lot if i can see more than one item in the filtered section. -
yes, my search filters my master table, which contains all the records.Leave a comment:
-
form filtering but not showing results
i have a search form that filters a master table, my vba code is complete and is correct, the only problem i am facing is that after i search my filter tells me at the bottom of the form how many values are filtered but doesnt show me any data.
i set the record source of the form to all the fields in my master table, and put the form's default view in continuous forms.
how can i get my form to show the data in a separate window or within... -
one more question, what is the purpose of having this search query when i have the vba code for my search form. would i be able to make my search form function without the queryLeave a comment:
-
it worked.
ThanksLeave a comment:
-
im not sure what questions i exactly missed, but i'll try to explain what i am having difficulty with.
for example if i take this code below:
how can i make this code in sql language?Code:If Not IsNull(Me.Defect) Then _ strFilter = strFilter & " AND " & "('" & Me.Defect & "' In([Defect Code 1]," & "[Defect Code 2]," & "[Defect Code 3]))"
...Leave a comment:
-
here is my sql code, i wasnt able to get it to work
...Code:SELECT [Part Number], [Code 1], [Quantity 1] FROM [Master Table] WHERE (([Code 1] IS NOT Null) OR ([Quantity 1] IS NOT Null)) UNION ALL SELECT [Part Number], [Code 2] AS [Code 1], [Quantity 2] AS [Quantity 1] FROM [Master Table] WHERE (([Code 2] IS NOT Null) OR ([Quantity 2] IS NOT Null)) UNION ALL
Leave a comment:
-
when i click query> make table query access switches to design view, but the grid is empty, and has no fields filled outLeave a comment:
-
Make a Table from a Query (SQL View)
i have created a query using the sql view, and want to make this query a table. is there any way i can do that. i have tried clicking on query-make table query, but this takes me to the design view and it completely neglects what i had in sql view.
Thanks -
i have been trying to manipulate the vba code into my search query but im running into a lot of problems.
i know that all i need to have are lines # 2, 6, 12, 17 from post #20
but i cant seem to have the right sql for it.
i was wondering if u had an example or anything that might help.
ThanksLeave a comment:
-
so this is gonna be a copy of the code, but instead of "if" we use "SELECT" or "procedure" , because it seems like it doesnt accept if or any quotation marks or at least not in the beginning of the code. it keeps saying that it is expecting "select", "update" , " insert" or "procedure"Leave a comment:
-
i wasn't trying to not use what i learned, i just had this sql before i fixed my code, and i was not sure if this query should have the same format as the code i used.
should i have if statements like in post# 32 line#15??Leave a comment:
-
compiling the project was greyed out, but that was just because i was into the search section, and not the whole code. i was able to get it to work.
please let me know if you still need me to attach the file based on my last response.Leave a comment:
-
what do u mean by tablename a and tablename bLeave a comment:
-
i think i figured out what is wrong with my database, and it definitely isn't my code.
the problem is that my search form is based on a search query. i went into my search query, and it didnt include defect code 3, associate, and associate 2. and that is why every time i searched, it asked me to enter parameter values. and i believe if i can get the correct sql into my search query, my code will work. here is what i have in my search query...Leave a comment:
-
i was able to complete all the steps correctly, except step #5 because when i went into my visual basic editor, that option was not available(i wasn't able to select it).
and what i mean about the form is, i checked the access file before i compress it, and everything seems to open and work correctly. however when i compress it in a zipped folder, i open the file and my search form is blank in regular view, but it has all the boxes in the design...Leave a comment:
-
for some reason whenever i try to put my access file into the zipped folder, the search form does not show in the regular view. however if the search form is in the design view it has everything.
i followed all the steps, but thats what happens when i try to compress it.
any ideas??Leave a comment:
-
Combining Columns
i was wondering if it is possible to do the combine columns into a query to make a new table.
if my original table looked like this
Part Number.....Col 1.......Col 2.....Col 3..Col 4.......Col 5.....Col 6
1.............. ..........10... .......20...... ..30.......12.. ........40..... ...15
2.............. ..........11... .......21...... ..31.......12.. ........__..... ...__
3.............. ..........12... .......22...... ..__.......__.. ........__..... ...__... -
they are the defects but im using this modified table for creating diagrams.
i was actually thinking of modifying this a little, if i wanted to do the following
Part Number.....Col 1.......Col 2.....Col 3..Col 4.......Col 5.....Col 6
1.............. ..........10... .......20...... ..30.......12.. ........40..... ...15
2.............. ..........11... .......21...... ..31.......12.. ........__..... ...__
3.............. ..........12... .......22...... ..__.......__.. ........__..... ...__...Leave a comment:
-
Thank you NeoPa, i appreciate your helpLeave a comment:
No activity results to display
Leave a comment: