Search results

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...

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...

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...

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...

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...

I been searching online but no luck so far. I have a subreport on a main form. I would like the subreport to grow to show all the items when the main form is open. I try using cangrow but no luck. I tried also using a subform , but also no luck. I would like the subreport to grow , so it shows...

I attached my database to help explain. I have a form with 5 combo box that select dates ( dates come from a dates table and listed in order by ID). I would like when a user selects a date in combo box 1 , combo box 2 - 5 will be limited to the next 4 date ranges. Example date is arrange...

Hi, i saw many post on how to automatically close a form after a certain time, ( example idle for 10 mins). But i would like to close a form on a certain DATE and TIME. For example users can open form called FRM_CHECKLIST but when it is FEB 20 at 4:00 pm or a later date and time they cannot...

I have a form where i would like users to select information from listbox1 ( its source comes from tbl_task) and move it to listbox2 where that information can be save in tbl_daily_task. I only need two command button, one to move the items from listbox1 to listbox 2, and one to remove items...

I search a few forums and how to prevent a user from entering duplicate item. i have a main table called MASTER_TBL. MASTER_TBL has a DATE, ORD_TYP, LOCATION fields. I would like to prevent users when they enter the same MASTER_ID,DATE AND ORD_TYP AND LOCATION, they will get a msg box notifying...

I learn share point isnt the best tool but I have a database connected to share point. In a traditional split database I was able to have multiple user at the same time use the same front in from a common location. I notice when we try this to a front end that was connected to share point we got...

A nice feature in access you can put your own icon.that works great when your database is local and you can link your icon file ( example c://photos/custom.ico) But what it you want your database to be use in a different location. Is there a way to store the icon within the database so anywhere...

I have a daily summary report that list the names of reports that was filled out for the. Given day.i would like to click on the report name from the main report and it will open up the report that I click. Fox example today main report shows that we fill out Clean log,Supplies update,Safety...

I seen how to set up dynamic combo box when you select a value in one combo box it limits the value in the second. I have two combo box cmb1 and cmb2. Cmb1 has days of the week (mon,tue,wed and so on).cmb2 has activities ( football,study time,tennis, free play).cmb1 and cmb2 does not have a...

Hello, I was wondering what would be the best way to deploy a front end access database , using SharePoint as the back end? Which deployment has the best way of keeping my users with the most updated front end?

I have a database for daily activities, in the database Master_tbl keeps track of which forms I filled out for the day. I have separate reports for each table, I would like when I select a given day it will only pull the reports for that day. For example one day I might fill out Clean-up log and...

Hi, I have two combo box (cb1, and cb2) I would like to enable and disable cb2 when certain values in cb1 is selected. cb1 I have two fields ( ID ,Reason). I used the following code, which works great when I use one value after the like statement. ( when I select ID 1 on cb1 it disables cb2)...

I have a table called tbl_Employess. The table is use to track a daily checklist. I have one field label " Check_Complete" which is a yes/no and another called "Resolution". I would like under "check_complete" when someone selects NO, it will automatically put "Turn over to other shift" in the...