Search results

The macros might be just hidden. In Access 2003 you can unhide hidden object with Tools -> Options -> View -> Show Hidden Objects (or the like, I do not have Access available right now). There must be an equivalent in A2007 HTH Thomas

Hello Jean-Louis, welcome to AWF. Here some links on ACESS/JET SQL Fundamental Microsoft Jet SQL for Access 2000 Intermediate Microsoft Jet SQL for Access 2000 Advanced Microsoft Jet SQL for Access 2000 And a page about JOINs LEFT JOIN, RIGHT JOIN Operations You might want to learn a bit...

I would propopse a solution with helper queries. First create a query Q1 that lists the records where all three fields are identical (NOT a duplicate per your definition) Now create a query Q2 that lists all records with identical Invoice Number and Vendor Name (should contain all records from...

Re: Navigate Internet Explorer using VBA Good to hear that you got it working. Just one hint: Finding a named element and navigate from there to the (only) child should be a bit more robust against site redesigns than picking the nth DIV item. For a one shot solution the approach is perfectly...

Re: Navigate Internet Explorer using VBA Hello codactu, you try to click the TD element with code, but I think that the link is located in the contained DIV element. If you inspect the page with Firefox+Firebug you will see that the TD element spans the whole page whereas the DIV contains only...

hascons, check the EnsureVisible methode of node objects. Here a link. http://visualbasic.freetutes.com/learn-vb6-advanced/lesson4/p13.html HTH Thomas

Welcome to AWF, you should be able to calculate the file name in the TransferText macro action with a formula like this: =Format(Date();"yyyymmdd") & "_Filename.txt" Check the help on the Format() function to determine the date/time format string you need. HTH Thomas

Hello James, I would do that with VBA, so I cannot comment on the macro syntax, but by the error message I would think that the macro does not know what form the filter (the form or the subform). Just do as the message says. Add a SelectObject Marcro action (giving the subform the focus) before...

This requires Excel VBA using ADO (at least as far as I know). Here how I would do it. 1) Connect to Access from Excel: Check help on Connection.Open 2) Read the data from Access: Check help on Recordset.Open 3) Write data to a (hidden) Excel sheet and define a named range containing all the...

Sarma, you need outer joins. In the query builder, double click the line that links your tables (the join). A dialog should pop up, that has three options. The default is the inner join (Option 1). Select the option that is called "Contains ALL records from Players table ..." and OK out. Now...

Pat, here a different approach, avoiding your problem in the first place. I am always annoyed, if a program does not have the standard GUI features (like the X in the upper right corner). You could address your need by sticking the code that needs to be executed on form close into the...

Hello Tony, thank you very much for the info. I now have another idea or two how it may work. I will need to study more (and learn more about the inside of activex controls). Your links will be a great help. E.g this snippet from one of the pages sounds promising: IProvideClassInfo2...

Hello Tony, thank you for your reply. As you point out in your video, there are five events easily accessible that are common to all ActiveX components (OnEnter, OnExit, OnGotFocus, OnLostFocus, OnUpdated) but the others are not. I tried all variations of your tip (class wrapper) I could think...

Here the scenario: I want to analyze forms via VBA code and see which controls have events behind them and of what type they are (Event Procedure, Macro or Expression). Now the problem: I have code for the standard controls like Text Boxes, Option Buttons etc. that works fine...

I attached a "quick-hack" DB that shows the concept for you to study. You will have to make changes as drop-downs for first and last name are not the best idea (these fields are not independent). For a Query button: Call setFilter() from a command button For a Clear button: set...

You are welcome.

I am not sure if I got the point. Anyhow, you have to differentiate "selecting records by status" from "setting a status for a record". Usually these two steps are done on different forms: a list form with that has filter options and a form for a single record for editing. If you want to do the...

You can filter the records in e.g the After_Update event of your combobox. Something like this if yourCombobox.Value = "OPEN" then Me.Filter = "NameOfYourStatusField = 'OPEN' " Me.FilterOn = True end if HTH Thomas

Hello SKK, you can set the record source of the form via VBA. You can hand over the "N" or "S" via OpenArgs and then set the record source in the Form_Load event to the query you want. HTH Thomas

You only need brackets, if your control (or table or query) contains non-standard characters (including space). Brackets do not hurt around names of DB objects, but they do harm if used on properties (like IsVisible). As you have removed the spaces from the object names (good practice anyhow)...