Search results

see, it seems like too much work if i make a query for every possible search criteria the user will enter. Is there a way I can use code such that the value entered is taken and put into the query?

see, it seems like too much work if i make a query for every possible search criteria the user will enter. Is there a way I can use code such that the value entered is taken and put into the query?

actually i want to update the sort on an already filtered list. I tried doing what you said anyways, but it causes my list to go blank and doesn't sort for anything. Ahh..I'm lost

but if say the user searches for Canada, and all items are filtered to show only based on the criteria how does that effect the report? Then what if the user searches for something else?

How do I do this? Anyone know? My listbox filters according to a search and I want to give my users the option to print the filtered list. How? HELLLPP!! Thanks!

I have a listbox that filters according to my search. I also have a combo box that chooses how to order the items in the listbox. It works well if I make the selection first then enter my search criteria prior to filter. But right now I am using an "if" statement and if i want to change the...

do you know if there is a way such that when hitting the print or preview button on FormA that FormB can tell which button was hit? I would prefer to keep formB as just a option1 option2 form and on close it will execute according to the chosen option. Would work well if it wasn't for both...

I only have Tools -> Add-ins -> Add-ins Manager

How do you set a check box to "yes" for only a specific record using code?

is there a way to execute a function in the code of a form after hitting ok from another form? In my formA I have a print and print preview button. As I click it I want to have a formB that pops up asking if you want to view/print the complete list or just the current record. I've put a...

This is what I used for the txt box that requires a search entry to filter the listbox. From here I don't know where to go in terms of printing a report. I wonder if I should completely change my approach? Private Sub txtDescription_Change() Dim txtSearchString As Variant Dim strSQL As String...

I have a listbox that filters according to my users entry. Say all contacts for a certain location. Then I want the user to be able to get a print out of this in report form. how would I go about this?

I've got a list box displaying all my files and a textbox that I use to enter a name/location etc. to search for in the box. So basically it filters according to my entry. How do I sort in a list box? Say I enter a search for Ontario and my list filters for Ontario, but I want to sort these...

How do I use a list box such that the user can select the item and hit OK to open that particular file? I know how to link files in forms but can it be down b/w a listbox and form?

I've split my database, but have brought the file(s) home to work on. How do I change the path?

Hi, does anyone know any good links showing some typical form represent good design practices? I've looked at the few examples on this site but want to get more ideas. Thanks

What do mean normalized? Is there a certain standard? Sorry, I don't know very much about access. Yeah, I guess I should think of redesigning it. Basically I have a load of records and I want the user to be able to search by company, location, description...etc. and then receive a list of all...

I currently have a subform in datasheet view that displays all my records. Unfortunately it is too much info that the user must scroll horizontally. I was thinking that I could still have this subform w/ limited information and have a second subform that shows the rest of the info depending on...

Another dumb question. Sorry! Why is it that the font size doesnt change in my subform? No matter what size I choose it has no effect when I view it?

I'm curious why this happens. On startup, I have a switchboard come up automatically. At one point I changed the the number of buttons and moved them around using the switchboard manager. So now eveytime it loads up I see the old form for about a second before it is updated with the new one...