Search results

I am normally able to figure this stuff out on my own, but I can't seem to get the logic for a SQL pivot. Here is what I have in Access: TRANSFORM Sum(Table.PaymentAmt) AS Amt SELECT RptDate FROM Table GROUP BY Table.RptDate ORDER BY Table.RptDate DESC PIVOT Table.PlanType; Which outputs...

Hey All, I have an Excel file that has been working just fine for the past 2 years. Yesterday it started to debug saying Item Not Found. I was able to determine the exact line of code that was causing the error, but I haven't been able to find the cure. Dim DB as DAO.Database set DB =...

Hey all, I have adopted someone elses database. It is a front end with about 100 linked tables/forms/reports/modules. The problem is that the database is really large. I would think by looking at the objects that it should be around 5mb tops, however after compacting it is still 63mb. Is...

Hi All, I have been sending plain text emails for a while, but now I have a project where the formatting of the text needs to be specific and I need to send as rich text. I can use the rich text from a table, excel, or word, but I am at a loss on how to get the data to Lotus Notes. Any...

It's been a while since I have been stumped, but I can't seem to get VBA IE to wait for the page. Here is the issue: Page loads, transaction is submitted, everything works fine 99% of the time, however, on occasion, the page loads a mini error page where you have to click a blue link for it to...

Hi Guys, I have recently started using acOutputReport to print my report to PDF. Previously I was clicking the Print button and chosing Adobe (distller). Everything is working fine, however, I noticed that the acOutputReport files are HUGE in comparison to the Distiller prints (859KB vs...

Hi all, I have a database that runs a macro/report every 2 hours, however our network has been up and down lately. This causes the macro to fail when trying to log into the system because the table that is storing your username is no longer in the database. When I check, all tables, linked...

Hi All, I've been running around in circles trying to get this to do what I want and it seems to ignore my request, so I figure I must be doing it wrong, so once again, I am asking for help. What I am trying to do is execute a function M-F every 2 hours between 4am and 6pm. The 2 hour part...

Hi all, I wrote some code in Excel to open and run a module in Access. The code executes, but when I check the results I get no records, however if I just step back 1 line and rerun the query, I get records. Alternately, if I run the code twice it will get results the 2nd time. The...

I am usually able to figure this stuff out on my own nowadays, but I am really stuck, so I defer to your knowledge. I am trying to use .Execute to run SQL to create a table in the database, the problem is that the table name is a string value that was determined through code. If I don't use a...

I am trying to use Access VB to open an excel file and encrypt it then close it. The code will open the file, and I am using SaveAs to apply a Password, these work without issue. However when using .SetPasswordEncryptionOptions it doesn't seem to do anything. I don't get any error, but when I...

Hi all, I have built modules in the past that have used a Reflection Session to connect to via telnet. But what I am trying to do now is use Reflection FTP to connect to an FTP server and up/download a file. I have been searching but I haven't found any code that would help me get started...

Hi Guys, I have created a report to print out to a pdf file. The problem is that I need a seperator page in between each record. Initially this wasn't a problem as each record was only 1 page on the report and I had just added the seperator page at the bottom of the report, but now that I...

OK, so this one is probably really easy to solve but im stuck, I have an IF statement After Update to make sure that the field has the required information. If it doesn't then it voids the entry. At this point I want the cursor to be set to the box it just cleared out but for some reason it...

I grabbed a module a while back from Microsoft's site, i cant remember the name, but what it does is tell me who has the database open (via computer name). The problem I am having is that when the database closes (DoCmd.Quit acQuitSaveNone) the ldb file still shows people logged in. I double...

Hi Guys, Once again I am playing with access and have a minor issue that I'm hoping you can help me out with. If there a setting or code that I can use to prevent people from going to a new record? When the form opens I want it to go to a new record (done already), but after that, I don't...

Hi Guys, I have an Onclick button that appends info to another db. On occasion, the sql doesn't work. I was thinking of adding some sort of error handling to this to try to alert the user when it fails. It never effects the same user and its somewhat random. Out of 200, I'd say 1 or 2 do not...

Hi Guys, I have taken over a db from a former employee. He locked the databases down by creating workgroups. The problem is that he stored the workgroup on his computer which is no longer available. When I try to modify any of the forms, reports, macros, or modules I get an error stating...

Hi Guys, I wanted to delete some duplicate records off of a table. I went through the steps of copying the structure of a table to a new table then setting the Primary Key as what I wanted to be unduplicated. In my case, I have the Primary Key setup as the Account SSN and the Persons ID...

Hi All, I have been using the ever popular Inactive Shutdown form that I found of the web for about a year, the problem I am having is that it doesn't seem to always work. I intentially left the database open 2 days ago and it still has not shut itself down, its set to a 6 hour timer. The...