Search results

Grimm this is what i have so far

Grumm Thank you very much, that is the idea how i wanted to work. One thing i notice it does let me go to a New record. For example today i select Work, And Lunch. Tomorrow i would like it to be blank to select new items, But i also want it to keep record of the items from today. I tired making...

sneuberg a million thank you,

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

velid, llkhoutox thank you for the information , was able to come up with a soultion

thank you for replying, let me try to explain a bit further, listed below is an example of how the table appears when a user enters an order. A user is able to put 2 of the same orders on the same DATE,ORD_TYP,LOCATION.This is what i am trying to prevent, we a user tries to put a order in on...

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

how did you get "FILLCombo" options, i look under the event tab for the selected combobox and did not see that event :confused:

arnelgp thank you for your reply. Will the code be the same if cmb1 is getting its values from tbl1 and cmb2 is getting its values from tbl2 ?

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?

sneuberg, I have a form that i enter daily activities, i call it Master_Frm. The form has Date, Activitie 1, activitie 2, activite 3. From there i can select different activities, when i do my subform loads to fill out the information. When you look at Master_tbl: Master_Id Date...

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

all, thank you for your help, i will not store it on the table, and recalculate when needed.

smig - thank you , using case statement works perfect

Minty - I have a combobox label cb1 that tracks employees , when I select certain employees I want combobox cb2 to be enable. I found the follow code Me.cb2.Enabled = Nz(Me.cb1.Value, vbNullString) Like "1" where "1" is the value of combobox cb1 (ID Field), so when I select the employee...

Uncle Gizmo, I did put it on cb1 after update event, it works find when its one value Me.cb2.Enabled = Nz(Me.cb1.Value, vbNullString) Like "1" but it I write it like this Me.cb2.Enabled = Nz(Me.cb1.Value, vbNullString) Like "1" Me.cb2.Enabled = Nz(Me.cb1.Value, vbNullString) Like "2"...