Recent content by pronate

Hi, I have a Access database and the user will key some data into a Access form. After that, i want to transfer this data to a PDF form. How can i do that? Thanks in advance. Cheers Teck Beng

Hi, I am trying to 'upsize' my .mdb database to MSDE. I know there is a upsizing wizard in access, but anyone knows where i can get a more detail step by step guide with this wizard in the internet? thanks in advance. cheers pronate

Hi, I have a nividia G-force video card with a s-video out to TV. A cable is provided by them to connect the s-video to TV (via RCA connector). It worked, but the image is not good. I see 2 bands of diagonal distortion in the picture (very slight, rather like poor reception). Tried to tweak...

Thanks for the tip....but i found that only doing this works...... V_date = Format(Me.Calendar5.Value, "dd") + "-" + Format(Me.Calendar5.Value, "mmmm") + "-" + Format(Me.Calendar5.Value, "yy") Cheers Sam

hi I am using a calender object for a user input. The user will input a date, for which a report will be generated based on that date as a criteria. This database is placed in the server for many people to access. Problem is, the user's PC have different data settings (under the regional and...

Hi... Does windows ME have net send function in the dos prompt? Mine doesn't. How can i get it? Thanks Sam

KornGeek, Postie is a small stand alone program. It sends out emails by a command line in dos. You can down load this program, and in VBA, execute in with the appropraite arguments to send emails. Just do a search on Postie, you will find the site for download. It works well for me.

when i tried to sign a PDF document, it gives me this error: There was an error committing to the signature. The document was not saved. Document revision count exceeds 100. Any ideas? Sam

Thanks Nathan, I found an alternative by using "postie".

hi, I suspect that this is setting is not in Access, but when i try to use sendobject to send an email, there will also be a warning massage, saying that "Outlook is trying to send an email.......if this is a virus, you should choose no." How can i do away with this message. it sort...

Thanks for all your responses. I tried the append query SQL, it works fine, still, i am interested to learn about malipulating recordsets. Has anyone got a articles in the web that talks about this?

Thank!, why haven't i thought of that? I use append query before.... I was actually thinking along recordset.....by the way i don't see a lot of book talking about unbound forms.

Hi, i am trying to have a user to enter some data into an unbound form and then upon clicking a "ok" button, i want to run a VB code to check the validitiy of the data, if ok, add it into as a new record in the data table. I know a bit of VB coding in Access, but am stuck with the...

Hello, this is a question on table design. I want to do a database for leave application. I have 2 tables, one is the information on the employee and linked to another one to record the leave details. In the leave details, there are different types of leave to apply. Eg, Annual leave, Medical...

I know how to insert a hyperlink in word to open a excel file, but how can i specify it to go to say sheet3, insert of sheet1? Cheers