Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: ychousa
  • Order by date
  1. ychousa

    Prevent User Input if there's a record in a field

    GingerR's code was right. The field that I tested was not null, even though it didn't have any data in it. I changed to Me![Serial Number]="" then it's working perfect. Thank you.
  2. ychousa

    Prevent User Input if there's a record in a field

    Thanks for your comments. Yes, I meant "if there's already DATA in the field." I tried the code on both onEnter and BeforeUpdate events, but it doesn't seem it's working. Basically, a user can enter Serial Number if the field is null, but he cannot do so if there's already data in that...
  3. ychousa

    Prevent User Input if there's a record in a field

    Hi. I was wondering if there's a way to prevent user input if there's already a record in the field. I would like to give an error message something like: MsgBox ("You can't modify this record") on the after update event of a field. What I can think of now is a logic like this. After Update...
  4. ychousa

    This might be a silly question. How to unhide a query?

    I found an anwer. It was on Access help file. I just didn't use a correct search term.
  5. ychousa

    This might be a silly question. How to unhide a query?

    Hi. This might sound silly, but what happened was that I wanted to hide a query and a report, so I right-clicked them and changed attribute to "hidden." Then I can't unhide them now. I checked Access Help files and googled a solution, but couldn't find any answer. Can anyone help? Thanks.
  6. ychousa

    What's wrong with my code?

    I use 2002 and DAO is referenced. I found that the 3rd If statement:(If Len(rs1![Serial Number]) > 0 Then ) is somehow causing the error. The commands under the statement don't work. If I remove the If statement and End If line, the commands work. Any suggestions?
  7. ychousa

    What's wrong with my code?

    Hi. 2 tables are involved in this case. Serial Number Table and Inventory. The naming is not so good, but anyways, the logic is like this: Serial Number Table and Inventory are related by a third field called OrderID. Inventory contains the list of current inventory and availability of each...
  8. ychousa

    Sorting Numbers in a text field without changing field type

    I made number part to 1,2,...50 to make things easier. Thanks.
  9. ychousa

    Sorting Numbers in a text field without changing field type

    I was wondering if there's any way to sort numbers in order in a text table without changing field's data type to Number. I need to have numbers(1st, 2nd,...,50th) and some text options(eg.Returned) together in a field, but I can't sort the numbers in order. Thanks for your reply in advance.
  10. ychousa

    How to start learning SBT?

    Thanks for your help, dgillz. Your comments are very helpful.
  11. ychousa

    How to start learning SBT?

    Thanks for your reply, dgillz. That seems a good idea, but wouldn't I need to learn Fox Pro before I start the session with a reseller to clear understand what she's talking about? I have intermediate knowledge about SQL and VBA, but I've never played around with Fox Pro. Being different from a...
  12. ychousa

    How to start learning SBT?

    Hi, I have been working in this company as a system developer, working on mainly extensive Access database development. Recently our key accounting staff, who knows SBT(Pro series 6.5) well, quit the company, and my boss wants me to learn SBT and give him the solutions that only IT people can...
  13. ychousa

    My client wants to go wireless how should we go about this?

    After I read the posts on this thread, I made 12 out of 23 workstations WIRED, and guess what? The internet speed increased! Well, it's still a little bit slower than it was in our old facility, but I certainly found speed increase. So, now I am convinced that my wireless network caused the...
  14. ychousa

    My client wants to go wireless how should we go about this?

    Hi, I have a very similar situation here. We have 23 computers running on a windows 2000 adv server. We have implemented wireless network here in our new facility but have been experincing very very slow internet speed when all the users are connected to the server. We have 3 wireless routers...
  15. ychousa

    DateDiff function and conditional formatting

    Hi, Roy-Vidar. Your suggestion worked! Thank you.
  16. ychousa

    DateDiff function and conditional formatting

    I tried Date, but it didn't work, so I'm trying with Now-both give the same result.
  17. ychousa

    DateDiff function and conditional formatting

    Thanks for your reply, but I already tried your suggestion. Your suggestion actually gives all negative values when I Debug.Print, so I think the one I posted is right, calculation-wise. I think my condition is not working, but I can't think of a reason.
  18. ychousa

    DateDiff function and conditional formatting

    Hi. I'm trying the following function to change the background color of a textbox if the date difference between today and expire date is less than 120 days. The form is a continuous form and a textbox to show expiration date is called Expires. Private Sub Form_Current() Dim vDiff As Long...
  19. ychousa

    Subforms and Report

    Hi. I have 5 subforms in a main form (frmMain) and a report. Main form is bound to Main table and each subforms has its bound tables. The child tables and the main table are connected by an ID.(DetID) This form is for calculating expenses for a show. The 5 subforms represent each category of...
  20. ychousa

    After search, open a form, scrollbar & Min botton disappears.

    I found an answer in another source. I'm posting this for other members. The problem was acDialog in DoCmd in my listbox. I changed it to stLinkCriteria, and it worked.

Part and Inventory Search

Back
Top