Search results

I have an MS Access 2003 database that has code in the open event of a form that sets the recordset to an adodb recordset. This is the code Dim sql As String sql = "Select * from tblQuickenData" Dim RsClone As ADODB.Recordset Set RsClone = New ADODB.Recordset RsClone.Open sql...

I have created an ms access database that uses a reference to outlook. The only problem is that some of uses still have office 2003 and others have office 2007 so I created 2 versions of the database one for 2003 users and one for 2007 users - I know this is the bad way to do things. I know...

Thanks, that worked

I’m using Access 2003 in a Windows 2003 server environment. Is there a way to determine the Windows user name of the current user? There is a user function CurrentUser() that will return the current user when using access security and I was wondering if there was a similar function in Access...

I have created an adp, and have created stored procedures for all of my forms. In the SQL Server database I have given my users permissions as db_datareader and db_datawriter, however they were unable to open any of my forms because they didn’t have execute permissions on my stored procedures...

Thanks for the suggestion. I have actually done that using ODBC, but I wanted to use the ADP route. There are so many things available in the adp as far as forms, reports, and the ability to create and modiy table, views, sp's and functions. The main drawback is that in an adp all of the sql...

Hello everyone, I hope I’m in the right forum for the question I’m asking. I’m using MS Access XP with Sql Server 2000 in an Access ADP. I am still designing my Sql Server database and recently I deleted field called “EmpStatus” from my database. When I tried to open the table I got a...

I'm trying to help someone with Access on a CITRIS Server. I'm working with them VIA email. They say they're having problems communicating with printers and would like to utilize their email with Access. Can someone fill me in on common problems using Access with CITRIS Server as far as...

I have an MS Access database that I am upsizing to an Access XP project using SQL Server 2000. In my Access database I have a lot of reports and forms that are based on list boxes where users can make multiple selections for criteria. When the report is opened I pass the users selections as a...

You could create your function in a database and then use your database as an add in or set a reference to your database in any other MS office program

I got the answer from another site. Here it is in case anyone wants it. If you try to keep things from getting "buggy", then you'll ......... never mind In the on format event for the page header and/or footer put in the following code (I tried to make it more buggy and confusing than it...

Sorry Crilen007 - I don't have a clue what you are talking about. Clean up what? What code

I have a report that prints the report header and footer on seperate pages. The only problem is that the page footer and page header show on the pages with the report header. Since the report header and footer show on seperate pages I don't need the page footer to show on these pages. How do you...

If you are deleting all the records from your table you can reset the autonumber field by running an append query and appending the number 1 to your autonumber field. this is the sql INSERT INTO Table1 ( AutoField ) SELECT 1 you could actually set the autonumber beginning value to anything you...

What is the syntax for calling a sub procedure on a subform from that subform’s parent form. I tried both of these and none work. Forms(Me.Name).Controls("SubChkds").Form.getlast10 Forms("subChkDS").getlast10 The name of the main from is frmChecking (I’m using me.name rather than the form...

Glad I could help! Now get rid of that prosthetic Head!

I think you are closing the wrong form! Instead of using the close form use cancel Try this If Me.RecordsetClone.RecordCount = 0 Then MsgBox "ERROR: There are zero records in the data source!", vbInformation, "No Records Found" Cancel = True End If This will Cancel the open event of the...

mylistbox.requery or mycombo.requery to requery the current form use me.requery Put the requery right after the code that opens the form Docmd.open form "Myform" mylist.requery This will open your form where the user can do his thing. After he does his thing and closes the form the next...

If you have your subform linked to the main form by cableid when you create a brand new record the subform should show no records because there won’t (or shouldn’t) be any related records for your new cableid. Are you sure you have your form and subform linked correctly. What is the link you...

here is a 2000 version