It worked! Had tried In("Etc") before but the syntax was wrong. A million thanks.
B
brynne
Last Activity: Mar 29 '07, 04:18 PM
Joined: Mar 19 '07
Location:
-
If, then, else statements
Can someone give some advice? I am not big on VB scripts, so am trying to write an expression in an update query that is designed to populate a field which I will use as the email first letter. If the rank is SC then the prefix is "s", if the rank is "Admin" etc through to "SRO2 then the prefix is "c" otherwise the rank is a police officer and the prefix is "p". The letters s or c or p are entered into... -
I have used the 'Indexes' definition button in design view to create a composite primary key. For a job evaluation database, I need both a unique number and a code to specify the job type. I created a primary index by including both PostNo and PostGp.
BLeave a comment:
-
Hi there,
Usually the primary key in a table is used as the foreign key in another linked table. No need to create a separate identifier for that purpose, e.g. if your primary key in the Appliance table was ApplicanceID of type 'autonumber', you would link it to the Room table by creating a field called ApplianceID with type 'number'. This is then the foreign key for Appliance in Room.
If you have specified the primary...Leave a comment:
-
Hi
I think you need to select the field you want to update twice (side by side, so to speak). In the first instance you show the criteria for the update, and in the second you show the update to.
BLeave a comment:
-
Hi
It doesn't really matter how many fields your Job table has, as long as all of the information contained in them relates directly to the Job. Likewise for client. However, it seems to me that you might need an intermediate table linking Client to Job, as (one would hope) that you will have many clients and many jobs. The intermediate table is the way one creates the necessary many to many relationship.
To give...Leave a comment:
-
No reason why I need to print letters in Word at all really. Seems the simplest solution will be to recreate the letter as a report in Access.
Thanks to all.
BLeave a comment:
-
Apologies to the more advanced developers in this forum. I don't do much VBA programming so most of the functionality in my databases is based on simple queries and macros.
I would create a new form with one or more unbound text boxes into which the user would enter the desired criteria, e.g. month, contract. (This must match the data type for the field in the table you are running the query on, so I often use a drop down list to...Leave a comment:
-
Hi Mary,
Thanks. I subsequently wondered whether I might get round the problem by creating a field that contains an array, e.g. AppID, AppName, IntTime, new line. I am sure I did something like this for a programming exercise (in Pascal!!) years ago, but I am not familiar enough with VBA to know if it is possible.
Does this sound feasible?
BLeave a comment:
-
You can display data in tables, forms, queries and reports. Tables and queries are formatted like a datasheet, the difference being that you can link tables in a query so show selected fields from two or more tables. From the design point of view, forms and reports work in a similar way. You can base them on either tables or queries and drag and drop the selected fields onto the background area. Forms are used principally to facilitate data entry,...Leave a comment:
-
Hi Charlie,
I don't write much VBA either (although I have a bit of Pascal and C+ experience). Are you sure you need to embed the Excel object? Could you not get round the problem by simply exporting the data into Excel? My experience has been that once you have created your spreadsheet and all the cells are correctly formatted and the functions working, one can quite simply replace the data by using the export facility on the File...Leave a comment:
-
Sounds like a relationship problem. Without telling us a bit more about the data that you are trying to record, it is a bit difficult to advise you. Are you familiar with the concept of 'normalisation' ? It may be that you need extra/intermediate tables to record the data correctly. You can link all the necessary tables together using a query, then create a form from the query.
B...Leave a comment:
-
Insert 'subform' in Word mail-merge?
I run a recruitment service for which, years ago, I set up an Access database to record details of job applications and run various mail merge functions including interview invitations, reference requests and panel letters.
However, my letters contain only the details that can be recorded in single fields. e.g. title, first name, last name, address1, address2, etc. Currently, where lists are involved, e.g. names of the interview panel,...
No activity results to display
Leave a comment: