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...

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...

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 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...

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...

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 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...

Have an adp database connected to SQL Server. Trying to read one table to update another one. Getting error about "Object variable or With variable not set" I'm used to dealing with mdb DAO connections and not ADO. I'm sure I'm just missing how to Open the Recordset. Dim strSqlQuery As...

I have a form that on the field the user inputs a number. On the After Update event I have a event procedure that does some testing of the values on the form. If the user gets an error I'm using the MsgBox, but it does not focus back on the field that I indicate and it places the cursor in the...

I have a form that adds a record when the user clicks a button. It does some edit checks and then the insert statement is CurrentDb.Execute "Insert into [Trip Details] ( [ListID],[Price],[Departure Date],[Group],[Cruise Line], [Category], [Ship],Destination,[Cabin No], Insurance)" & _...

I have a form that lets say has the following fields on it. date, location, precinct, type, low, high and lets say my data as filtered and sorted using a query on the screen looks like this 5/7/2010 A 100 D 1 50 5/7/2010 A 100 D 51 100 5/7/2010 A 100 D 101 150...

I have a form that performs a procedure on the click event. I want to set the properties of the mouse to an hour glass so that user knows the process is running. Is this possible and what is the code for this action.:confused: Thank you, Marnie

I am just trying to export the contents of a table to a csv file. Here is my command. DoCmd.TransferText acExportDelim, "ballotdist", "BallotDistribution", ballotdist.csv, True The "ballotdist" is my specification file and "BallotDistribution" is my table name. I want all the data for this...

I have a Dcount statement where I want to return a value based on a Select criteria of finding if the value they entered on the form is found between two fields in the database. Is there a "Between" method that can be used on a DCount. Here is my code now but it doesn't give me what I want...

I have a form that has many fields and when the user enters data and tabs off the field a select statement is dynamically built to query the table(s). I have one problem where I have a date range the user can enter, and the fields on the screen are of type date. They are going against a column...

I have a form that displays search results. After I have performed the search I want to have another button that exports certain data to MS Word to a label template. Any examples out there?

I have a form that displays data from 1 table, but I have a join on my query to reference data from another table for conditional formating on one of the fields on the form. When I want to delete a record from the form, it is deleting both records from both tables. I don't want the joined...