Search results

What would be the best way to filter a query in a subform? I want to use a combo box or a check box to filter the results. I am trying to make this easier than using the filter in the toolbar... need to make it simple for the pc noobs. Thanks, JB

I zipped it and attatched it..but it doesnt show. Ill try again

Here is my sample The forum doesnt seem to want to let me upload my file!! Can I email it? Thanks, JB

I have tables that are linked to a SQL server that relate to this problem. Will that be an issue?

Not sure how to do that.

It returned no records

I've tried this following the above link, but I cant seem to get it to work. I entered this into the criteria for one of the tables (scribe table) Like [particlefiles].[lot] & "*" Particlefiles is the other table. Both contain a field "Lot", but sometimes the number in Particlefiles contains...

Help needed I have set up the relationship between two tables in my query. The field is a Lot ID and it is in this format.... "2-11000". Sometimes there is "E" at the end of this. Question is: How do I make the query think that the two fields are the same even if one contains an "E"...

Any where that I could get a guide for coding this in? I've tried reading all the help topics that looked remotely close to this. There is really only 3 pieces of info that I need to get out of a txt file and plug into a SQL table. Thanks again, JB

Any way to make a macro in Access the same way it is done in Excel? Where is the record button!! Thanks, JB

Is there any noob tutorials out there to help with text importing/specifications? I have text files I want to import to a table. There will be new records for each file that is brought in. I've tried to use the wizard but I can never get the data to go where I want it. The files contain many...

Not sure how else to describe it, but here goes: I have a form with a chart and subform. The subform shows the results of a query. The chart shows the results of the same query in a chart. The Y axis of the chart shows the TagID from the query. The TagID number is supposed to like this...

Anyone?

Graph trouble...please help Hi there! I have placed a line graph in a form of mine. The graph is based upon a query. The problem is: I have a TagId number and a data value in this graph. The TagId number is doing some funky stuff. Some of the numbers display correctly (2-1500) and once I...

I have a sub form that displays the results of a query once a number from a list box is picked. When I run the query from outside of the form all goes as planned. But, when I run it from the form nothing shows up. The query the results are based on consisted of one table and two fields from that...