Search results

Okay, thanks Bob, that is a good start I'll check out the website.

Hey Bob, I do have access but everyone else out in the field has that server mapped to a different Drive Letter so I figured the easiest way was to just have them set the connection on their end. Maybe I am going about this all wrong is there an easier way?

I have an Access 2003 Front End that I am going to email out to 50 people and I want them to be able to push a button that will set the connection to the linked tables on the Back End. Below is the code I have but everytime I execute it I get "Could Not Find Installable ISAM" Dim tbl As...

BobLarson, thanks for the tip, I usually don't put spaces in names and certainly won't after this.......

JDraw, thanks for the help, I took your advice and I also added brackets around [Report Name] and that worked. Thanks again..

All, I am trying to pass the value of a combo box to a DLookup function to grab the Report Description field from a table. I keep gettting and error saying there is a missing operator in query expression (Report Description) txtRpt_ReportDescription = DLookup("Report Description"...

Ok, I figured it out... If I add In(1,2,3,4,5,6,7,8,9,10,11,12) after the Pivot Function it Works!

I have a Cross Tab Query that will Trend Calls by Month. I would like to be able to create a Report where the Months will Trend out as Columns. The report will need to be able to grow (Pick up New Months as the Data is entered) because I only have Jan - Feb data. Is this possible? I don't want...

Thanks DCrake that worked!

I have a Login form and I would like to store the login in a variable for use on another form how would I go about doing this?

Rural Guy thank you very much that worked like a charm!

I am trying to use the code below to validate a User when they log into the database but I am getting RunTime Error 2001. Private Sub ButtonLogin_Click() Dim strUserName As String Dim strPassword As String Dim strUserNamePassword As String 'Combine User Name and Password entered into...

I have a Database I created on Sql Server and I have created a User Login: FinancialAnalytics with Password: Finance. I want to be able to link Access to this Database and distribute to 10 or 15 people. I want everyone to use the same Login and Password mentioned above to access the data...

Thanks VbaInet that worked perfectly...

Option 3 seems like the easiest way "Import using TransferText into a Staging table then compare rows somehow? I am leaning towards this option." Import using TransferText into a staging table and use an update query to update the Main table based on some parameter. DoCmd.TransferText...

I am trying to execute the code below and I keep getting a RunTime Error 2001 'You canceled previous operation' When click debug it highlights the row: strLogin = Nz(DLookup("[QA LOGIN]", "Tbl_QA_Representatives", "[QA LOGIN]= " & Forms![FRM_LOGIN]![Login_txt_Id]), 0) I have attached a...

I have an access table that has one column named "Name". I have a login form that requires you to enter your name. I would like to take the value of the Name text box on the Login form and search for that name in the table if it exists I want login to procede and open a given form if login name...

I have a Access Database with 2 linked tables that are linked to SQL Server. At some point I want to be able to distribute this database to a couple other locations without having to create an odbc on the users end. How can I setup up a DSN Less connection that will connect the 2 tables to SQL...

I have SQL Server 2008 Express and I have Access 2003, I want to use SQL Server as the back end and Access as the front end. I will need to distribute the Access front end to several people across the country but the SQL Server will reside with me. What is the easiest way to connect to the SQL...

I have an excel worksheet with a list of invoices and I am trying to write a macro that will load an Invoice into a text box on a website then click the Insert Button to move the invoice over to a list box....Seems pretty simple... My code runs but now invoices get entered.. essentially nothing...