Search results

  1. K

    call subform validation from main form

    hi i have a piece of code that carrys out some form validation, see below 'form Validation Function CheckForEmpty() As Boolean CheckForEmpty = True ClearControlFormatting Dim ctrl As Control For Each ctrl In Me.Controls If ctrl.Tag = "FILL" Then...
  2. K

    calling a sub form bounbd to a form

    hi, ive written an if statement to check if a sub form is open before requering it, but im having an issue with c alling the object, below is my if statement, what is the correct method of calling the sub form inside a form please. If...
  3. K

    Solved query limiting character count in append

    hi im trying to append data from one table to another, but it seems the query is limiting the character to 255, is there a way around this? the table field is set to long text on both the table the data is coming from and the table where the data is going to.
  4. K

    Solved Field in form is limiting charactors to 255

    hi all i have a field on a form that is limiting the charactor count to 255, ive checked in the table and the field is set to long text and rich text the text box on the form is alos set to rich text, but its still limiting the charactor count to 255, is there anywhere else apart from the table...
  5. K

    Filter Query Based on two Date Fields

    hi all im trying to filter a query based on two fields, these two fields are date fields, [DateComp] and [DateCreated] what i would like to do is return all entries when [DateComp] is empty and todays date from [DateCreated] ive tried to add "IsNull" to the [DateComp] critieria, which...
  6. K

    Adding Checkbox to a grouped by query

    Hi all i have an issue im not sure how to resolve. i have a query thats grouped in in that query is an expression, that calculates total hours, baed upon a user and date which is the last box in picture 1 below. picture 2 displays the sub form that the query is bound to, in table TblManHours...
  7. K

    Solved using if statement on continous form

    i have two fields on a continous form, reason im using a continous form is so i can use a delete entry button. CbxEventTracker and CbxNonEventTracker when the CbxEventTracker has an entry, i want to grey out the CbxNonEventtracker field this is what i used Private Sub...
  8. K

    Bound Sub form Not loading when linked to MySQL Db

    hi all i have recently migrated my BE Db to a MySQL server, for the most part its stabel a few loading issues which i have resolved, however i seem to have come across a problem i cannot see a resolution to i have a form called FrmManHoursAdd in this form i have a subform called...
  9. K

    Solved GotFocus for combo box

    I've decided to deploy my backend into a MySQL server, and works well for the most part, but there is some issues with load times on some of the forms, so i need to quicken the form loads up, most of my forms are relatively fast in loading, but one of them has 10 combo boxes on it and this is...
  10. K

    Solved Update TextBox based on another text box

    hi all i have two text boxes, TxtOpenStatus and TxtUnitStatus when the TxtOpenStatus is 0 the TxtUnit Status should display "Serviceable" and if its 1 or above, then it should display "Out Of Service" heres what ive got so far but it doesnt work, any advies would be appreciated Private Sub...
  11. K

    Solved using BODY in emails

    hi all i have a piece of VBA that converts a form into a PDF and emails it to a recipient, what i cant find or do , is change the layout in side the .Body of the email How do i go to the next line for the email, so for example Hi All, please find attached info Regards
  12. K

    return most recent record

    Hi, im trying to create a query that will return the most recent record based on a unique number here is me table set up TblEventPartsLocation EventTrackableParts_ID EventTracker_IDFK Vehicle_IDFK Part_IDFK PartLocation_IDFK TimeStamp TblPart Part_ID SerialNumber Quantiy TimeStamp...
  13. K

    Manage Trackable Parts

    Hi all, im trying to create a model to manage parts from one location to another, two locations are either on a vehicle or in stores, im currntly trying to manage it like this TblEventPartsLocation EventTrackableParts_ID EventTracker_IDFK Vehicle_IDFK Part_IDFK PartLocation_IDFK TimeStamp...
  14. K

    check query prior to opening form

    I have a problem that I think I have a solution to but don’t know how to write the code for it. I have a button that opens a form, on this form there is a combo box that has a query attached to it, the number of records in this query can change and can return no results which is what it is...
  15. K

    Solved open form with last record

    Hi all, Im trying to open a form to the last record via a button but cant seem to find the correct command so i currently have sub CmdOpenForm_Click() DoCmd.OpenForm FormName:="FrmEventNewTrackPart", DataMode:= acLastRecord End Sub But that doesnt work can i run a DoCmd.OpenForm...
  16. K

    Solved Create Entry in second table from entry in first table

    hey all not used access in a while so im a little rusty, was wondering if someone could point me in th right direction. im trying to create a new entry in a table from an entry in another table Table 1 (TblEvent) Form 1 (FrmEvent_New) Event_ID Date unit_IDFK Vehicle_IDFK NontrackPart_IDFK...
  17. K

    displaying a sub report on a report

    hi is there any way i can display a sub report on a report just one, i have a report with data, that displays the events in continuous format, which is what i want. what i would like to do is display a sub report just once, which shows some totals values, but when i place this sub report on the...
  18. K

    send multiple attachements in email

    hi im trying to create a sub to be able to email multiple attachments in the same email, i cant use send object as it will only allow one attachment, i want to be able to send a report and a query as an excel format, how can i do this without having to save it on the computer first? the code...
  19. K

    automate table export

    hi i have a sub that exports all tables into an excel spreadsheet, is there any way i can automate this for a specific time of day? here is my code Private Sub btnExportDatabase_Click() Dim td As DAO.TableDef, db As DAO.Database Dim out_file As String out_file = "S:\Systems...
  20. K

    pre set folder path

    hi i have a function to open file dialog, how can i pre set the folder location heres my code Function selectFile() Dim fd As FileDialog Set fd = Application.FileDialog(msoFileDialogFilePicker) fd.AllowMultiSelect = False fd.Title = "Plase Select The Latest Run in."...
Top Bottom