Search results

All of my forms have a set of buttons (add record, save, next, last, etc...) Is there a way to for me to make some kind of a macro that I can add to a form so I don't have to re-create these buttons every time I make a new form? BTW - I'm pretty new here, so I haven't done much coding - i...

I am helping a non-profit set up a database of resources for their clients. The ultimate goal is for a client to come in, state their need (eg. immigration lawyer), and for us to to be able to pull up a listing of lawyers (or pediatricians or....) Some resources have multiple areas of specialty...

I am using the Button Wizard to open a form. When I review the property sheet under Event - it calls up an Embedded Macro. How do I get it to be an Event Procedure automatically instead of an imbedded macro?

In the subform (which is the many side of a one-many relationship), I would like to be able to add new records. I would like to have the client_id from the parent table (which is open in the main form), auto-populate into the table that is opened with the subform. At the moment, if no records...

I worked on a database at home, and then emailed it to the office. When I unzipped it at the office, it will only open in read-only mode. Any way I can convert it so that I can update the forms/tables etc?

In design view, my form looks perfect. But when it displays in Form view - the spacing is way off... Is there a way to have the design view in WYSIWYG?

I am trying to add a button to a Form that will open another form. THe secondary form is already designed (Assistance Requested) When I start the button wizard, I select : Form Operations Open Form (click next) Select: Assistance Requested Form (Next) Select: Open the Form and find specific...

I have a few forms that I have designed where the fields are stacked one above the other. It looks fine in design view. But, as soon as I access the form from another form- it only appears in datasheet view. Even when I'm in design view, if I click the icon to view Form view - I see the...

I am new to Access, and am helping a non-profit set up a database system to track the clients that they assist. Because I'm only in their office once a week, I am doing much of the work at home. In between my visits to the office, the volunteers at the non-profit enter data into the tables I...

In my form, I have FirstName and LastName fields displayed. I would like to trim the spaces and have the two fields concatenate for display purposes. I have tried going to the field Properties in Design View, and then attempted to make an expression something like: firstname & " " & Lastname...

3 Tables Main Table: Clients Child Table: Skills Child Table: HelpNeeded All linked with field named ClientID I have a form (Form1) which allows me to enter personal information for each client - one record per client. From this screen, I would like to open a 2nd window in which I can update...

How do I separate the label from the actual field when designing the form? When I click on one to resize or move - they both move. Every now and then I accidentally am able to separate them and treat them differently - but I have no idea how I did it!

3 Tables Client Skills AssistanceRequested 1. Client table has a field called Client_ID that is auto-numbered automatically by Access and becomes the unique primary key for the client. This table stores personal info (name, address, phone, etc.) 2. Two additional tables are related to Client...

I'm brand new to Access , but trying to get up to speed. 2 Tables: Client & Needs Client contains all the personal information for the client (name, address, phone...). The primary key is Client_ID Need Table: Just a few fields: Client_ID, Request, Date When a new Client is entered into the...