Search results

Thank you for the help again. I still cant get it to work. Here is a link for my database ) it is too big to attach: https://www.dropbox.com/s/b2qhm9vjscz6zva/Database%20V1.accdb?dl=0 (It is a working progress) for you to take a look at if you don't mind :) Here is some navigation tips for my...

Thank you for the advice and help guys. I have put the code into a separate module (CheckPlotCompleteM) as suggested. I am now getting an error which was expected as previously stated. I am getting the following error: Runtime error:2450 So the access is saying the form must be open for me to...

Thank you for the reply. If I was to change Private Sub SetCheck212() to Public Sub SetCheck212() Would I have to change all the other private subs that are calling the public sub to public as well? Then I assume on my other form modual I would call the public sub in exactly the same way?

Forms only display data (they dont actually contain and data). So this means you can not base a report upon a form or sub form. Reports are generally based upon tables or querys. I would create the query and base the subform of that query as previously suggested. Then base the report of that...

Hi guys. Okay I have a Private Sub on form PlotF: Private Sub SetCheck212() If Me.[Check161] And Me.[Check169] And _ Me.[Check167] And Me.[Check181] And _ Me.[Check261] And Me.[Check189] And _ Me.[Check187] And Me.[Check195] And _ Me.[Check203] And...

I would make a query. You would have to reference your control in the query (your combo box) in the criteria section on your query input the following: [Forms]![FormName]![ControlName] Replace FormName with the name of your form Replace Control with the name of you control (Your combo box)...

Hi plog, This is just a little sample database that I quickly made. My main database has confidential information in it so my boss would not like it being posted online. I think that this is the only place within the database where data will have to be generated automatically. Thank you for...

Thank you!! That has helped a lot!! :)

Hi guys, I am new to access, I still consider myself a newbie. Please if anybody posts anything try to dumb it down a little for me :D So I have a quick database that I have made please see attachment. On the CheckboxF form I would like Check 1,2,3,4,5,6 to be checked manually but when all of...

I don't know really. I understand it is easier to find them later on down the line but I figure it doesn't take to long to just look back at them. I need "Check212" to make the field "PlotComplete" true so that this will display on my continuous form. I have just read up that continuous forms...

It worked on my single form, But I have just realized this was already a bound checkbox. This is my new control source: =[Check161]+[Check178]+[Check169]+[Check167]+[Check181]+[Check192]+[Check261]+[Check264]+[Check189]+[Check187]+[Check195]+[Check206]+[Check203]+[Check201]=-14 Can I make it...

Worked perfectly thanks MarkK!

Thank you for the replies. I am very new to access so only know the basics for now I am taking lessons though so hopefully I should improve quickly. I will try your suggestions now :)

Hi guys, I have a form with 15 check boxes on all together. I want the "15th check box" to check to true automatically when the other 14 have been manually checked. I have used a Tag for all of the other 14 check boxes they are tagged with the word "FILL". Here is my code: Private Sub...

Hi guys, I have been tasked with building a database for the company I work for. I am new to access so I have signed up to gain knowledge from everyone :)