Search results for query: *

Hi AceMan, Currently I have got 6 values in combo box C. AI, AO, DI, DO, RTD, Thermistor. If AI or AO or RTD is selected, combo box D will have values from 1 - 8. IF DI or DO is selected, combo box D will have values from 1 - 32. If Thermistor is selected, values will be 1 - 16. These are...

Hi all. I have been asked to develop a form which has 4 combo boxes and the valuelist in each combo box will come based on the value selected in the previous combo boxes. e.g. Combo box B will have values based on value selected in combo box A, similarly combo box C will have values based on...

Hi Ken Many thanks for the input. Actually my question was more intended towards understanding why the after update event doesn't work with setvalue. As you yourself mentioned, its no rocket science to get around that. Your second answer, however helps a lot. And still if u see, only the...

Hi All. I have a form wherein based on changes to certain fields (any/all of them), I want to change values to other fields. What I have done is that I have written a macro that automatically updates a flag field as soon as any of the required field is changed. As soon as the flag field is...

I agree with you, Willir and that is what I did. I wrote a custom function and then called it in the On Current event property of the form and it worked. Tks for your input. Cheers.

Hi All, I have a macro that basically checks for certain values in a textbox on the form and based on that hides or displays a button. It works very well as a macro, but then I used Access' facility to convert from Macro to VBA, it generated the code and when I replaced the macro with the...

Thanks Roy and PHV. The link is excellent. Regards.

Hi All, Recently I read that when a database is split, it would make sense to avoid domain aggregate functions as much as possible since they slow the performance of reports and forms. I have a similar condition in my database, which is split into FE and BE and I am using a lot of DLookup()...

Hi FaeryFyrre and all, I am shocked. I followed Faer's suggestion of linking the images rather than embedding them and then compacted the database. To my utter surprise and joy, the database FE went from 260 MB to 17.4MB. That's amazing!!! Thanks a ton guys. It really helped me. Regards.

Hi LittleSmudge, Yes, there are no other tables directly in the FE anymore. There is just 1 table that holds the version information. I have done that for convinience purpose. Each time the client loads up the FE, it will check whether the client FE version is similar to the FE version on...

I did as instructed with "/decompile" option. It worked this time, but did not give any message of any sort. Once database opened up that way, I compacted it and then again Compiled it by going in the VB editor and choosing "Debug"-->"Compile Filename.mdb" But all the changes it gives me is...

Hi Faer. Here is my object count. Forms: 141 Queries: 389 Reports: 105 Macros: 118 I am using Access 2002 Version. And I also tried that uncompile suggestion. However, Access comes up with an error saying "The command line option you used to start contains an option that MS Access does not...

Many thanks to all for taking time to answer my query and providing valuable guidance. Much appreciated. Fair, sorry, used the wrong word "copied". I did import all the objects in another blank database, but size turned out to be the same. I would appreciate any more suggestions here. I was...

Hi Faer & Willir. Thanks for the advice. Faer, I tried doing what you suggested to me regarding importing objects in blank database, but there seems to be no change in FE file size. I copied over all the linked tables, forms, reports, queries and macros. That's all the stuff I am supposed to...

Hi All. I recently deployed a BE-FE version of a new Access Database in my firm, after restructuring the old one which was just a standalone mdb file. We have a normal 100Mbps LAN. Its recently deployed and so far it seems to work fine. However, now my firm wants me to try out and deploy the...

BNPMike, Thanks for your comments. However, when you say "adequate technology" (foxpro and Access), I think you need to have a close look. Yes they are adequate but not all the places. Constantly growing database will eventually lead problems with Access and FoxPro. That is what I am facing...

Hi All, Tks for the reply. Sleipnir, I did some research and found that VB can do the same thing as well. You can send a string across to mysql, whihc will contain the sql query, and that query will be processed on mysql side. So VB does have support of "pass-through" query (I dont know what...

Hi All. Currently my organization is undergoing restructuring of existing databases. Previously, certain applications were made using FoxPro and other applications were using MS Access. What i am planning to do is migrate everything to mysql, using it as backend. Now my problem is regarding...

Rest assured Jimoo, It wont be Access that is for sure. Access doesn't have that capability to handle such huge data. Frontend may be in Access, since many forms and reports are already made in Access, so to save time, I might use Access frontend, but backend will be MySql OR foxpro. I will...

Hi All, Tks for taking the time to answer my questions. Currently in my organisation, we have a foxpro database going on. Works fine, but there is also another database like MS Access being used frequently. What my organisation wants, and that is y they hired me, is they want to centralise the...