Search results

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...

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...

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...

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...

How would you design this table? (Price list lookup) I have to design a price list table which is currently done in Excel. The table looks like this : [Headers] Product Group | Layers | (this are quantity bands) 0-100 | 101-500 | 501-1000| etc Test1 | 2 | £10(normal)...

I'm slightly confused at what is happening so hopefully something could offer some advice... I have a subform in datasheet view and a button on the main form which is used to clear all filters in the subform. The button's OnClick event calls a procedure on the subform. The procedure in the...

I have a front/back end database and have a few "read only" queries. I've checked their settings and they are all set to open as "Snapshot" and also record locking set to "No Locks". I noticed that when I open this query on my frontend, a record locking file is created on the backend thus...

I am thinking of implementing barcode scanning in one of my Access 2010 databases. It currently prints out barcodes using font but I would like to improve on that further. 1) Barcode Scanners Am I right in saying that these devices should work the same as any HID devices? I.E once scanned it...

I am currently testing upgrading our database backends to SQL 2012 express. It's all still very early stages but I would very much like to lear more about this. I would like to say I am fairly proficient with MS Access (07/2010) and also have good enough grasps of programming (C/C++ and VBA)...

Hi all, I have a split MS Access 2010 databases at the moment. I've managed to "convert" the backend to the SQL Express database using the built in SQL Upsize Wizard. Instead of chossing the option to create ADP file I've selected the link option. Everything is fine bar some...

I have a front end that is opened virtually 24/7. One of the forms in the front end links into a table of another backend (let's call this Backend B). I've made sure the underlining queries is "Snapshot" and also made sure the form does not allow data entry or any editing. I've also made sure...

I have a switchboard ACCDE file which in turn opens another database (front end) on users machine. It currently sort of works but I have problems when the database needs an update. I am using bob larson's updateFE code to update my front ends. I suspect the problem is with the focus of which...

Hi all, I've been using IDBE Ribbon Creator lately to create customised ribbons and I must say it is great and easy to learn/use. I've came across a small obstacle regarding conceptual tabs. It seems that if I have any subform or form in datasheet view, whatever Ribbon that is assigned to that...

Hi all, Have a very peculiar problem that I hope someone can help out... I have a subform that is in Datasheet view. If I open this subform on it's own, the Date Picker works for the Date field. However, if I open the main form with the subform on it, the date picker doesn't work? Nothing...

Hi all, Have a very weird problem. I have a form with a subform that is linked via a one-to-many relationship. On my main form I have a few textboxes with the control source set to DSum the prices on the subform. My subform is set in datasheet view. I've created an "After Update" event in...

Sorry if this is posted before but I thought I will contribute back after the awesome help I've got here :) What I have is a Compact & Repair code specifically for split backends. I have tested this to be working with .accdb files and I am pretty sure it will be easy to modify to accomdate .mdb...

Hi all, I am having a very frustrating problem that is now more noticable as my users increases. I am running MS Access 2010 with all my backends split into FE/BE format. The BE is stored on a network shared drive where all users (should) have full rights. The FE is saved locally on each users...

Hi all, Just want to know opinions on this matter. Previously I have my FE sitting on a network share and users create a shortcut to this file. This has the following benefits : Small filesize/footprint on user PC Customisable icons (:P) Possibility of just having one shortcut for all...

Hi all! I have been tasked to design something which I currently think is a challenge to me so hopefully someone could give some pointers :) What I have now is an MS Access 2010 file which generates a report by querying data from an SQL server. I have a make table query in this db which...

Hi all, Pretty new to this side of things in Excel so I hope someone could help me out. We have an old spread sheet where we populate job information manually. However now that we've moved onto a database based system, there is no need to populate (most) of the field automatically. The...