Search results

I will have a look over next few days and see how it looks. Thanks.

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

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

Yes.

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

Thanks, let me digest properly and get back to you tomorrow. I have only been using sql server for the last few weeks, and my main contact in work is on holiday for the next week.

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

Hi all, i have used the above to format my data as a table, but i have 1 column that i want to format as a Currency - Can this be done in the same procedure ?

you were correct. I will the way you can set to either keep the report open, or closed. My previous export always made the report Visible and then carried out the formatting. This seems much smoother. thanks

I am trying to use the above to format as a table and get the error Invalid Proceedure call or arguement in procedure XLFormatTable, Line 0 Set tbl = xlWS.ListObjects.Add(xlSrcRange, rng, , xlYes)

I had read the above but struggled to see which piece of code i would need to borrow.

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

Never thought of that. Looks like I was trying to over complicate things. Thanks

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

Sorted thus in the end, we used the cknvert function and had to break the string down to its backs co.ponenrs, yyyy mm dd. Also when looking at some of the records they were not all saved as dates, so this gave me some issues. Thaks for all the help.

Not yet, might try that one tomorrow

Already done. Had to do that when testing.

Thanks, now getting Access Crashing. Using Access 64 bit in AWS environment. Might try again tomorrow.

Thanks, but i keep getting a fail. Ret value = -2146697208