Search results for query: *

Gerry My apologies - for 'template' read 'document' (i.e .we are talking here about .doc files and not .dot). Thanks

Hi I (and the users I deal with) are UK based, but as part of a multinational company. As a result, we often receive documents that have originated in other countries, created in languages other than UK English. These documents can be used as the source for new documents, which are ostensibly...

allanon I have managed to sort this one out since posting - can't remember how for the life of me, as this was some time ago, but thanks anyway. Mutt

When you are executing your code, what value does your SalesDate object hold? If you're not sure how to do this, either hold your cursor over the SalesDate text, or add the following line to your code before the update statement: debug.print SalesDate You can then view the properties of this...

Try creating a shortcut and putting the following into the target: "C:\Program Files\Microsoft Office\Office\msaccess.exe" "C:\YourDatabaseDirectory\YourDatabase.mdb" /decompile "C:\YourDatabaseDirectory\YourSecurityFile.mdw" Replacing the placeholders as necessary.

thread181-98582 Should work now!

Have a look at this thread for some suggestions: thread 181-98582 HTH

Hi I've created a new .mdw file to access my db for security purposes, together with a shortcut that references the .mdw file so that the password prompt only occurs when the users access the db via the shortcut. My problem is that if I try to open a new instance of Access in the normal way...

I've had the same error sometimes...an alternative approach that may fix it is to create the query using the normal query editor (paste the SQL from earlier into the SQL view), try running the query to see if it runs - that way you can check your SQL. If it works, save your query e.g. qryCheck...

use the 'OnCurrent' event of the form to me.cmdButton.visible = False Hang in there....!

Sorry Tina, got diverted - try modifying your SQL to say myQry = "SELECT User, Password FROM tblUser WHERE User = me.txtUserName AND Password = me.txtPassword" You were missing the 'me' in your password string

Try putting a carriage return between If Not myRs.BOF And Not myRs.EOF Then and DoCmd.OpenForm "frmMain_Menu1", acNormal Access treats single line 'if' statements differently than block 'if' statements. You should then be able to use 'Else' rather than 'Elseif' Let me know if any...

Bummer....here's the URL: http://support.microsoft.com/support/kb/articles/Q273/9/56.ASP It's worth having the above even if it doesn't work in your case...allows you to compact the db without opening it. Cheers Muttley

Oops, forgot the 'End If' statement - you need to put this after the latter openform statement. Soz!

Ok here goes: Create your form with the following text boxes: txtUserName txtPassword Create a button and then put the following code on the 'On Click' event; Dim myQry as String Dim myRs as Recordset myQry = "SELECT username, password FROM tblSecurity WHERE username = me.txtUserName...

I've had similar problems before, not guaranteeing that any of these will work, but you could try the following: 1. I'm assuming that your compact and repair worked OK - if not try using the Jetcomp Utility (downloadable from the Microsoft Developers Website) - let me know if you need the URL...

Try changing the visible property of the button in form design view to Visible = No. HTH

Someone's got their C++ head on..... matpj - Try using ' instead of // for comments

Try using the following: Docmd.setwarnings False before you run your query, but remember to make sure that your code (including error handling turns your warnings back on) by using the following: Docmd.setwarnings True HTH

Joe Thanks a million, that worked great! Muttley