Search results

Bob, 1) No 2) Yes, a lot of them 3) Let me think. Delete a lot? NO. Appending a lot of data? Yes! So, how should i optimize or rewrite to decrease geometric growth in size and bloating? thanks! flyinghippo99

Hi All, So, I've built this fancy db app with nice frontend and it does a bunch of CRUD operations , etc. etc. What I've noticed is that the db gets FAT and BLOATED very quickly. I tested it by viewing the data in various slices and the db grows by 2-3x in matter of minutes. If I continue...

bob, thanks! I figured it out which coincidentally is the same as your 2nd suggestion. In Access 2007, they don't have the number code anymore. At least I don't see it. "Background Dark Header" numeric code can be found by using the VBA editor and selecting the control(label in this case) and...

Missinglinq & boblarson: Thanks! I did not realize that BackColor default is Transparent. I set it to 1. So, now it's visible. However, I'm still looking for the numeric code for the color I'm interested it. Where can I find a color table lookup? Or how can I calculate those values myself...

Hey Guys, So, I got a label created from using CreateControl. Let's call the label ctl. I can set the Name, FontBold, Caption, etc. just fine. However, I'm running to a problem setting the BackColor. I've did a search on MSDN and tried their examples as well as the examples on this forum and...

Hi Bob & Steve - Thanks for the suggestion. I was thinking of just deleting it each time it's run. So, I'm still keeping that table in the front-end. Is that advisable? Hmm... On a separate note, I have an Access 2007 combo box question. So, I have this form and there's a combo box whose...

It WORKS! Whoohoo! Thanks Bob!

Cool. I'm resplitter to the network drive now... Now, how would it work if I want SQL Server to be the BE? Would I have to manually import the tables into SS(or thru some scripting since there are hundreds of tables)? Then each embedded SQL code I have in my VBA modules I have to specify the...

Bob, Cool! Let me try this. Now, does this mean this will solve my locking issue with ViewDataOrdered table? :)

OK. Makes sense. But it put my "ViewDataOrdered" table to the BE. I saw that in the Linked Table Manager. hehe. So, I should rewrite my code from the click event to make it write to the FE? And how easy it to move things back and forth if you don't agree with the Splitter autosplitting choices...

Bob, thx for the clarifications. I just did the Database Splitter on Access 2007. But ironically, the BE is SMALLER than the FE? I don't think the auto-splitter process did it right. So, what now? Does this mean I have manually delete and move the tables/queries I want from FE to BE and not...

Mr B & Bob, thank you! So you guys are saying the only way around this is to split the db to FE & BE? And then the FE would store the ViewDataOrdered table which is unique to each individual users selection. OK. It makes sense if that's the only way to go. I understand how this would work if...

Hi All, I just ran across this Access World Forums. Looks like a great resource. I have some questions about design & implementation to handle concurrency in Access 2007. And I did a search on the keyword concurrency in the forums. From what I've read and other resources(books,etc.), it seems...