Recent content by sefa333

Thank you very Much. It works great!!

Thanks in advance for your help. I am still new to Access code. I was wanting to know if there is a way to Add the Username to a table as a default value when a new record is added. I know you can add =Date() to get the date. Is there a simple way to get the ID of the person logged into Window...

Thank you for taking the time to answer. this will work out great. I am sorry if you think you are wasting your time. Thanks agian.

Is there a way to filter only select forms. We are using the following in row source of a list box SELECT msysobjects.Name FROM msysobjects WHERE msysobjects.Type=-32768 if i put something in the form name, maybe? example (Form1*)

Sorry, when I ran the form the list box it kept coming up blank. I noticed that my row source type was blank. My mistake, sorry. It works now. Could you give me an idea on how to filter out forms that we only want to show? Maybe if we put and * at the end of the form name. Is there a way to...

I am new to access and still learning. I am looking to do the same thing. I opened a form in design mode, added a list box, opened property box and added this to the row source SELECT msysobjects.Name FROM msysobjects WHERE msysobjects.Type=-32768 Ran form, but it does not work. Please help me...

Good Morning. I have 2 combo boxes on a sub form, one is called BOP Parts & the other is call Condition. I am tiring to get the BOP part combo box to change background color to green when the condition combo box is changed to “Good”. If this is possible please help me in how and where I would...

the front end is where everything happens. the back end is only where we store data to be retrieved so it need to go in the front end. thanks for helping me to understand what to do and why to do it. this is the first project i have worked on for a company. i will have a lot of question. could...

the append query will send it to the table. so the back end i would assume.

Sorry. one more thing. i am using a copy on a database(that is not split) to get all of this to work. when i go to put this into the functioning database that is already split (front end and back end), which end do i put the module in or does it matter.

ok. thanks. i also ran it in a query and it worked. thanks for all your help.

ok. it worked in a text box, when i put in the Default Value in my table is gives me an error message-- unknow function 'FOSUserName' in validation expression or default value on 'Table1.empname'. Sorry I am on a network. the text box show my #. is it possible to convert that to name. thanks for...

yes i got the link. trying to figure out what to do and how to do it.

I'm sorry i dont understand function name in the Default Value property. what funtions name? and are you talking about the Default Value Property in the table. If so what am i putting there (i.e. =Currentuser or something of sort.) sorry very new to Access. thanks

current machine/network.