access 2007

I am trying to use the export with formatting function in Access 2007. I want to export to an excel document on my C Drive in a folder called Pending_Waterfall , spreadsheet name CQ to start at cell A1. What would the full path be? Thank you so much for your help. Sharon

Hi, I'm working in Access 2007 and have a query that bring in fields A, B, C & D, all formatted as currency. I added an expression to subtract B, C & D from A. This only work if ALL THREE (B, C & D) have amounts entered (sometimes all 3 do, more than often only one or none have amounts). The...

I have a table, "Table A" created with basic data. I have another table, "Table B" that houses certain transactions done by Table A. However, I also need another table, "Table C", that houses a different set of transactions for the Table A data (I will actually have~4 tables of different...

I'd like to put a button on Form2 that sends a key combination to the Browser Object on Form2. Ideally, I'd prefer to have it not visually jump to the other form, but if the focus has to be switched that's not that big of a problem. ('BrowserWindow' is a Microsoft Web Browser Object) I tried...

Hi Experts, I'm trying to write a code to import the excel file into access. Here is the code.. Private Sub Command8_Click() Dim strPathFile As Variant Dim strFilter As String Dim ahtAddFilterItem() As String Dim ahtCommonFileOpenSave() As String Dim lngFlags As Long strFilter =...

I have a form in Access which I need to print a hard copy. The checkboxes on this form look terrible on the printout if they are checked. Is there any fix for this? In other words, is there a way to make them acutally look like checkmarks? I'd take completely filled in over what's actually...

I have an Access Data base with a given form that creates a new recorded with the Prime Key called (MDR#). I want to add a command button to the bottom of the form so when they click on it, it will create a folder in a given location (On the network) with the folder labeled with the "MDR# (MDR#...

Working in Access 2007 and Excel 2007.... I have an .accdb (WellCardPilot.accdb) that pulls information from multiple tables (some linked, some built into the DB). The following code works fine to return all records from a query called BridgeportWellCard to a specific worksheet in Excel (Sheet...

Hello, I'm new to Access and I've been trying to get my sales team's information gathered in a database. I have a table that has all my employees names and each date they submit a sale, what I'm trying to do is create a query that will tell me which persons did not submit information for a...

Hi all, Can anyone see why this query is hitting a syntax error (missing operator)? I've added as many square brackets as possible, but still there's a problem! It seems to point at my joins, I know DISTINCT queries are a nightmare in Access, but it all looks OK to me. Any help would be...

Ok, so I have an access 2010 database (accdb) I'm using as a front end to pull data from a mysql server and an oracle server (linked tables). I build queries and reports for a user who will run reports from this database who has access 2007. I have 2010. I have a reasonably straightforward...

Hi, My company has a database created on Access 2007 that is linked to our company's Sharepoint. Authorized users can go onto this access file and make edits that are automatically shared to the site. This works fine on Access 2007. However, the company is upgrading to Office 2010, and...

I am trying to build a database for work and need a bit of help. The database is set up as a one to many. I am having trouble designing the forms to go with it though. For example if i create a User table and need to enter events that occur for this user and I need to enter multiple contacts...

Hi Not very experienced at this VBA lark so hoping someone out there can enlighten me. I am trying to put a simple error trap into a procedure in Access VBA. Here is the code: Sub Tbay() On Error GoTo Proc_Err 'update linked tables to latest Torbay month mdb file 'if correct database not...

How can I get my Access 2007 VBA to recognize this Excel 2007 value[ActiveWorkbook.BuiltinDocumentProperties.Item("Creation date").Value] ? based upon the time frame between date created (as seen in the Stats tab of Excel) and Last Saved, I need to import the file. I'm new to VBA but have been...

Hello, Hoping someone can help with my problem. I have built a small database with 2 tables and 1 form. In the form, I am trying to concatenate 2 fields from the table which are also in the form. One of the fields is not visible in the form since I do not want anyone messing around with it...

I've got a form in Access 2007. When I try to change it and go to save it gives me the following message: "Microsoft Office Access cannot save the form or report, because it displays characters from a language that cannot be saved in your current system locale. Switch your system locale to the...

Hi, i am automating data transfer from Access 2007 to Excel 2007 and am having trouble with setting up the connection. below is what i have so far but i am having no luck with connecting to the data base via the connection string an defining my record set. i am also having trouble with...

I have an end user in Korea who is encountering an error when they execute a ListObject.QueryTable.Refresh from Excel VBA against an Access Db Query. There are three Excel worksheets with ListObject.QueryTable.Refresh updates in the workbook. Two are linked to Access Queries and one is linked to...

Hi, I have several of the MrExcel books and videos;BRILLIANT! However, I have a question I can't find the answer to. I have an Access 2007 database with hundreds of command buttons and I need to change the font on all of them from Calibre 10 to Arial 10. Is it possible to do this using basic...