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!

Register Log in
  • Congratulations Chriss Miller 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. dimmech

    Email template selector/editor

    Thanks rac2, access 2003 ado but I can use your example. As for editing or creating templates I thought it may be possible to create a cbobox driven sql query builder that I could merge with user input text fields and save the results into template file. Every come across that? -dimmech
  2. dimmech

    Email template selector/editor

    ...Set rsInfo = New ADODB.Recordset With rsInfo Set .ActiveConnection = cn .Source = "select * from tblCompanyInfo;" .LockType = adLockOptimistic .CursorType = adOpenKeyset .Open End With If Not IsNull(cboEmployee) Then...
  3. dimmech

    Dummy boxes?

    Thanks, what I was looking for is a way to layout multiple instances of a master object and be able to edit or replace its contents vector or raster. Kind of how symbols work in flash. Thought It might be possible in vba for Corel. -dimmech
  4. dimmech

    Dummy boxes?

    Is ther a way to have multiple place holders for an image in a file and have corel swap images from a selectin or external file? I cant search to see if this has been adressed cause I get a message that the forum search is not working. Thanks dimmech
  5. dimmech

    Advanced search function help requested

    Greetings. In my app there is a customer data form and prospect data form. Once a sales person gets a lead they use a search function to see if that lead exists in our db as a customer or prospect. If not they will use several websites to gather information about that lead. Typically the rep...
  6. dimmech

    Application conversion from Access to SQL Server

    Our company has been developing an app using access 2003 (front end on xp - back end windows 2003 server - 12 users). We now have to make the app vpn friendly and generally faster for local users. Can someone please provide discussion or references to online resources that address methodologies...
  7. dimmech

    single user choice fills multiple fields in a table

    evening... I have a table called TblBox in which i store box dimensions BoxType1,Dim1,Dim2,Dim3 ect. There is also a continuous form which pulls customer/order info called FrmShip where I would like to select "BoxType" from a pulldown list using TblBox as control source. Once selected I need...
  8. dimmech

    VPN client can ping cannot see domain

    Thanks for the explanation, that clears up alot. All clients establishing a connection WILL have to log on to the domain for the purposes intended. That being the case, are there any suggestions for a no frills firewall with minimal setup? I will also need a server side fw/router(preferably...
  9. dimmech

    VPN client can ping cannot see domain

    From everything I've read about this particular setup I should not have to open ports. As many times as we will need to make secure connections to remote computers with different setups I can already see where this is headed. Thanks for the replies. At this time we have decided to abandon the...
  10. dimmech

    VPN client can ping cannot see domain

    I had some help with setting up the network and I'm not sure why it was set up that way. In any event I made the correction and it was not the source of my issue. My dlink router(client side)logs show blocked connection attempts for tcp ports 135,445,1076 and 6101. The times seem to correspond...
  11. dimmech

    VPN client can ping cannot see domain

    That is correct the client employs the safenet virtual adapter interface which is almost identical to having a second physical adapter/nic. Set to: client requests ip 192.168.1.15 dns 192.168.1.2 wins 192.168.1.2 router vpn server reserves 192.168.1.15 Server static ip 192.168.1.2 default...
  12. dimmech

    VPN client can ping cannot see domain

    Creating this vpn has given me a crash course in basic networking but by no means am I experienced. Please keep that in mind when responding. I can connect and ping the server and other machines in the domain, but I do not have access to resources. I used 2003 server wizards to create domain...
  13. dimmech

    Percentage in A.S.

    Thanks! That did it. -dimmech
  14. dimmech

    Percentage in A.S.

    I don't really know how difficult or easy this may be but instead of a specified value, how would I get this to work based on a percentage of the screen width. onClipEvent (enterFrame) { if (_root._xmouse < 50) { setProperty("_root.sky", _x, _x+1); } if (_root._xmouse >...
  15. dimmech

    error on before update event

    Success!! Thanks the help. -dimmech [thumbsup]
  16. dimmech

    error on before update event

    You were right. The calender object on the form uses Option Compare Database Option Explicit Private mc As clsMonthCal Is there a way to use the code I want, or an alternative for what I want it to do? Please keep in mind that I am somewhat new to vba. -dimmech
  17. dimmech

    error on before update event

    Strange It works on the other form with the mistype. I just copy/pasted into the new form. After making the correction it halts on DMsg = same variable not defined msg.
  18. dimmech

    error on before update event

    I am using the following code on two forms in the same database. works great on one and halts the other with -msg "variable not defined" Private Sub Form_BeforeUpdate(Cancel As Integer) On Error GoTo Err_Form_BeforeUpdate DMsg = "You are about to update data!" & [highlight...
  19. dimmech

    Keeping track of TransferText

    Thank you for your responses. I'm sure I will experiment with both disable alternatives. Could you please include code examples on the following I am not really up on how to code this. I know this is probably basic but then again so am I.
  20. dimmech

    Keeping track of TransferText

    I am currently using Transfertext method in a "print" button's on click event to save a .csv file. I would like to disable autosave for this form, once the user clicks "save" have access save the current record and keep track of this record until it is "printed" to currentdate.csv. I have...

Part and Inventory Search

Back
Top