Recent content by christerhaard

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