Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. christerhaard

    Print number of copies that is the numeric value of a field in a. . .

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

    subforms again

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

    what am I doing wrong?

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

    Printing all entrys in the database

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

    Printing all entrys in the database

    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 :)
  6. christerhaard

    calender resource booking

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

    The most FAQ here ?!

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

    Access Database close forms

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

    ERR message control

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

    Thanx Roy Help!! don´t want to show records if they are included . . .

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

    Need to control what is writen to the database

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

    Need to control what is writen to the database

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

    Need to control what is writen to the database

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

    Need to control what is writen to the database

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

    delicate problem

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

    delicate problem

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

    delicate problem

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

    delicate problem

    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 !!!! . . . . . :) /...
  19. christerhaard

    delicate problem

    Hi Paul, OK this does not work. . . I will try to explain. the serial number does what it's supposed to do. The print out does 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...
  20. christerhaard

    delicate problem

    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

Part and Inventory Search

Back
Top