Search results

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...

Hi Mark, Thanks for the reply. I have a distributable db with over 100 tables I need to access through the User's runtime version. I would like to be able to edit their table data with a Find and Replace feature, but do not have access to their tables unless I create 100 forms as you suggest...

Hello AW! I am using Access 2003. I would like to be able to open a versatile form that can open any selected table in data sheet form. Currently I am using Command Button with the names of the tables as the trigger. I need some help with the VBA that would change the form's Record Source...

Thank you to all who responded. Good to know that controls are not allowed to Sum. It makes sense now that the the bound controls appear to be Sum'd because they are tied to the field and an unbound isn't. I guess the only way is through code. Ha ha! Thank you all again! Good info. Cheers! Steve

HI Marlan and Ilkhoutx, Sorry, it is Sum() not SumOf. This is a report so the code runs in the format. I used code to Sum the controls of the Detail section that were populated with code. I am having difficulty with the other controls as described below. Here's the code I am using to...

Hi Ilkhoutx, Thanks for the reply! I am sorry if I was not clear. The unbound text box in the Details section is populated by code as a Currency. I would like the Footer control to Sum the Detail control. Cheers, Steve