Search results for query: *

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

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

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

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

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

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

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

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

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

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

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

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

Thanks! That did it. -dimmech

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

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

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

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.

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

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.

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