Search results for query: *

How du I print number of copies of a report that is the numeric value of a field in a table? This is how i print one copy: stDocName = "Start_line_access" DoCmd.OpenReport stDocName, acNormal, "Start_line_access_filter" thanx. . .

Its me again, One form with two subforms, "A" & "B" "A" is based on information from the database that form "B" edits. I would like to change entrys in the database form witch I do in form "B" and when i setfocus back to "A" I would like to "refresh" the information, so I get the new...

Hi Gurus, Description Form with two subforms the subforms are "A" and "B" by double_click a field in "A" I want to set focus at subform "B" and search and display the same artikle that I clicked on in "A", yes they are linked to the same database. This is what I do today, but with this I open...

SELECT Resultat.* FROM Resultat; No filters are used anywhere. . .

This is the most silly. . . . For some reason I cant get the report to print all of the records in the database it only prints the first entry. My brain has stoped, I think I have solved this before but I can't find my own solution :)

Hi Guys, I'm starting a new webb project. I would like to book resources via a calender. Does anyone have a calender for Webb and asp to access.

Hi guys, have a numeric field have a report Would like the report to print as many copies as the value of the numeric field. to print i use vb code: If MyString = "yes" Then DocName = "xxx" DoCmd.OpenReport DocName, acNormal, "xxx_filter" End If Have a nice easter. . ...

Hi, will this help you? If KeyCode = vbKeyEscape Then DoCmd.Close

Me again! I Have two indexes one is "primary" index and the other is a secondary index. When the user trys to input duplicate data or some other forbiden input I get an err message from the database. But the problem is it want tell me witch index is sending the err message. I would...

Hi Guys, Happy new year to all of you! RoyVidar helped me on part of my problem with this before and I solved the initial problem but here is the next one. Hey Roy you did help me!! What you said about indexes made me check it out closer and I ended solving the problem with primary and...

Hi again, Thanx Roy! I will try what U sugest. I did not think that it was possible to set these conditions at the table level. You are absolutly correct about the spelling but every driver has a licens number so this will be used to make sure there are no double booking. And yes it is...

Hi RoyVidar, That does not help me at all sorry. . .

Thanx for your input Ken! Helps me a little. . . Problem is that I would like to set conditions for more info in other fields too. I didn´t describe that in my first entry, sorry. . . But I would like to set conditions fore one more field lets say that "Gus" can have different...

Hi Guys, I have a database that has all its info linked to it from other databases (except the ID ofc). Now I would like to control what is written to it. Example: first_name field is "gus" second_name field is "swansson" ok this is saved to the table Now I dont want my...

Paul and Cosmo, You two are great!!!!! Just tell me were to send a case of beer and I will deliver. . . It works great now and all because of you guy's. If you guys figure something out so that I can get my article rows back in sorting order too I would realy appreciate it. . ...

GREAT !!!!!!!! Has this site been down?? havent been able to get in. Works better now. . . But there seems to be a problem when trying to print more than 9 build sheets 1 - 9 works fine 10 generates &quot;>&quot; 11 &quot;=&quot; 12 &quot;<&quot; and so on. on the serial number that is. 1234->...

Hi Cosmo, No one page for every serial number like: page 1 = 1234-1 page 2 = 1234-2 page 3 = 1234-3 and so on. . . I didn't understand what you ment with the reply before. The problem for me is that I have a swedish version of access installed (stupid of me) so I could not figure out what...

Hi Cosmo, The serial number is not the problem, it works fine. The problem is like I explain above that I'm not printing lables. Simplified I need the field &quot;Antal_Produkter&quot; value to set the number of pages to print not lables. Thanx for all the help HELP HELP !!!! . . . . . :) /...

...almost. The value i have in &quot;antal_produkter&quot; for ex. 4 will print 4 build sheets (four papers) but the rows of articles (products) are * 4 on the same paper. What I would like is to have it print 4 copys of buildsheet and ser# 1234-1 / 1234-2 and so on But the serial number bit...

Hi Paul, OK me big nerd. . . I figured out the serialnumber my misstake please FORGET IT. . . :) it displays 1234-c dont know why but never mind. Other problem still there. / Chris