Search results

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

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

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

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

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

Hi all. I have run into a problem wich I can't figure out how to fix. Background is Access 2010. I have made a splitted database system. Due to a perfomance problem over the network, I tried to compile the fornt end to a ACCDE file. I have used the new "menu system" for access 2010, with top...

Hello all! I have ran into a problem which I can't figure out why happening. Background: Access 2010, wide area corporate network. I have made a app which are splitted in a "front end" with everything except tables, and a "Back end" with all the tables. The "Back End" are 7 tables, all tables...

Hi all. I am writing a program on my own private version of Access 2010, which are in norwegian language. But the users of this program are using a (international) / US / UK version of the Access 2010. When they start using my program, serverel "windows" in the new menu system will not load...

Hello all. I am really stuck in a case which I think is easy for "fresh" eyes to se what I am doing wrong. I have a simple (!) opening of a table with the folowing statment: rsCable.Open "SELECT * FROM [Cable] WHERE [Cable!BundleID] = " & midBundle The error message (in norweigian) can be...

Hi. I have got a mysterious problem - at least it is a problem for me. I have a sql that print records based on a Date field, and the criteria is only: Not IsNull on this date field. But I would like to "empty" the date field in the table - just for avoid printing this records. In my...