Search results

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.

Thanks everyone for your input. I still can't determine what is wrong. See attached sample. This is very weird. Steps to reproduce error: 1.) Open frm_BillingReview 2.) Select Date of Service from the option group 3.) Select 1/3/2022 from the combo box 4.) Click the Get Data to Review button...

Thanks for responding. The names of the fields are: Client_Name, Date_Of_Service.

I know. This should be an easy one - except for the fact that my combo box is unbound. I have an option group that lets the user choose to search by name, date, therapy, payer etc. If they choose Name (or anything else) then the rowsource for the combo box is dynamically populated accordingly...

Sorry isladogs. I misinterpreted your post. You are correct.

How can I get the Report Footer to "precede" the Page Footer? I can't move it up in design mode.

I hope this isn't a dumb question but I have a report that consists of: Report Header Detail Page Footer Report Footer When I view or print the report the Report footer always displays before (above) the Page footer. Shouldn't the Report footer always be at the bottom? Can anyone please tell...