Search results

Re: clear integer values in text boxes Hi all, I have a problem clearing or displaying empty values in text boxes. These fields are binding to a table and are storing integer data type. I want to clear the values in these text boxes when user clicks on a button but the fields that stores the...

Re: Syntax for textalign property Thanks trucktime! Your code works great. I think my problem was that there were blank spaces in the field that cause the value aligned to left. Thanks for your help!

Re: Syntax for textalign property Hi, I like to know the syntax to set the textalign property to Right for a textbox. by setting the property in Access works when I type but the field(s) is populated thru recordsource it shifted to the left regardless the setting in Access. Seems to me I...

Re: lower/upper case in password Thank you Ghudson! Thank you Fofa! That's what I'm looking for.

Re: lower/upper case in password Hi all, I have two text boxes where user type in their password. First they type in their password in text box one then they need to type in second text box to verify with the first one. No problem there. But when I try to compare two password fields one has a...

Re: populate a calculated field Hi one and all, I’m trying to populate a calculated field, an unbound field,on the form with the query in the Form open event. But tt_qty is not showing. The tt_qty calculated field is use to store the sum of bag_quantity field in tbl of a grouped...

Re: Selstart property? Hi all, I don't have problem moving to the beginning of the text box with the code I have. But once the line ran the cursor is @ the beginning of the control but you can't write to it(nothing happens when typing into the field). if I remove the .selstart line out it...

Re: You can’t go to the specified record. Hi all, I'm getting this error " You can’t go to the specified record" when I ran DoCmd.GoToRecord , , acNewRec. I haven't found any help w/ error above using acNewRec. Please help! Here is how my form works: when user enters a value in mfg field it...

Re: SelSTart property Hi all, I want to set focus on the next control(text box) and move pointer to the first position in the text box control. I added the code below and now I can't write to the text box. why? Me!insert_lotnum.SetFocus -->Me!insert_lotnum.SelStart =...

Re: sub or function not defined on Open error Hi all, I received this error when I tried to open the database. I used the shift key and tried to break to the error when opening db. but this error popped up before executing open form event. How do can I locate the error? The expression On...

Re: overflow error in opening form Hi everyone, I'm having trouble in opening a main form w/ a subform. when I try to open the main form it stops at the main form Form_error subroutine w/ 'overflow' error. 'the DataErr is 2585 Private Sub Form_Error(DataErr As Integer, Response As Integer)...

Re: How do you convert week # back to date? Thanks Col for your reply. That might work for me but I'll take a closer look and let you know. Thanks!! Alice

Re: How do you convert week# back to date? Thank you for your replies. I realized that after I posted the question but you have provided me a possible solution. Thanks much!

Re: How do you convert week # back to date? Hi all, How do you convert the week # back to a date? I used datepart function to get the week # ex: mfg_dt_num = DatePart("ww", Forms!start_sample!earliest_mfg_dt) and now I need to know how I can convert it back to the date format and display in...

Re: Display report w/ input parameters Hi, How can I display a report from database window(w/o form) which had input parameters in its recordsource? In the report_open event I passed in input paramters in the I have global variables which I passed in as input parameters in the report’s...

Re: Syntax on Not null Hi, What is the syntax for not null in the where clause? I have a field(say,col_z) in the SQL Server table that stores bit value. I want to write a query to return all records in the table that are not null in col_z but I can't get syntax right? I'm using AC2K & SQL...

Re: database design Thanks Wazz, You are a great help. Thanks for helping me to understand this. Nice to know I'm not too off. Thanks!

Re: database design Hi Wazz, Thanks for your reply. I would like to track the sections. Do I have to modify the tblSection? Are you saying I don’t need the tblmuscians_details and link the tables to get all details on each musician in all three orchestras? Thanks much!

Re: Database design Hi, I have a database problem if someone can provide some input on my database design if it confirms w/ normalization rules at least the three normal forms. Here is info/requirements of db: An orchestra has four broad classes if instruments(strings, woodwinds, brass, and...

Re: combo box issue changing to bound to column 2 works but doing that will add the same customer in customer tbl when user insert a new record. Since the setting controlsource of the combo box points to Company. But If I don't the customer name(cboCompany) will be blank on all records...