Search results

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

Pat Hartman for president!!

Brilliant! Thank you very much! I only had to use a very small snippet of code (see below). I did have to change SelectedID to string however. Also had to comment out the Exit For statement. '**************************** Dim varItm As Variant Dim SelectedID As String Dim i As Integer...

I have frm_NewClient which adds a new client to the database. The controls are: txt_Client_Id txt_FirstName txt_LastName lst_Payers (This is a multiselect list box that displays different insurance carriers) My insert query works perfectly. I am able to get the selected items from the listbox...

Thanks for responding Larry. Every user has their own front end copy. I know it is corrupt because I get calls from my users complaining of the same error message that always indicates corruption - and then shortly after that I get the classic "Your file may be corrupt" message. I agree with...

I have a split database. Occasionally I will need to compact and repair the back end. The corruption is always in the same field of the same table. The field is called "Comments". It is a Long Text field. When it is corrupt it contains hash marks ######## inside of it. I simply export the table...

Thanks Gemma. I appreciate you taking the time to show me this!

CJames & Gemma - Thanks so much. My dumb mistake on the Maximize command. Anyway, both of your codes work perfectly. Thanks so much! I appreciate your help! Just FYI. I did put Gemma's code in the open event of the dashboard form.

CJames & Gemma - Thanks so much. My dumb mistake on the Maximize command. Anyway, both of your codes work perfectly. Thanks so much! I appreciate your help! Just FYI. I did put Gemma's code in the open event of the dashboard form.

@CJames - The form opens exactly the size I want it when opened alone. The problem is when it is opened via the login form (frm_Login). Only then does it take up the entire screen. So, when I implement your code, it opens with the MoveSize settings - but when opened via frm_Login it still takes...

Thanks Gemma. I tried all of the below and none of them solved the problem. DoCmd.RunCommand acCmdSizeToFitForm DoCmd.RunCommand acCmdFormView DoCmd.RunCommand acCmdSaveLayout DoCmd.RunCommand acCmdSizeToGrid DoCmd.RunCommand acCmdSizeToNarrowest

I've had this problem before but was always able to resolve it. However, this time - no luck. I have a form called frm_Dashboard. It is sized the way I want in both design and form view. However, when calling it from frm_Login it becomes much bigger and takes up the entire screen. From...

Since the error occurs when the "Date" option is chosen first it wouldn't make sense to have that as the default. But - I made the "Name" option the default and changed the rowsource of the combo box accordingly on the form's On Open event and this seems to have worked. I would prefer to have no...

jdraw - Al pacino doesn't have any records that fit the criteria.

Thanks for your efforts jdraw. I really appreciate it. I used similiar debugging techniques but, so far, I still can't identify the issue.