Search results for query: *

Hello, I have this mostly down but was wondering if there was a primer or information on how what steps to take to create an access form that is like an application main form. That is acts as though it is not an access form but rather an application. I have trouble with the form still being...

I have Access apps that are deployed but we frequently image our machines. If I could implement the default System Short Date Format to MM/DD/YYYY from within access I would not have to do this on a per user basis whenever we image our machines. The image is a corporate build.

I was wondering if there is any way to change the Regional Options Short Date Format from within VBA for Access? Thanks, Lewis

Yes, I had not insured that the specific tab was selected? I was able to cut and paste it back onto the first tab. Thanks everyone for your help. This site ROCKS SO HARD! Just like MoJo JoJo would say!

I have an application with a tab control. I have placed a button on the first tab to preview a report. The button is appearing on the second tap of my TabCntl when I switch tabs. I do not know how this came about but how do I fix it? Thanks bunches as always!

That is what I have been thinking. I am going to take the code out of the Private-Sub and place it in a module on it's own so that there will not be any trouble accessing the Public variables. I would like to thank everyone for thier help!

Yes the public variables are only declared in the general section of the first module. The original module opens the custom dialog box, the data is entered, the box is closed and this is where the values are assigned to the public variables that should be able to display (msgbox) when the...

I have code running in a Private Sub where there are Public variables in the GENERAL section. The code runs and opens a custom dialog box that allows the user to enter data. When the dialog closes I want to pass the data to the variables in the original module. For the life of me I can't get...

I have a main report that I am using along with two sub reports to collect all the data. Main Report Group 1 Group 2 Detail 1 Detail 2 SubReportDetail 1 SubReportDetail 2 Group Footer 2 SubTotal SubTotal SubTotal SubTotal Group Footer 1 SubTotal SubTotal SubTotal...

I have a main form that is used to create a record and after insert the focus moves to the subform and I can add records associated to the parent form record. How can I put a button on my subform that will allow the user to start a new parent form record? This would mean that the user could...

I have a form that is the "Main" form for the application. I have a startup icon associated and works fine until I generate a report. I am hiding the "Main" form when the report opens and showing the "Main" form when the report closes. This way only one item is...

Thanks a bunch lameid! Your post worked beautifully and perfectly! As MoJo JoJo might say... "This Site Woks Soh Hod"!

Hello, I am running a timer event that takes the focus from the active control. I have the following code to determine the active control at the time the focus is taken away. ' Determine the name of the "Active" form at the time of the error. Dim getfrm As Form Dim...

Does anyone have a quick and dirty (or not) primer for taking an Access 2000 database and placing it in a multi-user environment. I have a Database that if fully functional, formally normalized, all the controls are programmed just the way I intended. The app is finished. How do I or what can...

Thanks to everyone for helping me with this. This forum is great and StarPassing get warm fuzzies and a well deserved "YOU ROCK"! Problem solved! Thanks all

Actually the options are set not to notify when runnig an action query. The message err.description appears because the append query is trying to append records that are already in the table (key violation). The records cannot be added beacase they would cause vioations in the primary key for...

The error is that the append query that I am running in VB cannot run, hence the 2501 error (RunSQL command stopped). the message I want to stop is associated with err.number 10510 and does not invoke the error handler? Thanks

Code is as follows: function test() on error goto trap code code code exit funtion trap: '''the default access err.description pops up here prior to '''hitting the "if" statement? if err.number = 2501 then msgbox(myerrormessage) endif

What I want to do is not have the default Microsoft Access error message (err.description) display. I would like to generate my own error message. When working in a sub routine for an event and error trapping say using the forms "OnError" event this is easy. I am writing a function...

I am working on an error handler in an Access 2000 function. I am fully capable of creating error handlers in private subs but I am having trouble with this error handler in a module function. When you are using the "OnError" sub on say a form you can identify the error, and use the...