Search results

  1. T

    Are Page Breaks in Reports Arbitrary?

    I have a report consisting of a few subreports. In certain instances a subreport will appear on the following page (or several spaces down from the sub above it) for no obvious reason. I changed Keep Together to "No" in the report footer and this resolved one occurrance. Does anyone know how I...
  2. T

    Invalid Query Results

    Okay, I admit I've had a long day and that my eyes and brain need a break. But - If Table1 has 2 entries each for Cust_Id (600145 & 600136), Payer (MLTSS) and Therapy (Structured Day) : {Total entries = 4} and If Table 2 has 2 entries each for Cust_Id (600145 & 600136), Payer (MLTSS) and...
  3. T

    Is this Possible?

    See attached example. I would like to have a form that has three command buttons positioned next to each other (side by side) in the uppermost part of my form. They should always be visible. If the first command button is clicked I would like to have another specific form open in the lower part...
  4. T

    Problem with Sorting on Report

    I have a report which has a query as its recordsource. The query sorts the "Task_No" field in ascending order. The query works fine but when the report opens the "Task_No" field is not always sorted properly. Sometimes it is and sometimes it isn't. This just started happening after we migrated...
  5. T

    Null Value Not Recognized

    The code below returns a null string (as it should) in query design. However, in my VBA code the vartype for rs("Number_UnitsBilled") is 9 which indicates that it is returning an object. Therefore, the program crashes with a "No current Record" error in the "Else" statement. How can this be...
  6. T

    Debugging a Query

    I am trying to use a msgbox to debug a query I have written in VBA code. However, the msgbox is not large enough to display the whole query. Is there any way to expand the msgbox so that I can see the whole query? sql1 = "SELECT tbl_Authorizations.ID, [tbl_Authorizations].[client_LName] & ', '...
  7. T

    Why do my Controls Shift in Form View?

    The controls in frm_Dashboard (see attached DB) are exactly where I want them in Design view. However, when I switch to Form view all of them shift to another location. I've already played around with all the properties and can't seem to figure out why this is happening. Does anyone know?
  8. T

    Close Button (X in upper right corner) Doesn't Close Access

    I have an Access 2016 accdb database that refuses to close when I click the X in the upper right corner. It will minimize when I click the minus sign but will not close when I click the X. I tried a Compact/Repair but no luck. I have to either end the task through Task Manager or right click the...
  9. T

    Searching for the Correct Event

    I have Form1 and Form2. If a user is on Form1 and they click a command button to bring them to Form2 I want a message box to appear in certain circumstances. I tried putting the message box in the On Open, On Load, On Current, On Activate and On Got Focus events of Form2. In every instance the...
  10. T

    Autonumber Primary Key Dupes

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

    CurrentForm Variable 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 =...
  12. T

    Duplicates in Primary Key

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

    Can't get Proper Week Start Date

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

    Listbox Question

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

    Table Gets Corrupted

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

    Form is Larger in Form View than in Design View

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

    Mysterious - The Value you entered isn't valid for this field - Error

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

    Report Footer Displays above Page Footer

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

    textbox.visible = false Not Working in Report

    I have the following code in the On Print event of my report footer: Private Sub PageFooterSection_Print(Cancel As Integer, PrintCount As Integer) If Me.Page = 1 Then MsgBox Me.Page Me.[lbl_ClientName_Footer].Visible = False Me.[txt_ClientName_Footer].Visible = False Else...
  20. T

    Docomd.OpenReport Opens Wrong Report (Sometimes)

    I have a command button that, when clicked, opens a report. I feed it a unique Trans_Id so that it opens the report with the data that pertains to the form that the user is viewing. The first time I open the report and Trans_Id = 14 it opens the correct report. If I change the Trans_Id to 15 it...
Top Bottom