Search results for query: *

Hello, I have a combox, I want to know how to add new info. in the combox. E.g: the combox have the control source "CompanyName", if the new CompanyName is not in the combox list, the user can add new CompanyName in the combox. Thank you very much for your kind help. Wdu

Hello, I have a ShopOrderNum that need to automatic show up. The ShopOrderNum like: ShopOrderNum ---------------------- 0001-0 0001-1 0002-0 0002-1 0003-0 0003-1 ..... Thank you very much for your kind help. Wdu

Hello, I have the ShopOrderNum need to be autonumber. The oringal number like ShopOrderNum ---------------------- 0001-0 0001-1 0002-0 0003-1 .... how to get autonumber like that: ShopOrderNum ------------------------- 0001-0 0001A-0...

Hi, Seaport, Thanks for your respond. My project basically works. but I can't update info. in the same row. for example: first row I enter 50% second row I enter 25%, if I changed this row from 25% to 50% should be OK, but this case still remember 25%. The means if I changed 25% to...

Hello, I have the datasheet form that form show up data by each orderID. In the this form I have a payment percentage field. I want to restrict this percentage when the user enter "percentage". The logical is total percentage should be less than 1. e.g: the user enter first row...

Hello, I have the datasheet form that form show up data by each orderID. In the this form I have a payment percentage field. I want to restrict this percentage when the user enter "percentage". The logical is total percentage should be less than 1. e.g: the user enter first row...

Hello, there, An automated number system for a multiple-part order needs to be created, so that when a new order is entered, the next avaialble number comes up; then, if there is more than one part to an order, each will get a letter(A, B, C, etc.) The original OrderNumber like: 001-1 002-1...

Hello, I have a pop form call frmPopDivisions(user can select item in this form's combox), and other form called frmPickDates. the pickDates form have the sub form that the sun form called Veh_Sched_sub. My problem is, when I click pop form button then the button link to the frmPickDates. if...

Hello, I have the problem for the format date time. In the forms I set up "Forms!PickDates!TimeOut" is (1:00-12:00 am, or pm), but in the "qrySCHEDULE", I set up "RESERVE_TIME_IN" is (1:00-24:00). The question is I don't know how to format them and compare the...

Hello, I have the problem for the format date time. In the forms I set up "Forms!PickDates!TimeOut" is (1:00-12:00 am, or pm), but in the "qrySCHEDULE", I set up "RESERVE_TIME_IN" is (1:00-24:00). The question is I don't know how to format them and compare the...

Hello, The refresh form just flash away, not show up on the screen. I need this refresh form show up on the screen. Any ideas? Thanks Wdu The following are my codes: Private Sub btnSaveAndClose_Click() On Error GoTo Err_btnSaveAndClose_Click If Me.Combo6 = 0 Or IsNull(Me.USER_ID) Then...

Hi, The other way you can caeate the tblPASSWORD including the username, password, id, dept... then you can depend this table to create pop form. and the data can be filtered by dept. Hope this help. Wdu

Hello, I try to create new form to use exist query. but this query have criteria inside, like "[Forms]![Popform]![Combo2]. Actually, I don't need this criteria in my new form and I also need to keep this query for other form. I already Copied the query, give it a new name, base my new...

Thanks JimHorton. Still not for me. I didn't know why?

Hello, I have the form called frmPickDates that have the button to link to other form(called frmReservations). When the frmReservations finished update then I have the button to link back to frmPickDates that should be show new info. in the frmPickDates. But this not work for me to show info...

Hi, All, I want to pop up form over the main form. I already set up this form's "Pop up" for yes, but it doesn't work for me. if I set up "pop up and modal" for yes, My mouse will be died. By the way, there is a subform in this form. if you have any suggestion, please let...

Hi, All, I have a combox that bound 5 fileds. Anybody know how to get combox works for search(select item from combox)? Thank you very much for your help. Yi

Hello, I have 2 tables that have the same field name in these 2 table. I want to append the same field in one table. Thanks for your help. Jeannia

Hello, I have 2 tables that have the same field names but different table name. These 2 tables have a lot of same data inside. I want to know how to check if these 2 tables acctually the same or not. if these 2 table have the different data, I need to merge in one and cut dupliate data. Thank...

Thanks Terry. I got it.