Search results for query: *

I want to change the Row Source of a pull-down list based on the value selected in another field on the form. There will be only two possibilities. I have 2 tables (SCA and SOC) containing the values I want in both cases. I am writing a VB procedure to run at the OnExit event for the later...

I want to change the Row Source of a pull-down list based on the value selected in another field on the form. There will be only two possibilities. I can create tables (table1 and table2) containing the values I want in both cases. I am writing a VB procedure to run at the OnExit event for the...

I have a data-entry form that I set up using the onEnter and onExit events to change the color of the question with the users focus is on the field for an answer, often a Yes/No combo. The problem now is that I have reached the limit for the number of controls on a form, and I am having to...

So, can someone tell me what the story is here? I remember reading somewhere that you can only put a certain number of controls on a form, but I can't find it anymore. I've done the "rename the form" trick and I've REALLY reached the limit. So, what are my options? I also tried creating a...

I am not sure if this can be done, but I'll toss it out there as a question anyhow. I have a tab control on my form that contains four tabs. In my database, this form will be opened from two different forms. I would like to have the tab that is first active on the form be the second tab when it...

Which form event would I need to modify so that the code occurs whenever the form closes or changes to another record?

I am creating a data entry form for clericals to use to enter data from a survey I am administering. Most of the questions are Yes/No, and I've created option groups that have two options, Yes or No. The data entered for each form goes into a table that contains just survey response information...

I don't know if this is the right place to ask. I want to create an installation program that will add a desktop icon of my choosing that will open Internet Explorer to a website of my choosing. Where should I start? I have used VB in Access and Excel environments, but I'm not even sure if I...

It cannot be as difficult as I am seeing to get a Browse for File to open dialog box to pop up from an Access form! I just want a button next to a text box control. The text box will accept the location of the file, as in "C:\SomeFolder\thisfile.xls", where an Excel input file is...

Let's say I have a check box control named CheckBox1 on a form named Main and I want to check the value of that check box in an If .. Then statement in some VB code. Can someone write a sample If .. Then statement for me? I'm not sure exactly how to access the values of controls I put on a form...

Here's me code: If BreakFlag1 Then Me.PageBreak1.Visible = True Else Me.PageBreak1.Visible = False End If If IsNull(Unavailable) Then Me.PageBreak2.Visible = False Me.Label154.Visible = True Me.Label136.Visible = True Me.Label139.Visible = True Me.Label160.Visible = False...

I have become quite adept in the past few weeks (thanks to a few folks in this forum!) at moving report controls around on the page based on field values. However, I am stumped as to why this is happening. When I modify the twips for the Top property of a field, sometimes the control...

I need to know the VB syntax to make a section footer NOT appear based on the value of a field, call it FooterFlag, a boolean field. So, whenever FooterFlag is true, I want the section footer to NOT appear.

I have the following code to move the License1, Label9, Unavailable1, and License2 controls on my report for one record out of 110. It works prefectly for this record and does not affect any of the records UP TO this one. However, it seems to be affecting all the records AFTER this one. I've...

Can I change the "Top" property of a text box on a report based on the value of a field on the report? In other words, will this work? If True Statement Then Me.TextBox1.Top = "5" End If If I am able to do this, what is the correct syntax for the inch measurement...

I am having some problems getting my report to format properly. The report consists of 110 2-page records, but on some records, I need to hide certain fields and replace them with a field that says no data is available. For example, in the code below, Graph110 is a horizontal bar graph that need...

My goal is to relieve the user of my Access database from having to go into the TransferSpreadSheet Macro properties and modify the File Name parameter to reflect where on their hard drive they have or want the Excel spreadsheet to be found or saved. I know I can write the macro as a VB...

I am going to use the following code to work my way through 32,000 records in a table and use a random number generator to select records randomly from varying-sized subsets of the 32,000 records. I know that the function will run much faster and be easier to write if the records are sorted the...

I had posted this question to the wrong forum, but received one response that left me with more questions: My Question I've used Visual Basic with Excel to look through my spreadsheet and make changes to "records" based on certain criteria. The syntax I used was: ActiveSheet.Cells(3...

I've used Visual Basic with Excel to look through my spreadsheet and make changes to "records" based on certain criteria. The syntax I used was: ActiveSheet.Cells(3, 14) = something where this would refer to the 3rd row, 14th column in the active spreadsheet. Is there a similar way...