Thanks for this.
I want the field in the table to be completed so I am unsure of where to put the code?
Sorry I'm fairly new to access so still finding my way around it.
Thanks again
Fluffygoldfish
Last Activity: Sep 16 '10, 11:02 AM
Joined: May 7 '09
Location:
-
Default date needs to earlier previous field + 1 day
Hi
I have a staff database to record absence.
I have a field in a table "Return notified" to display the date we were notified centrally staff returned to work (this could be some time after they actually came back - major management issue!!)
I want the default in this field to be the "last day absent" (an earlier field in the same table) + 1 day. Able to be typed over and ideally... -
How do I show text not ID number in report?
Hi
I have a query in my database to return staff absence by team. As there are three levels of team (Service, Locality, Setting) I used a form with combo boxes for the user to select the criteria (combo boxes are based on tables with 2 columns: ID no and team name).
I have a report generated from the above, but in the service, locality and setting fields, it only pulls through the ID number not the team name. How can... -
Linking Unbound Forms
Hi
I have the same problem as describe by kfboren. But when I try to set the LinkMasterField s & LinkChildFields on the subreports, an error says "Can't build a link between unbound forms". Am I missing something fundamental here??
Thanks for your help!
** Edit - Split from Report, Subreports, Multiple Queries ** -
Thank you so so much for your help. I'd almost given up on it then, but managed to get it to work. Fantastic! :o)Leave a comment:
-
Ah I think I've made it confusing by how the fields/columns are labelled!
Original Table: Name, DOB, House Name, Street Name, Post Code
So for everyone that had two or more addresses there would be two or more records in the table.
I split it so that:
Client Info Table: Client ID (primary key), Name, DOB
Client Address Table: Address ID (p key), Client ID, House Name, Street Name, Post Code.
...Leave a comment:
-
Thanks! Yes it is normalised.
What I am trying to achieve is:
If in Client Info table I had:
Joe Bloggs
Fred Smith
(each with an individual Client ID number)
And then in the address table I had 2 address records for Joe Bloggs and 1 for Fred Smith. I could link the two tables by having a Client ID column in the address table. I want the database to find all the addresses for Joe...Leave a comment:
-
Hi Fish :)
Umm yes I think so, fairly new to access!Leave a comment:
-
Update column with content from another table based on criteria
Hi
I am trying to tidy up an access database that has traditionally just been used as a spreadsheet. I have split up the information into different tables and need some help transferring information.
I now have two tables:
Client Info - Client ID (primary key), Name, DOB,
Client Address - Address Id (primary key), Client ID, Address 1, Address 2, etc
They are linked (client info)... -
Autocomplete in Access
Hi
In my database I have a table to record absence. The table has a start date column and an end date column. As staff seem to often have one day bugs (a seperate issue to work out!!), I would like the end date column to automatically populate with the date that was put in the start column. But also allow it to be written over should they have something more serious!
I'm fairly new to access still, so hopefully its... -
Showing query results in forms
Hi
I am fairly new to access, but have managed to create a form and link various tables and queries to it. I have a table with a date of referral and another with client info in. I have created a query to calculate the age of the client at date of referral, but cannot find the best way to put this on my main form. Ideally I would like to have a sub dataset with Date of Referral, Age at Referral, Discharge (plus other related columns)....
No activity results to display
Leave a comment: