Search results for query: *

Hi Everyone. I have a subform within a form. In the form there's a command that deletes fields from the table (tblTable) on which the subform is based. The command deletes fields from tblTable by executing the sub: Sub Delete1() DoCmd.RunSQL "ALTER TABLE tblTable DROP COLUMN Field1" End...

Hi Everyone. I have a main form with a subform, they are bound with a common key (linked child and master fields). After changing a record in the main form I try to execute Call Me.sfrmSubForm.Form.GoToLastRecord Which is: Public Sub GoToLastRecord() DoCmd.GoToRecord , , acLast End Sub...

Hi Everyone. I'm trying to alter externally the default value in a table. I've tried this: ALTER TABLE tblDocs ALTER COLUMN F10 SET DEFAULT "text1" and this ALTER TABLE tblDocs ALTER COLUMN F10 SET DEFAULT 'text1' without success. Does anyone know how can this be done via SQL or via DAO...

Hi Everyone. I have a subform container (sfrmGroups) with a frame buttons above it. Each button loads a different source object for the container. Also each time a new source object loads, the following VBA code is being performed: Do While rs.EOF = False If rs!GroupId = lngGroupId Then...

Hi Everyone! I have a database with a commonly used table of about 500 records. This tables includes a 40-char text field of object's name with unique values. The field is called ObjectName, and it is currently my Primary Key for this table. My question is, should I add an Autonumber field...

Hi Everyone. I'm using a code to leave some things dynamic in a report (rptGraph): Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) Dim MyDB As Database, Qry_RoundOrder As Recordset, Qry_GraphData As Recordset Set MyDB = CurrentDb() Set Qry_RoundOrder =...

Hi Everyone. I'm having trouble in trying to refer to a control in a Report through a variable So far I have attempted this: (i = VBA variable, txb1, txb2 ... are report's controls) Me("txb"& i).Caption = "1" Reports!MyReport("txb"& i).ControlSource = "field" & i...

Hello all! I have a form that can be viewed by either customer name or customer sir name. So I've created a menu bar with a custom menu called "View By", and 2 commands: "Name" and "Sir Name". Each command activates a macro that alters the form accordingly. I need something else for the menu...

Hi Everyone. In my access app VBA code, I very often use the same form names for reference in fuctions or methods, here's example from my code, in public Module: Function fColorAmount() If flgFrmMainIsLoaded Then If Not...

Hello there. I need some help in VBA form coding. I have a main form, which has many sub-forms. The some subforms take data from other subforms, so they are dependent, and so it is important in which order they all load. I've noticed they load in the opposite order of they creation time...

Hello. I need help in setting a public constant global reference to a form in public module for convinience, so that all form modules could use it. I've tried Global Const frmParameters = Forms!frmMain!sfrmParameters.Form I understand this is not the way as this is not a variable but an...

Hello. I need to be able to import .csv files into my database via VBA DoCmd.TransferText acImportDelim method. While most text tables do import well, importing one table, which doesn't look different from other tables, it has field names and values, gives the following error: Run-time error...

Hello. I have something strange going with a graph that is located on the only section [BranchId] of my report[ReportByBranch]. The graph that is set there takes the whole page size, and based on query that takes a criteria from a control of the same report -...

Hello. I have a report based on a query of the following type: BranchId CatgId DataId ...a............1........13.. ...a............1........29.. ...a............2........41.. ...b............4........15.. ...b............4........19.. ...b............5........22...

Hello All. I have many text table files needed to be imported to the database, while the user would specify which text file table to import. I created a VBA function with a parameter, which is for the text table file name. It doesn't work however: Function ImportTextTable(strFileName)...

Hi All. I've encountered a problem I do not understand, and seeking for advice from people who do. In a frmChooseBooks which is bound to qryChooseBooks, I have an unbounded cmbCountrycontrol, an anbounded cmbAuthor control, and bounded [BookName] and [ChooseBook] control. (Logically, each...

Hi All. I have a main form and a sub form which have underlying table and child table. There's a field in my table which is a count result of the records in it's child table. ([mainTable].[CountField]) My problem is that each time I add a new record to the sub form, count the records and update...

Hello all. Does anyone knows if it is possible and how to code a command button so it will continuously perform a command (for ex. x = x + 1), in a similar way a scroll button works? Thanks.

Hello. I have a basic report which has constant basic properties in it: Header, recordSource, box controls and other graphics which I do not want to create each time again, called rptBasicReport. I need to be able to create reports which will be based on this basic report but will add more...

Hello. I'm writing an application that has many tables of the same purpose/class [tblRecordsOrg1], [tblRecordsOrg2], etc. I would like to create a general purpose query that will select one of these tables depending on a control value, and will function as a base to other, more specific...