Microsoft Windows Tag Directory

Featured Microsoft Windows Questions

Create Button to Open Specific Form
I have a continuous subform. I have added a command button beside each record on the subform to open another form, which is specific to that record. Every time I use the control wizard to make the button, the record I want is not opened. My relationship is Continuous ID to Button Number. I am [...]

Answer Question   |  May 22, 2013  2:27 PM
Access 2007, Access 2007 forms
asked by:
5 pts.

C++ Redistributable
I could not find any real information of this so thought I’d present it here. When downloading and installing the C++ Redistributable packages, should you install 64-Bit only on a 64-Bit OS? Or is it best practice to install both 32-Bit and 64-Bit? I’ve never been really clear on that. Thank you.

Answer Question   |  November 28, 2012  2:09 PM
32-bit, 64-bit OS, C
asked by:
225 pts.

SQL Group by Query with aggregate function as well as detail information
Given a simple table with historical info about Hotelroom occupancies such as name of the guest, date in, type of room, number of nights, … I want to make a query resulting in 1 output record that shows the highest number of nights someone has ever stayed in the hotel, as well as the corresponding [...]

Answer Question   |  October 8, 2012  11:13 AM
Access, GROUP BY statement, MAX, Query
asked by:
20 pts.

Problem with relating multiple tables
access 2010 i’m not getting a good answer on my question on this form, i place the link here so i don’t need to explane it again Link to forum

Answer Question   |  October 4, 2012  9:25 PM
Access 2007 form creation
asked by:
20 pts.

access query criteria using LIKE operator and msgbox if no results
I am using Access 2010. My query criteria looks like this: Like [ENTER THE FIRST LETTER OF THE SUBJECT] & “*”……so the user clicks the button and a box pops up with the above question. If the user types in a letter and there are no subjects that start with that letter it just opens [...]

Answer Question   |  September 5, 2012  4:10 PM
Access, like operator, query criteria
asked by:
10 pts.

Report design Access 2010 / 2007
I do not know how to design a report that will display the data the way I need. It is hard to describe here, but I will try with a simple example. Each record is based on a date. On each date there are entries to 0-200 accounts for various $$ amounts. IE: on 1/1/12. [...]

Answer Question   |  August 3, 2012  3:46 PM
Access, Access 2007, Report format
asked by:
5 pts.

Access 2007 type mismatch
Why is Access 2007 macro getting type mismatch error message for a simple macro to pop-up a message box when a form field is left blank upon exiting the field?

Answer Question   |  June 6, 2012  8:59 PM
Access 2007
asked by:
5 pts.

Problems exporting Access table to XML file
I am having a problem with exporting a table from Access as an XML file. I export the table and the XML file has the following at the beginning of the XML file: [!--l version="1.0" encoding="UTF-8"--]- [dataroot xmlns:od=""urn:schemas-microsoft-com:officedata"" generated=""2012-05-17T08:57:06"">[/dataroot]

Answer Question   |  May 17, 2012  2:50 PM
Access, XML
asked by:
5 pts.

Access and sql server wide tables
Does anyone know how to access sql server wide tables using Access

Answer Question   |  May 5, 2012  7:01 PM
Access, SQL Server
5 pts.

Writing to multiple fields with one text box
I am trying to find a way to get a single text box to write to multiple fields within a table. The reason I want to do this is for graphing purposes (with an outside source) and to not over crowd/complicate a form for the operators who will be using it. If this is not [...]

Answer Question   |  February 28, 2012  2:20 PM
Access Database, Access query, Access Tables, MS Access 2007
asked by:
35 pts.

Modem Speed
I have a new modem Q100z. It is suppose to be faster than the Actiontec M1000 that I have been using. The Q100z doesn’t seem to be any faster at all. Please advise. Thank You.

Answer Question   |  February 7, 2012  12:29 AM
ActionTec M1000, Q100Z
asked by:
0 pts.

Access 2007 DB Project
Hello, I am setting up a database for a small airline. I have an ‘Aircraft_Table’ with the fields:

Answer Question   |  February 28, 2012  10:41 PM
Access 2007, Database, SQL
asked by:
5 pts.

Access 2003 Chart creation, scatter plot
I am looking to create a scatter plot in Microsoft Access with independent x and y values. For example: x       y 0.3035 0.3300 0.3023 0.3249 0.3032 0.3283 I can’t seem to find a good way to do this within Access… Any help is greatly appreciated.

Answer Question   |  February 28, 2012  5:34 PM
Access, Access Chart, Microsoft Access, Microsoft Access Chart, Scatter Plot
asked by:
5 pts.

Access List
Hello there, I would like to set up a firewall and i need some help in order to use the correct filters (access lists). I want to achieve the following: 1. The external users can access the server (website and ftp) in the DMZ 2. The external user can download files from the server via [...]

Answer Question   |  May 17, 2013  6:23 PM
Access List
asked by:
5 pts.

Lotus smart suit 97
Why is “access denied” to one spread sheet?

Answer Question   |  February 28, 2012  10:03 PM
Access denied
asked by:
5 pts.

Missing Record
why would a record not appear in a report when it has the correct criteria

Answer Question   |  February 28, 2012  4:16 PM
Access, Microsoft Access, Microsoft Access record, record
asked by:
15 pts.

I would like to know all the commands fired by all my users using command line, is it possible.?
I keep a track of all my users when they login and logout, i have very few interactive users on my system who use command line. I would like to know all the commands fired by all my users using command line, is it possible.? This is required from an audit perspective.

Answer Question   |  March 17, 2012  12:57 PM
Access 2007, Command line, iSeries
asked by:
1,160 pts.

Download AS400 Physical File to Excel Using VBA
I am in the process of developing an Access database with the intention of using it to control the download of AS/400 physical files into Excel. I am fine developing the Access / Excel side of the data, however I ahve no experience with the AS/400 side of things. The access database will contain information [...]

Answer Question   |  March 17, 2012  9:55 AM
Access, AS/400, excel, VBA
asked by:
5 pts.

Access History question
Does Access have the ability to show who made changes to a databse via userID?

Answer Question   |  March 6, 2012  2:42 PM
Access, Microsoft Access
asked by:
5 pts.

Access 2007 – Controlling Master ID when launching detail form from master form
Hello, I have a master table, and a detail table. (One master record to many detail records, and an ID number that links them.) I have a form that shows the master record data, with a button that launches a form that shows the detail records for that master record. (Where condition =”[Master ID]=” & [...]

Answer Question   |  March 6, 2012  5:44 AM
Access 2007, Access forms, access master form
asked by:
5 pts.