Search results

My client wants to be able to have a form open with a record, then open the same form with a different record. In all my experience I have not had this request or seen it done. I assume I could have a different form to open the second record. Can anyone confirm my assumption? The situation is...

It is using the Switchboard manager and all users are accessing the same db. When the application opens they have the ability to see all the object types. When they get the error and click OK, it only shows the linked tables and queries. The objects for FORMS and REPORTS are missing. The...

I am using Access 2007. I have had an application running now for about 1 year and now getting an error when user opens the database. (Have one for front end and one db for backend) Here's the error message: The form name Switchboard is misspelled or refers to a form that doesn't exist...

Thanks for the code examples. That worked!

I have a form with two fields, street number and street name. If the combination of the two does not exist on a current record I want to open the form with these values already set on the form. Here is the code I have, but get error on highlighted row. The Contacts form is used for adding and...

I have a multi-record browse form. On each record displayed I have a button that selects the record to open to more detail using code strLinkCriteria = Me.ID DoCmd.OpenForm "Contacts", , , strLinkCriteria Where the ID is the key to the table. My detail form "contacts" always comes open with...

I know the connection string is correct because I can access the database from other PCs. The only difference is that this adp file sits on the Terminal server that users are accessing. How does Terminal Server using Windows Authentication differ from desktop? I will check the file size on the...

I have a project that is an adp connected to sql server 2008. Most users have the adp file on their local machine which then connects to the database on the server using windows authentication. The client then wanted to put the adp file on a terminal server to allow access from outside the...

Yes decided to use the NZ function on my updates that use this field in the calculations.

I have a numeric field on a form and the database definition is that the default is 0. When the user is on the form and hits the space bar to clear the field it sets the database value to null instead of 0, which then causes issues when I try to do calculations on other fields using this field...

Yest this works if you Enabled=yes and Locked=no, BUT I don't want the user to click in the field and update it. Is there another property setting I should set?

Was able to add TransferText function to VB code so don't need Macro. Thanks, Marnie

I can't create a save spec for my file layout because it is an ADP file not a MDB. When I try to create one on the Import/Export Wizard the option to save the spec is greyed out. On my macro I'm just leaving the spec blank. Don't know if I can leave it blank in the VB code. Will try Thanks, Marnie

I have a macro that imports data using the TransferText Action. I want to pass the "File Name" from my VB code as a parameter. Currently having to hard code the file name in the macro, but want to pass it as a parameter. Here is my code for running the macro. DoCmd.RunMacro "importlead" I...

I am trying a similar task for reading in a .csv. I have an .adp file and when I try to import the csv using the "Get External Data" Import Wizard it will NOT allow me to create a SPEC. Is this because I have SQL backend? The option to save the spec is greyed out. Thanks for any help. I am...

So I believe what you are saying is just refer to the fields on that tab using the form name. Me.fieldname.Locked = True where ME = "Leads" is the name of my form? Thanks for your quick reply.

I have a form that has several tabs. Some of the tabs use subforms. The other tabs are just displaying data related to the main table. On the open of the form I am performing some security checks for making certain tabs visible or not. Now what I want to do is on one of the tabs that is just...

I currently have an ADP file developed using MS Access 2003. The SQL backend is on the server and my connection string is PROVIDER=SQLOLEDB.1;INTEGRATED SECURITY=SSPI;PERSIST SECURITY INFO=FALSE;INITIAL CATALOG=LeadTrack;DATA SOURCE=APMPRO;Use Procedure for Prepare=1;Auto Translate=True" Now...

I originally had a Access 2003 app connected to SQL backend. This was running on XP, Vista and W7 still using 2003 Access. Now I have Vista & W7 64bit trying to run the application using 2010 Access. I setup my SQL ODBC connections the same, but am getting "Login failed for user' Reason: Not...

I figured out the ADODB code for any others interested. Dim Sqltxt As String Dim cmd As New ADODB.Command Dim cnn As New ADODB.Connection Dim rst As New ADODB.Recordset cnn.ConnectionString = CurrentProject.BaseConnectionString cnn.Open cmd.ActiveConnection = cnn...