Search results for query: *

Access 2003 - I have a form in my application that has several fields. When you TAB from field to field there is a very thin vertical indicator (it is not the mouse pointer) to show where the next field is. However, this indicator is so thin that sometimes is very difficult to detected...

Access 2003 - Currently the cursor in my application (MDB) is a very thin vertical line which is hard to visualized. Is there any way to change the shape to something else? May be a square, trinagle, and arrow or something that is easy to visualized. Any ehlp is appreciated. Have a wonderful...

Access 2003 - Is there any function in VBA that would add time as in 120:15 + 10:15 = 130:30? Also, I need one for substract. I tested in excel and it can be done very simple. Any help is appreciated. Thank you.

I have the following query: SELECT "BRIEFED" as Type, T1.Name iif((T2.a < Date and T2.b = "N" and T2.C <> "Y")1,0) as Pet iif((T2.a < Date and T2.b = "N" and T2.C <> "Y" and T1.D = "Y"),1,0) as Cas T1.Dp, T2.a, T2.b, T2.C, T1.D FROM tblTrack as T1 INNER JOIN tblCdr as T2 ON T1.No = T2.No WHERE...

Access 2000 - I have a report that consists of 3 groups. Also, I have totals for each group. The requirement is that a grand total be produced as follows: GroupA + GroupB - GroupC. I have not been able to come with a solution. Can this be done? If so, please help.

I have the following query which will be used to create a report. I must create a report showing zero (0) values if there is no value. PARAMETERS [As Of Date] DateTime; SELECT "BRIEFED" as Type, T1.ALJName as Judge, 1 as Pet, iif(T1.Consol <> "C", 1 ,0) as Cas, T1.DisplTatno as DTatno, [As Of...

Access 2002 - I have the following routine: [code] . . strSql = "tblX" set deb = currentdb() set rec = db.OpenRecorset(strSql) rec.index = "IndexA" rec.Seek "=", strZ if Not rec.nomatch then rec.edit . . rec.update end if rec.close set rec = Nothing [\code] I want to loop thru it since...

Access 2000 - I am implementing a Tracking System that among other things requires that a tickler be provided so that the users will know what is to be done next on each individual case. I developed a Union Query that is doing the job except for this section. See the code below. In the first...

Access 2000 - I have a form which has four options to print a report based on the option selected. My problems is that I have not been able to carry the option selected to the Header of the Report. One of the things that I tried was to set up a Public variable and stored the option there, but...

I posted this request in a different forum and did not get a solution. Access 2000 - I have the following query: SELECT tblTracking.Tatno, tblTracking.Taxpayer, qryTick.Item, qryTick.ActDate FROM tblTracking INNER JOIN qryTick ON tblTracking.Tatno = qryTick.TatNum WHERE...

Access 2000 - I have the following query: SELECT tblTracking.Tatno, tblTracking.Taxpayer, qryTick.Item, qryTick.ActDate FROM tblTracking INNER JOIN qryTick ON tblTracking.Tatno = qryTick.TatNum WHERE (((tblTracking.Consol)="N") AND ((tblTracking.Related)="N") AND...

Access 2000 - I have a mdb project and I was trying to limit the user access to some elements in the menu bar. I went to Tools - Startup and disabled Allow Full Menu only. When I restarted the application I was left with File, Edit, Insert and Record in the menu bar. How can I restore the...

I have an application(.mdb) written in Access 2000. I was asked to start using Access 2003. The first thing that I tried to do in Access 2003 was to compile the file. The first error message from the compiler was 'Method or Data member not found' on the line "rec.edit" Then I changed it to...

Access 2000 - I am creating several documents and I need to highlight certain areas by printing special symbols (ie, Common Bullets, char(43)). I am printing the documents based on a predfined .dot file. At some point I want to change the font, print the special character and change the font...

Access 2000 - I have a report that has 10 subreports. The conditions are: 1) each subreport must start on a new page, 2) no blank pages. When I placed a pagebreak between subreports in the main report I got blank pages if there was no data for that report (on the ON NO DATE event I set CANCEL =...

I have a form with several txt boxes bound to a table. The General information for a specific entry is as follows: Data Type = Text Field Size = 20 Caption = Reps' Last Name Default Value = Validation Rule = Like "" or is Null Validation Text = NOT VALID Required = Yes Allow Zero Length = No...

I have the following problem: 1. Click on Report 2. Click on a particular report 3. click on design 4. Click on X to close the current window 5. At this point the following message is displayed: "This action will reset the current code in break mode. Do you want to stop the running code? * To...

ACCESS 2000 - I have a report that consists of 10 different subreports. I need to place a Page Break at the end of each subreport so that the next subreport will be positioned at the top of page. Any help is appreciated.

Win Xp Home Edition. Up until couple of days ago I was able to display all my hard drives(Disk 0 - C:, Disk 1 - E:, Disk2 F: and G:) using MyComputer or Explorer. All of the sudden two of the four drives (E: and F:) were not there any more. I went to Computer Manage -> Disk Management and the...

Three weeks ago my Computer running WIN XP Professional had a disk crashed. All my files were restored successfully. I have several Clipper applications that were runing fine and now I get the message "Error [35] General protection fault in [my clipper.exe]" If I run these applications in...