Search results

great! thanks for the tips! joe

Hi Everyone, I am fairly new to the whole Database thing, so hopefully you can help. So i created three tables; MONEYOWE.tbl, INVOICE.tbl, and PAYMENT.tbl. Basically, moneyowe.tbl is how much a client owes me. Invoice.tbl is the invoice i'll send the clients, letting them know that they...

Hi All, I am fairly new to Crystal, so still trying to learn. i am creating a report where i am able to get some good results, but now i am getting duplicates. Please see sample results: 0000018573 15 01 12/31/9999 1415 01FNR GARY JAMES 0000018573 15 01 12/31/9999 1415 01FNA GARY JAMES...

Hi, I created an Access form with a list box. The "row source type" is from Table/Query. My source table is sorting correctly(ie, 2008,2007,2006, etc.). HOWEVER, when I open my form, the sort order is incorrect; they are not in the 2008,2007, 2006, etc. order. Please advise how I can fix...

Oh...ic....ic. You "link" the table and NOT import the table to get the structure right. THank you all! Leon

Hi, I imported an Excel spreadsheet into Access. As you know, Access will automatically create 255 characters size for each 'text' datatype. Now the issue is, when I create a query and I specify Right([Field Name],3) I get no/empty results. I know my query syntax is correct, but the issue...

I'll be doing this maybe once every 5 years, so your method will do for now since it is a last minute thing. My email is joesmithf1@yahoo.com Thanks again! Joe

Hi MistyEE, Please do give me the Excel vba method! Anything is better than having to repeat everything manually. Thank you! Joe

no, the users do NOT pick any combo box. I simply wants to add records to my table, no users interaction whatsoever. The idea is, my company just added about 50,000 new GradeCodes and each separate gradeCodes(according to its alphabet) has a different % applied to the SalaryAmount. So instead...

Hi Wayne, Thank you VERY much! To clarify your question. What I am doing is, I currently have all the A,B,C,D...Z gradecodes, and I need to add more grades codes(with different % of salaryAmount applied to each NEW codes). But instead of manually go into to my database to add(potentially need...

Hello Everyone, I know the 'basic' stuff(like creating tables, simple forms, reports, etc.) but I am not too good with the advance stuff. Here is my table structure and data setups, and then I will list my issue. I have a table with two columns, "GradeCodes" and "SalaryAmount."...

Hi, Thanks! But this didn't help. I followered the steps but the query only return the top N records of the entire table. For example, I specified the top 3 record so all it(the query) did was returned the top 3 records, it did NOT return the top 3 records of EACH INDIVIDUAL in the table. Any...

Hi, My question 'sounds' easy, but i can't think of a way to do this. Please help! Ok, i have an 'employee' history table with 200K records. Each employee could have multiple records with different 'effective' dates(please see below for an example of two employees' records). What I want to...

This make sense. Thank you very much, Moniker! I was hoping i wouldn't have to program it. I'll try your method. Joe

Thank you Moniker for the explanation! Actually, what Namliam suggested is exactly what I wanted; just mulitple entries for a specific field in a table(not multiple fields). Now maybe you guys could help me with this. I changed the codes to IN([Enter Repunit]), then when I open the form and...

Hi, I know how to create a parameter query where users could enter ONE criteria each time for a particular field of a table. Please see codes below. Now is there a way I can allow users to enter more than one criteria SEPARATED with commas for a particular field of a table? Thank you. Joe...

Got it! Thanks, Paul! Leon

Hi, Thanks Paul. Where would I insert this "debug.print" command in the SQL string? And would I put it in both the Query Design veiw and the Script view?

I may have failed to mention that the 'run on background' i mentioned earlier meant that I am running VBScripts on the form. Here are my codes; query design view and then script 'behind' the form. Query Design View:SELECT DEDPARMS1.EMP_ID, DEDPARMS1.FORMAT_NM, First(DEDPARMS1.DEDPLAN_CD) AS...

Hi, I have a query which I run in the query design view. Then I have the same exact query which I run on the 'background' of a form. The issue is, both queries turn out to have different record counts(eventhough I am using the same query and same tables). What is going on? Please help...