Search results for query: *

Try using the detail_MouseDown event and check for button 2 Danny Never Think Impossible

First rule of Access Security is back-up your database before attempting.. Danny Never Think Impossible

A simple method of encryption would be to Xor the Asci value of each character, although this is very easy to break by a determine hacker it will confuse the average user. Function Crypter(pStrSent As String) As String Dim i As Integer Dim NewLetter As String For i = 1 to Len(pStrSent)...

please see my reply on AccessVBA.Com Danny Never Think Impossible

No Such Command DoCmd.TransferSpreadsheet Danny Never Think Impossible

If you use a delimiter in the file (comma, tab) then you could import this through the import right click and then save the file specification. To automate importing you would then be able to use the DoCmd.TransferText function in VBA (Look it up in vba help for full list of parameters) Danny...

Is this supposed to be a variable representing the form name [+transcript] or is this the actual form name? Is the Form Loaded (Open)? Danny Never Think Impossible

You can either set up custom menus for each type of user and activate the respective one for each form as the enter the database. Or if the permutations are going to be too many then you might consider coding these in at run-time, although trickier it can be done. You would be better using the...

Place the image in the page header should do it. Danny Never Think Impossible

Hi, This has already been discussed in this thread Danny Never Think Impossible

sk8er1, If this is to be either part of an automation or a regular method then please take a look at this example Danny Never Think Impossible

mordja, because you are submitting to the logerror function before your if statement you are infact sending the information from the Error Object, which will populate your table. Inside this function you are again setting the error event handler, so therefore you are resetting the Err object...

Traycee, The function will take parameters not table fields. Could you post some more of the function so we can establish what is trying to be achieved. Danny Never Think Impossible

You can capture the form names by using the AccessObjects Collection.. It does however depend on what version of Access you are using. If A2K or above then I'll demonstrate. Danny Never Think Impossible

hi, Try CRS.Open _ "INSERT INTO tbl_Input_In_CBD (" & DataTo & ") IN " & RemoteDb Location &" SELECT * FROM tbl_Output_From_DB _ WHERE " & DataFrom & " ", _ CDB, adOpenDynamic, adLockOptimistic Danny Never Think Impossible

How are you connecting to Access through Excel, and what do you need out of Access Danny Never Think Impossible

However, using a vbscript file placed on a server installed with sas, and using windows scheduler running this file every couple of minutes I have been able to offer up gui interfaces that submit sas code to the server for the server to run and return the results, without the need for the...

You could also just change the footer to =Environ("Username") Danny Never Think Impossible

earthandfire.. True, but as I have always been instructed, always include a relevant return value to minimise the memory allocation. Danny Never Think Impossible

Yes... But Creating every function as public in a standard module will increase the memory that your database needs to allocate, also not qualifying a correct return variable will also declare your function as variant, which again increases the amount of memory needed. Private Functions behind...