Search results for query: *

Hi all! I have a simple VBA macro in Word 2010 that is designed to apply a template to an existing document. The template is simple and contains only a .jpg image in both the header and footer (to mimic the client's letterhead). However, when I apply the template to an existing document, the...

Hi everyone, I have a simple block of code that reformats the text in a specific field after importing an Excel spreadsheet. I set it up as a sub accepting 2 variables, but I when I try to launch the sub using the following: formatlocations("Inventory_Snapshot", "Location") I get "Compile...

Hi everyone, I am wondering if there is such a thing as a graphical control that shows how much offset you have between a center value. Kind of a like a progress bar that starts in the middle of the control and fills either left or right of the line depending on the value feeding the control...

Hi everyone, I have a report that contains a chart built off of a saved query. The x-axis of this chart is a list of dates. What I would like to do is give the user an option based on a set of radio buttons as to how they would like to group the dates: daily, weekly or monthly. How would I...

Hi everyone, I have created a pivot chart in my database to help users more easily analyze data. When this form loads, however, the pivot chart field list defaults to being not visible. Could someone let me know the command I can use in VBA to set the field list to visible when the form...

I am using the docmd.transferdatabase method to move a table from one Access database to another. I want the new table to import and amend an existing table, but instead it keeps creating a new table (so instead of amending "mytable" as I indicate in the code it creates "mytable1"). Does...

Hi everyone, I am just wondering if it is possible to open a Word or PDF document from Access and have it display a specific page based on criteria from within the code? So if the code specifies that page 30 should be opened, can it launch the appropriate application and display page 30...

Hey guys, I need VBA to compact a database for me but first I need to make sure the database is not in use by the front-end application. Is there a quick way to disconnect from the back-end to ensure the compact will go smoothly? Regards...

Hi all, I have some code that needs to skip to a certain line if a recordset contains no information. Is there a simple command to check if a table has any information written to it or not? I tried the .recordcount property, but since it checks for records accessed it isn't returning a 0 or...

Hi everyone, This is probably more basic than I think it is, but I would like to do is enable a form to recognize a combination of keystrokes in order to trigger an event (ie. ctrl+j fires a VBA subroutine). Is there an easy way to go about this? Thanks in advance!

Hi guys, I'm trying to use VBA in Access to shell out to an Explorer window and move the cursor of a mainframe style interface to a specific set of coordinates. The shell I have working no problem (AppActivate "Window",True) but I don't know what the VBA command is to set the specific cursor...

Hi all, I have the following code which is an effort to create a Save As file dialog. It works perfectly, except when I try to add the filters to ensure the user saves the document as a .xls. I get a runtime error stating "Object doesn't support this property or method." Does...

I'm losing my mind. I'm getting Syntax error (Missing operator) in query expression '[EmpCod] =' yet for the life of me, I don't see where that syntax error is! Can someone please help?? ProdReport.MoveFirst Do While Not ProdReport.EOF If DCount("*", "EmployeeCodes", "[EmpCod] =" &...

Hi there, I am baffled by this one and can't figure it out. I added a conditional format to a text box control on a report which sets the text colour to red if the field value is below 123. When I swith to report view, the conditional format does not work (text remains black.) If I chance...

Hi all, I've been searching the forums and couldn't quite find help on this issue, so I'm starting this thread. My apologies if it has already been addressed elsewhere. Here's the deal: I have database that tracks shipments to our customers, then sends out email notifications to them to...

Hi all, Each day I have an Excel-format sheet which I need to spend considerable time formatting using text-to-columns prior to importing it into my Access database. I would love to be able to automate the formatting of the this sheet either within Excel (prior to the import) or within Acess...

Ok, I apologize for having to start a thread for this, but I searched high and low and couldn't find the answer in the other postings. This is probably super simple, but unfortunately I'm super simple and can't figure it out. I have a field in Access that contains order numbers of varying...

Hi all, I am using VBA to open a file in Microsoft Excel in an effort to save it in 2007 format. The file being opened is a plain .txt file, but VBA returns an error because the file isn't a .xls or .xlsx (I'm assuming.) Does anyone know an effective workaround for this issue? Dim Xl As...

Ok, here's my issue. I am opening a Visual C# file using Microsoft Excel 2007. When I'm using my work PC, everything formats great. When I'm using my laptop, not so much. Specifically, when I open the file on the laptop Excel doesn't auto-format the "DATE" field and instead return a numeric...

Here's a question that has probably been answered a hundred times. I simply need a line of VBA code that would output the current day's date (as per the PC system clock) in the format "mmmdd_yy" (ie. AUG29_08) Any suggestions?