Search results

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

It's not the line of code that's a problem but rather finding a way around this. I'm not sure if this is a bug or something I haven't discovered yet using IDBE hence why I am posting. There's no official forums for IDBE and the support emails only handle support calls. Anyway, I've found out...

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, Thanks for the reply. Sorry for my response as I got a bit confused. Anyway, all I did was requery the control itself in the main form and not the whole mainform. I can't recalc or refresh a textbox control but perhaps I am wrong? The control source of the textbox relates back to the...

er..which line? :P To be clearer in my sub form I have this : Private Sub Form_AfterUpdate() If IsNull(Me.intReqQty) = True Then Me.intReqQty.SetFocus End SubThis is the After Update event of the field "curUnitPrice" This is the control source of the textbox in the main form (if I don't...

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

Good advice, thanks. Move to SQL will lessen my headache ( I have some programming skill + basic SQL skills) but it would be a major move for the company due to lots of reasons - backups being one major headache. I will a look at the settings but just very confused why this is happening. Why...

edit: Just to clarify - I seem to be able to edit data from the FE, I just can't make any changes (Design View) to any tables in the BE.

I can schedule the maintenance some other time - that's not a problem. The problem is I am getting sproradic complains from users and from the screenshot it is because the code failed to run as the BE is locked. I am scratching my head why the code can't run as all it does is to query the BE...

Hi, Yes, at this time I was doing some maintenance on the BE hence why I have it open. The BE only has one form which shows me a summary of all the Backends I have and their versions. I have around 5 separate backends at the moment. However all of the FEs first do a query to the "Versions"...

I've just got sent this error from a user : "The expression On Open you entered as the event property setting produced the following error: The databse has been palced in a state by user "Admin" on machine XXXX that prevents it from being opened or locked" Background : The On Open code checks a...

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

This is almost what I have now but mine is much simpler. I just have a tickbox on the "master FE" that marks it as the Master copy so updates will skip running if this tick box is checked. This prevents situations of infinite update loops :D Thanks for the link though I will definitely have a...

Ah yes, I've done this but the "icons" only appear on top of forms etc. What I am on about is the actual icon you click on to start the database. AFAIK it's not possible to do this unless you use the shortcut method?

Yes, that is my concern too. I still have stubborn users who create shortcuts to the source file but I've created a code to check for that and terminates the program if it's run from source :) I'm just wondering if there's any elegant solution where users won't need to have 5-6 accde files on...

Great idea gemma! I was having some problems with the unmatched query but the handy Query Wizard in 2010 helped me through it :) I think I've got it working after trying out with some test data. What I did was have 2 tables - tblMain will be the table users will update and tblMainTemp will be a...