Search results for query: *

Tried that but this db has an application sitting on top of which does not allow the structure to be revised. So I have to maintain the integrity of the fields and tables Homer: But every time I learn something new, it pushes out something old! Remember that time I took a home wine-making...

So glad you responded! Good question. Not sure how to handle this will have to research more. Any suggestions? "2)SET @SHOPPERSON=(SELECT LAST_NUM FROM SEQ_NUMBER WHERE COLUMN_NAME = 'shop_person') this will probabaly always get the same row 3) what happens when 2 users hit this at the same...

Hi All, I am trying to create a trigger that auto-increments a PK field from another sequence table. Since I cannot change the structure of the existing table, I need to pull and increment the field and update the record for insert as a char type field. When I insert the record in the...

thank you very much. that actually worked!! Homer: But every time I learn something new, it pushes out something old! Remember that time I took a home wine-making course and forgot how to drive? Marge Simpson: That's because you were drunk! Homer: And how.

I have recreated a new report from an existing report but accidentlally saved the .rol file. Now i cannot see the old query (.rol) file. I have the orinigal from the install but cannot link the originl file (.rod) to the original .rol. Is there a way to do this? I have renamed both files but...

Thank you both!!! Been working on this all NITE!!! I actually tried all of those but in the wrong combinations. A million thanks!!! Homer: But every time I learn something new, it pushes out something old! Remember that time I took a home wine-making course and forgot how to drive? Marge...

I am trying to create a dynamic sql process based upon the following update code: UPDATE WORKORDER SET STATUS = 'COMP' WHERE REPORTDATE >= TO_DATE('08/01/2006','mm/dd/yyyy') AND STATUS = 'INPRG' AND ACTFINISH IS NOT NULL AND WONUM NOT LIKE '7%' Which works fine. The dynamic sql code is as...

Never mind. I found a duplicate Homer: But every time I learn something new, it pushes out something old! Remember that time I took a home wine-making course and forgot how to drive? Marge Simpson: That's because you were drunk! Homer: And how.

I continue to get the the following error when importing a CVS file into SqlServer2000: "cannot insert duplicate key row in object 'table1" with unique index 'table1_ndx'. I have looked at the records and there are no duplicates. No matter how many rows I test, I continue to get this error...

THAT WAS IT!!!!! THANKS A MILLION!!!!! Homer: But every time I learn something new, it pushes out something old! Remember that time I took a home wine-making course and forgot how to drive? Marge Simpson: That's because you were drunk! Homer: And how.

Yes. That one! Homer: But every time I learn something new, it pushes out something old! Remember that time I took a home wine-making course and forgot how to drive? Marge Simpson: That's because you were drunk! Homer: And how.

I have a form that displays records based on a form filter and combo box. The problem is that no matter what I select, the last null row from the table keeps printing and I cannot figure out why or how to hide it and do not know why it is printing. Can anyone help? Homer: But every time I...

Does anyone have any idea hot to insert row totals for a crosstab query? My form/report is grouped at two levels and using the =Sum(NZ([2005])) returns the sum at the highest grouping. Not at the lowest one. Homer: But every time I learn something new, it pushes out something old! Remember...

Hi! Are you still there? This actually came close. I have been adjusting it. The strSecLvl kept changing to maintenance at the same point in the code, then I looked more closely and find that a this point strSecLvl = Choose(x, "Maintenance", "Receiving", _...

Thank you for your research!!! And I see. quote: "On your return post (when I asked you to perform a search) you didn't say whether or not you found strSecLvl. This should've been revealing as you stepped thru all locations found. If you havn't done it, you should do so & log all...

Oh. So sorry for the confusion. I did not run across strSecLvl = "" in the code. Only when I step into the debug. And no, I was not aware that my testing and opening/closing the form would lose the value of strSecLvl when all forms are closed! That is what is happening to the user. While in...

Here is the code from the Swithcboard manager. I found the strSecLvl when I did the search. It is in all of the foem in the subfunction and the userlogin form where the strSecLvl is determined. I also found that the user on the forms is defaulting to the database user and not updating to the...

I decided to refresh with the following public function to refresh the user level security. I cannot seem to pinpoint when it fails to refresh the strSecLvl so now each time a form is opened it will just run the lookup. ' DETERMINE USER SECURITY LEVEL ' (strSecLvl is a global variable set in...

Fine. How are ya Aceman1? I have put the global strSecLvl in the ModGlbVars module which is the most used but only has this variable declared. There is another module in the modules window, but I don't use it much. The rest are forms. I am not using the DoCmd.OpenForm "FormName" to open...

What I mean by random is I can open and close the form(s) several times and it will be okay and then I'll open the form again and it will happen. This occurs when I am workingin the form. I am using a global variable and another form to set the strSeclvl. Using watcher also shows it changes...