Search results for query: *

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.

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...

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...

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

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.

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?

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...

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

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.

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

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...

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...

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...

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...

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

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

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.

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...

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...

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.