Search results for query: *

I am building a query and then opening it in a RecordSet. Most of the queries bring back one or more records, but some will only infrequently have records. The variable QUO brings the " character. SQLstr = "SELECT ExhNameFirst([tblExhibitors]![ID]) AS Name, tblExhibits.ExhingYr...

My buddy asked me to look at an Access Form on his computer. The Navigation bar at the bottom of the form is too short to read the data. Thinking maybe it was an anomaly in his database, we closed his database and opened mine. My database forms showed the squashed navigation bar on his computer...

Been a very long time since I tried to do this. Every time I try to open the exported workbook, it is corrupted. Are the spreadsheet types changed in Office 365? Private Sub cmdMailPrinter_Click() On Error GoTo cmdMailPrinter_Click_Err ' DoCmd.OpenQuery "qryMailing4Printer", acViewNormal...

Spent the last 2 weeks creating and tweaking a 150 line query pulling stuff from all over the place. My internal customer kept changing his mind what he needed. Found that I need to write the whole thing to a table on SQL Server; so created a table this morning. Started a stored proc and put a...

I have built an Add-Ins toolbar in Excel VBA. Sometimes when I open a spreadsheet the ADD-INS heading is missing. I go to DEVELOPER and Add-Ins and see that my add-in is checked. Is there a setting I need to do? I am about to share this with the rest of my workgroup and want to make sure they...

I'm sure that I solved this problem years ago but I cannot find my old code. :-( My customer has a spreadsheet with rows for multiple meetings to be scheduled. I've captured all the elements I want to put into the meeting notice but need some code to help me build the messages. I pretty sure...

So the programmer that left last year put passwords on the VBA of various ACCDB databases. I've been looking online for Recovery or Deletion tools and found lots that will seemingly work with MDB but nothing for Access 2007 or later. Anybody got ideas for me? Alan [smurf]

I have been opening a file every morning for months and manually (or Find and Replace) the date. My buddy suggested a computed value to get the date for me. I am now at the point of putting the whole thing together and having problems understanding the correct number of tick (') marks and the...

I figured out how to bring two or more spreadsheets into the same instance of Excel and populate a dropdown with the names of all the workbooks. Everything was working great! Now I have discovered that the user opens a separate instance of Excel with a spreadsheet from SharePoint. The name of...

My form is displaying the results of a search and the user has indicated that the data is wrong and typed the new stuff in another field. I try to update based on the old information: upSQ = "UPDATE dbo_DMPlatform SET " upSQ = upSQ & " dbo_DMPlatform.Program = " & Chr(34) &...

I'm building a report using a temp table to hold the data. The report looks great. The problem comes when the user tries to print and even though the report is selected and on top of the control form, the form is printed and not the report. Could the problem be in my code? DoCmd.OpenReport...

The data on the SQL Server is over 70,000 rows. The pages refresh very slowly when I am making SUMing and GROUPing in the queries. Even after that, I frequently are left with 100s of rows. I want to load the Temp table when the page is called and use it until the user goes elsewhere. My form...

My proof of concept is mostly working and pulling back 915K rows (now a typo) using my connection string and SQL. My problem is that I am not getting the field names into Excel 2010. Connection String: 'Use the SQL Server OLE DB Provider. strConn = "Trusted_Connection=Yes;Initial...

I am creating a Pivot Table on the fly that will be used in a further step. The problem is that the SourceData table changes name each time. ActiveWorkbook.PivotCaches.Create(SourceType:=xlDatabase, _ SourceData:="Table5", _...

I have 8 different DNSs that I need to connect thru Access VBA in turn, link three tables (same name in each DB), pull specific pieces of data from each one and go on to the next. The names of the DNSs all start with the same thing and I've built an array of the suffixes. I'm having problems...

I code VBA in both Excel and Access. Having a meltdown this morning and cannot remember. In Excel there is an event to run something when the spreadsheet is open: Auto_Open or Workbook_Open; what is the equivalent event in Access VBA. I need to create a couple lookup tables when the DB is...

We have many Access databases in which I need to add a new field to specific tables. The process needs to be repeatable because we will be refreshing our DEV environment many times before we go to production next year. I have a table with the paths, table names, and tables to be changed. Here...

I NEED TO EXPLAIN WHAT I am doing before I know the right words to ask my question. In our application in Access VBA, we do a bunch of stuff preparing the data; then open an Excel template and put in some of the data. Next my program calls a macro within the Excel. After it does its thing...

Our supplier sends a zillion spreadsheets with price quotes. Supposedly their system generates these and uses Named Ranges to place the data in the correct place. I wrote a macro on our end that reads the named ranges and puts everything into a master. After spinning through the first 50, I...

I am trying to pre-populate a combo box before I display the form with the list. Seems like it should be easy. It blows up when I try to call the form; highlighted in Red Private Sub cmdCompares_Click() Dim RS As Recordset Dim DB As Database Dim SQstr As String On Error...