Search results

Sorry, Didnt check the forum lately, you can try the Left(), ex. me."your textbox" = left("your control box",4). If you want to display only the first 4 string in your control. Paki cc mo nlang sa e-mail ko yung mga questions, minsan wala nang time para mag view. otnobj@yahoo.com Hope this...

Wayne, Attached is the 2K version, I know the SQL still need a lot of working, I am just resting for a while to sort out the needed lift. Please let me know what are the changes I need to do, or can you get it done without using SQL? Thanks.

SELECT tab_customer.po_cust, tab_customer.po_date, tab_customer.po_number, tab_customer.po_error, tab_customer.po_note FROM tab_customer WHERE (((tab_customer.po_cust)=[forms]![Form1]![cboCustomerCode]) AND ((tab_customer.po_date) Between [forms]![Form1]![txtStartDate] And...

SOLVED Merging Multiple Columns in a query! Below is the SQL statement I used to get the result: select Employee , "Renewal" as Reminder , Renewal as [Date Renewal] from Query5 order by Employee union all select Employee , "PassportExpiration" , PassportExpiration from Query5 order by...

Hi Guys, After a sleepless night, I found an SQL that suits the format what I wanted, attached is what I have so far. As you run the union query (Query6) it will display 3 columns "Employee", "Reminder" "Date_Renewal", but on the Reminder Column it shows the actual date what I want to put...

Hi Wayne, Thanks for the time, As you can see on my sample DB, I have multiple column results which actually gets into my neck everyday when I tried to figure out how to collect those info. and place it in a neat recordsource which I can present to the user in a friendly way. Any other...

Hi, Can someone help me how to reconcile the query results into one to create somewhat of a pop-up reminder. Attached is the DB of what I have so far, I am able to extract the records as well as filtered the data, but I can't figure out on how to fit the results into one column. What I am...

Hi, Can someone help me how to reconcile the query results into one to create somewhat of a pop-up reminder. Attached is the DB of what I have so far, I am able to extract the records as well as filtered the data, but I can't figure out on how to fit the results into one column. What I am...

Hi Jerry, Attached is a DB hope it helps. Does the "ph" on your ID stands for Philippines? Jeff

Hi Guys, I have 3 tables: tblEmp (Employee Table) EmpNo (PK) EmpName (Text) Address (Memo) Phone (Text) HireDate (Date/Time) tblAssignments (Assigment Table for the employee) EmpNo (Text) Client (Text) Location (Memo) TicketDate (Date/Time) Done (Yes/No) tblEmpMemo (Employee's Note)...

Just a thought, did you try cathing the afterupdate event on the second form and update the AuditTrail by referencing: Forms!FrmFactorScores.tbAuditTrailDSView = Forms!FrmFactorScores.tbAuditTrailDSView & "**-**" & Me.Remarks It's just a quick fix :) Jeff

Just bringing back all the help I got from this forum, I remembered the days when I was starting on Access 97. Glad to be of help. Cheers

Hi, I've updated the attached DB and include a Query and Report. Changes: 1. Created a Query named "Query1" merging all the fields in both Table. 2. Created a Report based on "Query1". Let me know if you need more assistance! Happy Halloween!:D

Hi, Attached is a DB, hope this helps. Although I get confused on your requirement since you want to fill 2 fileds based on selected Class but where do you plan to store the info.? Just let me know in details the concept you have and I will try to help you. Jeff

Thanks Kiwiman for the link, exactly what I am looking for and it does work perfectly. Cheers

Hi Guys, I have a form that has a tab control with 12 pages, I also have a label box. Now I wanted to change the label everytime I select pages on my tabl control. I am using A2K3, any help is appreciated. BTW, I tried the On Change, OnClick event of the tab control. Thanks a lot. Jeff

Hi SrtraitJacket, Welcome to the forum! Well, the solution that I was expecting is that after the deployment, because after you deploy the DB using the 2K7 runtime it's impossible to open and set trusted locations, now the next question is why do we need to modify trusted locations? Answer...

Hi Guys, How do I implement a user form to relink .dbf file? I found a lot of relinking solutions but all of them I've read was for .mdb. I uses 2 .dbf in a query to extract data and print reports, but I wanted to make a user form so that whenever problem arises (server changes, folder...

Kabayan, This is just my analysis based on the data presented: 1. Make your master table which holds the personal info (Name, Address.....Education) just be sure you have a unique identifier. 2. Create another table that will hold Crew Documents, and another one for Crew Training...

Hi Gary, Others have suggested that kind of route, but the info. at the back of every information is the same size of the detail section, the design was to be an I.D. card and the info. behind are some rules & regs of the office which is kinda lengthy in a way. I already suggested that...