Search results

I have two tables Isaac which are related. Table "Tenants" and Table "Lease" as you can see in the pic. I have the lease table as a sub form to display the data in one form. I know that data is from table to table. I am just looking for some suggestions as I am not an expert in this field. I...

Yes, its Back and and Front End. I was able to append the records from the main form and NOT from the subform "Lease Details". I tried all kinds of ways. I need to be able to transfer the one record from the main form and all related records from the subform. I just want to move a file to a...

I inadvertently created a back up of the database so someon1 was entering data into the copy DB and I was entering data into other. I just want to have all records in one DB. Ok, I will try Issac's suggestion. I will let you know how it turns out.

Its two copies of the same database. I was entering data in one and by error some people were entering into a copy of the database. So instead of re-entering all those records. I was thinking something like Issac has suggested but I am not sure how to do it the right way. I don't understand how...

I have records in a database that I would like to transfer/copy to another DB (Same fields) I am not sure how to do it. I have two tables which are related in a form. The main table is "Tenants" and the subform is "lease". any help would be appreciated.

Pat, I did the option groups for "Type of inspection, Housing type and Summary Decision" but I am stuck on how to do the following items (1. Living Room Present) etc. I attempted to use an option group but I only end up with one option per column and I need 3 options per row (Yes Pass / No...

Great! thank you so much for the free download and thank you for your patience. I will try to apply that to what I am doing. I will let you know how it turns out. Thanks a million again.

Thank you for your quick response Gizmo, I saw checked out your videos and the seem a bit overwhelming for me since I am not a programmer. Can your sample be customized to fit my needs without much coding. you can email me here if you prefer. platanudo@hotmail.com thank you.

Hello, I need some advise on how to build this form. I created the first page but it seems like I have to create way too many check-boxes. The access report must look like the "HQS Form" attached. I created a check box for each Yes, No, Inconclusive field but if you look at the HQS form I have...

arnelgp please help, how do I put the result for label38 on a report. I would like to display the result on a report. Please help. Thank you.

Thank you for your well observed suggestion. I will follow your advise.

Arnelgp, that is exactly what I was looking for, but i am new to access. can you give me some instructions how to implement this to me DB ? since I uploaded a sample DB. Thank you very much.

Hello, I need some help with the following situation. I need to display the results from a number of selections to a text box if some selections are made. I have included a demo DB as a sample. I have about 7 lines with 4 options each. Example: Heat = Natural Gas, Electric, Oil, Propane and a...

Excellent! that did it. Thank you very much. (y)(y)(y)(y)(y)

Look at "Lease" form and that's where I need the date in the field. and ultimately in a report.

I compressed the DB and put it in a zip folder 24.6 MB. it still says the file is too large. I only have two records in the DB. The name Lease Extended is the name of the query that joins "Tenants" and "Lease" tables.

Gasman, I get an error message (#Name?). Let me try one more time since not having the correct info is difficult to figure out and I understand. Image1 shows the field "Original lease date" where I want the result in. Look Image2 two see the control names and Image3 is where I would...

GasMan I am sorry, I am new to this. This is my first DB I am working on. Thank you for your patience. I don't what FK means. I followed the link and this is what I have In the query I typed =DMin("StartDate","Tenants Extended") i get only one date for all the records. I need each...

Field Name: StartDate Table Name: Lease The same field name holds all the dates for the contract. I would like to display the original contract date and the current contract date on the report, so the original date has an ID # and every time I create a new lease date the new date gets an ID...