Search results

Thanks Paul, Minor brain fart but all is well again. Forgot all about that. Now I close the calling form, run the restore and reopen the calling form. Good to get a nudge in the right direction. Regards Brett

I have a little backup utility that works perfectly if run all by itself however when called from within the main program it errors during the restore proceedure. At that time it is trying to delete the existing tables and that is where the error occurs. error 3211. The database engine could...

My suggestion re the LANDesk control is DONT. A third party control is nothing but trouble. namliam had the basics for an answer for me. Dim X As Integer Debug.Print Time() For X = -4 To 4 Debug.Print Format(CInt(Time() / #12:15:00 AM#) * #12:15:00 AM# + X * #12:15:00 AM#...

Hi again guys, I am using the TransferDatabase acExport/acImport function to backup and restore my table data. Does anyone have any suggestions re a reasonably simple function to act as acCompare - which obviously doesn't exist (but should :rolleyes:) - so I can verify that good things...

I saw that a few days ago but as I'd really prefer not to split my DB I decided not to persue it. Thanks for the thought though. Regards Brett

I have an update for you George. First off, I have found that there is a small issue with tabbed controls, or possibly simply an error in the way I am coding (most probably the latter). I am setting the accessibility and sometimes visibility of lots of controls. These controls are on 2...

Thanks George, Both the FE and BE have been moved to a test directory on my local system. It is a little better but still not a patch on having the lot in one MDE on the server. Still takes about 7 secs to load main screen and then about 1/4 sec for each page update. There are only about 30...

Oh dear... Issues have arisen... Just split the DB. It currently is not large at all. About 50 records with about 30 fields in each. Version is 2003. Windows is XP Pro fully patched. Office is SP2. Prior to the split everything was displaying wonderfully. The records are loaded and checked...

Just to make sure I follow the steps... Split the MDB into FE and BE. Make COPIES. Convert the BE to an MDE. Re-link all the tables in the BE-MDE to the FE-MDB. Convert the FE to an MDE. Is is worth putting a password on the BE-MDE as well? ps. The scales have been weighted in your favour.

so... is there any issues with using a split system and MDE format?

I have a general question for advice. When making a custom application for distribution, what is the best way of resolving possible update issues that might arise in the source code? Should one split the application into FE and BE or is there a simple way of changing a piece of code that is...

I had previously offered a user on this forum a piece of code I have been using to force Access to start in a particular window location and in a specific sized window. It works marvelously... 99% of the time. Sometime however, after ALT-TABing to another application, Access has decided to...

Hi Ray, The subform uses a query filter to look up data based on a combobox. Change the combobox and the subform changes. Some of the controls on the subform are initially switched off, dependant on what data is actually available. I needed to look at the current record and automatically set...

When a subform (which is attached to a query) is programatically requeried, what events are actually triggered on that subform? I am wanting to update the control accessability on record change of a subform (dependant on control content). I have the routine to update the info, just need the...

Thanks for the uplift. It is appreciated. Regards Brett.

I have not had any previous replys from you. Do you have the right thread?

Perfect solution khawar. The query has now been "massaged" and fits my requirement exactly. Thanks for your help. The scales have been weighted in your favour. Brett

Hi guys, I would like to be able to manipulate data in a subform based on info in two controls on the main form. The Main form is unlinked. The two controls allow the selection of names and dates. The subform is based on controls referencing a table laid out as follows... I would like...

WinDancer, The code I previously posted will put your main form in the RIGHT place with an EXACT form size EVERY time.

Why go to the trouble of using a form? A simple ComboBox would do the trick. And the base form is always current. Brett