Search results

Ah....fmName is a global variable in that case you must do it differently. I don't have my work PC infront of me at the moment but try something like this : Declare fmName as Form instead of String in the global module. You then have to initialise your global variable. Use the form's OnLoad...

Good code :) However when using recordsets it's good practice to close when done. So something like rs.close set rs = nothing db.close set db = nothing when closing database or form.

Hmm... if there's no network and not even internet connection how do you plan to update the front end on client PC when needed? Onsite visit?

Glad I could be of assistance :)

It is really easy to split a database if you are using AC 2010 but not so sure about 2003 as I've never used it much. I would think of an approach to create an MDB file with links to tables (backend) and leave all the forms on the client (file you want to update)

This is most probably because some of the results are invalid (null) hence cannot be evaluated against your criteria. One thing to try is to add NZ on each field. Days App to UW Receipt: IIf(Nz([CDF90 DATE- CREDIT RECEIVED BY UW],0)-Nz([B_Inter_Date],0)<0,Null,Nz([CDF90 DATE- CREDIT RECEIVED...

I do apologise. Initially I read your reply as targetted towards my response. Reading OP's initial post made me question his intentions. He seems to want data stored locally while still having the function to send data to a main server.

In that case try changing query criteria to : Is Not Null AND <=365

Try : Forms!frmName.Setfocus (this should set focus to frmName) If you want to set focus to a control on that form try : Forms!frmName.Form.ControlName.Setfocus

Instead of the NULL in the expression try using 0 (zero).

If you bothered to read his post (or have proper English comprehension) you will notice the OP mentioned that "each user has their own backend". Yes, split databases have their benefits but sometimes you need to analyse the requirements and not just blindly advocate it. And to actually provide...

Right, the only difference between the form that's working and not is that in the form that's not working I have the subforms in a tab control. Will tab control be the issue here?

Anyone using MS Access 2010 managed to get filters saved in Datasheet view at all? Basically all I want to do is for the subform to remember the user's last saved filters. I have inserted debug.print statements during the forms load and close events. From observation the filter gets cleared...

From what I understand this is a pure standalone single user database. You simply need to gauge if there is a need for splitting in the first place. I reckon it will be easier as a single database but with "Compact On Close" selected. Keep in mind though everytime you update the front end the...

Hi, thanks for the reply. I've thought about doing that but in some cases I still want users to "remember" the filters. Basically I want the filter to be saved everytime it's changed. I might have missed something here as right now I can't even save the filters anymore o.0

Right... this is getting weird. I've manually cleared the filter in the subform (Design View > Property Sheet > Data tab > Filter and saved the subform. Now it won't remember the last filters!

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

Hi, Sorry I should've phrased my question better. I have a front end that I would only like to use as a view only platform. I have this front end displaying some data from a linked table via query. I made sure any record locking is off, query "opens" table as snapshot mode and also disallow any...

Well done a lot of research on the barcode part and because of the EAN/UCC 128 barcode requirements it's not as easy as just using a barcode font for the string I generate... There's some kind of algorithm for UCC 128 which makes the barcode much more compact. I've found some free examples but...

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