Search results

here it is : ) I used "Distinct" SQL statements to build the rowsource for the dropdown combobox

haha ok : ) promise me some rep and I'll get it done : )! be right back with the finished product : )

HIii I think I did what you wanted I am attaching it. you are the first person I did this for : 0 so if I helped add to my rep, if you have more questions then ask away

I am stuck on my problem, I am waiting on help, so I am helping others to up my karma hahah

not to my knowledge, but it is possible to create your own masks

Hi Sven. When you reference a table- ie. A parent table to a child table You create a constraint called a foriegn key. This is how relationalship databases relate : ) The foriegn key has to reference a unique field or set of fields in the child table, the primary key. In the parent table...

I just took a quick glance but I think you might want to think about foriegn keys : )

hi karen add "distinct" to your sql statement

Hi Round I am having the same type of issue. How did you resolve this?

Hi transaction sounds great but what PB did for me was great. I had to play around with it alot because it was going through a button but its working great. I just needed a point in the right direction : )

I have a form I am working on and I want the user to be able to cancel his record update with a prompt. So far I have stopped every process I can think of that would update the record, except when the form is closed. I made vb code that resets the recordset to nothing before close and it...

1. My switchboard default is not opening when I access the database. I used a wizard to create the switchboard manager and made some aesthetic changes to it. Also, is there a way to put passcodes only on certain forms accessable through the switchboard? If you are using access 2007 click the...

I would take out Hoursworked and date and then I would use a clockin datetime and a clockout datetime. you can use datediff function to get the hours automated so there is no math. Each Charge Code is for a seperate clockin?

it decided to use a macro : ) is there a way to have a macro and a vba code assigned to one command button?

I have a form with a command button. I just want it to close the form. Any quick code?