Search results

Hi, I'm not really sure what your set up there is and what you actually trying to achieve with this, but yes there is a refresh method syntax. To refresh the current form (where your button is clicked on) you can try any of these: Me.Requery Me.Refresh Me.Repaint Me.requery is probably all...

Hi, what do you mean? I'm not understanding your request. The combobox is on the main form to make it possible for a user to make a selection to further see the details of the selection made. If the combobox would only show one value then there would not be any way for the user to select...

You're welcome. Glad I could assist. Good luck on future projects!

You're welcome. Glad I could assist. Good luck on future projects!

What do you mean?

There you go! Hi, sorry guys. Wasn't around yesterday...hope this will still help you! I fast put together a sample you should be able to use to figure out how to do this! HTH Good luck

You're welcome. Glad I could assist. Good luck on future projects!

Ah...ok! Mhh well you would need to do a count of how many times individual users have logged in. You can use Dcount to acomplish this. Then compare your results with each other and figure out which Dcount has the highest value. Then display that user based on these results. This might be a...

Hi, this is called cascading comboboxes. Search the forums as there should have been many discussions on this. You can use a distinct query to populate your first combobox to get distinct values and then use the cascading comboboxes method to filter down the selections. You can also look here...

Hi, base a form on the query and display the results there. Your users shouldn't really see the query itself rather then just the information displayed the way you want them to see it on a form. Then either requery the form after you run the query to reflect the changes (if the form is open all...

Looks a little too busy and unorganized for me, but I guess we can get used/adapt to anything if we want to ;)

Hi, how about taking a look here: http://office.microsoft.com/en-us/assistance/HA010345531033.aspx HTH Good luck

Hi, what do you want to achieve at the end? Query the last user who was recorded? Why would you use max on the username or computer name? I suggest not using last as it is inconsistent. Why don't you just add a datefield to the table and record the date and time the record was recorded and then...

Hi, maybe you can clarify a little more to what you want to do and what you have so far! Do you mean a short cut menu (mouse right click)? What do you want to do when? HTH Good luck

Hi, check out: http://www.mvps.org/access/api/api0060.htm HTH Good luck

Hi, check this: http://www.mvps.org/access/resources/downloads.htm#C Calculator form which you can use! I think it would be hard to integrate the windows calculator as you can't really control it programmatically. So either create your own one with code or use the above provided sample! HTH...

Hi, sounds like your db is corrupt! Did you try compact and repair (tools--database utilities...). Also did you try to import all objects into a new blank db? Take a look here: http://support.microsoft.com/kb/q182867/ and http://www.granite.ab.ca/access/corruption/symptoms.htm and...

Hi, you will need to use a method which can create HTML or RTF e-mails. Look at this sample (attached) I had put togethere a while back. HTH Good luck

Hi, print to pdf or snapshot! This way all formatting will stay the same as it is on the report! You can probably browse the forums for solutions on how to achieve both methods. To export as snapshot you need the snapshot viewer to be able to view the files! To export as pdf you need a pdf...

Hi, several methods you can do this with. First of all what list do you want to do to display your names! You can use a listbox or combobox so the user can make a selection. Use the combobox wizard to create a combo based on the key field in your record and the name field. You can format the...