Search results

i suck at adding foreign keys to tables. and the online help hasne been very clear. each time i get a combo box and i cant get the right relationship established. in this case it is a many to one (employee to residence)

yes i have a residence table that has all the info about the houses. it is in a relationship with the employee table through 'occupant' and 'employee'. ill work on it and get back to you

also, i need to have the string address return and not the number. in the 'assigned_unit' field

permanent address is a string. the PK is an automnumber ID field. The address can belong to more than one person i.e a husband and wife that are both employees. and yes it is the address i am changing. i am assigning new address to incoming employees. the old ones will com out of the form via a...

how do i set a criteria to look at my combo box? i have never done this before and need some input from you. thanks Alex

I have a combo box where you can select a residence out of and 'available residence' query. i created a yes/no column to indicate when a house was assigned and placed it in the 'employee' table that the available query is based on. when i click the residence in the box it goes into a field...

I have a form that lists data about current and incoming employees. for the incoming employees that need to be assigned housing i have a combo box that lists all available houses for the year. these houses are those that belong to departing employees and are up for reassignment. after the...

so i have been thinking about this and i think the most straightforward approach is to create a query that is made up of all employees that have departed and is grouped by address. that will creat a simple reference for past residents. as for the form i think the easiest way is just to create a...

i have never created a junction table before and am not sure i know how to get the foreing keys in the tables like you say. each time i add a field i am getting a combo box.

I have two main tables: 'employees' and 'residences' I have created several queries including one that lists all the employees leaving in the current year and their residences. there are two forms, one for each table, where new info will be entered to update the tables or add new records. the...

i am currently working on a form where i have a new employee arriving that will be staying in a departing employees house. in the form i have an employee that is going to arrive and several bits of info, including his permanent address (to be assigned by me). when the employee arrives there...

you have to create a 'where' clause that specifies which record in the form you are viewing, for instance form 1, you want to match in the for you are going to open, for instance for 3. you could do and onClick event that looks like that Do.Cmd.OpenForm "form_name", acNormal, , "[field_name]...

ok its working now. i had to add the brackets to the code but it works just perfect now. here is the final version i have Private Sub Command45_Click() Dim rs As DAO.Recordset Dim strMap As String strMap = "Select [Google Map] From Residences Where Address = '" & Me.Permanent_Address & "'"...

the code seems to be pointing me in the right direction. when the dialog box comes up to warn about opening hyperlinks it is going to the correct location as it indicates. i still get the 490 error and when i choose to debug it highlights the last line of my code: Application.FollowHyperlink...

the table is called 'residences' and the field in the form is called 'permanent_address'. ill try to see what happens with your code. hopefully i can get this figured out today.

i tried your suggestion and i am still getting the 490 error that says "cannot open specified file" here is what my code looks like now: Private Sub LookUpMap_Click() Dim ds As DAO.Database Dim rs As DAO.Recordset Dim strMap As String strMap = "(Select Google_Map From Residences Where...

address is a text field in the 'residence' table. 'Permanent_address' is a text field in 'employees' table. i am trying to use these as a way to reference the links and return those.

I am a n00b with VBA and need some help. I have a form that lists data about hundreds of employees. in that form is an address column that is also in a residences table. I put links to google maps for each address in the residence table. I am trying to develop a button that on click will go...

my problem is similar. i have two tables linked to a form. the "address" field in the 'employees' table is linked to a hyperlink in the 'residences' table. However, in the form employees can be assigned a new address. i would like the links to appear when the newe address is given. i keep...

update: I have my form set up so i can add links into the 'residence' table and have them match up with the correct employee in the 'employee' table. the problem now is that the recordset is not updatable. I have a section in the form where employees are proposed a housing assisnment and then...