Recent content by CrystalVis

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.