Search results

ppoole16: The link is not working, :confused: Let me know when you fix it. Regards Estuardo

Rich, You're right, i made i misktake, it should be on table per answer. thanks for the remark Estuardo

G'd morning to all: Jon K: I unless you had tested that code, i will conclude that the code works in both ways. I test my code before post it, but i'd tryed (by chance) with two fields one numerical and one string but in any moment i sourrended any of them with quotes. Regards Estuardo

Kieran: That's very strange. It just to happens when the fields has a non existen control source. Even so, it could happen when running the app in different MS Office Verssions, try to change it to =Date() if the Date function is the default value of the control. good luck Estuardo

Wayne: My apologizes, if i was rude, and i'm glad you did not get offended. i trully try to respect every ones, choices, but freedom is one thing anarchy, is very different. I guess i exceed the limit too. I'll try to not happen again. Best regards Estuardo

To BlahBlahBlah You're a lucky person, you may thank that i'm not Wayne, because if i would be, i would never help any one to show that infinite lack of respect for others, filling in the subscription Form with that kind of desconsiderative "id". It is obvious that you just came here for help...

ppoole16: The right sintax is as follows: [ID]=forms![Booking Sheet]![ID] And [Car Number]=forms!Test![Test]![Car Number] Without the quotes From Microsoft Access Help: Keyword OpenArgs Good Luck Estuardo

Its not easy G'd evening: I agree with Fizzio, this is no easy to do it. But if you want to make it the best possible, you will have to make 1 table per Question, which wont be complicated, since all keeps the same structure, you just have to copy paste the first table as need it. The answer...

Try this Hello Vince Well i'm not sure if i understood your question, but if what you want is to choose an available installed printer and send any report. Is not complicated at all Private sub ThisPrn() Dim prn as printer Dim sRpt as string sRpt = "rptName" docmd.openReport...

Try this Hello KAZ I think you must consider using combo boxes Regards Estuardo

Try this Hello Gimp, I had never tried the ActiveX Dialog, since Office has its own if you use the following code, you must set a reference to the Office Library. Copy this code behind a button, or in the OnEnter event of your Ole field, or where ever you need. Dim dlgBox As FileDialog...

Hello fishonland, I guess that what you're trying to do is not possible... Unless you hack the users file. What i honestly wouldn't attempt to do. Regards Estuardo

Good Evening, I just want to appoint that the following code, does not work: Quotes = chr$(34) because the Editor does check the sintax at run time and that is a clear sintax error. It is equals to Quotes = " and it can be assigned. One to do it is Quotes = """" and it will works as...