Recent content by jonathanchye

Actually it could impact how I update my apps. Currently I just overwrite the FE file on the shared folder. There is a switchboard app which first checks local version and server version and copy over if needed. If the Citrix applications launches the FE on the server I can't...

I currently have my Access database split into FE/BE. The BE is on a network shared folder while the FE gets copied locally onto users' CITRIX documents folder. This so far works nicely. However recently our IT vendor showed me the "Applications" function of CITRIX whereby instead of launching...

Hmm, finally some break through. I noticed if I removed the recordsource the report loads much faster! The record source is a query and if I open the query independently it loads quick too. Mystery deepens...

I've tried using the code below to open: Docmd.openreport "REPORT", acViewPreview ,, , acHidden Reports!REPORT.Report.visible = false it opens but takes forever to render through all the records so the DB hangs. The detail section of my report has the bulk of the controls (around 300). The...

Wrote function to count controls in the report and there's 335 controls... I've done all I can to optimise the recordsource, no grouping/sorting but can't really remove any controls due to design. Any other tips to speed up loading this report?

I have a report which unfortunately has a lot of controls. It takes around 15 seconds to open in Print Preview. What I'm trying to do is to open the report and set the visible property to false when the DB loads. When the user wants to print an order the report then finds the record and is...

Apologies - I should've gone into more details. First, I am planning to run the SQL Server on Hyper-V (virtual) running Server 2012 and SQL 2012. (If doesn't meet budget I might consider 2008 R2). What are the thoughts on this? Secondly, I believe the "Attachment" field in MS Access 2010 is...

Due to recent changes in the company I'm required to convert/migrate the backends of my MS Access 2010 databases to SQL. I've experimented with using the built in tool but seem to have some problems with some of my forms and queries. I guess it would be the stricter restrictions of SQL servers...

Yes, normally a relog will help but this time it took a full reboot of his laptop. I suspect it's because he had to use the VPN as well which could've caused the issue. Obviously it looks very bad on my systems as he was saying other programs works fine so I had to try my best and explain about...

I have a very perplexing problem with certain users in a Citrix environment and hopefully someone could shed some light. First a background, my databases are built using MS Access 2010 with a split FE/BE structure. The BE is stored on a network drive while the FE is copied over to the user's...

You should have a table for users. Something simple like txtUsername, txtPassword and txtAccessLevel. You then create a module with a function like GetAccessLevel. Finally on each control in your form you can then use the form's OnLoad event. As a pseudocode for OnLoad, if GetAccessLevel =...

Designing another database and ran into the same problem. I've tried your method but the changes will not last if I reboot PC or update client. Same really as Columnwidth = -2 doesn't work on split forms :( I really don't want to create subform just to resize as I want to keep this as simple...

I find that this problem can be regularly replicated for Datasheet forms and if the bound control has an After Update event attached. If the bound control has no even attached the Date Picker works! Frustrating...

Argh! Have this issue again. It was working fine and just stopped working out of the blue! Once the date picker stop working it won't work again :( One thing I've noticed that the problem is only when the date picker is in a subform. I've opened the subform on it's own and the date picker...

Good point thanks :) I was told there will ever only be 2 prices for this table but it's best to build for something to allow more :)