Search results

Hi, Does anyone know the correct syntax to create a TCP connection to a default instance of a Sql Server. I've tried: ODBC;DRIVER=SQL Server Native Client 11.0;SERVER=127.0.0.1,1433;DATABASE=myDatabaseName;Trusted_Connection=Yes;;TABLE=dbo.Customers That doesn't work. Regards

Hi all, Using Access 2016 installed on a Terminal Server - I have one user where the shortcut I created no longer opens the database, it just opens the Access Container window. The apps opens for other logged in users. No error messages, I can't even Shift+ Click into the database. Anyone got...

Hi all, Is it possible to pass an access constant as a argument to a function? I have a button called Last with a sub on the click event that runs DoCmd.GoToRecord , , acLast I want to replace that with a call to a Function like this =GoToRecord("acLast") -- passing in the access constant...

Below is a simple error handler that I usually wrap most of my sub code in. Is it possible to have this error handler called without hard-coding it into every sub? - so all my sub code runs in an error-handling wrapper automatically. Thanks Melt On Error GoTo Error_Handler 'Run code here...

Hi all, Is it possible to retrieve a dataset from a Sql Server database using code only? -- there can be no table or query in the navigation pane as they can be opened and data copied. So, a Form is opened and its OnLoad/OnOpen event goes and gets the data? Thanks Melt

I have an old database I need to clean up and I want to see what Forms are still being actively used. So, I'm going to create a log table and, if a Form is opened, log that event. I could write a public procedure -- open every Form and call the procedure in the OnOpen() event -- but, I was...

Hi all, Does anyone have a basic database support contract document/template that they would care to share please, or any links to one? Thanks Melt

In a query I'm trying to return a list of rows sorted by ServiceType Ascending and then the last item in the list should be a row called "Add Edit Value" (see screenshot). If I 'ORDER BY 2' then the "Add/Edit" row appears at the top which is not what i want. My SQL: SELECT '' As ServiceTypeID...

Hi all, Usually when you set a default value in a form, the user can remove the value and leave the textbox blank if they want. However, in Access 2010 when my user removes the defaults value and clicks into another textbox, Access 2010 puts the dafault value back into textbox, which is...

Hi all, How do i create a variable that will be visible to all Forms after it is created? At the top of my module I have: 'globalvarable to hold the line-item count for each section on the order form Global varHardware, varSupport, varEng As Integer My function is: Public Sub...

Hi all, I have a report with a sub-report in the OrderID footer. The page header is printing on all the pages in the report, however, I need to be able to turn off the page header if the page has the sub-report, as the sub-report has it's own page header with different values. My pseudo code...

Hi all, Using Access 2007 on Windows 7 machine. Every time I make a call to the following function Access crashes. Does this mean I need to re- register the MS ADO Ext 2.8 for DDL & Security dll on the machine? or is the problem elsewhere? This seems to run fine on other PCs with the same...

Hi all, Ona report, I have a column in a query called 'ReportLineNums'. I've dropped the column onto the report and the value is being printed to the report. However, I can't seem to reference the value in the control. I keep getting an "You entered an expression that has no value...

Hi all, I have a report and there is a grouping on the report called 'Options'. The report prints something like this: Option 1 - Line Item 1 - Line Item 2 - Line Item 3 -(Show number here) Option 2 - Line Item 1 - Line Item 2 - Line Item 3 - Line Item 4 -...

Hi all, In Access 2007 does anyone know how to use the Padding properties through code? I have two textboxes and I have them "Stacked" on a report, I can add padding through the properties box, but not through code, why is that? Me!Textbox1.BottomPadding = 2 Also, can you reference the...

Using Access 2007 Hi all, I've just found out that page breaks don't work on sub-reports, has anyone ever figured out a work-around solution to this problem? I have a Counter on the details section of a sub-report and I need the page to break at a certain number. Regards Melt

Hi all, What are all the gridlines and padding properties on a command button supposed to do? I've set a number of these and I don't see any effect on the button? Regards Melt

Hi all, I'm having a problem on a complex report where the page is breaking in an inappropriate place. I've tried all the options 'can grow/shrink', 'keep together' etc and the problem is still occuring. I was thinking of giving the user an option to change the font-size of the text on the...

Hi all, I have a continuous sub-form -- on the main form I want to put a button, that when clicked goes to or sets the focus to the fifth record in the sub-form, how would I do that please? Regards Melt

Hi All, Are there any known issues with Access 2007(SP2) and Windows 7. I have an app that performs great on Win XP/ Access 2007 and dire on Windows 7. Forms take ages to come up and now I have the following query which won't even run on Windows 7. The code below returns about 1,500 records...