Search results

Access still reserve for the full 255 chars. You can set(type) size limit in the field property. If you need more than 255 -- choose Memo data type.

Go to Query Tab within Access database and create a new query with this syntax.

=Dlookup("[Branch_Contact]","Branch","[Branch_City]=[Forms]![MainForm]![cboBranch_City] And [Branch_Name]=Forms![MainForm]![cboBranch_Name])

Create Command button on form and name it "cmdInsert" In code window: Private Sub cmdInsert_Click() DoCmd.SetWarnings False DoCmd.RunSql "Insert into YourTableName(YourFieldName) values(Forms!YourFormName.YourTextBoxName) DoCmd.SetWarnings True End Sub

That was easy, funciton presents in one of the MS Access book. Now show me a function which allow to restore Shift(Bypass) key for "secured" database running from external another database!!! Cheers.

Re: HELP!!!!!!!!!!!!!!!! Puuuurlease! Export as .txt file DoCmd.TransferText, acExportDelim, ,"YourTable", "C:\YourFile.txt" Then rename YourFile.txt to YourFile.csv

Hello everyone! Is there a way to print out graphical file(.jpg or .bmp) if you keep path to this file in Text box control or in the table field?? Example: in txtFileName I have path C:\MyPictures\File1.jpg I think I need API function technique. Thanks.

Your date format is dd/mm/yr. Should be dd/mm/yy.

In VBA code window Private Sub Text1_AfterUpdate() Text1=UCase(Text1) End Sub

Here is my question: I set Debug Breakpoint on active code in VBA code window(not on variable declaration line) which becomes with red line. I cannot test my procedure because it did not go to breakpoint for some reason. When I import all objects to a new database I do not have this problem...

To see Years without duplicate use "Select Distinct Years from TableName" in your ListBox RowSource.

DoCmd.SetWarnings False DoCmd.OpenQuery "UPQryJuly" DoCmd.SetWarnings True

I creted 2 tables and all fileds as you have. Even copied your query. Everything seems OK!! Union query with your syntax gave me a good result!!!!!!!!!!!!!! 1) Try highlight your query syntax, copy it to buffer. 2) Delete your original Query. 3) Create a new query. 4) Paste query syntax into...

1) All users should be within the same group having exact the same rights(read,write). This cause a sharing vialation. 2) Try to reboot computer and then delete manually .ldb if you know that nobody use database file.

Open your .mdb file on every user machine, get VBA code window and uncheck MISSING in Tool-->References.

Hi Richard I enclosed in functoin SQLConfigDataSource Login and Password, it did not work. I tried to use LoginID, UID, User ID and Password,PWD, Pswd - still not successfull..... I beleive that when Trusted_Connection=No we have to input manually Login ID and Password every time for every...

1) Open Notepad 2) type proper syntax for DOS command 3) Save file with extension .bat 4) Embed in your Access code Private Sub Command1_Click() Dim retval retval=Shell("c:\test.bat",vbMinimizeFocus) End Sub

To Autoeng: Even if we disable all toolbars you still can import objects. Also there is a way how to enable bypass to mdb again.....

Or recordset with NoMatch method

Hi, Richard! Hi everybody! The function you gave me creates DSN with trusted connection but the way we set up SQL Server connection required to pass UserID(LoginId) and password. So your function does not support it.... I found procedure which also creates DSN but does not establish LoginID and...