Search results for query: *

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

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')) ='"...

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

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

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

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

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

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

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

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

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

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

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

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

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