Search results

Is it possible to query using a public variable as the criteria ? I set up the public varible for the Part Number text field in my module using: Public varGlobalPN As Variant This variable can be reassigned on different several forms using a combo box. I'd like to be able to run the query...

It would seem like I could set the "on change" property for the form to run a requery event but this doesn't get me there. Any ideas why that would fall short? I'mkinda new at this.

Also, I'm not sure what happened to your reply to my message. I read it & attempted to apply it after reviewing the build criteria method help......

I'm still having a bit of difficulty with this. First, I'm unclear why you set the combo box null. And when do you actually requiry the table ?

I have a continuous form that displays a filtered table. I use a combo box on a previous form to select the desired part number and the continuous form is based on a select query using the result of the combo box. It works great. What I'd really like to do is have the combo box right on the...

I'd like to use Excel's graphing capabilities to plot data in an Access table and have the resulting graph display on my Access report. Anyone know how to do this ?

I am importing an excel file that has a column of numbers. Unfortunately there are several rows of text and intermixed blank rows in the excel table that are not relavent to analyzing the data. I'd like to set up a query that builds a new table with this column as a numeric with the goal of...

On my form I have a number of text boxes that the user fills in. Then he needs to click an icon to go to the next form. Sometimes users fill the form out completely but click the icon without pressing the "enter" key for the last text box in the form so that lastbit of information is not...

Works great ! Your the tops !!!! Thanks

I'd like the user to be able to fill in a test box and hide what is being typed - exactly like a password where astericks are shown instead of the real characters. Any ideas ?

Okay - this has got to be easy but ... Is there a way to change the background color & texture of a form without changing the font of all the text on it. The Autoformat feature trashes the text and UNDO doesn't apply. I'd like to try out a variety of backgrounds to see what I like best with...

any other ideas ?

I'm running Access 97 in a Windows 2000 envirnoment.

Thanks for your quick response. Auto resize & Auto Center are already set to NO, so this isn't it Any other suggestions ? Thanks.

Hi all, I posted a question on 10/8 about screen size. I implemented the recommendations and it appearred to work but ..... When I change back & forth from design view to form view, my forms were not returning to "full screen" instead, they were shifted around. The suggestion was that I...

I am trying to use an event procedure in the following way: On a form, I enter text into an unbound textbox then CLICK a "Continue" button that initiates the event. Now what I'd like to do is find a unique record in a table that has a field whose contents are equal to the text I typed in...

This is great advice - thanks!!!

I've been working with forms for a while now and haven't been able to solve the problem of having them resize and shift around the screen when I go from the design view to the form view. I've tried a number of options in the properties but nothing seems to work. Typically what happens is I try...

I'd like use an event procedure module to locate a record where the data is equal to the value of a variable (each record is unique). Once the record is found, I'd like to assign a variable to the contents of each of the other two fields in that record. It seems like this should be an easy...