Recent content by scopes456

Hi all, I was doing some research but could not find an answer. I have a database that i use to assign projects. One the form there is two combo box. One combobox has a list of all the projects [cmbProj] and the other is Priority [cmbPri]. What i would like to do if i select a project and a...

all thank you for your help, i will look at a redesign but you all set me on the right direction, i was able to use sneuberg code.

Hello All, i have a table that use to track employee training. The table has multiple columns with Date information on it. ( see example below)I would like a query to find the columns that has a due date 12 months form the date in the column. ( for example under CPR for MIKE , he did it on...

i have a database that i would like to find records using a QR code. Is this possible if i have the QR code listed for the given record i would like to find. The idea is to have an employee scan the QR code, it will either enter the code in the search field in the database , or automatically...

pbaldy can you give me an example how to use "OutputTo" VBA. Listed is the name of the report and the field I would like to attached so it can output to " LOG-AUG 11-2016.PDF" Report Name - LOG Log_Date - Date Field.

My prayers goes out to you and your family. Thank you for all the knowledge you spread throughout the years.

i have a report (LOG) that i can attach to an email using EmailDataBaseObject Macro. When the macro is used attachment name "log.pdf" is used since the report is called log and in pdf format. On the report it has a date field (date_log) i would like the date to be part of the name when the file...

sneuberg thank you

I have a database I use to handle orders. I have a pdf template that when a new order is added to the system my users attach this pdf to the record. I would like when I create a new record that the attachment is automatically copy from a default location onto the record. So users does not have...

ALL, thank You , i was able to solve it using a combination of selecting the control source

JHB thank you for your reply. I attached a db where I try to use the control source to link the combo to tbl_master. it will not let me go to add a new record.

Good day, I have a casading combobox (cmb1 and cmb2) they both work fine . The only issue am having I would like to save what the users select in cmb 1 and cmb2 to a tbl_master. In tbl_master I use Mst_ID to keep track to the records I want to save to the table. I try placing that in my form...

Good Day, I have 3 combobox of a main form. ( cbm1,cbm2,cbm3). All three combobox get their data from the same table (tbl1). What i would like to accomplish after selecting an item in cmb1, when i go to cmb2 i cannot select the same item that i did in cmb1 ( i do not want it to show on the...

sneuberg thank you. This is what I was looking for. I am just wondering, see how you have TestData Form on the main form, and when the main form opens , TestData Form goes to a height to see all records, What if I have another form right under it, would there be any code to "push" that form...

bob fitz thank you for showing me how to do this. I was able to put it on the other combo box and works perfect. missinglinq thank you for telling me the name of the concept I was going after.