Search results

Post the DB Can you post the database in Access97 format? I can take a look at it.

sample... I seen some sample database regarding what you want to do. please visit following. http://www.rogersaccesslibrary.com Good Luck

This will show all your tables and quries Put this in your combo box's row source (row source type: table/query selected) SELECT MsysObjects.Name AS ObjectName, IIf([type]=1 Or [type]=6,"Table","Query") AS ObjectType FROM MsysObjects WHERE (((Left$([Name],1))<>"~") AND...

You are right... I changed the AutoExec to AutoExec2 for interim. and it works. I just have to remember to turn it one when releasing it to public. Thanks for your help.

when I type any VBA and type docmd and put a period it shows the menu but for split of a second. Anyidea why ?

dlookup... I would use dlooiup if its only few fields.

This is the SQL Update Code... Use Following SQL Update code to replace blank with zero. Replace tblMain to your table Replace Field1 to your field UPDATE tblMain SET tblMain.Field1 = "0" WHERE (((tblMain.Field1) Is Null)); Good Luck

Thanks.... Thanks Mile for helping me. I wasn't hopeful. LOL.

Hi, I am using following to populate tables in the combo box. And IT WORKS. SELECT DISTINCT MSysObjects.Name FROM MSysObjects WHERE (((MSysObjects.Name) Like "tbl*") AND ((MSysObjects.Type)=1) AND ((MSysObjects.Flags)=0)); However, I would only like to show 4 tables and they are below...

I Knew No One Is Going To Help Me.... I Figured It Out... Private Sub Detail_Print(Cancel As Integer, PrintCount As Integer) Dim X1 As Single, Y1 As Single Dim X2 As Single, Y2 As Single Dim X3 As Single, Y3 As Single Dim X4 As Single, Y4 As Single Dim X5 As Single, Y5 As...

Found an article but need more help.... http://support.microsoft.com/?kbid=197595 Private Sub Detail_Print(Cancel As Integer, PrintCount As Integer) Dim X1 As Single, Y1 As Single Dim X2 As Single, Y2 As Single Dim Color As Long ' Specify unit of measurement for coordinates on a...

Hi everyone, I hope I can get some respond on these. I have a report with 5 fields. One of this field is a memo field and set to grow. (grow=yes). I put lines between these fields (verticle lines) so i looks good. Is there a way to make these line grow whenever memo field grows. Best Regards...

Why even put a delete button ????? Why even put a delete button if you dont want user to delete records ? Assuming you are controlling your data via Forms, not tables. I have a delete button on my form and it's only for managers. You can use delete button and password protect it. Regards...

Hi, I am using following code to update a field in another table from a form. When end user exit or click save following happens. Can any please verify and let me know why the update query is not working. Dim SQL As String, Conn As Connection Set Conn = currentdb.CreateQueryDef.SQL 'Set...

Anyone ??????????? Does Anyone want to share their idea about this ?

Post your database... Jenny, Why dont you zip your database and post it here. It's easier to work from a database instead throwing advice back and forth. Since, you are new to Access there are many term that will go over your head. Dianna goldsberg

Private Sub cmdPrint_Click() On Error GoTo Err_cmdPrint_Click Dim strFilter As String strFilter = "OrderID = Forms!Orders!OrderID" DoCmd.PrintOut Exit_cmdPrint_Click: Exit Sub Err_cmdPrint_Click: MsgBox Err.Description Resume Exit_cmdPrint_Click End Sub...

hmm Did u change the properties of the form according to the picture files attached in my last response.

Try this.. Not sure if you are asking for following. But try it if it works then great. go to form properties and go to load and type [event procedure] then click on the ... to open the visual basic editor. put following. (asssuming your combo box name combo1) me.combo1.value = null or...

Dont Ever Do Macro.... Dont ever do Macro. I just finished converting All the old macro from an ex employee to VB. Trust me it's better in VB. Never do Macro.