Search results

Is anyone aware of a diagnostic tool that can be used to trace activity and help determine what's causing the corruption in MS databases? I remember using two tools many years ago to trace an issue with SqlServer.

Hi Doc_Man - It's definitely corruption. That's how I'm alerted to the problem. The users can no longer use the application. The question is: did the fact that the primary key allow dupes create the corruption - Or did the corruption cause the dupes? Either way it's a problem - and it's...

Hello All, I have a program in which users create progress notes for clients with disabilities. When they begin writing a new note a Note_Id is assigned to it. This along with the client’s basic infoformation is then appended to a table called tbl_BasicInfo. Also, for each new note, five goals...

moke123 - My code is not only to requery listboxes but your code is very elegant and helpful. Thanks!

Thank you all very much for taking time with this. cheekybuddha's example above (via DBguy) definitely should have worked. Unfortunately it didn't along with everything else I've tried. It seems Access cannot recognize a variable used in this way. I will follow Pat's advise and take a completely...

Globals.glb_CurrentForm = "Forms(" & Globals.glb_CurrentForm & ")" I removed the bang, included "Forms" in my variable and enclosed it with parentheses. Now I get the error below. Not sure how to qualify lst_Tasks.Requery. I tried the bang and a period in my variable but no luck. It errors out...

Thanks DBguy. Unfortunately, that didn't work. I tried: Forms!(Globals).glb_CurrentForm!lst_Tasks.Requery Forms!(Globals.glb_CurrentForm)!lst_Tasks.Requery and now I get this error:

I'm trying to use a global variable to hold the name of a form. It works great and returns the correct form name but I get the error below when referencing it from within the form collection. Does anyone know why? 'On Open event of frm_X Dim frmCurrentForm As Form Set frmCurrentForm =...

Why do Brits say "In six week's time" instead of "In six weeks"? We know you're talking about time!!

CJLondon: Sorry. I didn't answer your first question. I grab the transaction ID (which is a unique primary key of another table) and insert that into this table.

MajP: Yes, the table is corrupt. That's why a CR works. But I've rebuilt the table several times from scratch by exporting the data to a text file, creating an entirely new blank table and importing the data back in. The table then becomes clean. But a few days later the same thing happens. So...

Okay. I need to slow down. The field is not autonumber. It is a Number field which is indexed with No Duplicates allowed. It is also the Primary Key. My sincerest apologies. The issue is still the same, however. Even though no duplicates are allowed occasionally duplicates get in. They are...

MajP - I never reseeded. I only did a CR. I tried using the code below to reseed but It's giving me the errors listed below. CJ_London - I am using an Insert query in VBA from a front end db to a back end where the table resides. Here's my reseeding code: The data type of Trans_ID is Long...

I just did a compact and repair. Wouldn't reseeding change the autonumber of each record? That would be disastrous.

I have a table that has an autonumber field (Indexed, No Duplicates) set as the primary key. Every now and then the table will get corrupt because Access will allow a duplicate entry. I've read the Allen Browne articles so I know how to fix this - but does anyone understand how this can happen...

DBGuy - you are correct. My mistake. But then it returns 2. TheDate Expr1 1/1/2030 2 1/2/2030 2 1/3/2030 2 1/4/2030 2 1/5/2030 2 1/6/2030 2 1/7/2030 2 1/8/2030 2

Mark - the query is perfect. Thanks! I already wrote a function that works and accomplished what I need but I knew there had to be a more efficient way.

vbMonday is not recognized in query design. So, I replaced it with 1 (Monday). It returns 3. TheDate Expr1 1/1/2030 3 1/2/2030 3 1/3/2030 3 1/4/2030 3 1/5/2030 3 1/6/2030 3 1/7/2030 3 1/8/2030 3

Guus2005 - I don't understand what you mean. Your suggested code returns "3" when I run it. Plog - Yes 1/3/2027 is week 53 of 2026. I'm sure my query just needs a bit of tweaking but I can't seem to get it to recognize that Monday is the start of the week although I don't have that problem with...

Our business week starts on a Monday. I am using the following query to return the year, the week number, the date, the day of the week and the week start date: SELECT "2027" AS TheYear, DatePart("ww",[TheDate],2,2) AS TheWeekNo, t_Calendar.TheDate, t_Calendar.TheDay...