Recent content by SteveStew44

Hello Gang! Spikepl, you were on to it! The solution was really quite simple and I was complicating it. A powerhouse programmer solved it for me with 1 simple line of code, lol! He did exactly what Spikepl was eluding to: Create an unbound Subform and assign a table to it by selecting a table...

Lol CJ! Yes, I saw what Dave said, and it seems that it would be cheaper to just buy my clients a copy of Access, lol, but I have over a thousand clients using it. I am making some progress, though, I'll update shortly... Thanks All! Cheers, Steve I

Hi CJ, Is there a way though code to drop the Field List of a table into a form? I could just open the form in Datasheet and that would be it. If only it were that simple, lol. Cheers, Steve

Hi CJ, Thanks for the info! Yes, I agree, I used to have a form for each table as you mentioned, but with over 100 tables, it became nuisance to manage because every time a new field was added in the table, the form did not have the new fields automatically. I like your idea of a form...

Hi Gang, Thanks for the replies! Here's a little update. I created some code that populates a table with the Table name, Field name, and Field Type. Private Sub btnOpenTable_Click() Dim strTableName Dim db As DAO.Database Dim rs As DAO.Recordset Dim strSQL As String Dim...

Hi gemma and others, The DB is a distributed runtime version and I need to be able to remote in and change table data through an Admin Only section. I would like to select a table in a combo box. Click on a button and the selected table opens in a form. I need the form so I can allow the...

OK, Thanks CJ! Steve

Thanks for the reply CJ! Yes, I agree, this is in the admin only section of the db (.mde.), where Users cannot access the tables. I need to pop in and manipulate data once in a while. So, I gather from what you are saying, you recommend to design a form where the tables can be opened? With...

Hello AW, I can open up my tables using the code below in a distributable runtime version, but I cannot filter and sort in the table. Right clicking does nothing. Dim strTableName strTableName = Nz(Me.cboTableNames, "") DoCmd.OpenTable TableName:=strTableName, View:=acViewNormal...

Hi WA! I found online a simple answer that worked: Private Sub Report_Open(Cancel As Integer) If (Forms!frmSalesTaxReports!Check72 = True) Then Me.GroupLevel(0).ControlSource = "Description" Else Me.GroupLevel(0).ControlSource = "TaxRate"...

Hello WA! Hope all have been well. How can I change report Sorting and Grouping through code? I tried: Dim rpt As Report Dim strReportName As String strReportName = "ReportName" DoCmd.OpenReport strReportName, acViewDesign Set rpt = Reports(strReportName) rpt.OrderByOn = True...

Hi Galaxiom, Yes, you are correct! I believe that my Db is far from great design, mostly because I am not a professional programmer. I am a businessman who has hired 3 brilliant programmers to build what I visioned. Fortunately, my programmers did not have the understanding of what the...

Thanks again Mark! You see, I feel so lame, I just learned that I do not even need a form to open up any table, ha ha! This will do it: DoCmd.OpenTable TableName:=strTableName, View:=acViewNormal, datamode:=acEdit Thanks to all who responded. Cheers! Steve

Hi Mark, Thanks for the reply. That is a great idea! I will try it. Btw, all the replies were criticizing the design of the db, so I beleive I was not clear on my question or the description of the problem. I apologize for any confusion, lol. Incidentally, the db genuinely uses over 100...

Hi Smig, Thanks for the reply. I have a fe/be. The User does not have access to the tables. I want to Edit the tables through an admin section where only I can Edit. My question I am seeking an answer to is: Is there a way through VBA to open a form that takes a selected table and inserts...