Search results

Softboss.. Thank you very much, you are right it is my lucky day... Just what I was looking for!!! R~

Bob.. Thanks.. I didn't even think about that..... Thanks R~

Hello.. I have a simple database of 4 tables. luTblJobTitle JobTitleID (pk) JobTitle luTblReason ReasonID(pk) Reason tblDateReason DateReasonID(pk) EntryNumber(fk) Date Reason Entered tblEmpMain EntryNumber(pk) EmployeeNumber Etc// I have a 1 to many setup between tblEmpMain and...

Keith.. Thank you very much.. I am working on it as we speak. I will let you know how it works out!! Thanks again R~

Hello.. I did a search for compare and difference but I didn't find anything I was looking for. So I am asking.. Is there a way to compare two spread sheets without manually doing it? I want to see what is in one and not the other so I can base a report off of it. IE spread #1 a b c d...

Rv.. Thank you, just what I was looking for. R~

Hello.. I have the following code that generates my report. {CHCustomFieldMap_T.CustomFieldID_TX} = '7A64DD0DE60E46E58FB507B02DC4C57B' AND {CHCustomFieldMap_T.CustomFieldValue_TX} In ["02/07/2007"] How can I add a counter to the end of the report? R~ I am new to CR and I don't know if...

Can you see the tables? Do they have a little arrow next to them? You might be opening up the back end of the database.. R~

Thanks for the link thou.. there are some really good points in the article. R~

Diamond. Can you explain why it is more flexible to run a query off a query the way you explained. I am new and was just curious as why you would do this. Thanks R~

Keith... Thank you very much, worked like a charm. I was trying out comma's etc... and it was the word "and". Thank you again R~

Criteria query help I have a query that works fine (based of a table). I have different job titles that I want it show me, however i only want to see jobs 5-10 not 1-4. My table looks like this: 1.Service Center 2.Computer Tech 3.Computer Sales 4.Manager 5.Supervisor 6.Supervisor Tech I...

RG.. Thanks a bunch!!! Worked like a charm.. R~

Hi all.. How can I get it to just requery a combo box on a form. I have a form that opens to add a city. Once you add a new city you close the form and it requeries the whole form. I just want it to requery the combo box. Is this possible? I used Rich's suggestion and that works fine..

Rich.. Thank you just what I was looking for... The only thing I had to change was to add the " = " sign infront of the Sum.. Thanks again R~

I have a feeling you might need to base your combo box on a query and then have that query update your table if something new is added. Does this make sense? Sorry I don't know how else to help you... Hopefully someone with more experience jumps in.. R~

What "0" are you deleting, is it in the drop down list or is it in one of the property fields. Just want to make sure we are talking about the same thing. Did you use the wizard to setup this button? R~

Yes... Select the combo box then right click properties>>Format>>Column count = 2 >>Column Widths 0";2" This should show the text not the number. R~

yes select the text field go to the properties>>data>>Input mask>> then select what type of date format you would like to use. When the user clicks in the field the input mask will be there and they can just type in the info with out having to enter the "/" etc... R~

Bob.. Can you see what I am doing wrong? I have tried several different ways and I am still haven't been able to get it to work. I am trying to get the last name of the FOS and the last name of the applicant to show up like you did for the investigaters name..... R~