Search results

I have the code below to connect to a access database but I am having trouble creating the recordset and placing it in Excel...any help would be appreciated. Dim intPID As Integer, i As Integer Dim oConn As Object Dim oSheet As Object Dim oRst As Object 'Dim strSQL As String, strRAGLoc As...

on the group footer change the property to force new page after group

take the data into Excel and delete the duplicates and then copy back into empty table or check out Pat's advice: http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=57641&highlight=delete+duplicate+rows

Can you fairly simply run time an application or are there alot of modifications / further programming required, bearing in mind I use a fair few macros. The only real problems with compiling a runtime are if you are to use sms to distribute it and/or if you have any activeX controls that need...

post the db here and give us an example of query & reports involved.

What do you need to know?

why dont you just add another field to your table called "potential year" and then you can carry on logging work as usual but query on "potential year" if you need to run any reports.

I would have thought that Excel would be the tool to use not Access.

If you really want a career in databases then I would advise you to learn SQL from the start. For supporting Microsoft then there are MCP's for MS Office or even Access.

It would be best to calculate it in the report. Posting an example would be good for us to look at but if not then group on the footor for the Office.

in the lease expiring date field in the query criteria put <date()+60 this will return all data with renewal dates up to 60 days in advance

This could be a Service Pack Patch you may need. I had this using NT4.0 Get the latest patch set on.

look here http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=53859&highlight=sound+files

Ensure your invoice form is built on a query and only return the records without an entry in the check box. For a form that only shows invoice paid use a query with the check box checked. OR To be neat what you can do is build the form on a query and then have a check field on the form that...

Dear all, I have a sub form in contineous mode. Each record on the form has a uniqueid number. I have all fields disabled except one combo box. What I need to do is enable the current record based on the combo box value. Currently if I enable the fields I get the whole sub form to enbale...

If the btrieve system supports ODBC you can connect to the system and you can take the data into Access tables and then create your reports directly in Access. If not then search for import on this forum!

Please look at the attached. The form is a subform filtered by projectid. What I want to do is select the Type and then filter the form where all the selected type for that projectid are returned and if there are none then msgbox them?

look at the attached. put some dates in and change the combo!

how is the db set up? client server? server? what sort of Server is the db on? eg if it is NT he just gives u admin rights on the server and u use servmgr.exe to boot them off!

Dear all, I have a tabbed control with many subforms on. The main form is filtered by ProjectID. One of the subforms in datasheet format stores history of project issues, constraints and dependencies. What I want to do is select the field, which is a combo box holding text issues...