Search results

  1. 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 ?
  2. 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...
  3. 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...
  4. 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...
  5. 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...
  6. 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...
  7. 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...
  8. 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...
  9. 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...
  10. 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...
  11. 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...
  12. 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...
  13. 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...
  14. T

    Align Visible Buttons on Menu Form

    Hi all, My Main Menu only shows buttons which are relevant dependent on the user permissions, this often leads with when people see the form there are blanks where the buttons are hidden. Is there a way to arrange the buttons, so the only ones that are visible are all aligned at the top of the...
  15. T

    Code to loop through and Send Emails to users.

    I have attached a cut down version of my Database. What i am trying to achieve is that on the Form FrmQcNonConformanceDeail we have a field TBSubCat. I am trying to look at this field, and then pull the email address's from the Query QryNCEmails. against that TbSubcat field and that Job...
  16. T

    Select All Checkbox - Error Code 3464

    Guys i am struggling with my Check box to select all records in subform. The code i have is below, The Field names Delivery is a short text field, but i get error message 3464 - data type Mismatch in Criteria Expression. if I run it as query it works, just not when i run as VB my...
  17. T

    VBA to Copy picture from one folder to another

    I have some code below that is called on Current Event of page, So when i refresh the page, the code automatically looks at the CatNo. and pulls back the picture from the network Drive, to a local drive, and it it cannot find the network drive - it justs gives me a No Picture.jpg. I would like...
  18. T

    Code to add Attachment to Email (If attachment is in its location)

    My code creates a email and attaches some images to the email. The images are stored in File_Location folder. The hyperlink to the images are stored in the TblQcFiles table. Some of the images have been archived into sharepoint, so are no longer in the folder, but the hyperlink is still in...
  19. T

    Lock File on Back End Can this cause inconsistent file type error ?

    Here's my setup. I have a Front and Back End, with upto 30 users at once who copy the front end to a local drive using a bat file. When Users log into front end the database should logs this user so i can see who is in the database. I have just checked file explorer and can see the lock file...
  20. T

    Type mismatch error

    i have moved the back end of my database into Sharepoint, and currently got approx 90% of the funtionality. One issue i have is code that has always workedi is below is now giving me a type mismatch error 13 at the Set index code highlighted in Red. Any advise appreciated. Function...
Top Bottom