Search results for query: *

That is what i thought just need confirmation...yuck :)

When I placed an order on hold a record created in sop10104 with a hold date of 7/30/2015. when I release the order today, GP update the hold date to 8/13/2015. Does GP move the original hold date 7/30/2015 to another table or just simply update the date? Your help is greatly appreciated...

PHV, i just apply your suggestion by going into each control in the detail section and set it to the corresponding field in the dbo_tblTasks. when i run the form, i see #Name? in each control but still nothing display when i select a taskcode in the combo drop down and click search. anything...

below is my latest code with the form requery as you suggested. still nothing happen PHV, Are the controls of the detail section bound to the new record source ? how do i check this? thank you Private Sub cmdSearch_Click() Dim strMsg As String Dim strSQL As String 'If...

like i say, i'm very green to this. what does that mean? i select a task code i know that is existing in the task table. what does RecordCount have to do with the record existing in the task table and when i select it does not show in the form detail section?

i forgot to mention that no data display in the detail section and no error/warning message return when i click search. thanks

Thank you all for a quick respond. i removed key word 'Set' as you suggested. Now when i select a value and click search, nothing happen? can you please advise.

i'm using Acess 2003 front end and backend is SQL Server 2000. i created a blank database and link it to SQL Server via ODBC. i'm trying to create form so the user can search/update/add record to a table. on the form header, i have a combo box base on the task table, once the user select a...

I need to collate all data by company and accounts for the current year. you can see from the case statement that i want to aggregate the amount from the beginning of the current year up to last month of the current year. however, when i get to Jan of a new year i need Dec of the previous year...

Anyone in the forum can help me with this? thanks

hello experts, i'm creating a simple form for my user to add data to a sql table. on the form i have a combo box that pulls the emp_id from the employee table. i also have 2 text boxes. text box1 displays employee first name and text box2 displays employee lastname. the values in the two text...

techie2, thank you for your respond. can you please provide more detail or point me to the documentation that shows how to write Processing Extension. I'm not farmiliar with the web/server site processing. your help/suggestion is much appreciated.

Can other experts in the forum please help me out with this obstacle. your help is much appreciated.

Ido, we are using CE ver 8.5 and SQL Server 2k. We want to use Active Directory user info to restrict the data. is it possible to accomplish this in ver 8.5? if so, will you please explain or point me to the document that describe how we can go about accomplish this. your help is greatly...

cmmrfrds, i'm using CE version 8.5 and SQL Server 2k and wanting to restrict data to the login in user. is it possible to accomplish this in ver 8.5? if so, can you please give me the steps or explanation of how i can accomplish this. your help is greatly appreciated.

Hello All, I'm using CR version 9 and Oracle 10g. How do I get Crystal Report to use stored procedure as a source for the report? Any help or suggestion is greatly appreciated.

you mentioned in the initial posted that you are working with SQL Server 2k. how do you get the oracle error message? anyway, it seems like there is a table missing in the query at the FROM clause. i think it should look like this if oracle is the backend: SELECT AKA.MEDIA_CODE FROM SALES_ITEM...

i believe i'm experiencing similar issue here. i installed orcl 10g successfully on my laptop (wins xp pro). after the installation, the IE launch and i was able to log in to Enterprise Manager with the sys account. i bookmart the url in IE. the next day, i try to login the Enterprise Manager...

I just install Oracle 10g to my laptop. the installation was successful. the last step, i change the password for the System and Sys accounts. Now when i try to connect to Enterprise Manager in IE using either account, i received a message indicates that these accounts were locked. can you...

i worked with Oracle a while back. all joins are done in the WHERE clause. left/right join is indicate by *=/=*. i thought this is strictly Oracle prefer method. where in sql, all joins are in the FROM clause.