Search results

Hi, Sorry, The fields to be tested are Telem Fwd & Telem Aft (within the Aircraft Info table) I want to test to see if there is a numeric value in either or both fields. If there is, then the macro will set the subform Telem Freq (within the switchboard) to visible. If there is no...

:banghead:Hi, I'm trying to create a Macro (as I'm not familiar with VB) to set a subform within my switchboard to visible. I have mastered that part. What I am struggling with, is setting the condition to set the subform to visible. The condition is based on one of two fields (either...

Hi, I would like to use the setvalue command within a macro to change the record source of a form from one table to another. I have entered [Forms]![T/C Mux].[RecordSource] into the item part. I have not been able to come up with what to put in the expression part. The two tables are called...

Hi, I'm a little confused as to what is going wrong. I am using the default switchboard to create menu options for a database. In that menu I have an option to open various tables. The final option is to close the current switchboard menu and return to the previous menu. I can create this and...

Hi, I have a form containing a subform. Currenty the sub form is invisible. I would like it to become visible when I click a command button. Is it possible to do this? If it is, Can it be done in expression builder and how? Thanks Steve

I have two tables. One has been imported and contains 27 records. The data contained in some of the fields is identical. i.e. issue name and number. I wish to update another table with the contents of the issue name and numberfrom this table. This I have managed OK. The problem is that I only...

Is it possible for a table field value to be set by the value of another field within the same table? Regards Steve

Thank you. It worked a treat!!

Hi, I have a table with a field that contains a four digit number. What I would like to do is select the numbers that begin with 6***. Then I would like to make them 5 digit numbers so they become 26***. Is there any way I can do this. Selecting with wildcards OK, updating seems to be the...

Hi, Still being a new to access, I am looking to restrict users from design and layout views with in a series of databases. The databases will be maintained and any changes made by 2 administrators. My requirement seems to be heading towards using users & permissions. I have a very limited...

Hi, I'm looking to display the contents of a field on my switchboard page. I have tried using expression builder to call up the contents using a text box and a combo box. All I get is a blank cell with the contents on the selection of the combo box or just blank with the text box containing...

Dave Thanks for your assistance. It now works. Steve

Sorry, I'm new to Access and a little unfamiliar with what you have written. If I lay out what I'm after then the command will be clearer to me. Form name = Calibration Information, Text box name = CMonths (numerical value) Report name = Parameter Cal Due, Title required = Calibrations due in...

Yes, It's Unbound

I have a text box containing a value on an open form. Can I display the value contained in the text box on a report that is subsequently generated by the form? If so, how? The value of the text box forms part of the title of the report.

Thankyou, It worked first time!!

I have a database in which I perform an update query on startup to update a field. The field contains a numerical value. What I'm looking to do is to have a text box on the switchboard form showing the number of occurances within the updated field which are below 30. I'm not quite sure what the...

I have a table in which one field is a list box. When I use this field in a report it is displayed again as a list box with the scrool bars. Is there any property I can change to display the field within the report as a normal text box?

Hi, The characters can be the same but only in different records. Basically the character is being used as an identifier for the queries to reduce the number of records for the report to display. Steve

Hi, I'm new to access and i have a question. I have a database with one field that can contain any number of characters. I have a number of queries looking for individual characters within the said field. What I am hoping to do, is to have one report that can display the results of any one of...