Search results

I could use that, but i am trying to work out why some inspections are are being assigned against the first job. Example - this week out of 147 inspections, 8 of the have been logged against the first job number in the database,

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

DB is massive with links into lots of other systems, so will take me days to pull together a sample. So far i have got the enclosed, being called from the Forms Current Sub. This seems to be working, thanks to the advise above. Next questions - would i need to do the below for all 15...

I am struggling with this, I have got this code but now get a syntax error. Am i best putting this in VBA or in the control source ? Tbpass = Nz(DCount("*", "TblQcMeasurements", "Id = '" & tbid & "' AND "TbSample1 >(Measurement+Tolerance)"), 0)

Would it be better to try and do the conditional format in VBA ? or carry on using the in built conditional format ? I have tried to convert to VBA, but get the issue below where it formats the full field dependant on the last ctl.value - and then place a count in this code ? Or just a Dcount...

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 ?

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

in the end - i created the macro to open and save as a xlsx. This worked, now i have set up a task to automate this part for me. So far working as planned. Thanks for all the help and advice.

Sorry i cant upload a copy of the file as it contains financial information, If i change the file extension to MTH, then the file opens in Chrome with no warnings, if i try HMTL, then i get the error "could not expend the 2nd filename to match the first" is due to the length of the extension is...

tried, and does not work

interesting - Tried to copy to a CSV file - Failed - but enabled me to read this message . This document is a Single File Web Page also known as a Web Archive file. If you are seeing this message your browser or editor doesn't support Web Archive files. Please download a browser that...

the error "could not expend the 2nd filename to match the first" is due to the length of the extension is different ie going from xls to xlsx. I have crated a copy of the file, with a different filename, keeping as a xls file and still get the original error.

yes, i get a copy of the file to my inbox, i have just set up the rule to save the attachment in a folder. When i open the fil ein my inbox i get the same error message.

I have tried using xcopy and got the message "could not expand the 2nd filename to match the first" I tried just by changing the file format, and i get the same originl error. If i open the file and saave as xlsx then it is fine.

sorry, my bad. it is a xls file, would vba be able to ignore the error message i get when trying to open ?

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

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

Thanks as Allways. Currently I have coded looking at the environ(username) and made the field visible=false Tomorrow I will look at how to format as password using vba.. Cheers both

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

I went for the tabbed approach, working quite well at the moment. Thanks..