Search results

Can you try the original 1, 2, 3 approach without the acDialog parameter just to see if that is causing the Maximize to fail?

Well it seems I managed to figure this one out. Putting =Environ("UserName") in the default value field for the textbox in the property sheet would not work no matter what I did so I made a standard code module with the following code: Public Function getWinUser() As String getWinUser =...

You're right, I forgot about the acDialog part which stops anymore code in the OnClick from running until the report is closed. So if you leave out the DoCmd.Maximize line from the Load event of the report it works fine?

That being said, according to Allen Browne, having the DoCmd.Maximize line in the Load event of the report shouldn't be a problem: http://bytes.com/topic/access/answers/211386-starting-form-maximized#post811177 Not sure about the MoveSize method.

I think vbaInet means to put your resize code after your OpenReport code like this: DoCmd.OpenReport "rptcurrent_openings", acViewReport, , , acDialog DoCmd.MoveSize 28000 DoCmd.Maximize Basically resize after the form has been completely opened. Note that the code in red is not correct, I...

Here is trick that I've used before that might help: You can enable/disable unbound controls on a line-by-line basis in Access 2010 on a continuous form using Conditional Formatting. The button will still be visible but it will be greyed out and not clickable. Let me know if this might be of...

Hello all, I am trying to set the default value of a textbox (for new records of course) to Environ("Username") by placing the following in the default value field in the textbox property sheet: =Environ("Username") When I go to a new record, my textbox is Null. I've tried with the equals...

Hmm, you are sure its null and not a zero-length string? That's the only thing I can think of.

OK, finally got it figured out. What I did was I kept the actual function I wanted to run in frmDataEntry's module (Function name: ReserveDrawing), then I created a standard module and inside that module I created a public function called modReserveDrawing and then I changed.OnAction property...

OK, I think I am starting to understand now, thank you for all your help so far. What I need to do then is change the .OnAction property of my menu control to a full reference. Right now it is: cmbControl.OnAction = "=ReserveDrawing()" And if I understand correctly, it needs to be something...

So how do I put a full reference to the ReserveDrawing() function in the .OnAction property of my right-click menu button? And can I do a full external reference to function in a form's code module even if that form's .IsLoaded property = False? I have done full reference to form controls but...

Hello all, I have a form called frmDataEntry that is used for entering data. I also have a navigation form called frmNavigation that has a series of navigation buttons (using the new Access 2010 nagivation controls) and a navigation subform control. When you click on one of the navigation...

Thank you all kindly for your responses. Just to clarify, I'm using bound forms for my input/update forms and the tables I'm using reside on SQL Server and are setup as linked tables inside my application. I'm wondering how to implement record locking in this scenario? I've since discovered...

I've also had major trouble in the past with error using shared access files (before I split into front-end and back-end) when some users had Office 2010 Service Pack 1 and others didn't. If the .accdb was opened and then saved on a computer that had SP1, it would give this exact error message...

Hello all, I am working with a Access file that has linked tables (previously local tables that have since been upsized) that reside on SQL Server. Each user gets their own copy of the Access front-end. If I'm not using DAO and I'm just using built-in form functionality for updating and...

So you just need to add a record to the subform using a button on the main form? Make a button and call it say, btnNew then in the On Click event for the button, use the following code as a template: With Me.M_tab_registrazioni.Form.RecordsetClone .AddNew...

Do you have the state holiday data in another table? Where will you be pulling the by-state holiday data?

Using the debugger can you verify that the combo box is not getting the full string? Is it possible that it's getting the full string but its not being displayed due to some formatting issue? Also, is it possible there is a character limit on the control source for the combo box?

Ah, clever, thanks for the explanation. For the DLookup, using that same trick doesn't really help you though because the DLookup is still going to return a null value right?

Awesome, glad to hear :)