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 derfloh 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: SirTECH
  • Content: Threads
  • Order by date
  1. SirTECH

    Complex Query >255 fields

    Scenario: An item can be assessed under 15 different categories, each category has between 15-25 sub categories. Most of the time a report would not need all of these categories and sub-categories. But (however rare it may) that all categories/sub-categores would be used, thus giving a report...
  2. SirTECH

    Type Mismatch - sometimes

    Using Access 2000 a recordset using a SQL statemtent similar to "Select * From tableA Where aDATE = #" & myDATE & "#" will work on one machine, but give a "type mismatch" error on another machine. I've changed the statement to read, "Select * From tableA Where CStr(Format(aDATE,'yyyymmdd')) ='"...
  3. SirTECH

    ADP "Connection" dialog doesn't open

    I'm working on an ADP program using Access 2000 that connects to a SQL Server database. A few days ago, I tried to connect to the database using the "Connection..." menu option under "File" and nothing happened - no dialog window opened. I tried creating a new ADP using the wizard, again...
  4. SirTECH

    Lebans MouseWheelHook stopped working

    I've been using Leban's solution for disabling the mouse scroll wheel for months with success. A couple office's have changed their equipment (not the OS). Now, when Access is opened, the scroll wheel is no longer disabled. No code has been changed, the OS is the same, it's just new...
  5. SirTECH

    Change system time format

    Is there a way to send a command to change the system time to 24-hour format? The system time can be changed by using... Time = #23:30# But, if the local computer setting is using the am/pm format, the result returns... 11:30:00 PM Of course within Access I can use Format(Time,"HH:nn") or...
  6. SirTECH

    Conditional Formating and Repainting the Form

    I have a continuous form that I want to use conditional formating. Field1 would use one set of conditional formating. Field2 would use a different set of conditional formating. The conditional formating I use works - well, kind of. After requerying the form, the form flickers, and the fields...
  7. SirTECH

    LINK TABLE ERROR 3033

    I've used the following code to automatically refresh table links. strCONN = ";DATABASE=" & strPATH & "MyDB_BE.mdb" For Each tdf In CurrentDb.TableDefs If tdf.Connect <> "" Then tdf.Connect = strCONN tdf.RefreshLink End If Next It works fine...
  8. SirTECH

    Multiuser Split Database - securing F/E and B/E

    I have a user-level secure database that I've split. However, while users must log into the Front-End, the Back-end can be opened without logging in. I then used the security wizard to protect the B/E using the same workgroup, which seems to work as far as protecting the B/E from being opened...
  9. SirTECH

    Multiuser Secure Back-End

    I have a user-level secure database that I've split. However, while users must log into the Front-End, the Back-end can be opened without logging in. I then used the security wizard to protect the B/E using the same workgroup, which seems to work as far as protecting the B/E from being opened...
  10. SirTECH

    Updating Recordsets

    The Problem. By using a form that's bound to a complex query, the records are not updatable. I thought that I could use a temporary table (stored in memory only) then update the permanent relevant tables as necessary. However, I haven't been able to find a way to do this. The database is...
  11. SirTECH

    Command Function

    I've created a custom logon form for a multi-user database rather than using Access' built-in logon. Before adding the custom logon form, several users used the /user and /pwd switches. So I tried to let them similarly do this by passing the username and password arguments to the custom form...
  12. SirTECH

    retrieve DefaultValue in VBA

    I have comboBoxes on a form that has a defaultvalue set as =GetINFO(string,date,number) Once the default value is changed on the form by the user, it is written to a table. I wanted a quick routine to check what the default value was, however when I use: Dim strVAL as string strVAL =...
  13. SirTECH

    using prtMip & prtDevMode for Paper Size in a multiuser DB

    I'm running a multiuser database, which means reports are printed from various printers. I can use code to size the reports to Legal, however I can't suppress the message for other users, "You do not have exclusive access to this database. Your design changes cannot be saved..." I don't want to...
  14. SirTECH

    Repeat a query to fill a report

    I have a table that holds various schedules. Each schedule has a different number of weeks in length. For example, say I've selected a schedule that is 3-weeks long. I want to generate a report that shows the schedule over a 52-week period. That means the query would repeat itself 18 times...
  15. SirTECH

    Looping inside query

    I need to print schedules stored in a table "tblSCHED". The problem is, for a different person, there is a different start point. If the selected schedule is 9 weeks in length, and the start point is week 6, then I want to display the weeks in this order 6, 7, 8, 9, 1, 2, 3, 4, 5. WHEN I...

Part and Inventory Search

Back
Top