Search results for query: *

Hi, Does anyone know if there is a way to use the "Copy to Personal Calendar" function via Visual Basic? Thanks

Hi, Does anyone know if there is a way to use the "Copy to Personal Calendar" function via Visual Basic? %-) Thanks

Hi MadJock Heres try this, its a piece of code I've used myself and works fine. Make sure you log in using a shortcut like the following OR change the default workgroup file in WorkGroup Aministrator "C:\Program Files\Microsoft Office\Office\msaccess.exe" "[DbPath & Name]&quot...

Worked great, Thanks

I am having trouble getting the date range selected from a prompt to display on the report. I've managed to get a single date parameter to display by putting the parameter field into a text box on the report, which works fine. But if I do the same for a range parameter nothing appears in the...

I am still getting the same result.

{Quotes.Create Date} = {?Date Range}

I have a report that gives a list records from a SQL database. I am trying to put in a date parameter to select by a Create_date field but this doesnt seem to be working. If i change the parameter to a range value it returns records but only upto the selected end date and not including. Is...

i have the same sort of problem trying to update a linked oracle server. i get the following error message: Server: Msg 7357, Level 16, State 2, Line 1 Could not process object 'update wixjda.wrk_piv_sales_ctl set RECORD_COUNT = 1'. The OLE DB provider 'MSDAORA' indicates that the object has...

try this. select * from openquery ( {Linked Server Name} ,'select * from {Table}')

Worked perfectly. Cheers

I have linked my SQL Server to an Oracle database, I can see all of the tables and views, but i cannot open them!! I only have the options 'Copy' and 'Help' when i right click on a table. i can see/do everything when i log in through Oracle but cant through SQL Server. Helllllpp

This should do it SELECT MSysObjects.Name FROM MSysObjects WHERE (((MSysObjects.Type)=5));

You can create sub-reports for all of your queries and put them all in the same report without writing to any tables. 8-)

Try this, create a new form and set its RecordSource to the table with your service call logs in. Create text boxes with the fields that you want to be displayed (the form needs to have the Default View property set to Continuous Forms and Allow filters to Yes with Form Header/Footers on), save...

Is there a VB equivelant to the VBA Openargs function? If so what is it and how does it work?