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 bkrike 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: *

  • Users: pronate
  • Content: Threads
  • Order by date
  1. pronate

    Populate PDF form with data in Access

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

    upsizing to Access Project

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

    S-video out to TV

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

    problem with date setting

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

    net send command in DOS

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

    problem with signing a document

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

    sendobject warning

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

    unbound form to record data

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

    table normalisation

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

    hyperlink in Word to point to a sheet in excel

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

    error in database

    Hi, I got this error.... The microsoft jet database engine could not find the object "Database". MAke sure the object exist and that you spelled its name and pathname correctly. Can anyone help? I can't open the file. Thanks.
  12. pronate

    how to archive data

    hi! I have a database that traks orders and delivery, about 6 or 7 tables, in a one to many relationship. Now i want to archive away (take out from the current databse) the old records, based on date, which is on the "one" table. I tried a query, but the result is not updateable...so...
  13. pronate

    powerpoint 2000 and XP

    Hi, I created a file in powerpoint XP with all the nice moving things but it cannot be shown in 2000 version. Help! Thanks Sam
  14. pronate

    Take out prompting in append query in VB

    Hi, I am trying to use the Docmd.RunSql method to run a append query. But everytime Access will prompt me for confirmation. Is there a way to do away with the confirmation dialog box? The same goes for make table query and update query. Cheers and thanks! Sam
  15. pronate

    Office XP problems with Access in Access 200

    Hi, Are there any know problems for running Access 2000 files in Office XP Pro? I seem to encounter prblems with Excel 2000 files in XP Pro. OS is Office XP. Cheers
  16. pronate

    formatting form outputs

    Hi all, This is the output i have from a continous form, bound to a query, relating 2 tables. Order No.| Customer | Items | Qty | Date-of-delivery ---------------------------------------------------- 12214 | A001 | 1114-77 | 01 | 11-1-02 12214 | A001 | 1254-54 | 03 |...
  17. pronate

    update query for this?

    Hi, Just need to know how to write this SQL... 2 tables, Orders_tbl and Order_detials_tbl. I have a "closed" yes/No field for both tables. If each order item is delivered, the user will tick "Closed" in the Order_detail_tbl. If all the items are delivered, the Order_tbl...
  18. pronate

    Calculate number of days based on 2 dates, exclude holidays

    Hi, Say i have 2 dates, how can i calculate the number of days between these 2 dates, minus away weekends and holidays? My holidays are stored in a table. In VB code, what are the functions that are handy for this use? Cheers Sam
  19. pronate

    program too slow. Users complaining!

    Hi, In a file/server setting, mulit-user, about 27 ppl. Sometime it takes rather long for a form to load. almost 20 to 30 seconds. I tried to index the common sorting and query fields, and setting sub-datasheet name to [none] in table properties, use single forms as much as possible instead...
  20. pronate

    search through on mutliple tables

    hi, I have a few tables....10 of them. User need to enter a search criteria into a textbox in a form to search through all the tables. What is the best way to do it? All the tables contain a common field i call "Part no", the user only search this field. Thanks. Sam

Part and Inventory Search

Back
Top