Search results

Hi Missinglinq. Thank You very much for your solution! It work perfectly - just the way I needed! And as SmallTime wrote, I will go through the whole app and check out all use of the IsNull function used (and there are several...) Regards,

Hi all. I just can't find soultion for the following prooblm: On the table - field proprties, I have set on of the field to be Required and not to alow Zero Length values. On the form, when skipping entering a value in the bound field, I get the standard system error message, but I would like...

Thank you for your reply, Guus2005 The soultion was however not a big deal, when I understand where to look.. What I did, after a normal "compact & repair" was; - In VBA Editor for the app, I select Debug and Compile Appname. Repair foult/comment if any. - Then I create a shortcut on my...

Hi there, HiTechCoach Thank you! This is an absolute perfect solution! It's exactly what I am looking for. Have a nice day. Regards

Hi all. In my app I have several reports, and some labels. My colleges which are running my app does all want to be able to select a separate printer for one of the labels, or the posibilty to select a specific printer / tray for some of the reports/labels. What I need is the posibility to...

Thanks!! I haven't seen this. It works absolute perfect! Regards

Hi all. I have a report, and one of the fields are showing a Yes or No value. I am trying to let the texbox's background color changing from eg. light red with the value No and light green with a value Yes in the field. Is this possible, if so - how can I fix this? Regards.

Hi Yes, collecting all in one report, grouping and the use of pagebrake may solve it. But splitting it up like i did works so fine for creating complete stand-alone report fir each "invocie". Back to studing reports...

Hi all. I have a problem which I cant't undersetand. I have something I would call a nesting report; First - I print a "froontpage" for one customer. Second, - I print all "invoices" for this customer. Next, a frontpage for the next customer, and then all invoicec for this customer. The code...

Hi all. I am "develeooping" an app, which have becam an app with several forms, lots of reports, querys. It's based on a Front-end and Back-end system. The front end have grown to a 2,6MB size after comapct and repair. My company are using lots of HP laptops, and today i think there are about...

Hi all. I have a problem which I hope I can get some help.. I have a ComboBox which select a value from a huge list (up to 250 - 300 records). When a value are selected, a releated subform updates. Just like a Invoice system. The CombBox have two coumns; (0)= ID number, and (1)= ID Text. When...

Hi again Thank you, Larson. The /decompile was an new experience for me. I did not fined any timer, but after a second run with the /decompile, the vba for this app seems to act normaly again. Thanks again! Regards.

Yepp, an older backup of the app do not create this behavior. So, some place in the code or somwhere in the app, there are something who creates this problem. I disabled the timer code in the splash form, without any changes... Regards.

Yes I have a small timer on a splash screen when the app starts. But - first - this timer have been in the app since last november. Second - the app runs fine - the problem is the editor in VBA which creates this problem. The problem started just a few days ago, and may there is something in...

Hi all. Resently, when working with a app createt in access 2010, I have seen that the VBA make som irritating "noise" and errors; When starting a line, the first word will be displayed i red, until the line have at least two - three words. When writing like 'Dim Variable As Text' the VBA...

Thanks for replay. There must be something I am missing. I tried the code in both the main form and one of the subform (one of the form in navigationforms), but the only thing happes, is the popup from Access it self stating the Alt-r is an Office key sequence.. (in norewegian - i dont know...

Hi all. Access 2010 with the navigation forms in use. On all textboxes I have the Keypressed event. But what I want, is a routine for the wole form. E.g.: When a form opens, and a user press Alt-R, then a contol.visible = true. If not, it stays unvisible. How do I trap this for a whole form...

Well, If I was talking about storeing values in tables I would be agree with you. I was talking about referencing fields in onther window/forms. Wich the two other replies where very helpfull. I hope this will answer your "Why?" Regards,

Hi All. While waiting for the big evening... I have a little problem with adressing a field in a another form; I have a NavigationForm which is the main form with the new Access 2010 navigation buttons. On the TopText Form area I have two fields; Field1 and Field2. One of this button...

Hi all. I have run into something I would like to call a problem. First, I am very fresh on updating Access to SQL, I and I am just starting study the case. I am using Access 2010. The app are based on the new "web - lookalike" menu system. I am using MS SQL Server Express 2008 R2. When...