Search results

I have a form with an Auto number field. When the form is opened in new record mode the auto number field displays the following: (Auto Number) instead of the actual number that it has generated. I want the number to be displayed

that worked fine, thanks

I have a form with a text box that the user enters their name into. When they click submit a menu form is opened. I want the name that was entered to be carried over to a field on the menu form. This will welcome the user, eg: WELCOME John Smith. Im thinking that i should use the INSERT INTO...

Hi i cant seem to find the default view option within properties

I have a form with a sub form. The parent form has a field called 'ReportedBy'. The user enters their name in this field. I want the subform to display all records that have been created by the name in ReportedBy. I have based the subform source object on the following sql query: SELECT * FROM...

Where in Access the functionality to link the two db's

Is it possible to create a database and link this to a form and another database? What i want to do is link a network database with a local database on a client machine?

I want a specific Excel spreadsheet to open when users click on a command button. I have tried using docmd [spreadsheet path] but this doesn't seem to work.

I have a report which details employee activities. Employees enter the jobs that they have completed throughout the day then a report is run by the manager in the evening. The current report shows a list of jobs completed by each employee's name. I also want to include a summary at the bottom of...

In design view right click the left hand corner of the menu bar on the form you are trying to edit. From the drop down list select 'Properties'. The caption attribute is listed on the poperties menu that should appear.

I have three combo boxes (name, team and activity) and a text box (comments)on my form. When the user has selected their name, team and activity and then entered relevant comments they click save this then saves the record to the table. I have used the following statements as on click events...

Thanks John that worked perfectly! :)

I want to stop standard Access messages prompting the user. For example When i run a delete query through a form the following is displayed: 'You are about to run a delete query that will modify data in your table'. My users don't understand what a table is and they don't need to. I want to...

I have three combo boxes (name, team and activity) and a text box (comments)on my form. When the user has selected their name, team and activity and then entered relevant comments they click save this then saves the reord to the table. I have used the following statements as on click events...