Search results

Thanks for the help Sprocket I think we are getting close. You mentioned you can't duplicate the problem. Here is what I am doing, create a table with a memo field in it, go to the datasheet view and add some text with either a space or a line at the end (ctrl-enter). Move to the next record...

Here is what I am trying to do. The Memo field is used as an additional information field for orders. I have a drop down box based on a table with some default information to be inserted into the memo field. (To save the users from having to type out the same information time and time again)...

It is possible to program a command button that will compact "another" database, however you can't program a command button to compact the current database because it is still open and will fail. You can always create a shortcut to compact the database. There are a couple of parts to creating...

You are right those darn quotations are messing you up. Try this Set qdf = CurrentDb.CreateQueryDef("qryExample") qdf.SQL = "SELECT tblCLIENT.ClientName FROM tblCLIENT WHERE (tblCLIENT.ClientName)=" & chr(34) & Me!cboClient & chr(34) Your problem exists because you are trying to set the...

I am simply trying to allow a memo field to allow the addition of blank lines or spaces at the end of the memo. Currently I add a couple of spaces onto the end of the memo, when I leave the field and re-enter the blanks are automatically removed. Anyone know how to turn this off? Thanks in...

You would place this function into a module and then call it from a form passing on the filename to search for. Example. You are looking up the file c:\Images Directory\Image.jpg. In the tblLocalSettings table you would have the directory stored as "c:\images directory" From a form that is...

You need to have special software to print out barcodes. Try some of these trials found at zdnet. Be Carefull when picking one out, make sure that supports controlls from MS Access, word, excel... some programs just allow you to type in the barcode information and then it creates a picture of...

Most of the time I have had problems when I was logging in as a user that was not the "owner" of the database. Check out this article from microsoft. http://support.microsoft.com/default.aspx?scid=kb;en-us;288960

I think the only way to do this is to use the Control Source Property of the ActiveX Control. Then by changing the Data in the table that it is based on you can set it 30 days ahead or behind. I normally set the activex control into a subform based on a table with one record that controls the...

Why don't you create a new table for local database settings. (IE a table that contains information pertinent to the local user or computer) I normally create a table that stores the local path, backend database name, User Name... (you get the point). Then once you have a table with the...

Try using this one. Application.SetOption "Default Find/Replace Behavior", 1 For Fast Search use 0 at the end For General Search use 1 For Start of Field Search use 2

You can do this using the following. For the first Problem you can use the InputBox function like this to call the function below and relink the backend. Call refreshlinks(InputBox("Please Specify the Database Path", "New Back End!")) For the second problem create a Form with an unbound...

I have been working on this script to resolve my problem. The problem comes up when I try to pass on a database and workgroup into it I get an error on the "cnn.Open "data source=...." line. Run-time error -2147217843' Not a valid account name or password. The username and password that I...

I don't need to "hack" the users file, I do have the workgroup file with administrator rights, however the users don't have access to this information (security reasons) and don't have enough rights to change permissions. Just to clarify, I would like to be able to create a script file that...

I need a solution for allowing a user to change permissions for all Tables/Queries/Forms One Problem 1. The user doesn't have security permissions for changing user/group permissions. (This must stay like this) Any Help would be great.