Recent content by rodin

I can use the Move Method on the FORM, but I need the MSGBOXES (that are triggered by various actions of the user) to show on top of the form if I move the form around the screen.

Hi, I have a Form that is modal and popup, and which opens without the MS Access in the background. It is like a separate window (piece of program) that runs under Windows XP. If I move the Form on my screens (I have dual monitors) I would like that the messages that are triggered by various...

Hi, Bellow is a code that I found on this forum, and which works. Follow the steps described. **************************************** API: Manipulate Access Window Author(s) Dev Ashish (Q) How do I maximize or minimize the main Access Window from code? (A) Pass one of the...

Hi, I don't know where to write the code (combaining OMain and MoveSize) and actualy how this code will be. Do I have to create a function, or work from a procedure, and if this is the case, what procedure? Any hints? Thank you!

Hi, Thanks for your replay. I have thought about MoveSize command, but I don't know how to use it in this case. You can use the MoveSize action to move or resize the active window. I don't know how to make MS Access Window active, and have this command work when I double click on the *.mdb...

Hi, I would like to open the MS Access Window in a certain position and size. Somehow similar to open a form when using: - to set the position and size: Private Sub Form_Load() Form.Move Left:=11500, Top:=6500, Width:=7000, Height:=6000 End Sub I would like to open the MS Access Window...

Thank you! It is working.

Hi, I would like to run a simple select query, where the CRITERIA is based on the user choice. I have a form with a combo box, with a few choices, and a button that will trigger a macro with one query for now. I can store the choice in to a variable e.g. "town", using Microsoft VB code. How can...

Thank you guys!

Hi, I have a table in Excel, and when I import the table in Access, some records from a specific field shows #Num! after importing, even before I imported the table, I selected the entire field in Excel and I Formated all cells to text. The specific field hosts records in digit...

Thanks, rodin

Hi, I have a table with many records, and I would like to update for one of the fields, the same information as in the first record. Keep in mind that a group of records have the same attribute. The same problem is easy to solve in EXCEL just by dragging down the info from the above cell - in...