Search results

: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

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

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.

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