Search results

  1. T

    Passing data between forms OpenArgs?

    Hi all, i need some help, Firstly - i tried to zip a copy of my database so i can upload, but the smallest i can get this is 12mb, so unfortunately i am unable to upload. I have 2 forms - FrmMain and Frminspection. My main form (FrmMain) assigns a job number to the request, and then when...
  2. T

    Audit Trail - Tabbed Control

    I have set up a new form with a Tab Control, that contains 5 tabs. On most of my forms in my database use the below code to track changes to fields that are Tagged ? If I Tag the Tab Control, I get error 2427 - You entered a expression that has no value. or error 438 - Object does not support...
  3. T

    How to call function name and pass into other function

    I am playing with some new code below to log the time that it takes to run a query. So i have added a new function called Startlog and EndLog. I want these to use the function name as i log this in my table, is there a easy way to pass the Function name to StartLog and EndLog so i dont have...
  4. T

    Import tables function

    I have the code below to import tables from my Master database to my Dummy database. The problem i have is the the Master database table is a link to a SQL table, and i want it to convert to a local table (Taking too long to pull data from SQL Server), and not just copy the link. Is there are...
  5. T

    Dlookup Multiple Criteria

    Still Struggling with another Dlookup for multiple criteria. My current code which works is WhoCharge = Nz(DLookup("Processor", "TblQCPreRetailSuppliers", "Supp_Code='" & Nz(tbSup_Code.Value, "") & "'"), "") and i want to add another criteria to check if the supplier is live, so tried this...
  6. T

    Inconsistent file errors

    Hi all, i have been having a few inconsistent file issues on my Front End recently. I have checked all my tables, and they do not seem to be corrupt, All forms and queries work, but i am seeing this error on a daily basis. Do i need to create a new Front End - Copy all current Forms / Queries...
  7. T

    Linking Forms

    Hi guys, i need some help, I have a main form (FrmMain) with a button to open another Form (FrmInspection) form main has a autonumber field (TBJobID) which i want to transfer over to the Frminspection form. so that when i open the inspection form it only shows the records for that job number...
  8. T

    Count fields that are conditionally Formatted

    I have 15 fields that are conditionally formatted based on there value, and i need to count eh number of fields that are Red and the number that are Green. Whats the easiest way to do this ?
  9. T

    Format Empty field on form

    I have the below code which works - but i wanted to condense it. due to the number of controls that i need to check. If IsNull(CboxSite) Then CboxSite.BackColor = vbRed CboxSite.SetFocus MsgBox ("Please complete the missing Fields.") Exit Sub Else CboxSite.BackColor = vbWhite End If So i have...
  10. T

    File format and extention dont match when opening file

    I have a file that is exported out of OBI, and sent to me on a weekly basis. I have set up With power automate that when the file is received then it saves it automatically in a folder - This part works with no issues. When i open the file, i get a message that the file may be corrupt "The...
  11. T

    Established table, need to change primary key due to duplication, but want to keep the data in the autonumber field.

    What is the best way to do this, i need to add a new primary key to stop some duplication i have noticed, so i have created a duplicate table, then thinking i need to clear out the data, set my primary key's, and then paste the old data back - excluding the duplicated files. - This is the bit i...
  12. T

    Hide / Mask Address field on form if you did not create the record.

    I have just created a subform which contains users Contact Name, Number and Address. I want to hide / Mask the address / Number (GPDR) unless it is a record you have created, so thinking about pulling back the username and then comparing against the person who is logged in, but cant decide on...
  13. T

    Hide Subform

    I am building a new form, I think it will contain possibly 4 sub forms due to the data types and Criteria in the forms being grouped together. I am thinking of a way to hide / unhide the forms when not in use - otherwise it will look quite busy. Is it just a button to show / Hide the forms...
  14. T

    Linking to Excel File stored with incorrect file type

    I get a file saved systemically, which i would like to link into. When i try to link, the file fails, When i open the file, I get a warning which states " the file format and Extension of ''X'' don't match. The file could be corrupt or unsafe, Unless you trust is source don't open it. Do...
  15. T

    Need help with conditional Formating.

    Hi guys, trying to conditional format a field if the value is <> a set tolerance. I have got so far, My TBControlMeasurement = 93, My Tolerance is 2, so i have a upper and lower limit set, So if the Value in Sample_1 is either higher than the upperlimit, or lower than the lower limit i would...
  16. T

    Acess queries slow when using sql server tables

    Hi all, I have just moved 2 tables from my access back end into sql server. I already had 8 tables that I lookup data from in a different sql server. When running local queries that use tables from both servers in access these seem at least 5 times slower than when they were local tables but...
  17. T

    Export into Excel and Format as Table

    I have a code that runs daily and formats the report into Excel. I now need to format the exported report as a table. Please can someone shoe me what bit of Code below needs to be changed in order to do this. Sub FormatExcel(ExcelFile As String, LastCell As Integer, FreezeColumn As Integer...
  18. T

    Check if Users ID is in List on Sheet

    I have a form where the user enters their ID number, When User inputs their number into Cell A5, i want it to check if the contents match a list that is on my Lists page. If they are not set up, i want them to get a msgbox. I am guessing this is in in the Worksheet.change section of the vba...
  19. T

    Form to Load /Save picture from Web URL

    I have a table in SQL which is full of hyperlinks to pictures. What i want to do is from within a access form, look up the picture on hyperlink address, then save the picture to a local drive, The URL is transferred to the MyPic String with no issues, but i am struggling to save this as a Jpg...
  20. T

    Import Dates into SQL

    I am migrating a Access database over to SQL, The dates in access were stored as Strings, whereas the SQL table they are moving into are the Datetime Format. When i try the insert Function i get the error message below What is the easiest way to change the format, Msg 241, Level 16, State...
Top Bottom