Search results for query: *

I have 5 boxes that take dates. I currently use a popup calendar with code that looks like this (cboOrig is a global Combobox, Orig is a global string) Private Sub Ready1_MouseDown(Button As Integer, Shift As Integer, x As Single, Y As Single) Set cboOrig = Me.ready1 Orig = "Ready1"...

Is there a utility out there to stress-test a graphics card? I have a system with an undefined memory error and I need to find out if the error exists in the graphics card and/or system ram is to blame.

I would like to have a macro or something of that sort that will go through each tab on a spreadsheet, and if a cell has a comment, copy the text of that comment to another location. So far, the only question I have, is how do I get at the comment in the cell?

I have a table with 48 columns in it. Most of the data is specific to each primary key, but there are several binary fields that could be pulled out and put into their own table, containing just the PK from the table where a specific binary field is true. With a small dataset (3000 records...

My project uses linked tables and pass-through queries to a MySQL Server in our main office. I have put in a check when the first form loads that checks if this database is available. If it isn't, the program notifies the end user, and then disables all controls on the main form. This project...

I have a project with about 50 forms in it. Some of these forms are obsolete, and no longer referenced by any other form, or even opened directly. Is there an easy way to find out what forms are not linked to others, or not opened by docmd.openform?

I have the following code in place to check for a connection to a database. It is supposed to do stuff on error instead of showing a cryptic error box. (run time error blah blah blah... can't connect to MySQL server on server ..... Private Sub Form_Load() Set cn = New ADODB.Connection On...

I have the following query which takes an absolute age to run in Access, but when run on MySQL is done in a flash. Access appears to lock up completely when I try to run the report generated from this query. Because the resultset is going to be used as a part of a nested subreport, I can't...

I have a portion of a query that gets a start date and end date from a form. It is used to get 4 different queries for events that have happened in the past. I need to modify the query definition so that it asks for dates in the future. I have tried explaining to a few people how it "should"...

I want to globall change the font used in my application, but I don't know how to address the collection. My code would be something like for each form in FormCollection for each control in form font = arial next control next form but I don't know how to get at the collection of forms.

I have a listview on one of my forms for issuing items to people. It has 3 columns, one for item names, one for version last issued, and one for the date of last issue. There is also a tickbox next to each item. When the box is ticked, and a button pressed, each ticked item is logged as...

I am trying to find the documentation so that I can begin writing timesheets from my application. I've got my query working right, I just need now to spit out that data, plus a few things like date range onto the spreadsheet, and end-column totals. I have tried a few things but with no luck...

I am using the following as a pass-thru query to Mysql, in order to get total hours spent by each person, doing a specific task. SELECT w.designer, sum(w.HoursWorked) as worked, t.work_type as `work type` from hoursworked as w left join work_types as t on w.work_id = t.type_id where w.date >=...

I am developing an app that uses MySQL as a backend. As a part of the requirement, if no connection to the MySQL server is available, data must still be accessible. I am getting around this via a locally installed, read-only MySQL database. Now, I am using linked tables in some areas, and I...

I am wanting to script the following actions, in sequential order (Currently done in a cmd window) C:\Program Files\TrueCrypt\TrueCrypt.exe /q /v c:\volume /lz /a C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt.exe "C:\Program Files\Microsoft Office\OFFICE11\msaccess.exe" "C:\Documents...

I have a use-case here that requires three groups of access restrictions. One is unfettered, one has access to all except sensitive data, and the third has access to only address-related items. I have various forms populated with buttons that open up the relevant parts of the database. As...

I'm needing to program my app to connect to one of 2 MySQL databases, either a remote database (Master) or localhost (Slave, no writes possible) Most everything is done via ADODB, but I have various fields that pull data as a RowSource property, etc that would be dependant on ODBC calls made...

I am using the following pass-through query to MySQL(Tried it as a view as well with identical results) Everything is getting passed back correctly, except for the case result. MySQL returns the correct info, but Access can't seem to latch on to that. select q.date_received , q.quote_id ...

Is it possible to enable/disable controls based on the Access username or group ID? I am looking to set up security using Access's built-in user and group permission system. I am using all linked tables, and I want to both disable direct access to these tables, as well as disable routes to...

I want to report on data coming from a monster MySQL statement with user input data. Within my application, I use ADODB recordsets throughout my application, and I was wondering if I can do the same for generating reports. If so, how do I do it?