Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: galorin
  • Content: Threads
  • Order by date
  1. galorin

    enabling/disabling controls in a chain

    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"...
  2. galorin

    graphics card testing

    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.
  3. galorin

    Excel: move cell comments to other cell

    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?
  4. galorin

    One table with many columns or many tables with a few?

    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...
  5. galorin

    Providing ODBC database fallover

    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...
  6. galorin

    finding orphaned forms

    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?
  7. galorin

    adodb connection error handling

    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...
  8. galorin

    long-running query Access 2k3

    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...
  9. galorin

    get a date that is 7 days in the future

    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"...
  10. galorin

    Accessing control properties in forms collection

    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.
  11. galorin

    ListView control questions

    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...
  12. galorin

    VBA/OLE documentation/howto request

    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...
  13. galorin

    Including/creating pivot table in report access 2k3

    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 >=...
  14. galorin

    changing where linked tables point to

    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...
  15. galorin

    Batch scripting

    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...
  16. galorin

    enabling security on an MDB file, and unhiding

    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...
  17. galorin

    scripting linked table manager

    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...
  18. galorin

    type mismatch and odd data returned from pass-through query

    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 ...
  19. galorin

    user security question

    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...
  20. galorin

    Simple report question re: sources for data

    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?

Part and Inventory Search

Back
Top