Search results for query: *

I am using an Access form that has a text box called – “Me.txtboxOwner_Addr” which displays owner information from a field called “Owner_Addr“ in a MS SQL database table “Apts”. This same record has another field “PRIMARYOWNERRECORD” that is "false". I want to pull out the “ID” number for...

I am trying to calculate a sum of values in column in an access form but can’t figure out the syntax. The access form displays the records from a table called “Apts” in a Microsoft SQL database and works fine. However, I tried to add a calculate button in the form to sum a numeric field called...

I have field that I want to change the formatting of when the condition is met whereby a separate field named “Street” has the value “MAIN ST”. All the records with this content are between ID = 49934 and ID = 50575. The conditional formatting works when I use [ID]>49933 And [ID]<50528 in the...

I have a form that has a data source ‘APTS’ and I am trying to store a field value directly into a Public global variable ‘sale.Picture’ and then transfer it into a second form controlled by a different table. When I do this with text fields with text boxes it works fine using code like...

I have table named “APTS” and a field named ‘Owner_Lname1_Corp’. I have a form where the record source is the ‘APTS’ table. I also have a public variable named ‘owner’ I want to store the value from ‘Owner_Lname1_Corp’ in the public variable ‘owner’. I know that I can bind a text box (such as...

I have a table set up for a todo list with a date field “DATE111”. Records with dates run through the year 2010. When I open the form I want it to pull up and display the record for the current date. I have the following code in the “On Open” event for the form “OrganizerToDoList”...

I use a query called ClientQRY with a field called “MetroAreaCode” which needs a value of 1 thru 10 to filter geographic regions. I use this query in my forms. I open my forms with a switch board form currently with different control buttons to open identical second forms with different...

Now that I understand Global variables I would like to apply it to another problem that I want to solve. I have recast the form of my application from one that had 16 tabbed pages into one that has one main page which acts as a switchboard and 15 popup forms replacing those other tabbed pages...

I am opening up a main form then with a command button opening a second form. How would I automatically trigger the execution of a subroutine in a first form after closing of second form?

I am opening up a mainform “frmMAIN” that will have command buttons to open a popup form “frmSECOND” and “frmTHIRD” and several others. I want to declare a public variable “strA1” that can be used and passed between the various popup forms. Where do I declare this variable? At this point I am...

I have a main form “frmMAIN” which is controlled by a table tblCLIENTS. Within that main form I use a command button to open a second form “frmSECOND” also controlled by “tblCLIENTS”. I navigate to different records in tblCLIENTS in the “frmSECOND”. Now when I close the “frmSECOND” I want to...

I have a main form with tabbed pages and a subform on one of the pages that when I double click on a field on that subform I want it to leave that subform and take me to the main page of the main form. I used the following code to take me to the main page from other pages of the main form...

I changed from list boxes to subforms with dataview (to look like the list boxes) and all is working fine. However, I had code to count the number of records being filtered by the list box but don’t know how to do it with the subforms. The code I used with list boxes was: Me.Text654.VALUE =...

For some reason my form started openning in a smaller window and I can't figure out where to set parameters or code to get it to maximize on open. Thanks

I have a form “MainForm1” and an embedded subform “SubFormCities”. The subform cities is not linked to the Main except through command buttons to filter the display. I have the subform designed to look like a list box. They are both linked to the same table. When I click on a certain field...

I have a form that I want to change the formatting on a text box “text1055” bound to field “Manager_Owner” if the value of a different field “Manager_num” shown in text box “text1056” is greater than zero. I tried to put into condition 1 of the Conditional Formatting box the expression...

I have reached the 255 controls limit on my form and I understand that the only way to get past it is to create an array of controls such as a text box array. How do you do that and where do you put the code? Thanks

I have a general question about nesting forms. I have a main form which has about 16 pages accessed with the named tabs at the top of the main form. The first tabbed page (1) is named “Main”. On page 6 which is named “Management” is a command button that opens up a second form called “Management...

How can I run an update of a table from a command button. I know I can run a query but I want to pass parameters to the query. how can I put the query code into the command button? Like: I have a table named "Clients" with a field named 'field11' and I want to put the contents of a the text...

How to use a command button to change the order and filter for a subform. I have a Main Form and a subform within it and was able to make it look like a list box in Dataview. However, I could not figure out how to change the order or filter for the subform in the same way as I could do for the...