Search results

I posted another thread about importing but I thought I'd just try to export the data from Access into Excel. It doesn't happen all the time but I am randomly get a 1004 error "Method 'Rows' of object'_Global Failed" It doesn't happen every time and when it doesn't happen all is good with the...

Howdy, I have written a Function to calculate the Monday of any date that is entered into my db. This works great and life is/was good until I tried building a front end in Exel for graphing purposes. When I try and run my code I get a Runtime Error saying Excel doesn't recognize the...

I apogize if this isn't the correct spot for this post. I have a program that was written in Access 2003 then went to 2007. For some reason on some users computers I can't utiilize the "Microsoft ListView Control version 6.0" My pc is fine but with others I get "There was a problem accessing...

Howdy, Haven't posted in a while so I thought I'd drive someone crazy (hope not). My company recently moved into Office 2007 so I need a little assistance. I created my customized ribbon but I'm quite confused on how the callback works for getVisible or getEnabled. When I open the database the...

I'm somewhat new to Access 2007 and I have a large form that is not a popup and no border. When I open the form I HAVE to scroll just a bit to get my form so it's viewable. I've never had this issue in 2003. I do have DoComd.Maximize in the Open Module. I do have a Function that resizes the...

When I open my application I simply hide my Menu Bar then when I close my form I make it visible. This works when I step through the code but in real time I lose my Menu Bar when I hold the shift button and open my file. So now when I open every other Access database or even go to create a new...

I know this ? is form related but I'll start here. I'm writing approximately 2700+ records from Excel 2003 to Access 2003 using an ADO connection and I have created a status bar. When about 30 - 40% of the records are recorded the status bar quits updating but the records get sent up...

First, my disclaimer, I haven't seen this in person but am told it keeps happening. I created an Excel Add-In and it works really well. I then gave it to some colleagues and it worked/works really well. I then hear that when they have given to others they get an error stating it can't find...

All, Not sure if this should go in the VBA section but I have some code that restores the Menu Bar during the Unload Event but when I hold the Shift Key to view tables and stuff I have no Toolbars. I have all the checkboxes marked under the Startup option and am not seeing the issue. Thoughts...

Hopefully this is the right section. I have some code that automatically generates an email in Outlook and I'm not smart enough to get around having to click the "Yes" button notifying the user he/she is going to send an email so whats the best way to put the focus back on my Access form? After...

I'm using Exel 2003 and not sure if I can do this but it will work when stepping through the code and won't work when I open a new instance of Excel. This is my first time working with Excel Addins so I'm not sure the best way to do it. Just trying to make sure a commandbar exists if it...

Currently I have a Module in Excel that works great but I'd like to have it fire when the user changes a value in one of thesecolumns (E:I). I created a Worsheet_Change Module but can't think of the syntax. The only code I know is Selection.Address but not sure how that fits in to to the...

I have written some code that generates a Batch File from Excel (2003) to copy a Backend File and another db file. Then I call a macro in the db file that relinks it to the Backend file on the users desktop. This was to speed up the process of pulling data. If I step through it it's fine but...

Hi All, Awesome Forum hoping some day I can help but until then I'll keep asking dumb questions. I'm pulling data into Excel (2003) from Access (2003) using ADO and the data in Excel is incorrect. I run the Query in Access and I get the correct # when it ends up in Excel it's not correct. I...

Howdy, Currently, I'm using an XL file (2003) that copies my Access BE file (2003) to the users Desktop and another Access.mdb with Queries and linked tables to the BE. I then execute a macro inside the db with the queries to relink the tables to the users Desktop. Then using ADO I pull data...

Not sure if my quetion goes in this section but I'll give it a shot. I currently have managers entering their daily production numbers (Access 2003 FE/BE) and at the end is a summary form that "spits" out the results and they are required to enter information as to why they didn't achieve their...

I have an Insert Into Query and an Update Query that will bomb out if the user enters double quotes. I was thinking the syntax was Function RemoveCharacters(x As String) As String RemoveCharacters = Replace(x, """", "'") Obviously this isn't working as I planned. Any information would be...

Hi All, Awesome forum I'm in here all the time browsing for goodies and getting help so for that THANKS! I created a FE/BE db in Access 2003 for my work and when 1 person opens it shazaam no problems as soon as another person opens it the forms open slow and the time for reports is increased...

Howdy all, Just a quick one here. My company has an automated scrap system that is currently storing the results in MSSQL 2005 located on someone's C Drive. I have created a database (FE/BE) to store production data and I would like to tie in the automated scrap system. This computer is on...

Hi All, I've never messed with Access Reporting but it seems cool if you understand it. I don't! I have approximately 20 or so fields to report. I'm grouping by Date, Product Line, and Shift, and Product and since there are so many columns it stretches across 3 pages. How can I get my report...