Adam Tippelt
Last Activity: Jul 21 '11, 10:08 AM
Joined: Nov 29 '10
Location:
-
Ah sorry you can probably ignore this one, I've found that I can add them as buttons on the quick access bar, which will suffice for now. -
How to export an Access 2007 report to Excel via VBA
I know there's a few topics on the forums about this already, but none of them seem to have a definitive answer, and it's unclear if they're for 2003 or 2007.
I've got a report in Access 2007 that I would like to be able to export to Excel using VBA.
The ribbon already has an option to export to Excel, which does everything I want, but the ribbon gets disabled as one of my security protocols, so the users are blocked from using... -
Assuming that your ID fields are integers (as is the norm for ID fields), you've wrapped them in single quotes when this isn't required - this is only needed for string based fields.
Try this:
...Code:Forms!frmVehicleDetails!State.Value = DLookup("[State]", "[tblSituation]", "[SituationID]=" & [Forms]![frmVehicleDetails]![Situation] & " AND " & "[QuoteID]=" &Leave a comment:
-
Basically Microsoft has done for Access 2007 what browsers have done to internet pages - the windows now have tabs to allow the user to easily switch between opened forms within the same Access window, so multiple forms can be open and accessed at once.
Tabs can however be turned off in the database settings if you want to hide them from users.Leave a comment:
-
Np Mihail, thanks anyway.
Access seems to have a mind of its own when it comes to resizing and moving the pop up forms.Leave a comment:
-
By design time do you mean design view?
The form in question is a continuous form so size cannot be determined in design view. I've resized a continuous form before but it was trial and error and I can't remember how I did it.
I've tried resizing it in form view then saving immediately after - sometimes this remembers it when you go between design/form view, but as soon as the form is closed it loses the size again.Leave a comment:
-
How to resize a Popup Form
This is possibly one of the most infuriating problems I've come across - how to permenantly resize a popup form.
I cannot for the life of me work out how to resize a popup form in a way that it always opens as that size. No matter what I change or turn off, it keeps reverting back to the size it started. I've tried turning off things like auto resize, changing the size in the Form_Open event, and yet nothing works.
For... -
Ah right, I was under the assumption that it was 2007.
I do not know 2003 very well, but I imagine the options exist somewhere on 2003 to disable whatever 2003's equivalent is of the navigation pane.
Try looking under Tools -> Options or similar areas, or perhaps someone with knowledge of 2003 can step in.Leave a comment:
-
Are you talking about users being able to use the Navigation Pane to access other forms?
If this is the case, go to:
File (Office Button) -> Access Options -> Current Database -> Navigation
and untick the Display Navigation Pane option. You will need to restart the application for it to take effect, but it will mean the only way to gain access to the menu is by logging in.
This...Leave a comment:
-
I imagine you got that error because ADezii was using 'Custom Menu' as the variable name which you should have replaced with the name of your own menu. As he said it iss semi-suedo it wouldn't just run as is.
Is your login form separate to the 'main menu' form, or are they the same form with the menu hidden until valid login?
I have a setup whereby I use a login form which then closes and opens the main menu. I use the...Leave a comment:
-
Ah just spotted your example - that's pretty much what I'd ended up doing. Seems to work well enough.
Thanks.
Adam.Leave a comment:
-
Ah. I've just realised that I think I've been thinking of something else when you've all been saying Calendar control...I always forget about ActiveX controls...
Yes maybe that would be a suitable replacement. I'll see how that works.
Cheers.
Adam.Leave a comment:
-
Unfortunately your suggestion does not quite work NeoPa. The calendar icon only appears when you enter the textbox (and subsequently disappears when you exit the textbox), so to disable the textbox's format On Entry would be to remove that functionality completely.
I tried applying a similar sort of strategy to things like the Keydown event, and while this works the problem with that strategy is the calendar icon doesn't seem to disappear,...Leave a comment:
-
I am Mihail - that's exactly what my own code uses. But the problem is that the system has it's own built in error/messagebox for textboxes formatted for dates. I'm trying to stop this firing so that it'll display my own message instead.Leave a comment:
-
@Pod can you actually reference the ActiveX Calendar in the way you're suggesting? I can understand that working from a form-build calendar, but I was hoping to avoid adding one of them in.Leave a comment:
-
Doesn't ADezii's article work on the basis that the error has a run time code that you use to distinguish what should be done for each error? As the 'error' I have doesn't have a code, surely this wouldn't work? (Unless it has a code but doesn't display it?)
Yes...yes it was. :)
I think I completely misread that post - I thought you were talking about removing the Format option completely, but you're talking about temporarily....Leave a comment:
-
Mmm the control-only idea could work, but how could I restrict access and still have the calendar functional? Locking the textbox stops user from editing it themselves, but it also stops the calendar from updating the value. And obviously setting the Enabled value to no will stop the users from entering the field at all, which means the calendar won't appear.Leave a comment:
-
All my procedures already use error trapping. However this is not an 'error' in the sense that the coding is triggering a run time problem with a code. It's caused by the data inputted, not the design, and shows just a standard messagebox with an OK button, just informing the user that the value isn't valid....Leave a comment:
-
Mmm yeah I don't think that approach would work - that seems to be based around using the run time error codes, whereas this doesn't have one.
The reason I used format was because it seems to be the cleanest way to get a calendar for the text boxes, unless there's another way? (aside from building a calendar form)Leave a comment:
-
Adam Tippelt started a topic How to replace "the value you entered isn't valid" with a custom messagein AccessHow to replace "the value you entered isn't valid" with a custom message
Is it possible to stop this message from appearing?
I've got a couple of unbound textboxes that I want to use as filters for start date/end date type parameters. I wanted to use the build-in calendar option to let users select a date (as well as being able to type it in) so I set the format of the text boxes to Short Date. However in doing this it means that this "invalid value" message now pops up when the date format is...
No activity results to display
Leave a comment: